Microsoft DP-900 Practice Exams
Last updated on Oct 23,2026- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Oct 23,2026
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
- A . native support for cross-database queries and transactions
- B . built-in high availability
- C . system-Initiated automatic backups
- D . support for encryption at rest
A
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
DRAG DROP
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description 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 the correctly completes the sentence.
You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?
- A . queue
- B . blob
- C . file
- D . table
C
Explanation:
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.
Reference: https://azure.microsoft.com/en-us/services/storage/files/
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)
- A . a report page
- B . a Microsoft PowerPoint slide
- C . a visualization from a report
- D . a dataflow
- E . a text box
ACE
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?
- A . Microsoft SQL Server Management Studio (SSMS)
- B . Azure Data Studio
- C . Azure CLI
- D . Azure PowerShell
B
Explanation:
Reference: https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A bar chart showing year-to date sales by region is an example of which type of analytics?
- A . descriptive
- B . diagnostic
- C . predictive
- D . prescriptive
Select the answer that correctly completes the sentence.
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
