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

QUESTION 22
You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the project is deployed to the production environment with the least amount of administrative effort. What should you do?

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

Answer: G
Explanation:
http://msdn.microsoft.com/en-us/library/hh479588.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx

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

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

QUESTION 24
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.    DROP USER [User1];
CREATE USER [User1]FOR LOGIN [User1];
ALTER ROLE [db_owner] ADD MEMBER [User1];
B.    ALTER ROLE ;db_owner] ADD MEMBER [User1];
C.    ALTER USER [User1]WITH LOGIN [User1];
D.    ALTER SERVER ROLE [sysadmin] ADD MEM3ER [User1];

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms176060.aspx

QUESTION 25
You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of user should you create?

A.    SQL user with login
B.    SQL user without login
C.    Domain user
D.    User mapped to an asymmetric key

Answer: A

QUESTION 26
You administer a Microsoft SQL Server 2012 database. You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01. You need to configure the availability group to minimize transaction latency on any available secondary databases. In the event of a database failure, the designated secondary database should come online automatically. Which Transact-SQL statement should you use?

A.    ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01\Contoso01’ WITH
(AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = AUTOMATIC)
B.    ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01\Contoso01’ WITH
(AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL)
C.    ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01\Contoso01’ WITH
(AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = AUTOMATIC)
D.    ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01\Contoso01’ WITH
(AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL)

Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/ff877931.aspx

QUESTION 27
You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table named Orders in a SQL Azure database. The company’s auditing policies have the following requirements:
* An entry must be written to a dedicated SQL Server log table named OrderLog.
* The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements. Which event handler should you use?

A.    OnProgress
B.    Onlnformation
C.    OnPostExecute
D.    OnComplete

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms140223.aspx

QUESTION 28
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model. Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder path to the package. You need to configure the package to accept the folder path from each job. Which package configuration should you use?

A.    .dtsConfig file
B.    Registry Entry
C.     Environment Variable
D.    Parent Package Variable
E.    XML Configuration File

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms345179.aspx
http://msdn.microsoft.com/en-us/library/ms141708.aspx
http://msdn.microsoft.com/en-us/library/hh213214.aspx
http://msdn.microsoft.com/en-us/library/hh213296.aspx
http://msdn.microsoft.com/en-us/library/hh213293.aspx

QUESTION 29
You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. 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: A
Explanation:
http://msdn.microsoft.com/en-us/library/ms141212.aspx http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012- part-1-of-2/
http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012- part-2-of-2/

QUESTION 30
You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database, The project uses the Package Deployment Model. This project is deployed to SQL Server on a test server. You need to ensure that the project is deployed to the SSIS catalog on the production server. 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: I
Explanation:
http://msdn.microsoft.com/en-us/library/hh231102.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx

If you want to pass Microsoft 70-458 successfully, donot missing to read latest lead2pass Microsoft 70-458 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/70-458.html

         

Why Choose Lead2pass?

If you want to pass the exam successfully in first attempt you have to choose the best IT study material provider, in my opinion, Lead2pass is one of the best way to prepare for the exam.

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back