PrepAway - Latest Free Exam Questions & Answers

What should you identify?

You have a customer who has several SQL Server 2012 database servers.
You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes.
The customer identifies that the following must be supported for the column store indexes.
Data manipulation language (DML) statements
Nonclustered columnstore indexes
Clustered columnstore indexes
Partitioning
You need to identify which technology requires the customer to implement an SQL Server 2014 database.
What should you identify?

PrepAway - Latest Free Exam Questions & Answers

A.
clustered columnstore indexes

B.
nonclustered columnstore indexes

C.
data manipulation language (DML) statements

D.
partitioning

Explanation:
SQL Server 2014 has the features of SQL Server 2012 plus updateable clustered columnstore indexes. This
feature is required here as DML statements must be supported in the warehouse.
Columnstore Indexes Described
https://msdn.microsoft.com/en-us/library/gg492088(v=sql.120).aspx


Leave a Reply