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 need to modify a view in a relational database by adding a new column.
Which statement should you use?
- A . MERGE
- B . ALTER
- C . INSERT
- D . UPDATE
HOTSPOT
Select the answer that correctly completes the sentence.
Explanation:
An aggregate function performs a calculation on a set of values, and returns a single value.
The following are aggregate functions:
✑ APPROX_COUNT_DISTINCT
✑ AVG
✑ CHECKSUM_AGG
✑ COUNT
✑ COUNT_BIG
✑ GROUPING
✑ GROUPING_ID
✑ MAX
✑ MIN
✑ STDEV
✑ STDEVP
✑ STRING_AGG
✑ SUM
✑ VAR
✑ VARP
Reference: https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15
You have data in a tabular format as shown in the following table.
Of which type of data is this an example?
- A . unstructured data
- B . semi-structured data
- C . document
- D . structured data
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://teachcomputerscience.com/relational-databases/
What is the primary purpose of a data warehouse?
- A . to provide answers to complex queries that rely on data from multiple sources
- B . to provide transformation services between source and target data stores
- C . to provide read-only storage of relational and non-relational historical data
- D . to provide storage for transactional line-of-business (LOB) applications
C
Explanation:
Consider using a data warehouse when you need to keep historical data separate from the source transaction systems for performance reasons. Data warehouses make it easy to access historical data from multiple locations, by providing a centralized location using common formats, keys, and data models.
Query both relational and nonrelational data.
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing
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/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms
https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench
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://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/
https://azure.microsoft.com/en-us/services/sql-database/#product-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
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.
Box 2: Yes
You can stream data into Azure Databricks using Event Hubs.
Box 3: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector.
Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs
Which storage solution supports access control lists (ACLs) at the file and folder level?
- A . Azure Data Lake Storage
- B . Azure Cosmos DB
- C . Azure Queue storage
- D . Azure Blob storage
A
Explanation:
Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
- A . Microsoft SQL Server Data Tools (SSDT)
- B . Microsoft SQL Server Management Studio (SSMS)
- C . Azure Databricks
- D . Azure Data Studio
A
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-serverver15