ADW Bootcamp Week 1 PreQuiz
ADW Bootcamp Week 1 PreQuiz
Welcome to the ADW Bootcamp Week 1 PreQuiz! This interactive quiz is designed to test your knowledge of the Advanced Data Warehouse (ADW) system components as well as key concepts related to data distribution and processing.
Prepare yourself for a series of engaging questions covering:
- ADW system components
- Data distribution methods
- Importance of surrogate keys
What are the components of the ADW system? (4)
SQL Database Storage
Compute Node
Control Node
DataBricks Delta
Blob/ADLS Remote Storage
OnPrem SQL Server
What are 3 goals for a Distribution Key? (3)
Minimize Data Movement
Minimize Data Skew
Limit Duplicate Data
Columnstore Compression
Balanced Execution
Partition Data by key
What is the purpose of a Surrogate Key? (2)
Applies a unique identifier for every row in a Dimension Table
A compressed descriptive of Natural Key
Transforms data for Customer Reporting needs
Replaces Natural Keys Used in Fact tables to point to a unique row in Dimension
{"name":"ADW Bootcamp Week 1 PreQuiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Welcome to the ADW Bootcamp Week 1 PreQuiz! This interactive quiz is designed to test your knowledge of the Advanced Data Warehouse (ADW) system components as well as key concepts related to data distribution and processing.Prepare yourself for a series of engaging questions covering:ADW system componentsData distribution methodsImportance of surrogate keys","img":"https:/images/course1.png"}