PracticeVideosBlogFlashcards
All Practice Exams

Free Practice Questions for Azure DP-900

Exam-style questions and explanations by OpenExamPrep.

✓ No registration✓ No credit card
200+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Microsoft Azure Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Azure AI-900

Practice Questions200 questionsStudy Guide30 topicsCheat Sheet67 factsFlashcards50 cardsFeedVideos4 videosBlogs5 blogs

Azure AZ-104

Practice Questions200 questionsStudy Guide75 topicsCheat Sheet104 factsFlashcards50 cardsGames20 termsFeedVideos4 videosBlogs5 blogs

Azure AZ-900

Practice Questions200 questionsStudy Guide40 topicsCheat Sheet73 factsFlashcards50 cardsGames44 termsFeedVideos4 videosBlogs5 blogs

Azure DP-700

Practice Questions200 questionsStudy Guide24 topicsCheat Sheet114 factsFlashcards50 cardsGames20 termsFeedVideos3 videosBlogs4 blogs

Microsoft Azure AI App and Agent Developer (AI-103)

Practice Questions200 questionsStudy Guide10 topicsCheat Sheet82 factsFlashcards50 cardsGames20 termsFeedVideos3 videosBlogs3 blogs

Microsoft Certified: Azure AI Fundamentals (AI-901)

Practice Questions100 questionsStudy Guide15 topicsCheat Sheet102 factsFlashcards50 cardsGames20 termsFeedVideos2 videosBlogs3 blogs

More From This Family

Videos and articles for deeper review.

VideoAI-102 vs AI-103 in 2026: Which Azure AI Exam, Foundry Shift, and Study MigrationVideoAI-200 Study Guide 2026: Build One Project Across All 4 DomainsVideoAI-900 Exam Guide 2026: FREE Azure AI Fundamentals Study PlanVideoAWS AI Practitioner vs Azure AI Fundamentals: Which AI Certification in 2026ArticleAZ-104 Study Guide 2026: Pass the Azure Administrator Exam19 min readArticleAzure vs AWS Certification 2026: Which Cloud Cert Should You Get First?18 min readArticleFREE AZ-700 Exam Guide 2026: 5 Domains, $165, Pass Score 700/100017 min readArticleFREE DP-300 Exam Guide 2026: 5-Domain Skills Outline + Pass on First Try16 min read
Exam Review

Key Facts: Azure DP-900 Exam

700/1000

Passing Score

Microsoft

40-60

Typical Questions

Most Microsoft exams

45 min

Time Limit

Microsoft

$99

Exam Fee

USD

25-35 hrs

Study Time

Recommended

4

Exam Domains

Microsoft

Sample Azure DP-900 Practice Questions

Try these sample questions to review concepts for the Azure DP-900 exam. Each question includes a detailed explanation. Start the interactive quiz above for the full 200+ question experience with AI tutoring.

1Which type of data is characterized by a predefined schema with rows and columns?
A.Unstructured data
B.Semi-structured data
C.Structured data
D.Binary data
Explanation: Structured data is organized in a predefined format with rows and columns, typically found in relational databases. Unstructured data has no predefined model (like images or videos), while semi-structured data has some organizational properties but not a rigid schema (like JSON or XML).
2Which of the following is an example of unstructured data?
A.A relational database table
B.A JSON document
C.A video file
D.An Excel spreadsheet
Explanation: Video files are unstructured data because they lack a predefined data model or organization. Relational databases and Excel spreadsheets are structured data with defined schemas. JSON documents are semi-structured data as they have organizational tags but flexible schemas.
3JSON and XML are examples of which data type?
A.Structured data
B.Unstructured data
C.Semi-structured data
D.Relational data
Explanation: JSON and XML are semi-structured data formats. They contain tags or markers to separate semantic elements and enforce hierarchies, but they do not require a rigid schema like relational databases. This flexibility makes them ideal for data interchange and NoSQL databases.
4Which data type requires a schema to be defined before data can be stored?
A.Structured data
B.Semi-structured data
C.Unstructured data
D.All data types
Explanation: Structured data requires a predefined schema that specifies the data types, relationships, and constraints before data can be stored. Semi-structured data allows flexibility with schema-on-read, while unstructured data has no schema requirements at all.
5Images, audio files, and text documents are all examples of which data type?
A.Structured data
B.Semi-structured data
C.Unstructured data
D.Metadata
Explanation: Images, audio files, and text documents are all unstructured data types. They do not have a predefined data model or organized structure that can be easily queried using traditional database query languages.
6Which storage option is best suited for storing files such as documents and images?
A.Relational database
B.Blob storage
C.Graph database
D.Column-family database
Explanation: Blob storage (Binary Large Object storage) is designed for storing unstructured binary data such as documents, images, videos, and backups. Relational databases are for structured data, while graph and column-family databases are specialized NoSQL stores for specific use cases.
7What is the primary difference between file storage and blob storage?
A.File storage is more expensive than blob storage
B.File storage provides a hierarchical folder structure while blob storage uses a flat namespace
C.Blob storage is only for structured data
D.File storage cannot be accessed over the network
Explanation: File storage provides a hierarchical folder structure similar to traditional file systems, making it compatible with existing applications that use file shares. Blob storage uses a flat namespace with containers and blobs, optimized for massive scale and unstructured data storage.
8Which type of database enforces referential integrity between tables?
A.Document database
B.Key-value store
C.Relational database
D.Time-series database
Explanation: Relational databases enforce referential integrity through foreign key constraints that maintain relationships between tables. Document databases, key-value stores, and time-series databases do not typically enforce such relationships at the database level.
9Non-relational databases are also commonly referred to as what?
A.SQL databases
B.NoSQL databases
C.OLAP databases
D.Data warehouses
Explanation: Non-relational databases are commonly called NoSQL databases. The term "NoSQL" stands for "Not Only SQL," indicating these databases do not use the traditional tabular relational database structure and may use other query languages or APIs.
10Which storage option is best for applications that require complex queries with JOIN operations?
A.Key-value store
B.Relational database
C.Blob storage
D.Queue storage
Explanation: Relational databases excel at complex queries involving JOIN operations that combine data from multiple tables. Key-value stores and blob storage do not support JOINs, while queue storage is for message passing, not query operations.

About the Azure DP-900 Exam

Foundational certification covering core data concepts, relational and non-relational data on Azure, and analytics workloads. Tests knowledge of Azure SQL services, Cosmos DB, Azure Storage, Azure Databricks, Microsoft Fabric, and Power BI.

Exam sponsor: Microsoft. The requirements and fees below concern the certification or admission exam, separate from our free practice resources.

Assessment

Question count not published by the exam provider

Time Limit

45 minutes

Passing Score

700/1000

Exam / Certification Fees

$99 USD

Exam sponsor website

Fees, eligibility, and exam policies can change. Confirm them with the exam sponsor before applying or paying.

Our practice resources: topics covered

We aim to reflect publicly available exam outlines and topic information in our study resources. Coverage, format, and difficulty may differ from the actual exam, and we cannot guarantee that every detail is accurate or current. Confirm exam requirements, fees, and policies with the official exam sponsor.

25-30%

Describe Core Data Concepts

Structured, semi-structured and unstructured data, common data file formats and data stores, transactional and analytical workloads, and data roles

20-25%

Identify Considerations for Relational Data on Azure

Normalization, SQL statements and database objects; Azure SQL Database, SQL Managed Instance, SQL Server on Azure VMs, and Azure services for open-source databases

15-20%

Describe Considerations for Working with Non-Relational Data on Azure

Azure Blob storage, Azure Files, Azure Table storage, and Azure Cosmos DB use cases and APIs

25-30%

Describe an Analytics Workload

Data ingestion and processing, analytical data stores, Azure Databricks, Microsoft Fabric, batch vs streaming data, real-time analytics, and Power BI

Preparing for the Azure DP-900 Exam

What You Need to Know

  • Passing score: 700/1000
  • Assessment: Question count not published by the exam provider
  • Time limit: 45 minutes
  • Exam / certification fees: $99 USD Official sources

Using Our Practice Resources

  • Work through all 200 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

Azure DP-900: Suggested Study Strategy

1Understand the differences between structured, semi-structured, and unstructured data with real-world examples
2Learn Azure SQL deployment options: Single Database (PaaS), Managed Instance (near 100% compatibility), and SQL on VMs (IaaS)
3Master Cosmos DB APIs: NoSQL, MongoDB, Apache Cassandra, Apache Gremlin (graph), and Table
4Know Cosmos DB consistency levels from strongest to weakest: Strong, Bounded Staleness, Session, Consistent Prefix, Eventual
5Understand Blob Storage tiers: Hot (frequent access), Cool (infrequent, 30+ days), Archive (rarely accessed, 180+ days)
6Learn analytics services: Synapse Analytics (unified platform), Databricks (Spark-based), Data Factory (ETL/ELT), Power BI (visualization)

Frequently Asked Questions

What is the Azure DP-900 exam?

The Azure DP-900 (Microsoft Azure Data Fundamentals) is an entry-level certification that validates your understanding of core data concepts and how data services work on Microsoft Azure. It covers relational data, non-relational data, and analytics workloads without requiring hands-on implementation experience.

How many questions are on the DP-900 exam?

Microsoft does not publish a fixed question count for DP-900; most Microsoft exams have 40-60 questions, including multiple-choice and multiple-select items. You have 45 minutes of exam time (65 minutes of seat time). The passing score is 700 out of 1000.

How long should I study for Azure DP-900?

Most candidates need 25-35 hours of study over 3-4 weeks to prepare for the DP-900 exam. If you have prior experience with databases or Azure, you may need less time. Focus on understanding the differences between relational and non-relational data and when to use each Azure service.

What topics are covered on the DP-900 exam?

The DP-900 exam covers four skill areas: Describe core data concepts (25-30%); Identify considerations for relational data on Azure (20-25%), including Azure SQL and open-source databases; Describe considerations for working with non-relational data on Azure (15-20%), including Azure Storage and Cosmos DB; and Describe an analytics workload (25-30%), including Azure Databricks, Microsoft Fabric and Power BI.

Is Azure DP-900 worth it?

Yes, the Azure DP-900 is valuable for anyone looking to demonstrate foundational data knowledge, especially database administrators, data analysts, and those pursuing Azure data certifications. It is a good stepping stone to role-based certifications like Azure Database Administrator Associate (DP-300) or Fabric Data Engineer Associate (DP-700).

What is the difference between DP-900 and DP-700?

DP-900 is a fundamentals-level exam testing conceptual knowledge of data concepts and Azure data services. DP-700 (Fabric Data Engineer Associate) is the associate-level data engineering exam; DP-203 (Azure Data Engineer Associate) was retired on March 31, 2025.