A healthcare organization receives patient records in CSV, JSON, and HL7 formats from multiple sources. They need to transform this data into a common schema for analysis. Which Azure service should they use for the transformation?

Azure Data Factory mapping data flows

A company needs to process a large batch of data overnight. They have a choice between using Azure Synapse Analytics dedicated SQL pool and Azure Databricks. The team is more proficient in SQL than Python. What is the most important factor in choosing Synapse over Databricks?

The team's SQL proficiency aligns with Synapse's T-SQL interface

Databricks does not support SQL

Synapse Analytics is always faster than Databricks for batch processing

Synapse Analytics is cheaper than Databricks for all workloads

A company uses Azure Databricks for ETL and wants to migrate to Microsoft Fabric to reduce management overhead. They have existing notebooks and Spark jobs. What is the primary consideration?

Fabric does not support Spark, so migration is impossible

Fabric is more expensive than Databricks for all workloads

Databricks notebooks cannot be exported

Compatibility of existing notebooks and Spark configurations with Fabric's Spark runtime

A company is designing a data platform. They need to support both structured data for SQL reporting and unstructured data for machine learning. They want to avoid duplicating data. Which architecture should they use?

Separate data warehouse and data lake

A data lake with a SQL query engine on top

Microsoft Certified:Azure Data Fundamentals

Domain 4Objective 1

Describe Common Elements of Large-Scale Analytics DP-900 Practice Questions (Page 1)

Part of the Describe an analytics workload on Azure domain, which accounts for 25–30% of the DP-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~5–9 in this domain), expect 2–3 from this objective — we provide 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

6concepts

25–30%of the exam

Questions 1–5

1application · medium
A healthcare organization receives patient records in CSV, JSON, and HL7 formats from multiple sources. They need to transform this data into a common schema for analysis. Which Azure service should they use for the transformation?
Select an answer first
2expert · hard
A company needs to process a large batch of data overnight. They have a choice between using Azure Synapse Analytics dedicated SQL pool and Azure Databricks. The team is more proficient in SQL than Python. What is the most important factor in choosing Synapse over Databricks?
Select an answer first
3expert · hard
A company uses Azure Databricks for ETL and wants to migrate to Microsoft Fabric to reduce management overhead. They have existing notebooks and Spark jobs. What is the primary consideration?
Select an answer first
4expert · hard
A company is designing a data platform. They need to support both structured data for SQL reporting and unstructured data for machine learning. They want to avoid duplicating data. Which architecture should they use?
Select an answer first
5application · medium
An e-commerce company stores all raw clickstream data in Azure Data Lake Storage Gen2. They now need to run SQL queries on this data for ad-hoc analysis without loading it into a separate data warehouse. Which Azure service should they use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-900

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-900” is a trademark of its owner, used for identification only.