Today’s Set
10 questions
Rotates at 10:00 AM local time
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.
DP-900
Microsoft Azure Data Fundamentals
Why this page works
- Daily exam-aligned questions
- Source links on every explanation
- Local progress saved automatically
- Email sync path ready for later
- Apps provide deeper drills when available
One-time unlock
Unlock the full DP-900 bank
Get 150 verified questions, every choice explained, Exam Mode, Practice Mode, random tests, readiness tracking, previous scores, and no ads.
Secure checkout by Stripe. Instant unlock on this page. No subscription.
See bundle and PDF options
Already Pro? Open dashboard
Choose an unlock option to continue. We will confirm your site email in one quick checkout step.
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.
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.
Question 1 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?
Azure Blob Storage is the ideal choice for storing unstructured data like photos and videos. It's designed for massive scalability, cost-effective storage of large binary files, and efficient content delivery through Azure CDN. Blob Storage offers different tiers (Hot, Cool, Archive) to optimize costs based on access frequency. The other options are unsuitable: Azure SQL Database is for relational data, Azure Cosmos DB is for NoSQL document databases requiring complex querying, and Azure Table Storage is for structured, semi-structured data and is not optimized for large binary files.
Concept tested: Non-Relational Data (Explore non-relational data in Azure)
Question 2 of 10
Objective Explore core data concepts
Relational Data Concepts
A startup is building an e-commerce platform that requires real-time transaction processing for credit card payments and order processing. The database must guarantee that no transactions are partially completed or lost in the event of a system failure. Which database service and workload type is most appropriate for this scenario?
This scenario demands ACID (Atomicity, Consistency, Isolation, Durability) properties to ensure data integrity and prevent data loss during system failures, which is a hallmark of Online Transaction Processing (OLTP). Azure SQL Database is a fully managed relational database service that excels at handling these types of workloads. Relational databases enforce relationships between data, ensuring consistency, and provide mechanisms like transactions to guarantee data integrity. The requirement for real-time processing and guaranteed completion makes a relational database the ideal choice.
Concept tested: Relational Data Concepts (Explore core data concepts)
Question 3 of 10
Objective Explore non-relational data in Azure
Non-Relational Data
A global IoT device manufacturer collects telemetry data from millions of sensors deployed across various environments. This data includes temperature readings, humidity levels, pressure measurements, and timestamps, arriving continuously and in high volumes. The data needs to be analyzed in near real-time to identify anomalies and trigger automated responses. The solution must be highly scalable, cost-effective for storing large volumes of time-series data, and support efficient querying based on time ranges. Which Azure service is the most appropriate for ingesting and storing this telemetry data?
Azure Time Series Insights (Gen2) is specifically designed for ingesting, storing, and analyzing time-series data. It provides built-in capabilities for data aggregation, anomaly detection, and querying data based on time ranges, making it ideal for IoT telemetry workloads. The service automatically handles partitioning and indexing for efficient time-based queries. While other options can store data, they lack the specialized features and optimizations for time-series analysis that Time Series Insights offers. This service is optimized for this exact scenario, providing a managed solution for complex time-series workloads.
Concept tested: Non-Relational Data (Explore non-relational data in Azure)
Question 4 of 10
Objective Explore core data concepts
Relational Data Concepts
A financial institution is designing a new Azure SQL Database to store transaction data for its banking ledger application. The application requires recording every financial transaction, including details like transaction date, time, account involved, transaction type (deposit, withdrawal, transfer), amount, and a unique transaction identifier. The system anticipates a high volume of transactions and needs to efficiently query for transactions within specific date ranges and by account. Which relational data structure would be most appropriate for this scenario?
The most appropriate structure is two tables: one for account information and another for transaction details. This approach separates the account data from the transaction data, which is a common and efficient practice. The account table stores static account information, while the transaction table stores the dynamic transaction records. The foreign key relationship between the tables allows for efficient querying of transactions associated with specific accounts. This design balances data organization, query performance, and maintainability, which are crucial for a banking ledger application handling high transaction volumes. A single table would lead to performance issues with large datasets. Three tables would add unnecessary complexity for this relatively simple relationship. An aggregated table would lose the granularity of individual transactions.
Concept tested: Relational Data Concepts (Explore core data concepts)
Question 5 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?
The Hot tier is the correct choice for frequently accessed data. It offers the lowest latency and highest throughput, making it ideal for active user file downloads. The Hot tier is designed for data that is accessed frequently and is the most expensive access tier. Archive tier is for infrequently accessed data, Cool tier is for data accessed less frequently than Hot but more frequently than Archive, and Premium tier is for block blob storage that requires high performance and low latency for write operations, which isn't the primary requirement here.
Concept tested: Non-Relational Data (Explore non-relational data in Azure)
Question 6 of 10
Objective Explore core data concepts
Relational Data Concepts
Contoso Corporation is implementing a system to manage its organizational structure. Each employee reports to a manager within the company. The system needs to efficiently represent the hierarchical relationships between employees, allowing for easy retrieval of reporting lines and organizational charts. Which relational database design approach is most suitable for representing this organizational hierarchy?
A self-referencing table is the most appropriate solution for representing hierarchical data like an organizational structure. This design allows each employee record to directly link to their manager's record within the same table, creating a chain of reporting relationships. This structure is efficient for traversing the hierarchy and generating organizational charts. The recursive nature inherently supports multiple levels of management. The other options are less efficient or flexible for this specific scenario. Option 1 would be difficult to query for deep reporting lines. Option 2 introduces unnecessary complexity and joins. Option 4, while flexible, would be less performant for querying and reporting on the hierarchy.
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 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?
Azure Cosmos DB for NoSQL (Key-value) is the optimal choice because it's designed for flexible schema and fast key-based lookups. The key-value model allows each product to have its own unique key (product ID) and a document containing its attributes. Changes to a product's attributes can be made directly without impacting other products, and the service provides low-latency reads and writes. Azure SQL Database is relational and requires a predefined schema, making it less flexible for frequently changing attributes. Azure Blob Storage is for storing unstructured data like images or videos, not structured configuration data. Azure Table Storage is a NoSQL option, but it has limitations in querying and schema flexibility compared to Cosmos DB, making it less ideal for this scenario.
Concept tested: Non-Relational Data (Explore non-relational data in Azure)
Question 8 of 10
Objective Explore core data concepts
Relational Data Concepts
A customer completes an online order checkout. The database transaction is committed successfully. Immediately after, the database server experiences a sudden power loss and crashes. Which ACID property guarantees that the committed order data is not lost and will remain saved when the server restarts?
The ACID properties are fundamental to database transactions. Durability specifically ensures that once a transaction is committed, the changes are permanent and survive even system failures like power outages. The database system will employ mechanisms like transaction logs and redundant storage to guarantee this. Atomicity ensures all parts of a transaction succeed or fail as a single unit. Consistency ensures data adheres to defined rules and constraints. Isolation prevents interference between concurrent transactions. In this scenario, the key concern is data persistence after a crash, which is directly addressed by the durability property.
Concept tested: Relational Data Concepts (Explore core data concepts)
Question 9 of 10
Objective Explore non-relational data in Azure
Non-Relational Data
A marketing analytics team is collecting website clickstream data. Each click event includes a user ID, timestamp, page URL, device type, and geographic region. The data volume is rapidly growing, and the team needs a flexible schema to accommodate potential new attributes in the future without requiring significant application code changes. They also need to be able to query the data based on various combinations of these attributes. Which data format would be MOST suitable for storing this data in Azure, considering the need for flexibility and query capabilities?
JSON (JavaScript Object Notation) is the most appropriate choice for this scenario. JSON's flexible, schema-less nature allows for easy addition of new attributes to click events without requiring schema migrations. This aligns perfectly with the team's requirement for adaptability. Furthermore, Azure data services like Azure Data Lake Storage Gen2 and Azure Cosmos DB offer excellent support for querying JSON documents, enabling efficient analysis based on various combinations of attributes. While XML is also semi-structured, JSON is generally preferred for its simpler syntax and broader adoption in modern web applications. CSV and TSV are structured formats and lack the flexibility needed to accommodate evolving data attributes.
Concept tested: Non-Relational Data (Explore non-relational data in Azure)
Question 10 of 10
Objective Explore core data concepts
Relational Data Concepts
A retail company, 'Global Gadgets,' uses Azure SQL Database to store order information. They frequently need to audit their database to ensure data integrity and compliance. Specifically, they need to be able to recreate the exact state of the database at a specific point in time for forensic analysis and to verify data consistency after potential errors or application updates. Which Azure SQL Database feature is most appropriate for Global Gadgets to achieve this capability?
Azure SQL Database Point-in-Time Restore allows you to restore your database to a specific point in time, effectively recreating its state as it existed at that moment. This is crucial for auditing, data recovery, and ensuring data consistency after unexpected events. Elastic Pools manage resource allocation across databases, Geo-Replication provides disaster recovery and read-scale capabilities, and Transparent Data Encryption protects data at rest but doesn't provide point-in-time recovery. Therefore, Point-in-Time Restore is the only option that directly addresses the requirement of recreating a database's state at a specific time.
Concept tested: Relational Data Concepts (Explore core data concepts)
Daily set complete
You finished today’s free 10.
Unlock the full 150-question bank to keep practicing now.
Full bank
Random tests
Exam Mode
Readiness tracking
Locked preview
You are viewing today’s free 10. Unlock 140 more questions.
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 and want the lower fundamentals price.
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 Access
$6.99/month
Unlock Microsoft, Azure, Power Platform, Copilot, and AI practice exams.
Why it fitsUnlock Microsoft, Azure, Power Platform, Copilot, and AI practice exams, Includes current and future Microsoft practice banks on dotCreds, Best for learners taking more than one Microsoft exam, PDF downloads sold separately where available
We will ask for your site email in a quick checkout step, remember it on this browser, and use it again for restore.
Secure checkout
Where should we send your unlock?
Use the same email for checkout, restore, and the dashboard on this browser.
Your selected purchase will stay attached while you confirm the checkout email.
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.
Pro practice
Build a DP-900 session
Choose the question count, question set, session mode, and timer for your full-bank practice.
Pass plan
Tell dotCreds what you are aiming for.
Set a target once. We will keep the next study action visible before every Pro session.
Do this next: start Practice Mode with 20 questions to build your baseline.
Exam readiness
0%
Start Exam Mode or Practice Mode to build your readiness trend on this browser.
Last 7 days: 0 questions answered
Based on 7-day accuracy, question volume, and bank coverage on this browser.
Previous tests
Box scores, domain breakdowns, and full answer explanations for Pro exam attempts on this browser.
Purchase options
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 full-bank 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
7-day score keeper
Answer questions today and this will become a rolling 7-day scorecard.
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
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, the correct answer explanation, wrong-answer distractor explanations when the reviewed bank provides them, objective mapping, and source links. Pro-only bank questions stay locked; this section mirrors only the 10 free daily questions already shown on this page.
Question 1 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?
Answer choices
- A. Azure SQL Database
- B. Azure Blob Storage
- C. Azure Cosmos DB
- D. Azure Table Storage
Correct answer
Azure Blob Storage
Azure Blob Storage is the ideal choice for storing unstructured data like photos and videos. It's designed for massive scalability, cost-effective storage of large binary files, and efficient content delivery through Azure CDN. Blob Storage offers different tiers (Hot, Cool, Archive) to optimize costs based on access frequency. The other options are unsuitable: Azure SQL Database is for relational data, Azure Cosmos DB is for NoSQL document databases requiring complex querying, and Azure Table Storage is for structured, semi-structured data and is not optimized for large binary files.
Wrong-answer review
- A. Azure SQL Database: Azure SQL Database is incorrect because it is a relational database service. It is designed for structured data and transactional workloads, not for storing large binary files like photos and videos. Using it for this purpose would be inefficient and costly.
- C. Azure Cosmos DB: Azure Cosmos DB is incorrect because it is a NoSQL database service optimized for document storage and complex querying. However, it can store binary data, it's not the most cost-effective or performant solution for serving large media files. It is strength lies in flexible schema and global distribution for application data, not media storage.
- D. Azure Table Storage: Azure Table Storage is incorrect because it is a NoSQL key-value store designed for structured or semi-structured data. It is not optimized for storing large binary files and lacks the content delivery capabilities of Blob Storage. It is best suited for storing metadata or configuration data, not media assets.
Question 2 A startup is building an e-commerce platform that requires real-time transaction processing for credit card payments and order processing. The database must guarantee that no transactions are partially completed or lost in the event of a system failure. Which database service and workload type is most appropriate for this scenario?
Answer choices
- A. A relational database workload (OLTP) utilizing Azure SQL Database.
- B. A non-relational database workload utilizing Azure Cosmos DB Cassandra API.
- C. An analytical workload (OLAP) utilizing Azure Synapse dedicated SQL pools.
- D. An unstructured storage workload utilizing Azure Blob Storage Archive tier.
Correct answer
A relational database workload (OLTP) utilizing Azure SQL Database.
This scenario demands ACID (Atomicity, Consistency, Isolation, Durability) properties to ensure data integrity and prevent data loss during system failures, which is a hallmark of Online Transaction Processing (OLTP). Azure SQL Database is a fully managed relational database service that excels at handling these types of workloads. Relational databases enforce relationships between data, ensuring consistency, and provide mechanisms like transactions to guarantee data integrity. The requirement for real-time processing and guaranteed completion makes a relational database the ideal choice.
Wrong-answer review
- B. A non-relational database workload utilizing Azure Cosmos DB Cassandra API.: A non-relational database workload utilizing Azure Cosmos DB Cassandra API. is incorrect because Azure Cosmos DB Cassandra API is a NoSQL database designed for high-volume, low-latency reads and writes, but it doesn't inherently guarantee the same level of ACID compliance as a relational database. However, Cosmos DB *can* be configured for ACID transactions, it's not the default or most efficient solution for this scenario, and the Cassandra API is particularly suited for wide-column stores, not transactional processing.
- C. An analytical workload (OLAP) utilizing Azure Synapse dedicated SQL pools.: An analytical workload (OLAP) utilizing Azure Synapse dedicated SQL pools. is incorrect because Azure Synapse dedicated SQL pools are optimized for analytical workloads (OLAP), which involve complex queries and reporting on large datasets. They are not designed for the high-frequency, low-latency transactions required by an e-commerce platform. Using Synapse for this purpose would be inefficient and costly.
- D. An unstructured storage workload utilizing Azure Blob Storage Archive tier.: An unstructured storage workload utilizing Azure Blob Storage Archive tier. is incorrect because Azure Blob Storage Archive tier is for storing infrequently accessed data. It is not a database service and doesn't support any transactional processing or data integrity guarantees. It is suitable for backups or archival purposes, but not for real-time e-commerce transactions.
Question 3 A global IoT device manufacturer collects telemetry data from millions of sensors deployed across various environments. This data includes temperature readings, humidity levels, pressure measurements, and timestamps, arriving continuously and in high volumes. The data needs to be analyzed in near real-time to identify anomalies and trigger automated responses. The solution must be highly scalable, cost-effective for storing large volumes of time-series data, and support efficient querying based on time ranges. Which Azure service is the most appropriate for ingesting and storing this telemetry data?
Answer choices
- A. Azure SQL Database
- B. Azure Data Lake Storage Gen2
- C. Azure Time Series Insights (Gen2)
- D. Azure Blob Storage
Correct answer
Azure Time Series Insights (Gen2)
Azure Time Series Insights (Gen2) is specifically designed for ingesting, storing, and analyzing time-series data. It provides built-in capabilities for data aggregation, anomaly detection, and querying data based on time ranges, making it ideal for IoT telemetry workloads. The service automatically handles partitioning and indexing for efficient time-based queries. While other options can store data, they lack the specialized features and optimizations for time-series analysis that Time Series Insights offers. This service is optimized for this exact scenario, providing a managed solution for complex time-series workloads.
Wrong-answer review
- A. Azure SQL Database: Azure SQL Database is incorrect because it is a relational database and not optimized for the high-volume, continuous ingestion and analysis of time-series data. However, it *can* store time-series data, it would be significantly less efficient and more expensive than a specialized time-series service. Relational databases are better suited for transactional workloads with well-defined schemas.
- B. Azure Data Lake Storage Gen2: Azure Data Lake Storage Gen2 is incorrect because it is excellent for storing large volumes of data in its raw format, but it doesn't provide built-in capabilities for time-series analysis or efficient querying based on time ranges. It is a storage solution, not an analytical service. You would need to build additional layers on top of Data Lake Storage to perform the required analysis.
- D. Azure Blob Storage: Azure Blob Storage is incorrect because it is a general-purpose storage service suitable for storing unstructured data like images and videos. However, it can store time-series data, it lacks the specialized features and optimizations for time-series analysis that Time Series Insights offers. It would require significant custom development to achieve the desired functionality.
Question 4 A financial institution is designing a new Azure SQL Database to store transaction data for its banking ledger application. The application requires recording every financial transaction, including details like transaction date, time, account involved, transaction type (deposit, withdrawal, transfer), amount, and a unique transaction identifier. The system anticipates a high volume of transactions and needs to efficiently query for transactions within specific date ranges and by account. Which relational data structure would be most appropriate for this scenario?
Answer choices
- A. A single table containing all transaction details, with columns for each attribute (date, time, account, type, amount, identifier).
- B. Two tables: one for account information (account ID, account type, balance) and another for transaction details (transaction ID, account ID, date, time, type, amount).
- C. Three tables: one for accounts, one for transaction types, and one for transaction details, using foreign keys to link the tables.
- D. A wide table with a single row per day, containing aggregated transaction data for each account.
Correct answer
Two tables: one for account information (account ID, account type, balance) and another for transaction details (transaction ID, account ID, date, time, type, amount).
The most appropriate structure is two tables: one for account information and another for transaction details. This approach separates the account data from the transaction data, which is a common and efficient practice. The account table stores static account information, while the transaction table stores the dynamic transaction records. The foreign key relationship between the tables allows for efficient querying of transactions associated with specific accounts. This design balances data organization, query performance, and maintainability, which are crucial for a banking ledger application handling high transaction volumes. A single table would lead to performance issues with large datasets. Three tables would add unnecessary complexity for this relatively simple relationship. An aggregated table would lose the granularity of individual transactions.
Wrong-answer review
- A. A single table containing all transaction details, with columns for each attribute (date, time, account, type, amount, identifier).: A single table containing all transaction details, with columns for each attribute (date, time, account, type, amount, identifier). is incorrect because using a single table would become very large and unwieldy, leading to performance issues when querying for specific transactions. It also mixes static account information with dynamic transaction data, making updates and maintenance more complex.
- C. Three tables: one for accounts, one for transaction types, and one for transaction details, using foreign keys to link the tables.: Three tables: one for accounts, one for transaction types, and one for transaction details, using foreign keys to link the tables. is incorrect because while using multiple tables is a valid design principle, three tables are unnecessary complexity for this scenario. The relationship between accounts and transactions is a simple one-to-many, which can be effectively managed with two tables.
- D. A wide table with a single row per day, containing aggregated transaction data for each account.: A wide table with a single row per day, containing aggregated transaction data for each account. is incorrect because Aggregating transaction data into a daily table would lose the detail of individual transactions, which is essential for a banking ledger application. It also makes it difficult to query for specific transactions or perform detailed analysis.
Question 5 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?
Answer choices
- A. Archive tier
- B. Cool tier
- C. Hot tier
- D. Premium tier
Correct answer
Hot tier
The Hot tier is the correct choice for frequently accessed data. It offers the lowest latency and highest throughput, making it ideal for active user file downloads. The Hot tier is designed for data that is accessed frequently and is the most expensive access tier. Archive tier is for infrequently accessed data, Cool tier is for data accessed less frequently than Hot but more frequently than Archive, and Premium tier is for block blob storage that requires high performance and low latency for write operations, which isn't the primary requirement here.
Wrong-answer review
- A. Archive tier: Archive tier is incorrect because The Archive tier is designed for data that is rarely accessed. Retrieving data from the Archive tier incurs significant retrieval costs and latency, making it unsuitable for frequent user downloads. This would result in a poor user experience and potentially high costs due to retrieval charges.
- B. Cool tier: Cool tier is incorrect because The Cool tier is intended for data that is accessed less frequently than Hot tier data, but more frequently than Archive tier data. However, it's cheaper than Hot, the increased latency for retrieval would negatively impact the user experience for frequently downloaded files.
- D. Premium tier: Premium tier is incorrect because it is specifically for block blob storage requiring high performance and low latency for *write* operations. The scenario focuses on read (download) performance, making this option irrelevant.
Question 6 Contoso Corporation is implementing a system to manage its organizational structure. Each employee reports to a manager within the company. The system needs to efficiently represent the hierarchical relationships between employees, allowing for easy retrieval of reporting lines and organizational charts. Which relational database design approach is most suitable for representing this organizational hierarchy?
Answer choices
- A. Create a single table with a 'reportsTo' column referencing the employee ID of the manager. This column would contain NULL values for employees at the top of the hierarchy.
- B. Create two tables: an 'Employees' table containing employee details and a 'ManagerAssignments' table linking employees to their managers.
- C. Create a recursive table with a self-referencing foreign key, where each employee record includes a 'managerEmployeeID' column referencing another employee record within the same table.
- D. Implement a JSON structure within a single table to store the reporting hierarchy for each employee, allowing for flexible and dynamic reporting lines.
Correct answer
Create a recursive table with a self-referencing foreign key, where each employee record includes a 'managerEmployeeID' column referencing another employee record within the same table.
A self-referencing table is the most appropriate solution for representing hierarchical data like an organizational structure. This design allows each employee record to directly link to their manager's record within the same table, creating a chain of reporting relationships. This structure is efficient for traversing the hierarchy and generating organizational charts. The recursive nature inherently supports multiple levels of management. The other options are less efficient or flexible for this specific scenario. Option 1 would be difficult to query for deep reporting lines. Option 2 introduces unnecessary complexity and joins. Option 4, while flexible, would be less performant for querying and reporting on the hierarchy.
Wrong-answer review
- A. Create a single table with a 'reportsTo' column referencing the employee ID of the manager. This column would contain NULL values for employees at the top of the hierarchy.: Create a single table with a 'reportsTo' column referencing the employee ID of the manager. This column would contain NULL values for employees at the top of the hierarchy. is incorrect because This approach is overly simplistic and would make querying for deeper reporting lines extremely inefficient. Retrieving the full reporting chain for an employee would require multiple queries and complex joins, significantly impacting performance. It also doesn't scale well as the hierarchy grows.
- B. Create two tables: an 'Employees' table containing employee details and a 'ManagerAssignments' table linking employees to their managers.: Create two tables: an 'Employees' table containing employee details and a 'ManagerAssignments' table linking employees to their managers. is incorrect because while this design could technically represent the relationships, it introduces unnecessary complexity and requires a join operation to retrieve the manager's information along with the employee's details. This adds overhead and reduces query performance compared to a self-referencing approach.
- D. Implement a JSON structure within a single table to store the reporting hierarchy for each employee, allowing for flexible and dynamic reporting lines.: Implement a JSON structure within a single table to store the reporting hierarchy for each employee, allowing for flexible and dynamic reporting lines. is incorrect because while JSON structures offer flexibility, they are generally less performant for querying and reporting on structured data compared to relational tables. Using JSON would also make it more difficult to enforce data integrity and consistency within the hierarchy.
Question 7 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?
Answer choices
- A. Azure SQL Database
- B. Azure Cosmos DB for NoSQL (Key-value)
- C. Azure Blob Storage
- D. Azure Table Storage
Correct answer
Azure Cosmos DB for NoSQL (Key-value)
Azure Cosmos DB for NoSQL (Key-value) is the optimal choice because it's designed for flexible schema and fast key-based lookups. The key-value model allows each product to have its own unique key (product ID) and a document containing its attributes. Changes to a product's attributes can be made directly without impacting other products, and the service provides low-latency reads and writes. Azure SQL Database is relational and requires a predefined schema, making it less flexible for frequently changing attributes. Azure Blob Storage is for storing unstructured data like images or videos, not structured configuration data. Azure Table Storage is a NoSQL option, but it has limitations in querying and schema flexibility compared to Cosmos DB, making it less ideal for this scenario.
Wrong-answer review
- A. Azure SQL Database: Azure SQL Database is incorrect because it is a relational database. The product configuration data's variable attributes would require frequent schema modifications, which is inefficient and costly in a relational database. It is not designed for this level of flexibility.
- C. Azure Blob Storage: Azure Blob Storage is incorrect because it is designed for storing unstructured data like images, videos, and documents. It is does not match the requirement for storing structured product configuration data that requires querying and updates.
- D. Azure Table Storage: Azure Table Storage is incorrect because it is a NoSQL option, but it has limitations in querying capabilities and schema flexibility compared to Azure Cosmos DB. However, it supports key-value pairs, Cosmos DB offers better performance and more advanced features for this use case.
Question 8 A customer completes an online order checkout. The database transaction is committed successfully. Immediately after, the database server experiences a sudden power loss and crashes. Which ACID property guarantees that the committed order data is not lost and will remain saved when the server restarts?
Answer choices
- A. Atomicity
- B. Consistency
- C. Durability
- D. Isolation
Correct answer
Durability
The ACID properties are fundamental to database transactions. Durability specifically ensures that once a transaction is committed, the changes are permanent and survive even system failures like power outages. The database system will employ mechanisms like transaction logs and redundant storage to guarantee this. Atomicity ensures all parts of a transaction succeed or fail as a single unit. Consistency ensures data adheres to defined rules and constraints. Isolation prevents interference between concurrent transactions. In this scenario, the key concern is data persistence after a crash, which is directly addressed by the durability property.
Wrong-answer review
- A. Atomicity: Atomicity is incorrect because it ensures that a transaction is treated as a single, indivisible unit of work. If any part of the transaction fails, the entire transaction is rolled back, preventing partial updates. However, important for data integrity, it doesn't guarantee data survival after a system crash. It focuses on the 'all or nothing' aspect of a transaction.
- B. Consistency: Consistency is incorrect because it ensures that a transaction brings the database from one valid state to another, adhering to defined rules and constraints. It prevents invalid data from being written to the database. However, consistency doesn't address data persistence in the face of system failures; it focuses on maintaining data validity.
- D. Isolation: Isolation is incorrect because it ensures that concurrent transactions do not interfere with each other. It prevents data corruption and ensures data accuracy when multiple users or processes are accessing the database simultaneously. However, important for concurrency, it doesn't guarantee data survival after a system crash.
Question 9 A marketing analytics team is collecting website clickstream data. Each click event includes a user ID, timestamp, page URL, device type, and geographic region. The data volume is rapidly growing, and the team needs a flexible schema to accommodate potential new attributes in the future without requiring significant application code changes. They also need to be able to query the data based on various combinations of these attributes. Which data format would be MOST suitable for storing this data in Azure, considering the need for flexibility and query capabilities?
Answer choices
- A. Comma-Separated Values (CSV)
- B. JavaScript Object Notation (JSON)
- C. Extensible Markup Language (XML)
- D. Tab-Separated Values (TSV)
Correct answer
JavaScript Object Notation (JSON)
JSON (JavaScript Object Notation) is the most appropriate choice for this scenario. JSON's flexible, schema-less nature allows for easy addition of new attributes to click events without requiring schema migrations. This aligns perfectly with the team's requirement for adaptability. Furthermore, Azure data services like Azure Data Lake Storage Gen2 and Azure Cosmos DB offer excellent support for querying JSON documents, enabling efficient analysis based on various combinations of attributes. While XML is also semi-structured, JSON is generally preferred for its simpler syntax and broader adoption in modern web applications. CSV and TSV are structured formats and lack the flexibility needed to accommodate evolving data attributes.
Wrong-answer review
- A. Comma-Separated Values (CSV): Comma-Separated Values (CSV) is incorrect because CSV (Comma-Separated Values) is a structured format. It requires a predefined schema, which would make it difficult to accommodate new attributes in the clickstream data without modifying the schema and potentially breaking existing applications. It lacks the flexibility needed for this scenario.
- C. Extensible Markup Language (XML): Extensible Markup Language (XML) is incorrect because XML (Extensible Markup Language) is also a semi-structured format, but it's generally more verbose and complex than JSON. However, it offers flexibility, JSON is often preferred for its simpler syntax and wider adoption in modern web applications. The added complexity of XML doesn't provide a significant advantage over JSON in this scenario.
- D. Tab-Separated Values (TSV): Tab-Separated Values (TSV) is incorrect because TSV (Tab-Separated Values) is a structured format, similar to CSV. It also requires a predefined schema and lacks the flexibility needed to accommodate evolving data attributes. It is does not match the requirement for this scenario.
Question 10 A retail company, 'Global Gadgets,' uses Azure SQL Database to store order information. They frequently need to audit their database to ensure data integrity and compliance. Specifically, they need to be able to recreate the exact state of the database at a specific point in time for forensic analysis and to verify data consistency after potential errors or application updates. Which Azure SQL Database feature is most appropriate for Global Gadgets to achieve this capability?
Answer choices
- A. Azure SQL Database Elastic Pools
- B. Azure SQL Database Point-in-Time Restore
- C. Azure SQL Database Geo-Replication
- D. Azure SQL Database Transparent Data Encryption
Correct answer
Azure SQL Database Point-in-Time Restore
Azure SQL Database Point-in-Time Restore allows you to restore your database to a specific point in time, effectively recreating its state as it existed at that moment. This is crucial for auditing, data recovery, and ensuring data consistency after unexpected events. Elastic Pools manage resource allocation across databases, Geo-Replication provides disaster recovery and read-scale capabilities, and Transparent Data Encryption protects data at rest but doesn't provide point-in-time recovery. Therefore, Point-in-Time Restore is the only option that directly addresses the requirement of recreating a database's state at a specific time.
Wrong-answer review
- A. Azure SQL Database Elastic Pools: Azure SQL Database Elastic Pools is incorrect because Elastic Pools are used for managing and optimizing resource usage across multiple Azure SQL Databases. However, they can improve performance and cost-efficiency, they don't provide the ability to restore a database to a specific point in time. They are a resource management feature, not a recovery feature.
- C. Azure SQL Database Geo-Replication: Azure SQL Database Geo-Replication is incorrect because Geo-Replication provides disaster recovery and read-scale capabilities by creating copies of your database in different Azure regions. However, it enhances availability, it doesn't allow you to revert to a specific point in time within a single database.
- D. Azure SQL Database Transparent Data Encryption: Azure SQL Database Transparent Data Encryption is incorrect because Transparent Data Encryption protects data at rest by encrypting the database files. It is a security feature and doesn't provide any functionality related to restoring a database to a previous state.
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.
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.