Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 : 070-458 exam dump

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

DRAG DROP
You administer a Microsoft SQL Server database.
You want to import data from a text file to the database.
You need to ensure that the following requirements are met:
- Data import is performed from a Windows batch file.
- Data is loaded as a unit and is minimally logged.
Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from aWindows Azure SQL Database database. The project uses the PackageDeployment Model. This project is deployed to SQL Server on atest server.
You need to ensure that the project is deployed to the SSIS catalog on the production server.
What should you do?

• A. create a reusable custom logging component and use it in the SSIS project.
• B. Open a command prompt and run the dtutil /copy command.
• C. Configure the output of a component in the package data flow to use a data tap.
• D. use an msi file to deploy the package on the server.
• E. Add an OnError event handler to the SSIS project.
• F. Open a command prompt and run the dtexec /rep /conn command.
• G. Open a command prompt and run the gacutil command.
• H. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
• I. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
• J. Open a command prompt and run the dtexec /dumperror /conn command.
• K. Configure the SSIS solution to use the Project Deployment Model.

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.
Which data flow transformation should you use?

• A. Pivot
• B. CDC Splitter
• C. Merge
• D. Audit

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named userA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that the following requirements are met:
The Sales role does not have the Select permission on the Customers schema.UserA has the Select permission on the Regions table.
Which Transact-SQL statement should you use?

• A. REVOKE SELECT ON Schema::Customers FROM UserA
• B. REVOKE SELECT ON Schema:Customers FROM Soles
• C. DENY SELECT ON Object::Regions FROM UserA
• D. REVOKE SELECT ON Object::Regions FROM UserA
• E. DENY SELECT OH Schema:: Customers FROM Soles
• F. EXEC sp_oddrolemember 'Sales', 'UserA'
• G. EXEC sp_droprolemember 'Sales', 'UserA'
• H. REVOKE SELECT ON Object::Regions FROM Soles
• I. DENY SELECT ON Schema:Customers FROM UserA
• J. DENY SELECT ON Object::Regions FROM Sales