70-463 試験問題を無料オンラインアクセス

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.Use the dtutil /copy command.
• B.Use the gacutil command.
• C.Create a reusable custom logging component.
• D.Add a data tap on the output of a component in the package data flow.
• E.Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
• F.Deploy the package by using an msi file.
• G.Run the package by using the dtexec /rep /conn command.
• H.Run the package by using the dtexec /dumperror /conn command.
• I.Create an OnError event handler.
• J.Run the package by using the dtexecui.exe utility and the SQL Log provider.
• K.Use the Project Deployment Wizard.

You need to design a data load strategy for a data warehouse fact table. The solution must use an ordered data load.
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.

正解：

Explanation

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 SQL Agent Error Log
• C.the SSISDB.[catalog].[executions] view
• D.the SQL Agent Job History
• E.the SSISDB.[catalog].[event_messages] view

You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?

• A.Execute the catalog.create_execution_dump stored procedure with the package execution_id.
• B.Run the DTEXEC utility with the /Reporting V option.
• C.Run the DTEXEC utility with the /DumpOnError option.
• D.Execute the catalog.add_data_tap stored procedure with the package execution_id.

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.Modify the DefaultBufferMaxRows package setting.
• B.Configure the package to run by using MaxConcurrent option.
• C.Modify the ForceExecutionResult Package setting.
• D.Configure the package to run by using the CallerInfo option.
• E.Modify the DefaultBufferSize package setting.