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
HOTSPOT
To complete the sentence select the appropriate option in the answer area.
In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?
- A . bridge
- B . dimension
- C . fact
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Box 1: simple lookups
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15
Select the answer that correctly completes the sentence.
You have a SQL query that combines customer data and order dat a. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?
- A . a table
- B . an index
- C . scalar function
- D . a view
D
Explanation:
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
Which statement is an example of Data Manipulation Language (DML)?
- A . REVOKE
- B . DISABLE
- C . CREATE
- D . UPDATE
D
Explanation:
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
