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
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.

Explanation:
Reference:
https://en.wikipedia.org/wiki/Table_(database)#:~:text=A%20table%20is%20a%20collection,table%20format%20within%20a%20database.&text=In%20relational%20databases%2C%20and%20flat,a%20row%20and%20column%20intersect.
https://en.wikipedia.org/wiki/View_(SQL)
https://en.wikipedia.org/wiki/Database_index#:~:text=A%20database%20index%20is%20a,maintain %20the%20index%20data%20structure.
DRAG DROP
match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description 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:
Box 1: Dataset
Datasets must be created from paths in Azure datastores or public web URLs, for the data to be accessible by Azure Machine Learning.
Box 2: Linked service
Linked services are much like connection strings, which define the connection information needed for Data Factory to connect to external resources.
Box 3: Pipeline
A pipeline is a logical grouping of activities that together perform a task.
Reference:
https://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/
https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities
Which service is optimized for loT scenarios that involve streaming time series data?
- A . SQL Server on Azure Virtual Machines
- B . Azure SQL Managed Instance
- C . Azure SQL Database
- D . Azure SQL Edge
Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?
- A . isolation
- B . durability
- C . atomicity
- D . consistency
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

Explanation:
Reference: https://docs.microsoft.com/en-us/azure/data-factory/frequently-asked-questions
What can be used with native notebook support to query and visualize data by using a web-based interface?
- A . Azure Databricks
- B . pgAdmin
- C . Microsoft Power Bl
Select the answer that correctly completes the sentence.
![]()
![]()
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

Explanation:
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal



