How should you complete the Transact-SQL code?

HOTSPOT
You create a database table named FactSales by running the following Transact-SQL statements:

You must optimize the indexes without making changes to the ix_FactSales_EmployeeKey index.
You need to implement a columnstore index for the table.
How should you complete the Transact-SQL code? To answer, select the appropriate Transact-SQL segments
in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

HOTSPOT
You create a database table named FactSales by running the following Transact-SQL statements:

You must optimize the indexes without making changes to the ix_FactSales_EmployeeKey index.
You need to implement a columnstore index for the table.
How should you complete the Transact-SQL code? To answer, select the appropriate Transact-SQL segments
in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Show Hint

← Previous question

Next question →