DP-900 Microsoft Azure Data Fundamentals Free Practice Exam Questions (2026 Updated)
Prepare effectively for your Microsoft DP-900 Microsoft Azure Data Fundamentals certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2026, ensuring you have the most current resources to build confidence and succeed on your first attempt.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Match the processes to the appropriate scenarios.
To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To complete the sentence, select the appropriate option in the answer area.
You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select the answer that correctly completes the sentence.
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
What should you use to build a Microsoft Power BI paginated report?
For each of the following statements, select yes if he statement is true, Otherwise select No.
NOTE: Each correct selection is worth one point.
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
Select the answer that correctly completes the sentence.
Which type of database is Azure Database for PostgreSQL?
Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You need to create a visualization of running sales totals per quarter as shown in the following exhibit.
What should you create in Power BI Desktop?
What should you use to automatically delete blobs from Azure Blob Storage?
Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
