DP-200 Azure Data Storage Solutions

Question 1

Which Azure storage service is best suited for storing petabytes of unstructured data for big data analytics workloads?

Accepted Answer

Azure Data Lake Storage Gen2

Answer

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?

Accepted Answer

POSIX-compliant ACLs

Answer

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?

Accepted Answer

To support atomic directory operations and improve analytics performance

Answer

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?

Accepted Answer

Archive tier

Answer

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?

Accepted Answer

Querying data stored outside Synapse such as ADLS Gen2 without importing it

Answer

PolyBase external tables allow Synapse Analytics to query data stored in external sources like ADLS Gen2 or Azure Blob Storage without moving it.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Storage Solutions