Question 62 of 982

Describe an analytics workload on Azure →hardMultiple ChoiceObjective-mapped

Quick Answer

The answer is Azure Synapse Serverless SQL pool because it enables you to query data directly in Azure Data Lake without moving data, using T-SQL over Parquet files stored in Azure Data Lake Storage Gen2. This serverless engine processes queries on-demand, reading only the relevant partitions and columns, which eliminates data duplication and reduces latency for Power BI dashboards. On the DP-900 exam, this question tests your understanding of how to separate compute from storage—a core Azure data concept—and often appears as a scenario where analysts need ad-hoc SQL queries without provisioning dedicated resources. A common trap is choosing Azure SQL Database or dedicated Synapse pools, which require data movement; remember that “serverless” means no persistent infrastructure. Memory tip: think “Serverless = Stay in the Lake” to recall that the data never leaves its original location.

DP-900 Describe an analytics workload on Azure Practice Question

This DP-900 practice question tests your understanding of describe an analytics workload on azure. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

A marketing company stores years of historical campaign data in Azure Data Lake Storage Gen2 as Parquet files. Data analysts need to run complex SQL queries over this data to identify trends, and they want to visualize results in Power BI dashboards. The company wants to avoid moving data into a separate database to minimize duplication and latency. Which Azure service should they use to query the data directly in the data lake?

Clue words in this question

Noticing these words before you look at the options changes how you read each choice.

Clue: "minimum / minimize"
Why it matters: Asks for the least resource use — fewest addresses, smallest subnet, lowest overhead. Eliminate over-provisioned options even if they would technically work.

Question 1hardmultiple choice

Full question →

A
Azure Data Factory
Why wrong: Azure Data Factory is an ETL and orchestration service. It does not provide a direct SQL query interface over data in a data lake; it moves or transforms data but does not serve interactive queries.
B
Azure Synapse Serverless SQL pool
Serverless SQL pool (part of Azure Synapse Analytics) enables querying data directly from Azure Data Lake Storage using standard T-SQL. It is serverless (no infrastructure to manage) and perfect for ad-hoc analytics integration with Power BI.
C
Azure Databricks
Why wrong: Azure Databricks provides a Spark-based analytics platform. While it can query Parquet files, it requires using Spark SQL or notebooks, not standard T-SQL. It also involves cluster management and is not serverless by default.
D
Azure HDInsight
Why wrong: Azure HDInsight is a managed Hadoop/Spark service. It can query data in a data lake but requires provisioning a cluster, is more complex to manage, and is not ideal for simple ad-hoc SQL queries that integrate directly with Power BI.

Full breakdown with real-world context →

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Azure Synapse Serverless SQL pool

Azure Synapse Serverless SQL pool is the correct choice because it allows you to run T-SQL queries directly over Parquet files in Azure Data Lake Storage Gen2 without moving or copying the data. It uses a pay-per-query model and supports standard SQL syntax, making it ideal for analysts who need to query historical campaign data and visualize results in Power BI with minimal latency.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Azure Data Factory
Why it's wrong here
Azure Data Factory is an ETL and orchestration service. It does not provide a direct SQL query interface over data in a data lake; it moves or transforms data but does not serve interactive queries.
✓
Azure Synapse Serverless SQL pool
Why this is correct
Serverless SQL pool (part of Azure Synapse Analytics) enables querying data directly from Azure Data Lake Storage using standard T-SQL. It is serverless (no infrastructure to manage) and perfect for ad-hoc analytics integration with Power BI.
Clue confirmation
The clue word "minimum / minimize" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
✗
Azure Databricks
Why it's wrong here
Azure Databricks provides a Spark-based analytics platform. While it can query Parquet files, it requires using Spark SQL or notebooks, not standard T-SQL. It also involves cluster management and is not serverless by default.
✗
Azure HDInsight
Why it's wrong here
Azure HDInsight is a managed Hadoop/Spark service. It can query data in a data lake but requires provisioning a cluster, is more complex to manage, and is not ideal for simple ad-hoc SQL queries that integrate directly with Power BI.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often confuse Azure Data Factory (an ETL tool) with a query service, or they assume Azure Databricks is the only option for big data SQL queries, overlooking the serverless SQL pool's ability to query data in place without cluster management.

Detailed technical explanation

How to think about this question

Azure Synapse Serverless SQL pool uses a distributed query engine that reads Parquet files via the OPENROWSET function or external tables, leveraging columnar storage and predicate pushdown to optimize performance. It supports T-SQL syntax, including GROUP BY and JOINs, and integrates directly with Power BI through the Synapse SQL endpoint, enabling real-time dashboards without data movement. Under the hood, it uses the same compute nodes as dedicated SQL pools but dynamically allocates resources per query, making it cost-effective for intermittent workloads.

KKey Concepts to Remember

Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.

TExam Day Tips

Watch for words such as best, first, most likely and least administrative effort.
Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related DP-900 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Describe core data concepts practice questions

Practise DP-900 questions linked to Describe core data concepts.

Describe an analytics workload on Azure practice questions

Practise DP-900 questions linked to Describe an analytics workload on Azure.

Identify considerations for relational data on Azure practice questions

Practise DP-900 questions linked to Identify considerations for relational data on Azure.

Describe considerations for working with non-relational data on Azure practice questions

Practise DP-900 questions linked to Describe considerations for working with non-relational data on Azure.

DP-900 fundamentals practice questions

Practise DP-900 questions linked to DP-900 fundamentals.

DP-900 scenario practice questions

Practise DP-900 questions linked to DP-900 scenario.

DP-900 troubleshooting practice questions

Practise DP-900 questions linked to DP-900 troubleshooting.

Practice this exam

Start a free DP-900 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

DP-900 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this DP-900 question test?

Describe an analytics workload on Azure — This question tests Describe an analytics workload on Azure — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Azure Synapse Serverless SQL pool — Azure Synapse Serverless SQL pool is the correct choice because it allows you to run T-SQL queries directly over Parquet files in Azure Data Lake Storage Gen2 without moving or copying the data. It uses a pay-per-query model and supports standard SQL syntax, making it ideal for analysts who need to query historical campaign data and visualize results in Power BI with minimal latency.

What should I do if I get this DP-900 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Are there clue words in this question I should notice?

Yes — watch for: "minimum / minimize". Asks for the least resource use — fewest addresses, smallest subnet, lowest overhead. Eliminate over-provisioned options even if they would technically work.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more ways this is tested on DP-900

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. A company needs to run complex SQL queries on petabytes of data stored in Azure Data Lake Storage Gen2. They want to pay only for the queries they run and do not want to manage any infrastructure. Which Azure service should they use?

easy

✓ A.Azure Synapse Serverless SQL pool
B.Azure Synapse dedicated SQL pool
C.Azure SQL Database
D.Azure HDInsight

Why A: Azure Synapse Serverless SQL pool is the correct choice because it enables running complex SQL queries directly against data in Azure Data Lake Storage Gen2 without provisioning any infrastructure. It uses a pay-per-query billing model, charging only for the amount of data processed, which aligns with the requirement to pay only for queries run and avoid infrastructure management.

Keep practising

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.