Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-900

Microsoft DP-900 Exam Questions
Microsoft Azure Data Fundamentals (Page 7 )

Updated On: 24-Feb-2026
Page 7 of 63
PDF with 314 Questions

DRAG DROP (Drag and Drop is not supported)
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location 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.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: A standalone data analysis tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.


Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl



Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown in the fourth quarter?

  1. predictive
  2. prescriptive
  3. descriptive
  4. diagnostic

Answer(s): A

Explanation:

Predictive, to answer the question: What will happen?


Reference:

https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/



Which statement is an example of Data Manipulation Language (DML)?

  1. REVOKE
  2. DISABLE
  3. CREATE
  4. UPDATE

Answer(s): 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



HOTSPOT (Drag and Drop is not supported)
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Descriptive, to answer the question: What's happening?

Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords.
You can process one media file or multiple media files in a batch.


Reference:

https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/ https://docs.microsoft.com/en-us/azure/media-services/previous/media-services-index-content



HOTSPOT (Drag and Drop is not supported)
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Generally speaking, data analytics comes in four types:
1. Descriptive, to answer the question: What's happening?
2. Diagnostic, to answer the question: Why's happening?
3. Predictive, to answer the question: What will happen?
4. 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/






Post your Comments and Discuss Microsoft DP-900 exam dumps with other Community members:

Join the DP-900 Discussion