Latest MCSE 70-463 Real Exam Download 41-50

Ensurepass

 

QUESTION 41

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in the project uses a custom task component. You need to ensure that the custom object is deployed on the test environment correctly. What should you do?

 

A. Run the package by using the dtexec /rep /conn command.
B. Create a reusable custom logging component.

C. Create an OnError event handler.
D. Use the gacutil command.

E. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

F. Run the package by using the dtexec /dumperror /conn command.

G. Use the Integration Services Deployment Wizard.

H. Deploy the package by using an msi file.

I.  Add a data tap on the output of a component in the package data flow.

J. Run the package by using the dtexecui.exe utility and the SQL Log provider.

K. Use the dtutil /copy command.

 

Correct Answer: D

 

QUESTION 42

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system. Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes. You need to establish the best technique to log these invalid rows while minimizing the amount of development effort. What should you do?

 

A. Add a data tap on the output of a component in the package data flow.
B. Deploy the package by using an msi file.

C. Run the package by using the dtexecui.exe utility and the SQL Log provider.
D. Uses the dtutil /copy command.

E. Create an OnError event handler.

F. Use the Integration Services Deployment Wizard.

G. Use the gacutil command

H. Create a reusable custom logging component.

I.  Run the package by using the dtexec /rep /conn command.

J. Run the package by using the dtexec /dumperror /conn command.

K. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

 

Correct Answer: A

 

QUESTION 43

You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the project is deployed to the production environment with the least amount of administrative effort. What should you do?

 

A. Create an On Error event handler.

B. Add a data tap on the output of a component in the package data flow.
C. Use the gacutil command.

D. Create a reusable custom logging component.

E. Run the package by using the dtexecui.exe utility and the SQL Log provider.

F. Run the package by using the dtexec /rep /conn command.

G. Use the Integration Services Deployment Wizard.

H. Run the package by using the dtexec /dumperror /conn command.

I.  Use the dtutil /copy command.

J. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

K. Deploy the package by using an msi file.

 

Correct Answer: G

 

QUESTION 44

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. What should you do?

 

A. Create a reusable custom logging component.
B. Use the gacutil command.

C. Use the Integration Services Deployment Wizard.

D. Run the package by using the dtexec /rep /conn command.

E. Add a data tap on the output of a component in the package data flow.

F. Create an OnError event handler.

G. Use the dtutil /copy command.

H. Deploy the package by using an msi file.

I.  Run the package by using the dtexec /dumperror /conn command.

J. Run the package by using the dtexecui.exe utility and the SQL Log provider.

K. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

 

Correct Answer: J

 

QUESTION 45

You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages. The new capability is not available as an SSIS task. Each package must be extended with the same new capability. You need to add the new capability to all the packages without copying the code between packages. What should you do?

 

A. Use the Expression task.
B. Use the Script component.
C. Use the Script task.

D. Develop a custom task.

E. Develop a custom component.

 

Correct Answer: D

 

QUESTION 46

You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project. You need to produce the CSV file with the least amount of development effort. What should you do?

 

A. Create an Integration Services package and use a Data Profiling transform.
B. Create a custom .NET application based on the Knowledgebase class.

C. Create a CLR stored procedure based on the Knowledgebase class.
D. Create a Master Data Services (MDS) business rule.

E. Create a data quality project.

 

Correct Answer: E

 

QUESTION 47

You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse, and the dimDistrict table contains information about sales districts. The system is accessed by users from certain districts, as well as by area supervisors and users from the corporate headquarters. You need to design a table structure to ensure that certain users can see sales data for only certain districts. Some users must be permitted to see sales data from multiple districts. What should you do?

 

A. Create a userDistrict table that contains primary key columns from the dimUser and dimDistrict tables.
B. Partition the factSales table on the district column.

C. Add a district column to the dimUser table.

D. For each district, create a view of the factSales table that includes a WHERE clause for the district.

 

Correct Answer: A

 

QUESTION 48

You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download sales transaction data. You create project parameters to store the username and password that are used to access the FTP site. You need to ensure that the username and password values are encrypted when they are deployed. What should you do?

 

A. set the Sensitive property of the parameters to True.

B. Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey

C. Change the parameters to package parameters.

D. Change the project to the Legacy Deployment model

 

Correct Answer: A

 

QUESTION 49

 

A SQL Server Integration Services (SSIS) package on a computer is failing periodically in production. The package was created less than one year ago and was deployed to the SSIS catalog. Sometimes the package is started on a SQL Agent schedule; sometimes the package is started manually by an SSIS developer by using the Object Explorer in SQL Server Management Studio. You need to identify the authenticated user responsible for starting the package each time it failed in the past. Where can you find this information?

 

A. the SQL Server Log

B. the SSISDB.[catalog].[executions] view

C. the SSISDB.[catalog].[event_messages] view

D. the SQL Agent Job History

E. the SQL Agent Error Log

Correct Answer: B

QUESTION 50

You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using

SQL Server 2008 Business Intelligence Development Studio (BIDS). The package includes custom scripts that must be upgraded. You need to upgrade the package to SQL Server 2012. Which tool should you use?

 

A. SSIS Upgrade Wizard in SQL Server 2008 BIDS
B. SSIS Upgrade Wizard in SQL Server Data Tools
C. SQL Server DTExecUI utility (dtexecui.exe)

D. SQL Server dtexec utility (dtexec.exe)

 

Correct Answer: B

 

Download Latest 70-463 Real Free Tests , help you to pass exam 100%.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.