DP-900 Describe an analytics workload on Azure Practice Question

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 incorrect because it is a data integration and orchestration service used to build ETL/ELT pipelines, not a query engine. It cannot execute ad-hoc T-SQL queries against CSV files; it simply moves or transforms data from one location to another, typically invoking other compute services like SQL pools, Azure Databricks, or HDInsight. While ADF could potentially copy the CSV data into a queryable store, that introduces unnecessary steps and contradicts the requirement for analysts to directly query the logs without data movement or pipeline orchestration.

  When this WOULD be correct

  A company needs to ingest web server logs from multiple sources, transform them (e.g., clean, aggregate), and load the processed data into a data warehouse or lake on a scheduled basis. Azure Data Factory would be the correct choice for building and managing these data pipelines.

• ✓

  Azure Synapse Serverless SQL pool

  Why this is correct

  Azure Synapse Serverless SQL pool is the correct choice because it provides a serverless T-SQL query engine that reads files directly from Azure Data Lake Storage without requiring data to be loaded into a database. It can query terabytes of CSV logs on demand, using compute resources that scale automatically with the amount of data scanned, making it ideal for ad-hoc analysis with zero infrastructure provisioning. The service supports metadata inference for CSV files and integrates with standard T-SQL tools, so analysts can immediately run SQL queries over the raw log data exactly where it is stored.

• ✗

  Azure SQL Database

  Why it's wrong here

  Azure SQL Database is incorrect because it is a fully managed relational database that requires data to be physically imported into tables before any query can execute. The requirement explicitly calls for keeping data in place and running ad-hoc SQL queries on CSV files, but Azure SQL Database would force you to move, transform, and load the terabytes of log data into storage, incurring data movement costs, latency, and ongoing storage charges. Moreover, it is not designed to directly query external files like CSV, so it fails the core 'query in place' requirement.

  When this WOULD be correct

  For a scenario where structured data is already stored in Azure SQL Database and needs to be queried with complex joins, or when migrating an on-premises SQL Server database to a managed cloud service with minimal changes.

• ✗

  Azure HDInsight

  Why it's wrong here

  HDInsight is a managed cluster service for big data frameworks like Spark and Hadoop, not a serverless SQL query engine. It fails because the analysts need ad-hoc SQL queries without provisioning or managing clusters, and HDInsight requires configuring and scaling an active cluster to run interactive queries. It is tempting because HDInsight supports SQL-like interfaces (e.g., Hive or Spark SQL) and can query CSV files in Data Lake Storage, making it a correct choice for batch processing or ETL workloads where cluster management is acceptable.

  When this WOULD be correct

  A company needs to run complex, batch-oriented transformations (e.g., ETL) on terabytes of web logs using custom MapReduce or Spark code, and they are willing to manage a Hadoop/Spark cluster. The question would specify the need for distributed processing frameworks like Spark or Hive.

Option-by-option analysis

Why each answer is right or wrong

Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.

Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”

Go deeper

Related to this question