dc dotCreds
Microsoft Azure Data Fundamentals

DP-900 Practice Test

Start today's 10-question DP-900 set with source-backed explanations, local progress, and a fresh rotation every morning.

10 Free Daily Questions Source-backed Explanations 150 Verified Questions

Questions updated at Jul 18, 2026, 1:30 PM CDT

Start Daily Practice Open Dashboard
Go Pro - One Time Unlock

Unlock the full DP-900 bank

150 verified questions Exam Mode Practice Mode Detailed explanations Weak-area review No subscription - one-time unlock

Get the complete source-backed bank with Interview Questions, the full Study Guide, full Course Notes, detailed explanations, weak-area review, and exam-style practice.

Interview Questions Full Study Guide Full Course Notes Exam Mode Practice Mode Guided Course Detailed explanations Weak-area review No subscription
$2.99 One-time payment
See bundle and PDF options

We will confirm your site email in one quick checkout step.

Why DotCreds?

Practice with explanations that teach.

Source links for every answer Every wrong answer explained Guided Course included Practice and Exam Mode Weak-area tracking Same verified bank across web practice

What you get with free practice

10 Free Questions Daily Fresh set every day from the live bank
Detailed Explanations Learn with clear source-backed answers
Track Your Progress Daily history and performance insights
Upgrade Anytime Unlock the full bank when you are ready
Today's 10 DP-900 questions

Use this DP-900 practice test to review Microsoft Azure Data Fundamentals. Questions rotate daily and each explanation links to the source used to validate the answer.

Today’s Set
10 questions
Rotates at 10:00 AM local time
Progress
0/10
Answered on this page
Accuracy
0%
Loading countdown…

150 verified questions are in the live bank. Free daily questions are selected from a rotating sample set. Unlock Pro to access the full question bank.

Preparing today’s free questions... Ordering the final locked-bank set before showing the practice cards.
Question 1 of 10
Objective Explore data analytics in Azure Analytics Workloads

Contoso Retail operates a chain of stores across Europe. They need to regularly copy data from on-premises SQL Server databases located within their stores to Azure Data Lake Storage Gen2 for analytics. These stores have varying internet connectivity, with some experiencing intermittent outages. To minimize data transfer latency and ensure reliable data movement, Contoso wants to leverage an Azure Data Factory integration runtime. Which type of integration runtime would be the MOST suitable for this scenario?

Concept tested:
Source:Explore fundamentals of large-scale data analytics
Question 2 of 10
Objective Explore data analytics in Azure Microsoft Fabric / Power BI

A retail company, 'GlobalGadgets,' uses a large on-premises SQL Server database to store sales transaction data. They want to create a Power BI report that displays real-time sales figures without importing the data into Power BI. The SQL Server database is frequently updated with new transactions. Which Power BI data connectivity mode should the data analyst use to achieve this goal and minimize the impact on the SQL Server database’s performance?

Concept tested:
Question 3 of 10
Objective Explore data analytics in Azure Microsoft Fabric / Power BI

Contoso Retail is building a Power BI report to analyze daily sales data. The data resides in an Azure SQL Database, which is updated hourly with transactional data. They also need to incorporate static product dimension data stored in a flat file on Azure Data Lake Storage Gen2, updated monthly. The report needs to display near real-time sales figures while ensuring the product dimension data remains consistent. Which Power BI semantic model configuration would be the most appropriate to meet these requirements?

Concept tested:
Question 4 of 10
Objective Explore core data concepts Relational Data Concepts

Contoso Retail is migrating its on-premises order processing system to Azure SQL Database. The system handles a high volume of transactions, and data integrity is paramount. A critical requirement is that all committed transactions must survive unexpected server crashes or power outages without data loss. Which of the following Azure SQL Database configuration options best ensures this durability?

Concept tested:
Question 5 of 10
Objective Explore data analytics in Azure Analytics Workloads

A retail company is launching a new online store and needs to track website visitor activity in real-time to personalize product recommendations and trigger immediate promotional offers. The system must process events with extremely low latency (under 1 second) and handle a high volume of events (millions per minute) during peak hours. The data needs to be available for immediate analysis and action. Which Azure service is MOST appropriate for this stream processing workload?

Concept tested:
Question 6 of 10
Objective Explore non-relational data in Azure Non-Relational Data

A global manufacturing company stores large files (engineering drawings, CAD models, documentation) on a central Azure cloud file share. Several regional offices need local, fast access to these files to minimize latency and improve user productivity. The company wants to avoid frequent, full file copies and ensure changes made locally are eventually synchronized back to the central cloud share. Which Azure service is the MOST appropriate solution to meet these requirements?

Concept tested:
Question 7 of 10
Objective Explore non-relational data in Azure Azure Cosmos DB

A product catalog in Azure Cosmos DB will store millions of items and receive heavy traffic. Which partition key strategy best supports scalability?

Concept tested:
Question 8 of 10
Objective Explore relational data in Azure Azure SQL Services

Contoso Retail stores customer data in an Azure SQL Database. The database contains Personally Identifiable Information (PII) such as credit card numbers and social security numbers. A team of data analysts needs access to the database for reporting purposes, but they do not require access to the PII data. As a data architect, what is the most appropriate method to protect the PII data while still allowing the analysts to perform their reporting tasks?

Concept tested:
Question 9 of 10
Objective Explore non-relational data in Azure Non-Relational Data

A financial services company is required to retain regulatory compliance records for a minimum of seven years. These records must be immutable and protected from accidental or malicious modification. The company plans to store these records in Azure Blob Storage. Which Azure Blob Storage feature should be implemented to meet this regulatory requirement?

Concept tested:
Question 10 of 10
Objective Explore core data concepts Relational Data Concepts

A retail company is designing an Azure SQL Database for customer orders. The 'order_id' column must be unique, and the 'shipping_state' column must contain valid US state abbreviations. Which database constraints should be applied to these columns?

Concept tested:
Locked preview

You are viewing today’s free 10. Unlock 140 more questions.

Unlock full bank
Daily sample Rotating practice Free daily questions are selected from a rotating sample set.
Pro bank Full access Unlock Pro to access the full question bank, Exam Mode, Practice Mode, and random tests.
DP-900 Pro $2.99 one-time

Best if you only need this one certification.

50 Exam Practice Test $1.99 one-time

A 50-question DP-900 PDF for short review sessions. Questions come first, then the answer review and explanations later in the file.

Microsoft Data Bundle $9.99 one-time

Unlock all 4 active Microsoft Data Bundle practice banks in one permanent purchase.

What’s includedDP-900, DP-300, DP-600, DP-700
All Access $6.99/month

Unlock every active practice exam, bundle and path experience, Pro course and study content, and included downloads.

What’s includedEvery current and future active practice exam, All active bundle and career-path practice content, Pro course lessons, study content, and supported paid downloads

Choose an unlock option to continue. We will confirm your site email in one quick checkout step.

Secure checkout powered by Stripe. Source-backed questions. Not brain dumps. Checkout stays on this page and unlocks the same Pro builder on this practice page.
Already Pro? Open dashboard

Purchase options

Unlock the full DP-900 bank.

Get the full bank, Exam Mode, Practice Mode, question sets, random tests, readiness tracking, saved box scores, and review tools for this exam.

The PDF versions keep questions first and move the answer review, explanations, and distractor notes to the back of the file.

150 verified exam-style questions Every choice explained Exam Mode and Practice Mode Question sets and random tests Readiness score and trends Previous test box scores

You've answered 0/10 questions in today's set.

Locked: 140 more questions in the full bank.

Locked: exam simulation mode, practice mode, readiness tracking, and saved review history.

Checkout stays on this page, so you can keep practicing, unlock the full bank, and start Exam Mode or Practice Mode when you are ready.

Cheat Sheets

7-day score keeper

Answer questions today and this will become a rolling 7-day scorecard.

Local history
Optional progress sync

Keep today’s practice moving

Guest progress saves automatically on this device. Add an email later when you want a magic link that keeps your daily DP-900 practice in sync across browsers.

Guest progress saves on this device automatically

Guest progress is available without an account.

Official exam resources

Use these official Microsoft resources alongside the daily practice set. They cover the provider's own exam page, study guide, or prep material.

Certification Microsoft Certified: Azure Data Fundamentals Study guide DP-900 study guide Docs Azure data documentation

Need adjacent Microsoft practice pages too? Microsoft practice hub.

Source-backed answer review

The free daily DP-900 set includes crawlable question text, answer choices, correct answer labels, objective mapping, and source links. Only the first SEO card includes answer explanations and any extra learning features. Pro-only bank questions stay locked; this section mirrors only the 10 free daily questions already shown on this page.

Question 1 Contoso Retail operates a chain of stores across Europe. They need to regularly copy data from on-premises SQL Server databases located within their stores to Azure Data Lake Storage Gen2 for analytics. These stores have varying internet connectivity, with some experiencing intermittent outages. To minimize data transfer latency and ensure reliable data movement, Contoso wants to leverage an Azure Data Factory integration runtime. Which type of integration runtime would be the MOST suitable for this scenario?

Answer choices

  1. A. Azure Integration Runtime
  2. B. Self-Hosted Integration Runtime
  3. C. Azure-SSIS Integration Runtime
  4. D. Azure Data Lake Analytics Integration Runtime

Correct answer

Self-Hosted Integration Runtime

A Self-Hosted Integration Runtime (SHIR) is the correct choice because it allows Contoso to deploy an agent within their on-premises stores. This agent then directly connects to the on-premises SQL Server databases and transfers data to Azure Data Lake Storage Gen2. The SHIR operates independently of the internet connection at each store, making it resilient to intermittent outages and reducing latency by avoiding data traversing the public internet. Azure Integration Runtime relies on Azure's infrastructure and would be susceptible to the same connectivity issues. Azure-SSIS Integration Runtime is specifically for running SSIS packages, not general data movement. Azure Data Lake Analytics Integration Runtime is used for running analytics jobs within Azure Data Lake Analytics, not for data integration.

Wrong-answer review

  • A. Azure Integration Runtime: Azure Integration Runtime is incorrect because this option would require data to travel over the internet from the on-premises stores to Azure, making it vulnerable to the intermittent connectivity issues Contoso experiences. It also introduces higher latency.
  • C. Azure-SSIS Integration Runtime: Azure-SSIS Integration Runtime is incorrect because it is specifically designed for executing SSIS packages within Azure. However, it can be used for data movement, it's not the primary or most efficient solution for this scenario. It adds unnecessary complexity.
  • D. Azure Data Lake Analytics Integration Runtime: Azure Data Lake Analytics Integration Runtime is incorrect because it is used for running analytics jobs within Azure Data Lake Analytics. It is not used for data integration or data movement.

Extra learning features

Why candidates miss this

Selecting Azure Integration Runtime demonstrates a misunderstanding of how Azure Data Factory handles on-premises data sources. This runtime relies entirely on Azure’s infrastructure, which means data transfer would be subject to the stores’ intermittent internet connectivity. A Self-Hosted Integration Runtime, deployed within the stores, provides a direct connection, bypassing the public internet and ensuring data movement even during outages. Likely wrong answer: Azure Integration Runtime Review focus: Explore fundamentals of large-scale data analytics

Why this matters

Understanding the differences between Azure-hosted and self-hosted integration runtimes is crucial for designing reliable and efficient data integration pipelines in Azure. This knowledge is frequently tested and directly impacts the ability to build solutions that meet business requirements for data availability and performance.

Objective/domain: Analytics Workloads

Source: Explore fundamentals of large-scale data analytics

Question 2 A retail company, 'GlobalGadgets,' uses a large on-premises SQL Server database to store sales transaction data. They want to create a Power BI report that displays real-time sales figures without importing the data into Power BI. The SQL Server database is frequently updated with new transactions. Which Power BI data connectivity mode should the data analyst use to achieve this goal and minimize the impact on the SQL Server database’s performance?

Answer choices

  1. A. Import mode
  2. B. DirectQuery mode
  3. C. Dual mode
  4. D. Live Connection mode

Correct answer

DirectQuery mode

Objective/domain: Microsoft Fabric / Power BI

Source: Explore fundamentals of data visualization

Question 3 Contoso Retail is building a Power BI report to analyze daily sales data. The data resides in an Azure SQL Database, which is updated hourly with transactional data. They also need to incorporate static product dimension data stored in a flat file on Azure Data Lake Storage Gen2, updated monthly. The report needs to display near real-time sales figures while ensuring the product dimension data remains consistent. Which Power BI semantic model configuration would be the most appropriate to meet these requirements?

Answer choices

  1. A. Use Import mode for both the Azure SQL Database and the Azure Data Lake Storage Gen2 data.
  2. B. Use DirectQuery mode for the Azure SQL Database and Import mode for the Azure Data Lake Storage Gen2 data.
  3. C. Use a combination of DirectQuery mode for the Azure SQL Database and DirectQuery mode for the Azure Data Lake Storage Gen2 data.
  4. D. Use Import mode for the Azure SQL Database and DirectQuery mode for the Azure Data Lake Storage Gen2 data.

Correct answer

Use DirectQuery mode for the Azure SQL Database and Import mode for the Azure Data Lake Storage Gen2 data.

Objective/domain: Microsoft Fabric / Power BI

Source: Explore fundamentals of data visualization

Question 4 Contoso Retail is migrating its on-premises order processing system to Azure SQL Database. The system handles a high volume of transactions, and data integrity is paramount. A critical requirement is that all committed transactions must survive unexpected server crashes or power outages without data loss. Which of the following Azure SQL Database configuration options best ensures this durability?

Answer choices

  1. A. Enable the 'READ_COMMITTED' snapshot isolation level.
  2. B. Configure the database with the 'Standard' service objective and a maximum size of 100 GB.
  3. C. Set the database to the 'Business Critical' service objective with automatic page patching enabled.
  4. D. Implement Azure Data Lake Storage Gen2 for transaction logs and configure periodic backups.

Correct answer

Set the database to the 'Business Critical' service objective with automatic page patching enabled.

Objective/domain: Relational Data Concepts

Source: Explore fundamental relational data concepts

Question 5 A retail company is launching a new online store and needs to track website visitor activity in real-time to personalize product recommendations and trigger immediate promotional offers. The system must process events with extremely low latency (under 1 second) and handle a high volume of events (millions per minute) during peak hours. The data needs to be available for immediate analysis and action. Which Azure service is MOST appropriate for this stream processing workload?

Answer choices

  1. A. Azure Data Factory
  2. B. Azure Synapse Analytics
  3. C. Azure Stream Analytics
  4. D. Azure Data Lake Storage Gen2

Correct answer

Azure Stream Analytics

Objective/domain: Analytics Workloads

Source: Explore fundamentals of large-scale data analytics

Question 6 A global manufacturing company stores large files (engineering drawings, CAD models, documentation) on a central Azure cloud file share. Several regional offices need local, fast access to these files to minimize latency and improve user productivity. The company wants to avoid frequent, full file copies and ensure changes made locally are eventually synchronized back to the central cloud share. Which Azure service is the MOST appropriate solution to meet these requirements?

Answer choices

  1. A. Azure File Sync
  2. B. Azure Data Lake Storage Gen2
  3. C. Azure Blob Storage with CDN
  4. D. Azure NetApp Files

Correct answer

Azure File Sync

Objective/domain: Non-Relational Data

Source: Explore Azure Storage for non-relational data

Question 7 A product catalog in Azure Cosmos DB will store millions of items and receive heavy traffic. Which partition key strategy best supports scalability?

Answer choices

  1. A. Use a partition key that places all products in one logical partition for simpler queries.
  2. B. Manually assign a fixed number of physical partitions before loading the data.
  3. C. Choose a partition key that distributes data and request volume evenly across logical partitions.
  4. D. Bypass partition keys by spreading data across multiple unrelated Cosmos DB accounts.

Correct answer

Choose a partition key that distributes data and request volume evenly across logical partitions.

Objective/domain: Azure Cosmos DB

Source: Explore fundamentals of Azure Cosmos DB

Question 8 Contoso Retail stores customer data in an Azure SQL Database. The database contains Personally Identifiable Information (PII) such as credit card numbers and social security numbers. A team of data analysts needs access to the database for reporting purposes, but they do not require access to the PII data. As a data architect, what is the most appropriate method to protect the PII data while still allowing the analysts to perform their reporting tasks?

Answer choices

  1. A. Implement Transparent Data Encryption (TDE) on the entire database.
  2. B. Create a new database specifically for the analysts and copy the non-PII data into it.
  3. C. Utilize Dynamic Data Masking to mask the PII columns for the data analyst users.
  4. D. Restrict all access to the database and require analysts to request data extracts on a scheduled basis.

Correct answer

Utilize Dynamic Data Masking to mask the PII columns for the data analyst users.

Objective/domain: Azure SQL Services

Source: Explore relational database services in Azure

Question 9 A financial services company is required to retain regulatory compliance records for a minimum of seven years. These records must be immutable and protected from accidental or malicious modification. The company plans to store these records in Azure Blob Storage. Which Azure Blob Storage feature should be implemented to meet this regulatory requirement?

Answer choices

  1. A. Enabling versioning on the blob container.
  2. B. Configuring lifecycle management policies to move blobs to the Archive tier.
  3. C. Enabling immutable blob storage with WORM (Write Once, Read Many) policy.
  4. D. Implementing soft delete on the blob container.

Correct answer

Enabling immutable blob storage with WORM (Write Once, Read Many) policy.

Objective/domain: Non-Relational Data

Source: Explore Azure Storage for non-relational data

Question 10 A retail company is designing an Azure SQL Database for customer orders. The 'order_id' column must be unique, and the 'shipping_state' column must contain valid US state abbreviations. Which database constraints should be applied to these columns?

Answer choices

  1. A. UNIQUE constraint on 'order_id' and NOT NULL constraint on 'shipping_state'
  2. B. PRIMARY KEY constraint on 'order_id' and CHECK constraint on 'shipping_state'
  3. C. UNIQUE constraint on 'order_id' and CHECK constraint on 'shipping_state'
  4. D. NOT NULL constraint on 'order_id' and UNIQUE constraint on 'shipping_state'

Correct answer

UNIQUE constraint on 'order_id' and CHECK constraint on 'shipping_state'

Objective/domain: Relational Data Concepts

Source: Explore fundamental relational data concepts

Where to go after the daily web set

How are DP-900 questions generated?

dotCreds builds DP-900 practice questions from public exam objectives and Microsoft Learn and exam-objective references. The questions are written for realistic study practice, not copied from exam dumps.

How are explanations sourced?

Each question includes an explanation and, when available, a source link back to the provider documentation or reference used to validate the answer. That keeps the practice tied to study material you can actually review.

What score do I get?

The page tracks today's answered count and accuracy for the 10-question daily set, then saves a 7-day score history on this device so you can see your recent practice trend.

Why use this site?

The site is the fastest way to start DP-900 practice without installing anything. It is built for daily recall, quick weak-topic discovery, and source-backed explanations you can review immediately.

More Microsoft practice tests

If you're studying adjacent Microsoft certs, these pages use the same daily-question format with source-backed explanations.

AI-901 Practice Test AI-300 Practice Test AZ-900 Practice Test AB-900 Practice Test