DP-200 Azure Real-Time and Batch Analytics 2

Question 1

What Azure Synapse Analytics feature enables querying operational Azure Cosmos DB data using Spark or SQL without impacting the transactional workload?

Accepted Answer

Synapse Link for Azure Cosmos DB

Answer

Azure Synapse Link for Cosmos DB automatically syncs data to the Synapse analytical store, allowing Spark and SQL queries without any ETL or impact on Cosmos DB throughput.

Question 2

In Azure Databricks, what does the term 'cluster auto-scaling' mean?

Accepted Answer

Dynamically adding or removing worker nodes based on workload demand

Answer

Auto-scaling in Databricks dynamically adjusts the number of worker nodes between configured min and max values based on current job demands.

Question 3

Which file format is recommended for storing large analytical datasets in Azure Data Lake Storage for maximum query performance with columnar compression?

Accepted Answer

Parquet

Answer

Parquet is a columnar storage format that provides efficient compression and encoding, enabling fast analytical queries by reading only required columns.

Question 4

What is the key difference between Azure Event Hubs and Azure Service Bus for data platform scenarios?

Accepted Answer

Event Hubs is optimized for high-throughput event streaming; Service Bus is for reliable message queuing with ordering guarantees

Answer

Event Hubs is designed for telemetry streaming at millions of events/second, while Service Bus provides ordered, reliable messaging with features like dead-lettering for transactional scenarios.

Question 5

In Azure Synapse Analytics, which pool type should you use for interactive, ad-hoc SQL queries over data in ADLS Gen2 without pre-provisioning compute?

Accepted Answer

Serverless SQL pool

Answer

The Synapse serverless SQL pool enables pay-per-query T-SQL analytics over ADLS Gen2 files without provisioning or managing dedicated compute resources.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Real-Time and Batch Analytics 2