Study with Microsoft : 070-458 Exam Torrent as your best preparation materials

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 and the Sales role is granted the Select permission on the Customers schema.
You need to ensure that the Sales role, including userA, is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?

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

DRAG DROP
You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data.
You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.
Which four 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.)

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. CDC Splitter
• B. Merge
• C. Audit
• D. Pivot

You are developing a SQL Server Integration Services (SSIS) project by using the Project 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. Run the DTEXEC utility with the /Logger option.
• B. Execute the catalog.create_execution_dump stored procedure with the package execution_id.
• C. Run the DTEXEC utility with the /Reporting V option.
• D. Execute the catalog.add_data_tap stored procedure with the package execution_id.

You administer a Microsoft SQL Server 2012 database instance.
You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database. You need to ensure that database users and required server logins are migrated to
Windows Azure SQL Database. What should you do?

• A. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database.
• B. Use the Database Transfer wizard.
• C. Use the Copy Database wizard.
• D. Back up the database from the local server and restore it to Windows Azure SQL Database.