QUESTION: 227
You plan to deploy a package to a server that has SQL Server installed. The server
contains a SQL Server Integration Services Catalog. You need to ensure that the
package credentials are encrypted. Which protection level should you set for the
package?
A. EncryptSensitivewithUserKey
B. EncryptAllWithUserKey
C. ServerStorage
D. EncryptSensitivewithPassword
Answer: D
QUESTION: 228
DRAG DROP
You are maintaining a SQL Server Integration Services (SSIS) package. The package
uses custom functionality that is implemented in Microsoft Visual C#.
The implementation of the custom functionality changes overtime. The design of the
package allows you to deploy new releases of the custom functionality without
redeploying the entire package. You need to implement and deploy an update to the
custom functionality without requiring package redeployment. Which three actions
should you perform in sequence? (To answer, move the appropriate actions from the list
of actions to the answer area and arrange them in the correct order.)
Answer:
Exhibit
QUESTION: 229
You are designing a data warehouse with two fact tables. The first table contains sales
per month and the second table contains orders per day. Referential integrity must be
enforced declaratively. You need to design a solution that can join a single time
dimension to both fact tables. What should you do?
A. Join the two fact tables.
B. Merge the fact tables.
C. Change the level of granularity in both fact tables to be the same.
D. Partition the fact tables by day.
Answer: D
QUESTION: 230
You have a SQL server integration Services (SSIS) package named package1. You
discover that the Data Flow task for Package1 runs slower than expected. You need to
reduce the amount of time required to run the Data Flow task. Which two actions should
you perform? (Select Two)
A. Configure the package to run by using the CallerInfo option.
B. Modify the DefaultBufferSize package setting.
C. Modify the ForceExecutionResult Package setting.
D. Modify the DefaultBufferMaxRows package setting.
E. Configure the package to run by using MaxConcurrent option.
Answer: D, E
QUESTION: 231
You are designing an extract, transform, and load (ETL) solution that loads data into
dimension tables. The ETL process involves many transformation steps.
You need to ensure that the design can provide:
�Auditing information for compliance and business user acceptance
�Tracking and unique identification of records for troubleshooting and error correction
What should you do?
A.Create aSQLCommon LanguageRuntime (SQLCLR)
component that records all transformation steps in a Microsoft SharePoint
list.
B. Create a version control repository for the transformation steps in Team Foundation
Server (TFS).
C. Develop a custom data lineage solution.
D. Develop a Data Quality Services (DQS) solution.
Answer: C
QUESTION: 232
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to load data into
a SQL Server 2016 database. The name of the target instance is passed to the package
via an Environment variable. The Environment variable provides the server name to the
Project parameter named ServerName. The OLE DB Project Connection Manager has
been parameterized. You need to configure the Connection Manager property to accept
the parameter. Which property and parameter should you use? (To answer, configure the
appropriate option or options in the dialog box in the answer area.)
Answer:
Exhibit
QUESTION: 233
You are designing a SQL Server Integration Services (SSIS) project that uses the Project
Deployment Model. The project will contain 10 packages. All the packages must
connect to the same data source and destination. You need to define and reuse the
connection managers in all the packages by using the least development effort.
What should you do?
A. Implement parent package variables.
B. Copy and paste connection managers from one package to the others.
C. Implement project connection managers.
D. Implement package connection managers.
Answer: C
QUESTION: 234
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source
for the data flow task is a table that has been configured as a change data capture (CDC)
table. You are using a CDC Source component to obtain the CDC data.
The data source will be polled once per hour. The data is updated with multiple
important status changes per minute. For each captured data change, the before and after
values must be included. You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option in the dialog box in the answer area.)
Answer:
Exhibit
QUESTION: 235
You are administering SQL Server Integration Services (SSIS) permissions on a
production server that runs SQL Server 2016. Package developers in your company
must have permission to perform the following tasks only on their own projects:
View projects and packages, View Environments, Validate packages, Execute packages.
You need to grant rights to the developers without assigning unnecessary privileges.
What should you do? (Each correct answer presents part of a solution. Choose all that
apply.)
A. Add developer logins to the db_ssisltduser role in the msdb database.
B. Add developer logins to the db_ssisoperator role in the msdb database.
C. Grant Execute permission in the projects for the developer logins.
D. Grant Read permission in the SSIS catalog folder, the projects, and the
Environments.
E. Add developer logins to the ssis_admin role in the SSISDB database.
F. Grant Modify permission in the projects for the developer logins.
Answer: B, D
QUESTION: 236
You are implementing a new SQL Server Integration Services (SSIS) 2016 package that
loads data from various flat files and a Windows Azure SQL Database database.
Daily transactions must be loaded into a staging database. All the SSIS tasks will use the
CurrentDate variable as the transaction date. You need to set the CurrentDate variable to
the current execution date when the package starts. You need to achieve this goal by
using the least amount of development effort. What should you use to set the variable?
A. An Expression task
B. A Script component
C. A Script task
D. An Execute SQL task
Answer: A
QUESTION: 237
You are completing the installation of the Data Quality Server component of SQL
Server Data Quality Services (DQS). You need to complete the post-installation
configuration. What should you do?
A. Install the Analysis Services OLE DB Provider.
B. Run the DQSInstaller.exe command.
C. Run the Configuration component in the Data Quality Client.
D. Make the data available for DQS operations.
Answer: B
For More exams visit https://killexams.com
Kill your exam at First Attempt....Guaranteed!
No comments:
Post a Comment