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

QUESTION 32
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You add an Execute SQL task to the control flow. The task must execute a simple INSERT statement. The task has the following requirements:
* The INSERT statement must use the value of a string package variable. The variable name is StringVar.
* The Execute SQL task must use an OLE DB Connection Manager. In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only parameter.
You must configure the SQLStatement property of the Execute SQL task. Which SQL statement should you use?

A.    INSERT INTO dbo.Table (variablevalue) VALUES ($Project::StringVar)
B.    INSERT INTO dbo.Table (variablevalue) VALUES (@StringVar)
C.    INSERT INTO dbo.Table (variablevalue) VALUES ($Package::StringVar)
D.    INSERT INTO dbo.Table (variablevalue) VALUES (?)

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms141003.aspx
http://msdn.microsoft.com/en-us/library/ms140355.aspx
http://msdn.microsoft.com/en-us/library/cc280502.aspx

QUESTION 33
Drag and Drop Question
You are building a SQL Server Integration Services (SSIS) package to load data from all files that are automatically copied to a directory each night through an external FTP process. You need to load data from all copied files to a destination table in SQL Server. Which three steps 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
Explanation:
http://msdn.microsoft.com/en-us/library/ms141724.aspx
http://msdn.microsoft.com/en-us/library/ms137728.aspx

QUESTION 34
You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to Supported. You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes. What should you do?

A.    Change the TransactionOption property of the package to Required.
B.    Change the TransactionOption property of all three Execute SQL tasks to Required.
C.    Move the three Execute SQL tasks into a Sequence container.
D.    Move the three Execute SQL tasks into a Foreach Loop container.

Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/ms137749.aspx
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtstransactionoption.aspx

QUESTION 35
You are designing a SQL Server Integration Services (SSIS) 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.    OnWarning
B.    OnVariableValueChanged
C.    OnExecStatusChanged
D.    OnPostExecute

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

QUESTION 36
You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse. You are importing data from a relational table named Projects. The table has change data capture enabled on all columns. You need to process only the most recent values from rows that have been inserted or updated since the previous execution of the package. Which query should you use as the data source?

A.    SELECT * FROM cdc.fn_cdc_get_all_changes_Projects (@from_lsn, @to_lsn, N’ all update old’)
B.    SELECT * FROM cdc.fn_cdc_get_all_changes_Projects (@from_lsn, @to_lsn, N’ all’)
C.    SELECT * FROM cdc.fn_cdc_get_net_changes_Projects (@from_lsn, @to_lsn)
D.    SELECT * FROM cdc.Projects_CT WHERE @from_lsn >= _$start_lsn AND @to_lsn < _$start_lsn

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/bb522511.aspx
http://msdn.microsoft.com/en-us/library/bb510627.aspx
http://msdn.microsoft.com/en-us/library/cc645937.aspx

QUESTION 37
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. The package includes a data flow and is executed on ServerB. The destination table has its own identity column. The destination data load has the following requirements:
* The identity values from the source table must be used.
* Default constraints on the destination table must be ignored.
* Batch size must be 100,000 rows.
You need to add a destination and configure it to meet the requirements. Which destination should you use?

A.    ADO NET Destination with Bulk Insert
B.    SQL Server Destination
C.    OLE DB Destination with Fast Load
D.    ADO NET Destination without Bulk Insert
E.    OLE DB Destination without Fast Load

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ms141237.aspx
http://msdn.microsoft.com/en-us/library/ms139821.aspx
http://msdn.microsoft.com/en-us/library/ms141095.aspx

QUESTION 38
You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages. The new capability is not available as an SSIS task. Each package must be extended with the same new capability. You need to add the new capability to all the packages without copying the code between packages. What should you do?

A.    Use the Expression task.
B.    Use the Script component.
C.    Use the Script task.
D.    Develop a custom task.
E.    Develop a custom component.

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

QUESTION 39
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 SQL Azure. 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.    Source Assistant
B.    Audit
C.    Destination Assistant
D.    Script Component

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms137640.aspx
http://msdn.microsoft.com/en-us/library/ms141150.aspx
http://msdn.microsoft.com/en-us/library/ff929138.aspx
http://msdn.microsoft.com/en-us/library/ff929116.aspx

QUESTION 40
To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place. The methodology has the following requirements:
* The deployment process must be simplified.
* All the logs must be centralized in SQL Server.
* Log data must be available via reports or T-SQL.
* Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?

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

Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx

If you want to pass Microsoft 70-458 successfully, donot missing to read latest lead2pass Microsoft 70-458 practice tests.
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