Online Access Free 70-458 Exam Questions

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 deploying a new SQL Server Integration Services (SSIS) package to several servers.
The package must meet the following requirements:
- INET Common Language Runtime (CLR) integration in SQL Server must not be enabled. - The Connection Managers used in the package must be configurable without editing the package. - The deployment procedure must be automated as much as possible.
You need to set up a deployment strategy that meets the requirements.
What should you do?

• A.Run the package by using the dtexecui.exe utility and the SQL Log provider.
• B.create an OnError event handler.
• C.use the dtutll /copy command.
• D.create a reusable custom logging component.
• E.Run the package by using the dtexec /dumperror /conn command.
• F.Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
• G.Use the gacutil command.
• H.use the Project Deployment Wizard.
• I.Deploy the package by using an msi file.
• J.Run the package by using the dtexec /rep /conn command.
• K.Add a data tap on the output of a component in the package data flow.

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:

The differential backup of the reporting database fails. Then, the reporting database fails at
14:00 hours.
You need to ensure that the reporting database is restored. You also need to ensure that
data loss is minimal.
What should you do?

• A.Restore the latest full backup.
• B.Perform a point-in-time restore.
• C.Perform a page 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, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
• F.Restore the latest full backup. Then, restore the latest differential backup.
• G.Perform a partial restore.
• H.Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.

DRAG DROP
You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks.
You need to prepare the AdventureWorks database for database mirroring. ServerB will act as the mirror in a mirroring partnership along with ServerA.
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:

DRAG DROP
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01.
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
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:

A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL Server table named Transaction. Each file corresponds to a different store and is imported in parallel with the other files. The data flow tasks use OLE DB destinations in fast load data access mode.
The number of daily transactions per store can be very large and is growing. The Transaction table does not have any indexes.
You need to minimize the package execution time.
What should you do?

• A.Partition the table by day and store.
• B.Reduce the value of the Maximum Insert Commit Size property.
• C.Run the package in Performance mode.
• D.Create a clustered index on the Transaction table.