Prep and try our 70-458 valid and latest training questions & answers

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. DENY SELECT ON Object::Regions FROM UserA
• B. REVOKE SELECT ON Schema:Customers FROM Soles
• C. DENY SELECT OH Schema:: Customers FROM Soles
• D. EXEC sp_droprolemember 'Sales', 'UserA'
• E. DENY SELECT ON Schema:Customers FROM UserA
• F. DENY SELECT ON Object::Regions FROM Sales
• G. REVOKE SELECT ON Object::Regions FROM Soles
• H. REVOKE SELECT ON Schema::Customers FROM UserA
• I. REVOKE SELECT ON Object::Regions FROM UserA
• J. EXEC sp_oddrolemember 'Sales', 'UserA'

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.
The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project.
You need to meet the requirements by using the least amount of administrative effort.
What should you do?

• A. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.
• B. For each target server, create separate registry entry configurations. Select the registry entry at package execution time.
• C. For each target server, create a separate XML configuration file. Select the XML configuration file at package execution time.
• D. Create one SSIS catalog Environment. Change the values of each Environment variable at package execution time.

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 Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table: At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database.

You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal.
What should you do?

• A. Perform a page restore.
• B. Restore the latest full backup. Then, restore the latest differential backup.
• C. Perform a point-in-time restore.
• D. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
• E. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
• F. Perform a partial restore.
• G. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
• H. Restore the latest full backup.

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

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that loads data into a data warehouse hosted on Windows Azure SQL Database.
You must combine two data sources together by using the ProductID column to provide complete details for each record. The data retrieved from each data source is sorted in ascending order by the ProductID column.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.)