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
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document. NOTE: Each correct selection is worth one point.
Explanation:
Reference:
https://www.w3schools.com/js/js_json_arrays.asp
https://www.w3schools.com/js/js_json_objects.asp
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
You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?
- A . extract transform, and load (ETL)
- B . a data warehouse
- C . online analytical processing (OLAP)
- D . online transaction processing (OLTP)
Select the answer that correctly completes the sentence.
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 Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
You can use Azure Data Studio to connect to an Azure SQL Database server. You’ll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.
Box 2: No
SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks. Instead use Azure Data Studio to create SQL notebook.
Box 3: Yes
You can use the Azure Data Studio to restore databases.
Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
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://www.precisely.com/blog/big-data/big-data-101-batch-stream-processing
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question : What’s happening?
Diagnostic, to answer the question: Why’s happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-
will-happen-with-iot-analytics/