Microsoft
70-465 · Question #155
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 correct answer is A. clustered columnstore indexes. 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. https://msdn.microsoft.com/en-us/library/gg492088(v=sql.120).aspx
Submitted by takeshi77· Mar 5, 2026Design and implement a data warehousing solution
Question
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?
Options
- Aclustered columnstore indexes
- Bnonclustered columnstore indexes
- Cdata manipulation language (DML) statements
- Dpartitioning
How the community answered
(41 responses)- A88% (36)
- B7% (3)
- C2% (1)
- D2% (1)
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. https://msdn.microsoft.com/en-us/library/gg492088(v=sql.120).aspx
Topics
#columnstore indexes#SQL Server 2014#data warehousing#clustered columnstore indexes
Community Discussion
No community discussion yet for this question.