Home » Microsoft » 70-767 » Which index types should you use?
DRAG DROP
A company is designing a database storage strategy. The company wants to segment online transaction processing (OLTP) and analytic workloads.
You need to design the workload.
Which index types should you use? To answer, drag the appropriate index types to the correct workloads. Each index type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
OLTP: nonclustered index
OLTP memory-optimized indexes. Such indexes must be one of the following:
Memory-optimized Nonclustered index (meaning the default internal structure of a B-tree)
Hash index
Real-time analytics: clustered columnstore
In Azure, all of the following data stores will meet the core requirements for OLAP:
SQL Server with Columnstore indexes
Azure Analysis Services
SQL Server Analysis Services (SSAS)
References:
https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/indexes-for-memory-optimized-tables
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-analytical-processing