CTS Consulting & Technical Support Database Architect Interview Questions and Answers

CAS stands for Columnstore Archive Storage in Azure SQL Database.

• CAS is a storage tier in Azure SQL Database that is optimized for cold data storage.

• It is designed to store large amounts of data that is infrequently accessed.

• CAS uses columnstore indexing to achieve high compression rates and reduce storage costs.

• Data can be moved to CAS using the ALTER TABLE command in SQL Server Management Studio.

• CAS is a cost-effecti...read more