Practice Test GeeksDP-200 - Microsoft Azure Data Solutions Practice Test
← All DP-200 Flashcard Decks

Azure Real-Time and Batch Analytics Flashcards

6 cards from real DP-200 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Azure Real-Time and Batch Analytics flashcards as text

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

    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.

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

    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.

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

    Answer: Parquet

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

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

    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.

  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?

    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.

  6. Which Azure service enables you to build real-time dashboards and reports from streaming data ingested through Azure Event Hubs?

    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.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. learn.microsoft.com — Eligibility, renewal, score validity, retake policy, passing score, score release, exam information · verified Nov 2026
  2. pearsonvue.com — Test delivery · verified Nov 2026