Microsoft DP-900 Practice Exams
Last updated on Oct 22,2026- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Oct 22,2026
Select the answer that correctly completes the sentence.
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?
- A . service principal authentication
- B . Azure Active Directory (Azure AD) authentication
- C . SQL authentication
- D . certificate authentication
B
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
DRAG DROP
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario on the right.
Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
- A . database
- B . partition
- C . collection
- D . account
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?
- A . key/value
- B . document
- C . graph
- D . columnar
B
Explanation:
A key/value store associates each data value with a unique key.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-
overview
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)
- A . report and dashboard creation
- B . report sharing and distribution
- C . data modeling
- D . data acquisition and preparation
DRAG DROP
Match the job roles to the appropriate tasks.
To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
SELECT, INSERT, and UPDATE are examples of which type of SQL statement?
- A . Data Definition Language (DDL)
- B . Data Control Language (DCL)
- C . Data Manipulation Language (DML)
Select the answer that correctly completes the sentence.
