DP-200 Azure Data Storage Solutions 1 — Questions and Answers
Question 1: Which Azure storage service is best suited for storing petabytes of unstructured data for big data analytics workloads?
- Azure Blob Storage
- Azure Data Lake Storage Gen2 (Correct answer)
- Azure Table Storage
- Azure Queue Storage
Correct answer: Azure Data Lake Storage Gen2
Azure Data Lake Storage Gen2 is specifically designed for big data analytics with hierarchical namespace support and petabyte-scale capacity.
Question 2: When configuring Azure Data Lake Storage Gen2, which authentication method provides the finest-grained access control at the file and directory level?
- Shared Access Signatures (SAS)
- Storage Account Keys
- POSIX-compliant ACLs (Correct answer)
- Azure AD OAuth tokens only
Correct answer: POSIX-compliant ACLs
POSIX-compliant ACLs in ADLS Gen2 allow granular access control at the file and directory level, beyond what RBAC alone provides.
Question 3: What is the purpose of the hierarchical namespace feature in Azure Data Lake Storage Gen2?
- To enable geo-replication
- To support atomic directory operations and improve analytics performance (Correct answer)
- To enable static website hosting
- To provide CDN capabilities
Correct answer: To support atomic directory operations and improve analytics performance
Hierarchical namespace enables atomic directory operations, which dramatically improves analytics job performance by reducing overhead.
Question 4: Which Azure Blob Storage access tier is most cost-effective for data that is rarely accessed and stored for at least 180 days?
- Hot tier
- Cool tier
- Archive tier (Correct answer)
- Premium tier
Correct answer: Archive tier
The Archive tier offers the lowest storage cost for data accessed infrequently, with a recommended minimum retention of 180 days.
Question 5: In Azure Synapse Analytics, what is a PolyBase external table used for?
- Storing relational data inside Synapse
- Querying data stored outside Synapse such as ADLS Gen2 without importing it (Correct answer)
- Creating in-memory indexes
- Encrypting data at rest
Correct answer: Querying data stored outside Synapse such as ADLS Gen2 without importing it
PolyBase external tables allow Synapse Analytics to query data stored in external sources like ADLS Gen2 or Azure Blob Storage without moving it.
Question 6: Which replication option provides the highest durability for Azure Storage by maintaining six copies across two geographically separated data centers?
- Locally Redundant Storage (LRS)
- Zone-Redundant Storage (ZRS)
- Geo-Redundant Storage (GRS)
- Geo-Zone-Redundant Storage (GZRS) (Correct answer)
Correct answer: Geo-Zone-Redundant Storage (GZRS)
GZRS combines zone redundancy within the primary region and geo-replication to a secondary region, providing the highest overall durability.
DP-200 Azure Data Storage Solutions 1
Which Azure storage service is best suited for storing petabytes of unstructured data for big data analytics workloads?