Microsoft DP-900: Microsoft Azure Data Fundamentals

Last checked October 22, 2026 against the official Microsoft exam page.

1. Question 1Relational data on Azure

   A company needs a fully managed relational database service on Azure that handles patching, backups, and high availability. Which service should be used?

   1. AAzure SQL Database
   2. BAzure Cosmos DB
   3. CAzure Cache for Redis
   4. DAzure Blob Storage
   Show answer and explanationHide answer

   Correct answer: A

   Azure SQL Database is a managed relational service that handles patching, backups and high availability. Cosmos DB is a multi-model NoSQL service, Blob Storage stores objects, and Redis is an in-memory cache.

2. Question 2Core data concepts

   A retailer stores customer orders in a table where every row has the same columns, such as order ID, customer ID, and total. What type of data is this?

   1. ASemi-structured data
   2. BStreaming data
   3. CStructured data
   4. DUnstructured data
   Show answer and explanationHide answer

   Correct answer: C

   Structured data follows a fixed schema with defined columns, as in relational tables. Semi-structured data such as JSON has flexible fields, and unstructured data such as images has no schema.

3. Question 3Non-relational data on Azure

   An application stores user profiles with flexible attributes and needs low-latency reads at global scale with a key-value or document model. Which service fits best?

   1. AAzure Data Factory
   2. BAzure Monitor
   3. CAzure SQL Database
   4. DAzure Cosmos DB
   Show answer and explanationHide answer

   Correct answer: D

   Cosmos DB is a globally distributed multi-model database with low-latency reads and flexible documents. SQL Database is relational, Data Factory orchestrates data movement, and Monitor collects telemetry.

4. Question 4Analytics workloads on Azure

   Which TWO are typical Azure services for analytics and reporting? (Choose two.)

   1. AAzure Synapse Analytics
   2. BAzure Cache for Redis as the main analytics engine
   3. CAzure Front Door for querying data
   4. DAzure Files for analytical queries
   5. EPower BI for reports and dashboards
   Show answer and explanationHide answer

   Correct answer: A, E

   Synapse Analytics supports large-scale analytics and Power BI provides reports and dashboards. Redis, Files and Front Door are not analytics engines.

5. Question 5Relational data on Azure

   A team wants to run a relational database with full control over the operating system and the database engine version. Which option fits best?

   1. AAzure Table storage account with LRS
   2. BSQL Server on an Azure virtual machine
   3. CAzure Cosmos DB NoSQL API account
   4. DAzure Data Lake Storage Gen2 HNS
   Show answer and explanationHide answer

   Correct answer: B

   SQL Server on an Azure VM gives full control over the operating system and engine. Cosmos DB and Table storage are non-relational, and Data Lake Storage holds files for analytics.