Box 1: Azure SQL Data Warehourse
Scenario: Relecloud plans to implement a data warehouse named DB2.
Box 2: Clustered Columnstore index
Columnstore index is a new type of index introduced in SQL Server 2012. It is a column-based non-clustered index geared toward increasing query performance for workloads that involve large amounts of data, typically found in data warehouse fact tables.
A clustered columnstore index is the physical storage for the entire table.
Relecloud identifies the following requirements for DB2:
DB2 must be able to store more than 40 TB of data.