ADW Bootcamp Week 2 PreQuiz
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
Replicate Tables should be? (3)
Less than 2GB
Infrequently modified
Good fit for Dimensions
Good for Report output
Good fit for staging tables
Tables are Distributed across how many distributions?
1
30
60
Tables aren't distributed across Distributions
None of the above
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
{"name":"ADW Bootcamp Week 2 PreQuiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsTopics include replication, hash key selection, and table distributionsInstant feedback on your answers","img":"https:/images/course1.png"}