QUESTION 191
Drag and Drop Questions
You administer a large and complex SQL Server Integration Services (SSIS) solution in the SSIS catalog. You are instructed to execute a package by using PowerShell. You need to create the correct PowerShell command. How should you place the four code segments in sequence? (To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.)
Tag: 70-463 dumps download
Updated Microsoft 70-463 PDF & VCE Free Download Now (171-180)
QUESTION 171
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job. You make changes to the package that should improve performance. You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal. What should you do?
A. After 10 executions, view the job history for the SQL Server Agent job.
B. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the project.
C. Enable logging to the Application Event Log in the package control flow for the On information event. After 10 executions, view the Application Event Log.
D. Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10 executions, view the XML file.
Updated Microsoft 70-463 PDF & VCE Free Download Now (161-170)
QUESTION 161
Hotspot Questions
You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model- The model consists of two entities: one named Customer and one named State.
You opened the Customer entity.
Currently, data stewards can enter any text value in the Customer entity’s State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity. You need to configure the State attribute of the Customer entity. Which command should you use? (To answer, select the appropriate command in the answer area.)
Updated Microsoft 70-463 PDF & VCE Free Download Now (151-160)
QUESTION 151
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.add_data_tap stored procedure with the package execution_id.
B. Execute the catalog.create_execution_dump stored procedure with the package execution_id.
C. Run the DTEXEC utility with the /DumpOnError option.
D. Run the DTEXEC utility with the /Reporting V option.
Updated Microsoft 70-463 PDF & VCE Free Download Now (141-150)
QUESTION 141
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job. You make changes to the package that should improve performance. You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal. What should you do?
A. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the package.
B. Configure the package to send you an email upon completion that includes information about the duration of the package. After 10 executions, view the emails.
C. Enable logging to the Application Event Log in the package control flow for the OnInformation event. After 10 executions, view the Application Event Log.
D. Enable logging to the Application Event Log in the package control flow for the OnPostExecute event. After 10 executions, view the Application Event Log.
Updated Microsoft 70-463 PDF & VCE Free Download Now (121-130)
QUESTION 121
You work as a database administrator at Lead2pass.com. The Lead2pass.com network consists of a single domain named Lead2pass.com. Lead2pass.com makes use of Microsoft SQL Server 2012 in their environment. You have created a SQL Server Integration Services (SSIS) project that you are preparing to deploy using the Integration Services Deployment Wizard. Which of the following is the third step in the Integration Services Deployment Wizard’s process?
A. Review
B. Select Destination
C. Deploy/Results
D. Select Source
Updated Microsoft 70-463 PDF & VCE Free Download Now (111-120)
QUESTION 111
You work as a senior database administrator at Lead2pass.com. The Lead2pass.com network consists of a single domain named Lead2pass.com. Lead2pass.com makes use of Microsoft SQL Server 2012 in their environment. You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing Multicast transformation. Which of the following is TRUE with regards to Multicast transformation? (Choose two.)
A. It prevents a package from creating logical copies of data.
B. It allows a package to create logical copies of data.
C. It distributes its input to one or more outputs.
D. It distributes its input to a single output.
Updated Microsoft 70-463 PDF & VCE Free Download Now (91-100)
QUESTION 91
Drag and Drop Question
A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor data feed. The package is executed several times a day, either as part of other packages’ control flow or by itself. The external data feed is unreliable because network failures and slow response times are frequent. The package is currently deployed on the file system. To analyze the reliability of the external data feed, you must collect execution data. Every time the DataFeed package is executed, the following information must be logged:
Start Time
End Time
Execution Result
Execution Duration
You need to design a logging solution that meets the requirements by using the least amount of administrative and development effort. 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.)
Updated Microsoft 70-463 PDF & VCE Free Download Now (81-90)
QUESTION 81
Hotspot Questions
You are editing a SQL Server Integration Services (SSIS) package. You need to edit the Script task that has an expression defined. Which task should you select? To answer, select the appropriate setting or settings in the answer area.
Updated Microsoft 70-463 PDF & VCE Free Download Now (71-80)
QUESTION 71
Drag and Drop Questions
You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record. In the current implementation, the DimProduct table must be scanned twice, once for the insert and again for the update. As a result, inserts and updates to the DimProduct table take longer than expected. You need to create a solution that uses a single command to perform an update and an insert. How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the appropriate answer choice from the list of options to the correct location or locations in the answer area. You may need to drag the split bar between panes or scroll to view content.)