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 the responsibility of a database administrator?
- A . applying data cleaning routines
- B . creating data visualizations
- C . managing data integration processes
- D . storing backup copies of data
Select the answer that correctly completes the sentence.
Which type of Azure resource supports the serverless configuration of an Azure SQL database?
- A . Azure SQL Managed Instance
- B . SQL Server on Azure Virtual Machines
- C . a single database in Azure SQL Database
- D . an Azure SQL Database elastic pool
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal
Which statement is an example of Data Definition Language (DDL)?
- A . SELECT
- B . INSERT
- C . DELETE
- D . DROP
D
Explanation:
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database.
These statements include:
ALTER
Collations
CREATE
DROP
DISABLE TRIGGER
ENABLE TRIGGER
RENAME
UPDATE STATISTICS
TRUNCATE TABLE
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
You have the following two tables of customer data.
Which type of data do the tables contain?
- A . non-relational
- B . structured
- C . semi-structured
- D . unstructured
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 . stream processing
- B . batch processing
- C . Online Analytical Processing (OLTP)
- D . Online Transaction Processing (OLTP)
D
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing
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.
- A . container
- B . item
- C . database
- D . partition
AC
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
- A . Online Transaction Processing (OLTP)
- B . batch processing
- C . Online Analytical Processing (OLAP)
- D . stream processing
A
Explanation:
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
Reference: https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/