OFFER Free Microsoft 70-458 PDF and VCE Exam Dumps (51-60)

QUESTION 51
Drag and Drop Question
You administer three Microsoft SQL Server 2008 R2 instances. Database mirroring is configured in High-Safety mode with Automatic Failover between the following three servers:
* SQL1 is the Principal server.
* SQL2 is the mirror server.
* SQL3 is the witness server.
You need to upgrade SQL1 and SQL2 to SQL Server 2012. You need to ensure that downtime is minimized during the upgrade. Which six 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.)

image
Answer:

image

Continue reading

OFFER Free Microsoft 70-458 PDF and VCE Exam Dumps (41-50)

QUESTION 41
Drag and Drop Question
You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into a data warehouse hosted on SQL Azure. You have the following requirements:
* A destination table must contain all of the data in two source tables.
* Duplicate records must be inserted into the destination table.
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.)

image
Answer:

image
Explanation:
http://msdn.microsoft.com/en-us/library/ms141703.aspx
http://msdn.microsoft.com/en-us/library/ms141775.aspx
http://msdn.microsoft.com/en-us/library/ms141020.aspx
http://msdn.microsoft.com/en-us/library/ms140182.aspx

Continue reading

OFFER Free Microsoft 70-458 PDF and VCE Exam Dumps (31-40)

QUESTION 31
Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. What should you do?

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

Answer: C

Continue reading

OFFER Free Microsoft 70-458 PDF and VCE Exam Dumps (21-30)

QUESTION 21
You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in the project uses a custom task component. You need to ensure that the custom object is deployed on the test environment correctly. What should you do?

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

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms403356.aspx

Continue reading

OFFER Free Microsoft 70-458 PDF and VCE Exam Dumps (11-20)

QUESTION 11
You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse. The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis. You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum. What should you do?

A.    Add an OnError event handler to the SSIS project.
B.    Use an msi file to deploy the package on the server.
C.    Open a command prompt and run the gacutil command.
D.    Open a command prompt and run the dtutil /copy command.
E.    Open a command prompt and run the dtexec /rep /conn command.
F.    Open a command prompt and run the dtexec /dumperror /conn command.
G.    Open a command prompt and execute the package by using the SQL Log provider and running
the dtexecui.exe utility.
H.    Create a reusable custom logging component and use it in the SSIS project.
I.    Configure the SSIS solution to use the Project Deployment Model.
J.    Configure the output of a component in the package data flow to use a data tap.
K.    Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in
SQL Server.

Answer: J
Explanation:
http://technet.microsoft.com/en-us/library/hh230989.aspx
http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html http://msdn.microsoft.com/en-us/library/ms162820.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx
http://technet.microsoft.com/en-us/library/ms140223.aspx
http://msdn.microsoft.com/en-us/library/jj655339.aspx

Continue reading

OFFER Free Microsoft 70-458 PDF and VCE Exam Dumps (1-10)

QUESTION 1
You are developing a SQL Server Integration Services (SSIS) package. To process complex scientific data originating from a SQL Azure database, a custom task component is added to the project. You need to ensure that the custom component is deployed on a test environment correctly. What should you do?

A.    Add an OnError event handler to the SSIS project.
B.    Use an msi file to deploy the package on the server.
C.    Open a command prompt and run the gacutil command.
D.    Open a command prompt and run the dtutil /copy command.
E.    Open a command prompt and run the dtexec /rep /conn command.
F.    Open a command prompt and run the dtexec /dumperror /conn command.
G.    Open a command prompt and execute the package by using the SQL Log provider and running
the dtexecui.exe utility.
H.    Create a reusable custom logging component and use it in the SSIS project.
I.    Configure the SSIS solution to use the Project Deployment Model.
J.    Configure the output of a component in the package data flow to use a data tap.
K.    Run the dtutil command to deploy the package to the SSIS catalog and store the configuration
in SQL Server.

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/lib

Continue reading