Free Microsoft 70-467 Exam Dumps Questions & Answers

You need to create the factCustomerContact table.
Which type of table should you create?

• A.A fact table with an additive measure
• B.A factless fact table
• C.A periodic snapshot fact table
• D.A fact table with a non-additive measure

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
Box 1:

Box 2:

Box 3:

Note:
* You are going to become very very familiar indeed with [catalog].[executions]. It is a view that provides a record of all package executions on the server and, most importantly, it contains [execution_id] - the identifier for each execution and the field to which all other objects herein will be related.

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.

You have the following requirements:
* Ensure that queries of the data model correctly display average student age by class and average class level by student.
* Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create a multidimensional project and define measures and a many-to-many dimensional relationship.
• B.Create a tabular project and define calculated columns.
• C.Create a tabular project and define measures.
• D.Create a multidimensional project and define measures and a reference relationship.

You have a business intelligence (BI) solution that uses SQL Server Integration Services (SSIS). The BI solution includes an extract transformation, and load (ETL) system.
You are designing a logging and auditing strategy for the ETL system.
You need to ensure that an ETL administrator can view the row counts of any data flow path for each package execution.
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
Box 1:

Box 2:

Box 3:

You need to implement a strategy for efficiently storing sales order data in the data warehouse.
What should you do?

• A.Create daily partitions in the factOrders table.
• B.Separate the factOrders table into multiple tables, one for each day that has orders, and use a local partitioned view.
• C.Separate the factOrders table into multiple tables, one for each month that has orders, and use a local partitioned view.
• D.Create monthly partitions in the factOrders table.