Microsoft Azure Data Fundamentals (DP-900) is a beginner-level Microsoft certification exam. The blueprint splits the exam across 4 domains, starting with Describe core data concepts, Identify considerations for relational data on Azure, Describe considerations for non-relational data on Azure. On exam day you face around 124 questions in 45 minutes, in formats such as multiple-choice,case studies. The 20 questions below are free samples written to match that style: answer each one first, then reveal the correct answer and note which topics you miss. The DP-900 is rated easy in difficulty. Because every answer is revealed in place, you can work through the whole set without leaving this page. Work through all 20 samples before deciding whether to buy the full 124+ question PDF.
Looking for more? Click here to get the full PDF with 124+ practice questions for $10 for offline study and deeper preparation.
Which three services support Apache Spark? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
What is a characteristic of batch processing?
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?
Which Azure Storage service implements the key/value model?
Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
What is the responsibility of a database administrator?
Which scenario is an example of a streaming workload?
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?
A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail. Of which ACID semantic is this an example?
Which Azure Cosmos DB API should you use for a graph database?
You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
What is a characteristic of non-relational data?
Which statement is an example of Data Manipulation Language (DML)?
No. They are original practice questions written to match the format and topic mix of the Microsoft Azure Data Fundamentals exam, which contains around 124 questions. Treat them as representative practice, not leaked exam content.
This page includes 20 questions, each with its correct answer you can reveal in place. The full study PDF expands that to 124+ questions.
Yes. Open the answer panel under each question to see which option is correct. Answer first, then reveal, so the set works as a self-check rather than a reading exercise.
Not on its own. Use the samples to find weak topics, revise them against the official domains, then work through the full 124+ question set under timed conditions before booking the exam.
Download the complete DP-900 study bundle with 124+ questions in a single printable PDF.
Start typing to search exams
Access practice tests for AWS, Microsoft, Cisco and more.