Updated Mar 07, 2026 Test Engine to Practice Test for DP-900 Valid and Updated Dumps [Q107-Q127]

March 7, 2026 admin 0 Comments

5/5 - (1 vote)

Updated Mar 07, 2026 Test Engine to Practice Test for DP-900 Valid and Updated Dumps

Exam Questions for DP-900 Updated Versions With Test Engine

Q107. Select the answer that correctly completes the sentence.

Explanation

Q108. You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Q109. A bar chart showing year-to date sales by region is an example of which type of analytics?

descriptive

diagnostic

predictive

prescriptive

Q110. To complete the sentence, select the appropriate option in the answer area.

Q111. You have a SQL query that combines customer data and order data. 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 table

an index

scalar function

a view

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

Q112. Select the answer that correctly completes the sentence.

Q113. To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing- mpp-architecture

Q114. Select the answer that correctly completes the sentence.

Q115. You have data saved in the following format:

Which format was used?

YAML

HTML

XML

JSON

Q116. To complete the sentence, select the appropriate option in the answer area.

Q117. Hotspot Question
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:
Cloud features such as scalability, high-availability and multi-tenant capability are included, reducing the amount of coding that developers must do.
Single databases in Azure SQL Database support manual dynamic scalability, but not autoscale.
https://azure.microsoft.com/en-gb/overview/what-is-paas/
https://docs.microsoft.com/en-us/azure/azure-sql/database/scale-resources
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Q118. To complete the sentence, select the appropriate option in the answer area.

Explanation:

Disadvantages of non-relational databases include: Data Consistency – non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

Q119. Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Q120. To complete the sentence, select the appropriate option in the answer area.

Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

Q121. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboardshttps://powerbi.microsoft.com/en-us/excel-and-power-bi/

Q122. Select the answer that correctly completes the sentence.

Q123. To complete the sentence, select the appropriate option in the answer area.

Q124. Select the answer that correctly completes the sentence.

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15

Q125. 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
A screenshot of a computer Description automatically generated with medium confidence

Q126. For each of the following statements, select Yes if the statement is true. Otherwise select No.
NOTE: Each correct selection is worth one point.