DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ1

Monitor, configure, and optimize database resources

You have an Azure subscription containing an Azure SQL database. The database includes a table named tablet that uses partitioned columnstores.

You need to configure table1 to meet these requirements:

  • Every partition must be compressed.
  • The compression ratio must be maximized.
  • You must be able to index the compressed data.

What should you use?

Explanation

Columnstore archival compression (COLUMNSTORE_ARCHIVE) further compresses columnstore data to reduce its size beyond standard columnstore compression, and it can be configured for each partition of a partitioned columnstore table or index. Unlike data produced by the COMPRESS function, this remains columnstore data and can be indexed.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!