ADW Bootcamp Week 3 PreQuiz

An informative and engaging image depicting a data center with visual elements representing data compression, columnstore indexing, and performance optimization in data warehousing. Include a futuristic digital design theme.

ADW Bootcamp CCI Quiz

Welcome to the ADW Bootcamp Week 3 PreQuiz! This challenging quiz is designed to test your knowledge of Clustered Columnstore Index (CCI) and its practical applications. Perfect for anyone looking to sharpen their skills in data warehousing and performance optimization.

10 engaging questions
Multiple-choice format
Score based on correct answers

10 Questions2 MinutesCreated by OptimizingData42

What are the main benefits of CCI (Clustered Columnstore Index) (5)

Candidates for CCI should have a minimum of?

3M rows / Partition

30M rows / Partition

60M rows / Partition

What are major ADW health performance impacts when using CCI?

Small Compressed Rowgroups

High number of updated or deleted rows

Uncompressed rows

All of the above

In altering a table to/from CCI - Which is faster?

Use CTAS to convert

Use Drop/Create Columnstore Index on table

Which of the following is a good practice when using a CCI table?

Use CCI on Dimension Table

Use Select * to query CCI table

Using Windowing Functions with Range Select

Using partitions with less than 1M rows

Use CCI on Fact Table

Ordered CCI characteristics

Rows in new Segments are sorted before compression

Existing segments are NOT re-processed on Insert/Update

Enhances scan performance

Enhances segment elimination

Order column cannot be varchar()

All of the above

What is the purpose of Statistics Usage? (6)

Estimate number of rows impacted by query

Estimate Costs to Execution Plan

Choose plan based on lowest cost

A Good estimation accurately reflects rows processed

Enables the best plan to be chosen

Auto Update should be used

Need to be proactively managed

ADW Bootcamp Week 3 PreQuiz

ADW Bootcamp CCI Quiz

More Quizzes