Microsoft 70-467 Exam Practice Test Instant Access

Question 1

You execute the SalesbyCategory report and receive the following error message: "Members, tuples, or sets must use the same hierarchies in the function."

You need to ensure that the query executes successfully.

Which two actions should you perform? Each correct answer presents part of the solution.

AMove the Product clause from line 08 to line 10.

BMove the Date and Product clauses on line 11 to axis 0.

CMove the Date clause from line 10 to line 08.

DMove the Measures clause on line 02 to axis 1.

Answer : C

Question 2

You need to recommend a cube architecture for CUBE1. The solution must meet the performance requirements for CUBE1.

Which two partitions should you recommend creating? Each correct answer presents part of the solution.

APartitions based on the values of the customerID column in the dimension table

BPartitions based on the values of the customerID column in the fact table

CPartitions based on the values of the productID column in the fact table

DPartitions based on the values of the productID column in the dimension table

Answer : A, D

Question 3

You need to update the Execute SQL task in the OnVariableValueChanged event handler of all SSIS packages.

Which additional variable should be logged?

ASystem::ExecutionInstanceGUID

BSystem::ServerExecutionID

CSystem::VariableID

DSystem::SourceID

Answer : C

Question 4

You need to develop the tabular project to support the date analysis requirements.

What should you do?

ACreate one date table named Date.
* Create an active relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
* Create an inactive relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.

BCreate two date tables, one named Order Date and one named Ship Date.
* Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
* Create an inactive relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.

CCreate one date table named Date.
* Create an active relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
* Create an inactive relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.

DCreate two date tables, one named Order Date and one named Ship Date.
* Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
* Create an active relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.

Answer : C

Question 5

You need to identify the reasons that data alert notifications are not being sent.

Which of the following reasons are possible? (Each correct answer presents a complete solution. Choose al that apply.)

AThe shared schedule is paused.

BThe data source used by the report is disabled.

CThe SSRS service is not running.

DThe report data has not changed since the previous notification

EThe SQL Server Agent is not running.

FThe SSRS encryption key has been deleted.

Answer : C, E

One possibility is that no SQL Server Agent alerts have been configured. This is a free, easy way to get notified of corruption, job failures, or major outages even before monitoring systems pick it up.

Question 6

You need to design the dimCustomers table.

Which design approach should you use?

AReference dimension

BType 2 slowly changing dimension

CJunk dimension

DConformed dimension

EType 1 slowly changing dimension

Answer : B

Question 7

You need to select the appropriate mode for the Sales database.

Which mode should you select?

AROLAP

BDirect Query

CMOLAP

DIn-Memory

Answer : B

Microsoft 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Exam Practice Test