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

When you need geo-replication only

Answer

When using MongoDB APIs

Answer

When cost is the primary concern

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

Round-robin distribution

Answer

Replicated tables

Answer

Heap distribution

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 SQL Database

Answer

Azure File Storage

Answer

Azure Queue Storage

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

Lower cost per GB

Answer

Built-in machine learning capabilities

Answer

Automatic schema detection

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 Link

Answer

Dedicated SQL pool

Answer

Spark pool

Question 6

In a lambda architecture on Azure, which component serves the speed layer for low-latency real-time queries?

Accepted Answer

Azure Stream Analytics or Event Hubs with real-time consumers

Answer

Azure Data Factory

Answer

Azure Blob Storage

Answer

Azure Data Lake Analytics