Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 (070-463日本語版) - 070-463日本語 Exam Practice Test
Correct Answer: A
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Correct Answer: D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Correct Answer: D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
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.
Correct Answer:
Explanation
References:
http://msdn.microsoft.com/en-us/librar
http://msdn.microsoft.com/en-us/library/ms137728.aspx
