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.

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.

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.

Why use the app when available?

The web page is the quick daily practice layer. If a dotCreds app is available for DP-900, the app is better for larger banks, focused weak-domain drills, longer review sessions, and mobile study routines.

Free DP-900 Practice Test

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 10, 2026, 12:01 AM CDT

Guided Course Included Learn DP-900 step by step. Structured lessons, progress tracking, practice questions, and per-exam Course Notes covering every section in this bank.

Step-by-step lessons Per-exam Course Notes All sections included Practice tied to the same bank

Start DP-900 Guided Course Course Notes

Unlock the full DP-900 bank

150 verified exam-style questions $2.99 one-time No subscription Secure checkout Instant unlock

Get the complete source-backed bank with correct-answer explanations, distractor breakdowns, saved review, full Course Mode, and per-exam Course Notes.

Instant unlock • Secure checkout • No subscription

Exam Mode Practice Mode Course Mode Course Notes Weak-area review Previous scores Source links Every choice explained No ads

Question 1 of 10

Objective Explore non-relational data in Azure Non-Relational Data

A social media company is building a new feature to recommend connections to users based on shared interests and groups. They need to store information about users (name, profile details, interests) and the relationships between them (follows, belongs to groups). The relationships are complex and frequently changing, with users joining and leaving groups and following/unfollowing other users. The application requires fast traversal of these relationships to generate connection recommendations. Which Azure data store is the MOST appropriate for this scenario?

Concept tested: Non-Relational Data (Explore non-relational data in Azure)

Source:Explore fundamentals of Azure Cosmos DB

Question 2 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: Relational Data Concepts (Explore core data concepts)

Question 3 of 10

Objective Explore non-relational data in Azure Non-Relational Data

A media company is building a platform for users to upload and share high-resolution photos and videos. They anticipate a large volume of uploads daily, with varying file sizes and formats. The primary use case is serving these media files to users on demand. The company needs a storage solution that is cost-effective for storing large binary files and provides efficient delivery to users globally. Which Azure storage service is the MOST appropriate for this scenario?

Concept tested: Non-Relational Data (Explore non-relational data in Azure)

Question 4 of 10

Objective Explore core data concepts Relational Data Concepts

An online store database is experiencing slow query performance when customers search for items by category, but inserts and updates are fast. What should a developer create to improve the search query performance, and what is its trade-off?

Concept tested: Relational Data Concepts (Explore core data concepts)

Question 5 of 10

Objective Explore non-relational data in Azure Non-Relational Data

A retail company is building a system to store product configuration data. Each product has a unique ID and a variable set of attributes (e.g., color, size, material) that can change frequently. The system needs to support fast retrieval of product configurations based on product ID and allow for easy updates to individual attributes without affecting other products. Given these requirements, which Azure data storage service is the MOST suitable for this scenario?

Concept tested: Non-Relational Data (Explore non-relational data in Azure)

Question 6 of 10

Objective Explore core data concepts Relational Data Concepts

Contoso Retail is implementing a new system to track customer orders. The system will process a high volume of transactions throughout the day, including order placement, payment processing, and inventory updates. However, the primary use case is to quickly retrieve order information for customer service representatives who handle a large number of inquiries. The database administrator is evaluating Azure SQL Database options. Which Azure SQL Database configuration would be most appropriate to balance the need for transactional throughput with the requirement for fast read performance?

Concept tested: Relational Data Concepts (Explore core data concepts)

Question 7 of 10

Objective Explore non-relational data in Azure Non-Relational Data

A retail company is building a new online store. They need to store product catalog information, including product name, description, price, and images. A key requirement is that products can have a variable number of attributes – some products might have size, color, and material, while others might have voltage, wattage, and model number. The company anticipates frequent updates to product attributes and a high volume of reads for displaying product details on the website. Which Azure data store is the most suitable choice for this product catalog?

Concept tested: Non-Relational Data (Explore non-relational data in Azure)

Question 8 of 10

Objective Explore core data concepts Relational Data Concepts

A retail company is implementing an online order processing system using Azure SQL Database. The system needs to reliably handle concurrent order placements, ensuring that either all changes related to a single order (inventory updates, payment processing, order creation) are completed successfully, or none are. A failure during any part of the order process must roll back all previous changes to maintain data consistency. Which of the following characteristics of database transactions is MOST critical to ensure this level of reliability?

Concept tested: Relational Data Concepts (Explore core data concepts)

Question 9 of 10

Objective Explore non-relational data in Azure Non-Relational Data

Contoso Retail is experiencing high volumes of user file downloads (e.g., product manuals, invoices) from their Azure Blob Storage account. These files are accessed frequently throughout the day and are critical for daily operations. To optimize costs while maintaining performance, what Azure Blob Storage access tier is MOST appropriate for these files?

Concept tested: Non-Relational Data (Explore non-relational data in Azure)

Question 10 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: Relational Data Concepts (Explore core data concepts)

Unlock the full DP-900 bank. No ads.

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.

No ads

Question 1 A social media company is building a new feature to recommend connections to users based on shared interests and groups. They need to store information about users (name, profile details, interests) and the relationships between them (follows, belongs to groups). The relationships are complex and frequently changing, with users joining and leaving groups and following/unfollowing other users. The application requires fast traversal of these relationships to generate connection recommendations. Which Azure data store is the MOST appropriate for this scenario?

Answer choices

A. Azure SQL Database, configured with clustered indexes on relationship tables.
B. Azure Cosmos DB with a graph API, modeling users as nodes and relationships as edges.
C. Azure Blob Storage, storing user and relationship data as JSON files.
D. Azure Data Lake Storage Gen2, optimized for large-scale data analytics and batch processing.

Correct answer

Azure Cosmos DB with a graph API, modeling users as nodes and relationships as edges.

Azure Cosmos DB with a graph API is the ideal choice for this scenario. Graph databases are specifically designed to efficiently manage and query complex relationships between entities. Modeling users as nodes and relationships (follows, group memberships) as edges allows for rapid traversal and recommendation generation. The flexible schema of Cosmos DB also accommodates the frequent changes in relationships. The other options are unsuitable: Azure SQL Database would struggle with the complexity and frequent updates of relationships, Blob Storage lacks the querying capabilities needed, and Data Lake Storage is designed for analytics, not real-time relationship traversal.

Wrong-answer review

A. Azure SQL Database, configured with clustered indexes on relationship tables.: Azure SQL Database, configured with clustered indexes on relationship tables. is incorrect because Azure SQL Database is a relational database. However, it can store relationships, querying complex, frequently changing relationships would be inefficient and require significant indexing and maintenance. It is not optimized for graph traversal.
C. Azure Blob Storage, storing user and relationship data as JSON files.: Azure Blob Storage, storing user and relationship data as JSON files. is incorrect because Azure Blob Storage is designed for storing unstructured data like images and videos. It lacks the querying capabilities needed to efficiently manage and query relationships between users.
D. Azure Data Lake Storage Gen2, optimized for large-scale data analytics and batch processing.: Azure Data Lake Storage Gen2, optimized for large-scale data analytics and batch processing. is incorrect because Azure Data Lake Storage Gen2 is optimized for large-scale data analytics and batch processing. It is does not match the requirement for real-time relationship traversal and recommendation generation.

Objective/domain: Non-Relational Data (Explore non-relational data in Azure)

Question 2 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?

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

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

Objective/domain: Relational Data Concepts (Explore core data concepts)

Source: Explore fundamental relational data concepts

Question 3 A media company is building a platform for users to upload and share high-resolution photos and videos. They anticipate a large volume of uploads daily, with varying file sizes and formats. The primary use case is serving these media files to users on demand. The company needs a storage solution that is cost-effective for storing large binary files and provides efficient delivery to users globally. Which Azure storage service is the MOST appropriate for this scenario?

A. Azure SQL Database
B. Azure Blob Storage
C. Azure Cosmos DB
D. Azure Table Storage

Azure Blob Storage

Source: Explore Azure Storage for non-relational data

Question 4 An online store database is experiencing slow query performance when customers search for items by category, but inserts and updates are fast. What should a developer create to improve the search query performance, and what is its trade-off?

A. Create an index on the category column, which speeds up search queries but may slightly slow down inserts and updates.
B. Create a database view, which speeds up both search queries and update performance.
C. Implement a clustered columnstore index, which speeds up writes but slows down reads.
D. Partition the database, which speeds up writes but increases search time.

Create an index on the category column, which speeds up search queries but may slightly slow down inserts and updates.

Question 5 A retail company is building a system to store product configuration data. Each product has a unique ID and a variable set of attributes (e.g., color, size, material) that can change frequently. The system needs to support fast retrieval of product configurations based on product ID and allow for easy updates to individual attributes without affecting other products. Given these requirements, which Azure data storage service is the MOST suitable for this scenario?

A. Azure SQL Database
B. Azure Cosmos DB for NoSQL (Key-value)
C. Azure Blob Storage
D. Azure Table Storage

Azure Cosmos DB for NoSQL (Key-value)

Question 6 Contoso Retail is implementing a new system to track customer orders. The system will process a high volume of transactions throughout the day, including order placement, payment processing, and inventory updates. However, the primary use case is to quickly retrieve order information for customer service representatives who handle a large number of inquiries. The database administrator is evaluating Azure SQL Database options. Which Azure SQL Database configuration would be most appropriate to balance the need for transactional throughput with the requirement for fast read performance?

A. General Purpose tier with a high DTU/vCore count.
B. Business Critical tier with a high DTU/vCore count.
C. Basic tier with a moderate DTU/vCore count.
D. Serverless tier with auto-pause enabled.

General Purpose tier with a high DTU/vCore count.

Question 7 A retail company is building a new online store. They need to store product catalog information, including product name, description, price, and images. A key requirement is that products can have a variable number of attributes – some products might have size, color, and material, while others might have voltage, wattage, and model number. The company anticipates frequent updates to product attributes and a high volume of reads for displaying product details on the website. Which Azure data store is the most suitable choice for this product catalog?

A. Azure SQL Database
B. Azure Blob Storage
C. Azure Cosmos DB (DocumentDB API)
D. Azure Table Storage

Azure Cosmos DB (DocumentDB API)

Question 8 A retail company is implementing an online order processing system using Azure SQL Database. The system needs to reliably handle concurrent order placements, ensuring that either all changes related to a single order (inventory updates, payment processing, order creation) are completed successfully, or none are. A failure during any part of the order process must roll back all previous changes to maintain data consistency. Which of the following characteristics of database transactions is MOST critical to ensure this level of reliability?

A. Durability: Guaranteeing that committed data persists even in the event of system failures.
B. Atomicity: Ensuring that a series of operations are treated as a single, indivisible unit of work.
C. Isolation: Preventing concurrent transactions from interfering with each other’s results.
D. Consistency: Maintaining predefined rules and constraints to ensure data validity.

Atomicity: Ensuring that a series of operations are treated as a single, indivisible unit of work.

Question 9 Contoso Retail is experiencing high volumes of user file downloads (e.g., product manuals, invoices) from their Azure Blob Storage account. These files are accessed frequently throughout the day and are critical for daily operations. To optimize costs while maintaining performance, what Azure Blob Storage access tier is MOST appropriate for these files?

A. Archive tier
B. Cool tier
C. Hot tier
D. Premium tier

Hot tier

Question 10 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?

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

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

DP-900 Practice Test

DP-900

Why this page works

Unlock the full DP-900 bank

Practice with explanations that teach.

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?

An online store database is experiencing slow query performance when customers search for items by category, but inserts and updates are fast. What should a developer create to improve the search query performance, and what is its trade-off?

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

Build your practice session

Set your target once.

Customize your session

Unlock the full DP-900 bank. No ads.

7-day score keeper

Keep today’s practice moving

Answer choices

Correct answer

Wrong-answer review

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

How are DP-900 questions generated?

How are explanations sourced?

What score do I get?

Why use this site?

Why use the app when available?