ADW Bootcamp Week 2 PreQuiz

A colorful and informative illustration of data warehousing concepts, featuring tables, graphs, and geometric shapes representing distribution strategies in a modern digital style.

ADW Bootcamp Week 2 PreQuiz

Test your knowledge of data warehousing concepts with our engaging ADW Bootcamp Week 2 PreQuiz! This quiz is designed for learners and professionals alike. Challenge yourself and see how well you understand key distribution strategies and table management techniques.

Multiple choice questions
Topics include replication, hash key selection, and table distributions
Instant feedback on your answers

13 Questions3 MinutesCreated by AnalyzingData101

If you have a table of new information that needs to be merged into the existing table which geometry would you pick?

Hash

Round_Robin

Replicate

What should be done with a Dim table > 2GB but is used in joins to several fact tables? Select all possible things to try. (more than 1)

Set up as Round_Robin with Clustered Index

Split table into 2 tables, one with main attributes used in reporting and the other with most of the large Varchar fields to bring table under 2GB

Hash on Join key if table is > 60M rows

Leave as is, it's ok if a few Dim tables are > 2GB

Which answer is not true for what it means for a table to be distributed?

Each table is divided into 60 distributions

Each distribution is implemented as a distinct table

Date joins across the distributions

Each distribution holds unique data

Distributed tables can be partitioned

No data is repeated in different distributions

What happens when you attempt to merge a Replicate geometry into a Replicate geometry?

The process is significantly faster due to running on all compute nodes

The process is slowed down significantly because the entire process will take place on Node 1 and all other Nodes will be idle

Round_Robin tables are good for? (3)

Data Sink / Staging tables

When No Candidate key can be identified for HASH

It is Final Target Table

Used in queries where it is joined to other tables

Not a good candidate for Replicated Table

What are the 3 criteria for picking a Hash distribution key? (3)

Minimize Data Movement

Balanced Execution

Use Default value for key instead of NULL

Minimize Data Skew

When would you use a Round_Robin table? (3)

For Data Sink/Staging Tables

Fast writes

Data will be used in a later process in the transformation logic

Tables over 60M rows

ADW Bootcamp Week 2 PreQuiz

ADW Bootcamp Week 2 PreQuiz

More Quizzes