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
You have a transactional application that stem data in an Azure SQL managed instance.
When should you implement a read-only database replica?
- A . You need to generate reports without affecting the transactional workload.
- B . You need to audit the transactional application.
- C . You need to implement high availability in the event of a regional outage
- D . You need to improve the recovery point objective (RPO).
A
Explanation:
Use read-only replicas to offload read-only query workloads.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out
DRAG DROP
Match the types of data stores to the appropriate scenarios.
To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type 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/azure/architecture/guide/technology-choices/data-store-
overview
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.
Explanation:
Box 1: Yes
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.
Box 2: No
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the
table or view.
Box 3: Yes
A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described
https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15
How is raw data stored in a data lakehoose?
- A . as tables
- B . as queues
- C . as files
- D . as disks
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.
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/