Description

For learners studying for Microsoft Certified: Azure Data Fundamentals
What you'll learn
Practice pack content
Domain 1 - Describe core data concepts
Domain 2 – Identify considerations for relational data on Azure
Domain 3 – Describe considerations for working with non-relational data on Azure
Domain 4 – Describe an analytics workload on Azure
Final Exam Simulators
Exam Study Guide
Interactive Flashcards
Try 3 Azure Data Fundamentals DP-900 practice questions
Choose an answer, explore the explanation, and see why the other options are less suitable. Three short scenarios. No sign-in required.
Identify considerations for relational data on AzureTopic · Describe relational concepts
1. One current email address per instructor
A training company stores one instructor per course in a relational Courses table, repeating each instructor's current email address across their courses. Email changes sometimes leave conflicting copies. Which design change most directly reduces this duplication while keeping each course linked to its instructor?
- Add an index on the instructor email column and keep the address in each course row.
- Create a view of instructor emails and keep the address stored in each course row.
- Move instructor emails into an Instructors table and reference it using InstructorID.
- Split courses into separate tables by subject and keep instructor emails in each table.
Answer and full explanation
Correct answer: C — Store instructor details separately and link each course by InstructorID.
Why C is correct
Normalization separates information about different entities to reduce unnecessary duplication. The instructor's current email belongs with the instructor, rather than being repeated for every course. An Instructors table can store that email once alongside a primary key such as InstructorID. Each course then holds a foreign key referencing the appropriate instructor. Updating the instructor's email changes one stored value instead of requiring changes to every associated course row.
Why the other options are less suitable
- A — An index on the repeated email: An index can help the database find rows more efficiently. It does not remove the duplicated addresses or ensure that every copy is updated together.
- B — A view over the existing rows: A view can present selected data from the underlying table. Keeping the same stored rows leaves the duplication and update problem in place.
- D — Separate tables by course subject: Splitting courses by subject changes how course records are grouped. An instructor teaching several courses can still have the same email repeated, so it does not establish one shared instructor record.
Key takeaway: Store shared entity details once and use keys to relate the records that need them.
Read two more sample questions
Describe considerations for working with non-relational data on AzureTopic · Describe the capabilities of Azure storage
2. Storage for product photographs and videos
An e-commerce application must store original product photographs and large video clips as individual objects that it retrieves through HTTPS. It does not require shared folders mounted by office computers. Which Azure storage service is the most suitable place for this media content?
- Use Azure Blob storage to keep the media as separate stored objects.
- Use Azure Files to keep the media in a shared network file system.
- Use Azure Table storage to keep the media as entity property values.
- Use Azure Queue storage to keep the media in application messages.
Answer and full explanation
Correct answer: A — Azure Blob storage for the media objects.
Why A is correct
Azure Blob storage provides object storage for unstructured data such as images and video. These media files do not need the rows and columns of a relational table. The application can retrieve individual blobs through HTTPS using supported interfaces. The requirement is to store media objects, not to provide a mounted network file share or exchange processing messages. Access permissions should still be configured for the intended audience; choosing Blob storage does not require making the content public.
Why the other options are less suitable
- B — A shared file system: Azure Files is useful when applications or users need managed file shares, including SMB or NFS access. It can store media, but the scenario specifically calls for object storage rather than shared file-system access.
- C — Entity properties in Table storage: Azure Table storage suits structured, non-relational records with flexible properties, such as product metadata. It is not the appropriate primary store for the original photographs and large video objects described here.
- D — Application queue messages: Azure Queue storage carries messages between application components, such as a request to process an uploaded video. That message can identify the media object, but a queue is not the requested store for the media itself.
Key takeaway: Separate media objects, shared files, entity records and processing messages when choosing storage.
Describe an analytics workload on AzureTopic · Describe considerations for real-time data analytics
3. Processing temperature readings as they arrive
A delivery company sends vehicle temperature readings to Azure Event Hubs throughout the day. The operations team needs a managed service to filter those events and calculate averages over time windows using SQL-like queries as readings arrive. Which service best provides that processing step?
- Use Azure Data Factory to coordinate scheduled data integration pipelines.
- Use Azure Event Hubs to ingest and retain incoming telemetry event streams.
- Use Microsoft Power BI to present operational metrics in interactive reports.
- Use Azure Stream Analytics to evaluate queries continuously over event streams.
Answer and full explanation
Correct answer: D — Azure Stream Analytics for the continuous query-processing step.
Why D is correct
Azure Stream Analytics is a managed engine for processing streaming data. It can read events from Azure Event Hubs and apply SQL-based queries. Filtering and time-window aggregation match the processing requested in this scenario. Event ingestion, query processing and presentation are distinct roles even when the services work together. The processed results can be sent to a supported output for reporting, storage or further action.
Why the other options are less suitable
- A — Data integration pipelines: Azure Data Factory coordinates data movement and transformation through pipelines. A scheduled integration pipeline is not the continuous, SQL-based stream-processing step requested here.
- B — Event ingestion and retention: Azure Event Hubs receives and retains event streams for consumers. It already supplies the input in this scenario; the separate processing engine must perform the requested filtering and windowed calculations.
- C — Interactive reporting: Power BI helps people explore and visualize data through reports. It could display the resulting metrics, but it is not the stream-processing engine being selected for this step.
Key takeaway: Distinguish the service that ingests events from the engine that analyzes them and the tool that displays results.
Preview complete
You have tried all three samples
Review the explanations or try the samples again. This short preview covers only a small part of the exam objectives.
Your sample score resets when this page reloads.
Your practice pack includes
More ways to make each study session count
Focus on a topic, practise under a time limit, or return to the supporting resources before your next attempt.
Domain-based practice
Timed practice sets
Study guide
Flashcards
Requirements
- Microsoft recommends familiarity with DP-900 learning materials, relational and non-relational data, and transactional versus analytical workloads. Use these foundations to understand the requirements in each practice scenario.
- Combine questions with foundational study and your own authorized exercises, such as comparing storage services, interpreting simple SQL or examining a small report. No bundled Azure environment is assumed.
- You will need an internet-connected device, a current web browser and an ExamsDigest account to access this online practice product and review your study work.
Know the exam you’re studying for
These details describe Microsoft’s official Microsoft Azure Data Fundamentals (DP-900) exam exam.
What our students say
“I could remember the Azure service names, but choosing between them in a scenario was harder. The ExamsDigest questions helped me notice which details mattered, especially when comparing storage options. I had a much clearer idea of what to revisit in my notes.”
Daniel Foster
✓ Verified Review
“The normalization example helped something click that I hadn’t understood from reading alone. Seeing why an index or a view wouldn’t solve the same problem made the explanation much more useful than simply checking the correct answer.”
Amelia Hughes
✓ Verified Review
“I used the questions alongside Microsoft Learn while studying for DP-900. I kept mixing up the services that collect data, process it and display the results. Comparing the explanations helped me separate those roles instead of memorizing another list of products.”
Christopher Reed
✓ Verified Review
Your questions, answered.
Which exam and skills outline does this practice target?
These practice questions target DP-900: Microsoft Azure Data Fundamentals, using the English skills outline effective 21 July 2026. Before purchasing, compare the product’s listed topics, practice formats and access terms with your needs. Check Microsoft’s study guide for your exam language and date; naming DP-900 does not by itself confirm complete coverage of every objective.
Who is Azure Data Fundamentals practice for?
This practice is for learners beginning to work with data in the cloud. Familiarity with relational and non-relational data, and the difference between transactional and analytical workloads, will help. Microsoft recommends familiarity with DP-900 learning materials. The focus is foundational understanding, not proof that you can administer a production database or engineer a complete analytics platform.
How should I combine questions with practical study?
Combine questions with Microsoft’s learning materials and small exercises using data you are authorized to use. Try separating repeated information into related tables, comparing storage choices for images and records, or explaining a simple report. These activities reinforce the decisions behind an answer; they do not imply that Azure subscriptions, hosted labs or Power BI licenses are included in the pack.
What should I do after an incorrect answer?
Use each incorrect answer to identify a specific distinction to revisit, such as a table versus a view, object storage versus file shares, or ingestion versus stream processing. Compare the explanation with your original reasoning, then try a different example. Focus on the requirement that makes an option suitable rather than memorizing its letter; a practice score does not guarantee an official exam result.
Does this preview reproduce the official exam format?
No. This preview contains three single-answer questions with four choices each. Microsoft describes DP-900 as proctored and notes that interactive components may be included. Use the exam sandbox linked from the official certification page to explore navigation and example item types. Check the paid pack’s listed formats separately rather than assuming these samples represent every official task.
Does completing this practice award the certification?
No. Purchasing or completing practice questions does not award Microsoft Certified: Azure Data Fundamentals. The credential requires passing the official DP-900 exam and meeting Microsoft’s applicable candidate requirements. Register through an authorized exam provider, and check the product’s stated terms for any voucher arrangements rather than assuming a practice purchase also books your official examination.
30-day conditional refund policy
Eligible requests must be made within 30 calendar days, with no more than 20% of any included simulator completed. The purchase must not already be refunded or under a payment dispute or chargeback. Other provisions apply; mandatory consumer rights remain unaffected.
Useful links for your preparation



