Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors

Microsoft Azure Data Fundamentals DP-900 Exam Questions in PDF

Free Microsoft DP-900 Dumps Questions (page: 7)

DP-900 PDF — 323 Questions

You have the following data.
Which type of data is this?

  1. unstructured
  2. semi-structured
  3. structured

Answer(s): B



You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?

  1. az storage share create
  2. az storage account create
  3. az cosmosdb create
  4. az storage container create

Answer(s): B


Reference:

https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest



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:



Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL) syntax.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api



You need to modify a view in a relational database by adding a new column.
Which statement should you use?

  1. MERGE
  2. ALTER
  3. INSERT
  4. UPDATE

Answer(s): B



HOTSPOT (Drag and Drop is not supported)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

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



Viewing page 7 of 63

Share your comments for Microsoft DP-900 exam with other users:

A
AI Tutor Explanation
5/16/2026 7:04:20 AM

Question 4:
Question 4 is about when to use batch processing.

  • Answer key: A (the option related to “When to use batch processing”).
  • Core idea: Batch processing is used when you can tolerate some delay and don’t need results instantly. Data is collected over a period, then processed together in a batch.

Why this is correct:
  • Latencies are expected with batch jobs. The system processes data in groups rather than as soon as data arrives.
  • The processes are often not mission-critical at the exact moment they run, so delays don’t impact operations.

Key concepts to know:
  • Batch processing vs real-time processing: Batch processes collect data and run at scheduled times or when resources are available, whereas real-time processing handles data immediately.
  • When to use batch processing:
- High-volume data where immediate results aren’t required - Tasks that can be scheduled (e.g., nightly ETL, end-of-day payroll, bulk reports) - When cost or resource utilization is optimized by processing in groups
Examples: nightly data aggregation, batch payroll processing, end-of-day reconciliations.
If you want, I can walk through how to identify the right scenario for batch vs real-time in practice.

Cape Town, South Africa
G
Gerrard
3/18/2026 6:58:37 AM

The DP-900 exam can be tricky if you aren't familiar with Microsoft’s specific cloud terminology. I used the practice questions from free-braindumps.com and found them incredibly helpful. The site breaks down core data concepts and Azure services in a way that actually mirrors the real test. As a resutl I passed my exam.

United States
AI Tutor 👋 I’m here to help!