DP-200 Azure Data Storage Solutions 3

Question 1

When should you choose Azure SQL Database Hyperscale over a standard Azure SQL Database tier?

Accepted Answer

When the database size exceeds 4 TB

Answer

Azure SQL Hyperscale supports databases up to 100 TB and is the appropriate choice when data size exceeds the 4 TB limit of standard tiers.

Question 2

In Azure SQL Data Warehouse (now Synapse Analytics dedicated pool), what distribution method minimizes data movement for large fact tables joined frequently with dimension tables?

Accepted Answer

Hash distribution on the join key

Answer

Hash distributing a large fact table on its join key co-locates matching rows on the same compute node, eliminating data movement during joins.

Question 3

Which Azure storage option is most appropriate for storing semi-structured IoT telemetry data that requires millisecond reads by device ID?

Accepted Answer

Azure Table Storage

Answer

Azure Table Storage is a key-value NoSQL store optimized for fast point lookups by partition key (e.g., device ID) at low cost.

Question 4

What is the primary advantage of using Azure Data Lake Storage Gen2 over Azure Blob Storage for analytics workloads?

Accepted Answer

Hierarchical namespace enabling faster analytics operations

Answer

ADLS Gen2's hierarchical namespace makes directory-level operations atomic and significantly faster, improving analytics throughput.

Question 5

Which feature in Azure Synapse Analytics allows querying CSV or Parquet files in ADLS Gen2 without creating a dedicated SQL pool?

Accepted Answer

Serverless SQL pool

Answer

Synapse serverless SQL pool enables on-demand T-SQL queries over files in ADLS Gen2 with no infrastructure to provision.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Storage Solutions 3