Online Access Free 70-458 Practice Test

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.)

Correct Answer:

You administer a Windows Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?

• A.Option C
• B.Option D
• C.Option B
• D.Option A

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Mode.
The project will be deployed to an SSIS catalog folder where Environments have already been created.
You need to deploy the project.
What should you do?

• A.Store the System::SourceID variable in the custom log table.
• B.Use an event handler for OnTaskFailed for the package.
• C.Use an event handler for OnError for the package.
• D.Store the System::ExecutionInstanceGUID variable in the custom log table.
• E.Enable the SSIS log provider for SQL Server for OnError in the package control flow.
• F.Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
• G.View the job history for the SQL Server Agent job.
• H.Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
• I.Deploy the .ispac file by using the Integration Services Deployment Wizard.
• J.Create a SQL Server Agent job to execute the SSISDB.catalog.create_execution and SSISDB.catalog.*tart_execution stored procedures.
• K.Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
• L.Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.
• M.Use an event handler for OnError for each data flow task.
• N.Store the System::ServerExecutionID variable in the custom log table.
• O.View the All Messages subsection of the All Executions report for the package.
• P.Deploy the project by using dtutil.exe with the /COPY SQL option.
• Q.Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.
• R.Deploy the project by using dtutil.exe with the /COPY DTS option.

You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders.
Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is heavily fragmented.
You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation.
Which Transact-SQL command should you use?

• A.Option C
• B.Option D
• C.Option B
• D.Option A

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains several tasks that must repeat until an expression evaluates to
FALSE.
You need to add and configure a container to enable this design.
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.)

Correct Answer: