070-463日本語 Exam Training Practice Tests (Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 (070-463日本語版))]

Question 1

Correct Answer:

Explanation
Box 1: Create the fact table.
Box 2: Load the data.
Box 3: Create the columnstore index with the MAXDOP keyword.
Only nonclustered columnstore indexes are available in SQL Server 2012 so when the index is created, you cannot update the table (without using partition switching). Therefore you have to load the data BEFORE creating the index.
In SQL Server 2014, you could create a clustered columnstore index which would allow updates to the table after the index is created.

Question 2

Correct Answer:

Explanation

Question 3

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

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

Correct Answer:

Explanation

Question 5

Correct Answer:

Explanation

Question 6

A. Option E B. Option D C. Option B D. Option A E. Option C

Correct Answer: A,B

Question 7

A. Pivot B. DQS Cleansing C. Merge Join D. Conditional Split

Correct Answer: D

Question 8

A. OnPostExecute B. OnVariableValueChanged C. OnExecStatusChanged D. OnWarning

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 9

A. 1. FactFinance
2. DimOrganization, DimScenario, DimAccount in parallel
3. DimCurrency B. DimCurrency, DimOrganization in parallel
2. DimScenario, DimAccount in parallel
3. FactFinance C. 1. DimCurrency
2. DimOrganization
3. DimScenario, DimAccount in parallel
4. FactFinance D. 1. DimCurrency, FactFinance in parallel
2. DimOrganization, DimScenario, DimAccount in parallel E. 1. DimCurrency, DimScenario, DimAccount in parallel
2. DimOrganization
3. FactFinance

Correct Answer: E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 10