Study with 70-458 Actual Test Questions

Not sure if a study resource is worth your money? Actualtests4sure offers a free demo of the 70-458 practice questions, so you can judge the quality of our Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 material before you spend a cent.

Microsoft 70-458 Exam Overview:

Microsoft 70-458 Exam Syllabus Topics:

Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Sample Questions:

Question 1

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012.
You attempt to add a SQL login, [User1], to the database. However, you receive the following error message:
"User already exists in current database."
You need to configure the [User1] login to be able to access the Orders database and retain the original permissions. You need to achieve this goal by using the minimum required permissions.
Which Transact-SQL statement should you use?

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

Question 2

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The package contains a user-defined variable named @Queue which has an initial value of 10.
The package control flow contains many tasks that must repeat execution until the @Queue variable equals 0.
You need to enable the tasks to be grouped together for repeat execution.
Which item should you add to the package? (To answer, select the appropriate item in the answer area.)

Question 3

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

Question 4

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

Question 5

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 writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?

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

Solutions: