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
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.
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.
You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes.
What should you include in the solution?
- A . Azure Cosmos
- B . Azure Table storage
- C . Azure Files
- D . Azure Blob storage
Which type of database is Azure Database for PostgreSQL?
- A . Platform as a service (PaaS)
- B . Infrastructure as a service (laaS)
- C . Microsoft SQL Server
- D . on-premises
A
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options
HOTSPOT
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
Reference:
https://azure.microsoft.com/en-us/overview/what-is-saas/
https://azure.microsoft.com/en-us/overview/what-is-paas/
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
You need to recommend a non-relational data store that is optimized for storing and retrieving files,
videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you rec ommend?
- A . document
- B . key/value
- C . object
- D . columnar
C
Explanation:
Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
You have data saved in the following format:
Which format was used?
- A . YAML
- B . HTML
- C . XML
- D . JSON