1
Single choice~60s
What does the hierarchical namespace feature in Azure Data Lake Storage Gen2 provide?
Azure Data Engineer Associate
AZURE_DP_203Ready to test yourself?
A timed, blueprint-proportional exam drawn fresh from this bank — with a per-domain score report.
🔓 Free preview: showing 10 of 60 questions. Unlock the full bank — every question, explanation, and reference.
Unlock all 60 questions →10 questions across 5 topics. Choose an answer for each question, then check it to see the correct answer and explanation.
Filter by topic
10 questions in Data Storage Design & Implementation
DATA_STORAGE
Data Storage Design & Implementation
10 questions in topicData Lake Storage, medallion architecture, Synapse storage pools, distributions, and file formats.
2
Single choice~80s
In the medallion architecture, what does the Bronze layer contain?
3
Single choice~80s
What is a dedicated SQL pool in Azure Synapse Analytics?
4
Single choice~85s
What is the key characteristic of a serverless SQL pool?
5
Single choice~80s
Which dedicated SQL pool distribution strategy assigns rows based on a hash of a chosen column?
6
Single choice~85s
Which table type stores a full copy of the data on every compute node in a dedicated SQL pool?
7
Single choice~100s
What is the default and most efficient storage format for large tables in a dedicated SQL pool?
8
Single choice~80s
What characterizes the Parquet file format?
9
Single choice~85s
What does Delta Lake add on top of standard data lake storage?
10
Single choice~80s
What does a Type 2 slowly changing dimension (SCD) technique do?