DP-200 Azure Real-Time and Batch Analytics 2 — Questions and Answers
Question 1: What Azure Synapse Analytics feature enables querying operational Azure Cosmos DB data using Spark or SQL without impacting the transactional workload?
- Synapse Link for Azure Cosmos DB (Correct answer)
- Cosmos DB Change Feed
- Azure Data Factory Copy
- PolyBase external tables
Correct answer: Synapse Link for Azure Cosmos DB
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?
- Automatically upgrading the Databricks runtime version
- Dynamically adding or removing worker nodes based on workload demand (Correct answer)
- Automatically partitioning data in Delta tables
- Scaling storage independently of compute
Correct answer: Dynamically adding or removing worker nodes based on workload demand
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?
- CSV
- JSON
- Parquet (Correct answer)
- XML
Correct answer: Parquet
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?
- Service Bus supports higher throughput than Event Hubs
- Event Hubs is optimized for high-throughput event streaming; Service Bus is for reliable message queuing with ordering guarantees (Correct answer)
- Event Hubs supports dead-lettering; Service Bus does not
- Service Bus retains messages indefinitely; Event Hubs deletes them immediately
Correct answer: Event Hubs is optimized for high-throughput event streaming; Service Bus is for reliable message queuing with ordering guarantees
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?
- Dedicated SQL pool
- Serverless SQL pool (Correct answer)
- Spark pool
- Data Explorer pool
Correct answer: Serverless SQL pool
The Synapse serverless SQL pool enables pay-per-query T-SQL analytics over ADLS Gen2 files without provisioning or managing dedicated compute resources.
Question 6: Which Azure service enables you to build real-time dashboards and reports from streaming data ingested through Azure Event Hubs?
- Azure Analysis Services
- Power BI with streaming datasets (Correct answer)
- Azure Synapse Analytics dedicated pool
- Azure Data Factory
Correct answer: Power BI with streaming datasets
Power BI streaming datasets accept real-time data pushes (e.g., from Stream Analytics) and update dashboards live without data being stored first.
DP-200 Azure Real-Time and Batch Analytics 2
What Azure Synapse Analytics feature enables querying operational Azure Cosmos DB data using Spark or SQL without impacting the transactional workload?