Free Microsoft 070-463 Exam Dumps Questions & Answers

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a Microsotf Azure SQL Data Warehouse instance. The package contains a data flow task that has 10 source-to-destination execution trees.
Only five of the source-to-destination execution trees are running in parallel.
You need to ensure that all the execution trees run in parallel.

• A.  Set the EngineThreads property of the data flow task to 10.
• B.  Create 10 data flow tasks that contain one source-to-destination execution tree each.
• C.  Set the MaxConcurrentExcecutables property of the package to 10.
• D.  Place the data flow task in a For Loop container configured to execute 10 times.

NO: 208
In your SSIS solution, you need to load a large set of rows into the database as quickly as possible.
The rows are stored in a delimited text file, and only one source column needs its data type converted from String (used by the source column) to Decimal (used by the destination column).
What control flow task would be most suitable for this operation?

• A.  The data flow task would have to be used, because the data needs to be transformed before it can be loaded into the table.
• B.  The File System task would be perfect in this case, because it can read data from files and can be configured to handle data type conversions.
• C.  The Bulk Insert task would be the most appropriate, because it is the quickest and can handle data type conversions.
• D.  No single control flow task can be used for this operation, because the data needs to be extracted from the source file, transformed, and then loaded into the destination table.At least three different tasks would have to be used--the Bulk Insert task to load the data into a staging database, a Data Conversion task to convert the data appropriately, and finally, an Execute SQL task to merge the transformed data with existing destination data.

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse.
You are developing the part of the SSIS package that populates the ProjectDates dimension table.
The business key of the ProjectDates table is the ProjectName column. The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table:
*ExpectedStartDate - New values should be tracked over time.
*ActualStartDate - New values should not be accepted.
*ExpectedEndDate - New values should replace existing values.
*ActualEndDate - New values should be tracked over time.
You use the SSIS Slowly Changing Dimension Transformation.
You must configure the Change Type value for each source column.
Which settings should you select? (To answer, select the appropriate setting or settings in the answer area.
Each Change Type may be used once, more than once, or not at all.)

Correct Answer:

Explanation

References:
http://msdn.microsoft.com/en-us/library/ms141715.aspx
http://msdn.microsoft.com/en-us/library/ms141662.aspx

You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A SQL Server Agent job is used to execute a package daily with the basic logging level.
Recently, the package execution failed because of a primary key violation when the package inserted data into the destination table.
You need to identify all previous times that the package execution failed because of a primary key violation.
What should you do?

• A.  Use an event handler for OnTaskFailed for the package.
• B.  Use an event handler for OnError for the package.
• C.  Deploy the .ispac file by using the Integration Services Deployment Wizard.
• D.  View the All Messages subsection of the All Executions report for the package.
• E.  Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
• F.  Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
• G.  View the job history for the SQL Server Agent job.
• H.  Use an event handler for OnError for each data flow task.
• I.  Create a SQL Server Agent job to execute the
  SSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures.
• J.  Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
• K.  Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.
• L.  Store the System::ServerExecutionID variable in the custom log table.
• M.  Deploy the project by using dtutil.exe with the /COPY SQL option.
• N.  Store the System::SourceID variable in the custom log table.
• O.  Enable the SSIS log provider for SQL Server for OnError in the package control flow.
• P.  Store the System::ExecutionInstanceGUID variable in the custom log table.
• Q.  Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.
• R.  Deploy the project by using dtutil.exe with the /COPY DTS option.

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).
You need to complete the post-installation configuration.
What should you do?

• A.  Run the dbimpexp.exe command.
• B.  Run the DQSInstaller.exe command.
• C.  Install ADOMD.NET.
• D.  Install the data providers that are used for data refresh.