Pass with 70-458 Practice Materials 100% for sure

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:

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

2. HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
The package control flow will contain many tasks. The tasks will execute consecutively and none will execute more than once. Certaingroups of tasks will share variable and transaction scope.
You need to group tasks together while enabling them to be collapsed and expanded as a group.
Which item should you use from the SSIS Toolbox? (To answer, select the appropriate item in the answer area.)

3. 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 a separate XML configuration file. Select the XML configuration file at package execution time.
C) For each target server, create separate registry entry configurations. Select the registry entry at package execution time.
D) Create one SSIS catalog Environment. Change the values of each Environment variable at package execution time.

4. You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which Data Flow transformation should you use?

A) Multicast
B) Conditional Split
C) Script Task
D) Source Assistant

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

Solutions: