Free Microsoft 70-463 Exam Dumps Questions & Answers

You are designing a complex SQL Server Integration Services (SSIS) project that uses the Project Deployment model.
The project will contain between 15 and 20 packages. All the packages must connect to the same data source and destination.
You need to define and reuse the connection managers in all the packages by using the least development effort.
What should you do?

• A.  Implement parent package variables in all packages.
• B.  Implement project connection managers.
• C.  Implement package connection managers.
• D.  Copy and paste the connection manager details into each package.

You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog.
You need to add the Environment to the project.
Which stored procedure should you use?

• A.  catalog.set_execution_parameter_value
• B.  catalog.create_environment_variable
• C.  catalog.set_environment_variable_value
• D.  catalog.create_environment_reference

You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.
Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.
You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented.
What should you do?

• A.  Create a Type 2 slowly changing dimension for the geography dimension.
• B.  Implement change tracking.
• C.  Create a conformed dimension for the geography dimension.
• D.  Create a degenerate dimension for the geography dimension.

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain.
You need to complete the mapping of the Group column.
What should you do?

• A.  Add a domain for the Group column.
• B.  Add a column mapping for the Group column.
• C.  Create a composite domain that includes the Group column.
• D.  Map a composite domain to the source column.

You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow component of the package.
Which three 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.)

Correct Answer:

Explanation
1. Run with verbose settings
2. Get Execution ID from .executions
3. Get stats from .execution_data_statistics ( rows_sent )
Ref: http://msdn.microsoft.com/en-us/library/hh230986.aspx