Administering a SQL Database Infrastructure — Question 185

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?

Answer options

Correct answer: A

Explanation

The correct answer is A, as clustered columnstore indexes with partitioning were introduced in SQL Server 2014, making it necessary to upgrade from SQL Server 2012. The other options, such as DML statements and nonclustered columnstore indexes, are supported in SQL Server 2012 and do not require the upgrade.