Pass Microsoft Azure Data DP-900 Exam in First Attempt Easily
Real Microsoft Azure Data DP-900 Exam Questions, Accurate & Verified Answers As Experienced in the Actual Test!

Verified by experts
3 products

You save $69.98

DP-900 Premium Bundle

  • Premium File 332 Questions & Answers
  • Last Update: Nov 14, 2026
  • Training Course 32 Lectures
  • Study Guide 672 Pages
$79.99 $149.97

Purchase Individually

  • Premium File

    332 Questions & Answers
    Last Update: Nov 14, 2026

    $76.99
    $69.99
  • Training Course

    32 Lectures

    $43.99
    $39.99
  • Study Guide

    672 Pages

    $43.99
    $39.99

Microsoft Azure Data Fundamentals DP-900 Practice Test 6

Question 50

Several Azure VMs must mount one shared directory via SMB for a legacy application. A team proposes: Select a managed cloud file share exposed over SMB. Which observation would BEST demonstrate that this exact requirement was met?

  1. A setting can be read using its composite identity despite varying attributes across devices.
  2. The existing application accesses the same file path from multiple authorized hosts.
  3. A reader round-trips nested objects and arrays while retaining their field names.
  4. Spreadsheet software reads the same fixed-column values using the agreed delimiter and encoding.

Explanation

Correct Answer

B:

The existing application accesses the same file path from multiple authorized hosts. File shares offer familiar directory and file semantics over network protocols. It is tied to this case: Several Azure VMs must mount one shared directory via SMB for a legacy application.

Incorrect Answers

A:

A setting can be read using its composite identity despite varying attributes across devices. This would validate a different scenario: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. The proposed change here is Select a managed cloud file share exposed over SMB. and its decisive acceptance check is The existing application accesses the same file path from multiple authorized hosts.

C:

A reader round-trips nested objects and arrays while retaining their field names. This would validate a different scenario: A telemetry archive contains deeply nested device properties and optional arrays for each event. The proposed change here is Select a managed cloud file share exposed over SMB. and its decisive acceptance check is The existing application accesses the same file path from multiple authorized hosts.

D:

Spreadsheet software reads the same fixed-column values using the agreed delimiter and encoding. This would validate a different scenario: A financial team exports normalized monthly totals for interchange with spreadsheet tools and no nested records. The proposed change here is Select a managed cloud file share exposed over SMB. and its decisive acceptance check is The existing application accesses the same file path from multiple authorized hosts.

Question 51

During an architecture review, the team proposes: Select a managed cloud file share exposed over SMB. The requirement is: Several Azure VMs must mount one shared directory via SMB for a legacy application. Which technical explanation BEST justifies this specific recommendation?

  1. Key/attribute stores hold flexibly shaped entities optimized around access keys.
  2. JSON represents nested objects and arrays as a flexible data-interchange format.
  3. File shares offer familiar directory and file semantics over network protocols.
  4. CSV stores tabular values as delimited text without embedded relational constraints.

Explanation

Correct Answer

C:

File shares offer familiar directory and file semantics over network protocols. Evidence would be: The existing application accesses the same file path from multiple authorized hosts. The choice avoids this risk: Changing the app to use object-storage URLs does not satisfy an existing SMB path dependency.

Incorrect Answers

A:

Key/attribute stores hold flexibly shaped entities optimized around access keys. That principle applies to the separate requirement: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. It may be true in that setting, but does not specifically explain why Select a managed cloud file share exposed over SMB. is the best fit here. The relevant reason is File shares offer familiar directory and file semantics over network protocols.

B:

JSON represents nested objects and arrays as a flexible data-interchange format. That principle applies to the separate requirement: A telemetry archive contains deeply nested device properties and optional arrays for each event. It may be true in that setting, but does not specifically explain why Select a managed cloud file share exposed over SMB. is the best fit here. The relevant reason is File shares offer familiar directory and file semantics over network protocols.

D:

CSV stores tabular values as delimited text without embedded relational constraints. That principle applies to the separate requirement: A financial team exports normalized monthly totals for interchange with spreadsheet tools and no nested records. It may be true in that setting, but does not specifically explain why Select a managed cloud file share exposed over SMB. is the best fit here. The relevant reason is File shares offer familiar directory and file semantics over network protocols.

Question 52

Several Azure VMs must mount one shared directory via SMB for a legacy application. If the team ignores the targeted approach (Select a managed cloud file share exposed over SMB.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Forcing every device option into a global fixed relational schema adds needless sparse columns.
  2. Flattening arbitrary nested arrays into one CSV row can lose parent-child relationships.
  3. Using CSV without a documented header or delimiter can misalign numeric fields.
  4. Changing the app to use object-storage URLs does not satisfy an existing SMB path dependency.

Explanation

Correct Answer

D:

Changing the app to use object-storage URLs does not satisfy an existing SMB path dependency. This risk follows from the exact scenario: Several Azure VMs must mount one shared directory via SMB for a legacy application. The reason is file shares offer familiar directory and file semantics over network protocols. The direct mitigation is: Select a managed cloud file share exposed over SMB.

Incorrect Answers

A:

Forcing every device option into a global fixed relational schema adds needless sparse columns. This is a real potential problem in a different scenario: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. The present case instead concerns Several Azure VMs must mount one shared directory via SMB for a legacy application. With the targeted action omitted, the direct exposure is Changing the app to use object-storage URLs does not satisfy an existing SMB path dependency.

B:

Flattening arbitrary nested arrays into one CSV row can lose parent-child relationships. This is a real potential problem in a different scenario: A telemetry archive contains deeply nested device properties and optional arrays for each event. The present case instead concerns Several Azure VMs must mount one shared directory via SMB for a legacy application. With the targeted action omitted, the direct exposure is Changing the app to use object-storage URLs does not satisfy an existing SMB path dependency.

C:

Using CSV without a documented header or delimiter can misalign numeric fields. This is a real potential problem in a different scenario: A financial team exports normalized monthly totals for interchange with spreadsheet tools and no nested records. The present case instead concerns Several Azure VMs must mount one shared directory via SMB for a legacy application. With the targeted action omitted, the direct exposure is Changing the app to use object-storage URLs does not satisfy an existing SMB path dependency.

Question 53

A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Choose a relational database rather than a plain object-file archive as the operational system of record.
  2. Choose a key/attribute non-relational data store with application-managed access patterns.
  3. Use CSV for the simple delimited tabular export with an agreed column header.
  4. Select scalable object/blob storage for the binary attachments.

Explanation

Correct Answer

B:

Choose a key/attribute non-relational data store with application-managed access patterns. This directly addresses the case: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. The deciding technical reason is that key/attribute stores hold flexibly shaped entities optimized around access keys. Verify the solution by checking: A setting can be read using its composite identity despite varying attributes across devices.

Incorrect Answers

A:

Choose a relational database rather than a plain object-file archive as the operational system of record. This is a legitimate approach for a different problem: An order-entry app requires transactions, referential constraints, and SQL joins across product and customer entities. Relational database engines manage constrained tables and transactional access. It does not directly satisfy the present constraint: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. The needed outcome is: A setting can be read using its composite identity despite varying attributes across devices.

C:

Use CSV for the simple delimited tabular export with an agreed column header. This is a legitimate approach for a different problem: A financial team exports normalized monthly totals for interchange with spreadsheet tools and no nested records. CSV stores tabular values as delimited text without embedded relational constraints. It does not directly satisfy the present constraint: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. The needed outcome is: A setting can be read using its composite identity despite varying attributes across devices.

D:

Select scalable object/blob storage for the binary attachments. This is a legitimate approach for a different problem: A website needs durable storage of image uploads and PDF attachments accessed by URL rather than mounted drive paths. Object storage is suited to large numbers of independent unstructured items. It does not directly satisfy the present constraint: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. The needed outcome is: A setting can be read using its composite identity despite varying attributes across devices.

Question 54

A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. A team proposes: Choose a key/attribute non-relational data store with application-managed access patterns. Which observation would BEST demonstrate that this exact requirement was met?

  1. The service validates foreign keys and commits related row changes transactionally.
  2. Spreadsheet software reads the same fixed-column values using the agreed delimiter and encoding.
  3. A setting can be read using its composite identity despite varying attributes across devices.
  4. The application reads and writes files as objects with identifiers and metadata.

Explanation

Correct Answer

C:

A setting can be read using its composite identity despite varying attributes across devices. Key/attribute stores hold flexibly shaped entities optimized around access keys. It is tied to this case: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity.

Incorrect Answers

A:

The service validates foreign keys and commits related row changes transactionally. This would validate a different scenario: An order-entry app requires transactions, referential constraints, and SQL joins across product and customer entities. The proposed change here is Choose a key/attribute non-relational data store with application-managed access patterns. and its decisive acceptance check is A setting can be read using its composite identity despite varying attributes across devices.

B:

Spreadsheet software reads the same fixed-column values using the agreed delimiter and encoding. This would validate a different scenario: A financial team exports normalized monthly totals for interchange with spreadsheet tools and no nested records. The proposed change here is Choose a key/attribute non-relational data store with application-managed access patterns. and its decisive acceptance check is A setting can be read using its composite identity despite varying attributes across devices.

D:

The application reads and writes files as objects with identifiers and metadata. This would validate a different scenario: A website needs durable storage of image uploads and PDF attachments accessed by URL rather than mounted drive paths. The proposed change here is Choose a key/attribute non-relational data store with application-managed access patterns. and its decisive acceptance check is A setting can be read using its composite identity despite varying attributes across devices.

Question 55

During an architecture review, the team proposes: Choose a key/attribute non-relational data store with application-managed access patterns. The requirement is: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. Which technical explanation BEST justifies this specific recommendation?

  1. Relational database engines manage constrained tables and transactional access.
  2. CSV stores tabular values as delimited text without embedded relational constraints.
  3. Object storage is suited to large numbers of independent unstructured items.
  4. Key/attribute stores hold flexibly shaped entities optimized around access keys.

Explanation

Correct Answer

D:

Key/attribute stores hold flexibly shaped entities optimized around access keys. Evidence would be: A setting can be read using its composite identity despite varying attributes across devices. The choice avoids this risk: Forcing every device option into a global fixed relational schema adds needless sparse columns.

Incorrect Answers

A:

Relational database engines manage constrained tables and transactional access. That principle applies to the separate requirement: An order-entry app requires transactions, referential constraints, and SQL joins across product and customer entities. It may be true in that setting, but does not specifically explain why Choose a key/attribute non-relational data store with application-managed access patterns. is the best fit here. The relevant reason is Key/attribute stores hold flexibly shaped entities optimized around access keys.

B:

CSV stores tabular values as delimited text without embedded relational constraints. That principle applies to the separate requirement: A financial team exports normalized monthly totals for interchange with spreadsheet tools and no nested records. It may be true in that setting, but does not specifically explain why Choose a key/attribute non-relational data store with application-managed access patterns. is the best fit here. The relevant reason is Key/attribute stores hold flexibly shaped entities optimized around access keys.

C:

Object storage is suited to large numbers of independent unstructured items. That principle applies to the separate requirement: A website needs durable storage of image uploads and PDF attachments accessed by URL rather than mounted drive paths. It may be true in that setting, but does not specifically explain why Choose a key/attribute non-relational data store with application-managed access patterns. is the best fit here. The relevant reason is Key/attribute stores hold flexibly shaped entities optimized around access keys.

Question 56

A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. If the team ignores the targeted approach (Choose a key/attribute non-relational data store with application-managed access patterns.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Forcing every device option into a global fixed relational schema adds needless sparse columns.
  2. Object files alone do not provide built-in relational transactions or foreign keys.
  3. Using CSV without a documented header or delimiter can misalign numeric fields.
  4. A SQL table of large binary blobs may be less appropriate than purpose-built object storage for this requirement.

Explanation

Correct Answer

A:

Forcing every device option into a global fixed relational schema adds needless sparse columns. This risk follows from the exact scenario: A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. The reason is key/attribute stores hold flexibly shaped entities optimized around access keys. The direct mitigation is: Choose a key/attribute non-relational data store with application-managed access patterns.

Incorrect Answers

B:

Object files alone do not provide built-in relational transactions or foreign keys. This is a real potential problem in a different scenario: An order-entry app requires transactions, referential constraints, and SQL joins across product and customer entities. The present case instead concerns A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. With the targeted action omitted, the direct exposure is Forcing every device option into a global fixed relational schema adds needless sparse columns.

C:

Using CSV without a documented header or delimiter can misalign numeric fields. This is a real potential problem in a different scenario: A financial team exports normalized monthly totals for interchange with spreadsheet tools and no nested records. The present case instead concerns A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. With the targeted action omitted, the direct exposure is Forcing every device option into a global fixed relational schema adds needless sparse columns.

D:

A SQL table of large binary blobs may be less appropriate than purpose-built object storage for this requirement. This is a real potential problem in a different scenario: A website needs durable storage of image uploads and PDF attachments accessed by URL rather than mounted drive paths. The present case instead concerns A team wants an operational key-value store for sparse device settings keyed by tenant and device identity. With the targeted action omitted, the direct exposure is Forcing every device option into a global fixed relational schema adds needless sparse columns.

Question 57

A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Classify the request as an analytical workload with large historical scans.
  2. Execute aggregate analytical queries on historical order facts.
  3. Classify the workload as online transaction processing with ACID integrity.
  4. Use event streaming rather than a once-per-day ETL run for immediate detection.

Explanation

Correct Answer

C:

Classify the workload as online transaction processing with ACID integrity. This directly addresses the case: A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. The deciding technical reason is that oLTP prioritizes frequent short consistent reads and writes for business operations. Verify the solution by checking: The order and stock update either both commit or both roll back on failure.

Incorrect Answers

A:

Classify the request as an analytical workload with large historical scans. This is a legitimate approach for a different problem: Leadership asks for five-year revenue trends by region using aggregated historical transactions. OLAP emphasizes aggregations and exploration across many historical records. It does not directly satisfy the present constraint: A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. The needed outcome is: The order and stock update either both commit or both roll back on failure.

B:

Execute aggregate analytical queries on historical order facts. This is a legitimate approach for a different problem: A retailer asks to analyze basket size across thousands of purchases, grouped by quarter and product category. Analytical systems summarize many operational records for decision support. It does not directly satisfy the present constraint: A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. The needed outcome is: The order and stock update either both commit or both roll back on failure.

D:

Use event streaming rather than a once-per-day ETL run for immediate detection. This is a legitimate approach for a different problem: A fraud monitor must recognize a spike in card declines within seconds of each event. Streaming workloads continuously process arriving records for low-latency decisions. It does not directly satisfy the present constraint: A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. The needed outcome is: The order and stock update either both commit or both roll back on failure.

Question 58

A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. A team proposes: Classify the workload as online transaction processing with ACID integrity. Which observation would BEST demonstrate that this exact requirement was met?

  1. The query groups long-range sales records without holding up front-line transaction entry.
  2. The report computes category totals over the requested quarters without changing orders.
  3. A threshold rule reacts to recent events within the seconds-level business target.
  4. The order and stock update either both commit or both roll back on failure.

Explanation

Correct Answer

D:

The order and stock update either both commit or both roll back on failure. OLTP prioritizes frequent short consistent reads and writes for business operations. It is tied to this case: A payment checkout must atomically debit inventory and create one order without leaving a partial transaction.

Incorrect Answers

A:

The query groups long-range sales records without holding up front-line transaction entry. This would validate a different scenario: Leadership asks for five-year revenue trends by region using aggregated historical transactions. The proposed change here is Classify the workload as online transaction processing with ACID integrity. and its decisive acceptance check is The order and stock update either both commit or both roll back on failure.

B:

The report computes category totals over the requested quarters without changing orders. This would validate a different scenario: A retailer asks to analyze basket size across thousands of purchases, grouped by quarter and product category. The proposed change here is Classify the workload as online transaction processing with ACID integrity. and its decisive acceptance check is The order and stock update either both commit or both roll back on failure.

C:

A threshold rule reacts to recent events within the seconds-level business target. This would validate a different scenario: A fraud monitor must recognize a spike in card declines within seconds of each event. The proposed change here is Classify the workload as online transaction processing with ACID integrity. and its decisive acceptance check is The order and stock update either both commit or both roll back on failure.

Question 59

During an architecture review, the team proposes: Classify the workload as online transaction processing with ACID integrity. The requirement is: A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. Which technical explanation BEST justifies this specific recommendation?

  1. OLTP prioritizes frequent short consistent reads and writes for business operations.
  2. OLAP emphasizes aggregations and exploration across many historical records.
  3. Analytical systems summarize many operational records for decision support.
  4. Streaming workloads continuously process arriving records for low-latency decisions.

Explanation

Correct Answer

A:

OLTP prioritizes frequent short consistent reads and writes for business operations. Evidence would be: The order and stock update either both commit or both roll back on failure. The choice avoids this risk: Treating a checkout as a periodically refreshed report risks inconsistent operational balances.

Incorrect Answers

B:

OLAP emphasizes aggregations and exploration across many historical records. That principle applies to the separate requirement: Leadership asks for five-year revenue trends by region using aggregated historical transactions. It may be true in that setting, but does not specifically explain why Classify the workload as online transaction processing with ACID integrity. is the best fit here. The relevant reason is OLTP prioritizes frequent short consistent reads and writes for business operations.

C:

Analytical systems summarize many operational records for decision support. That principle applies to the separate requirement: A retailer asks to analyze basket size across thousands of purchases, grouped by quarter and product category. It may be true in that setting, but does not specifically explain why Classify the workload as online transaction processing with ACID integrity. is the best fit here. The relevant reason is OLTP prioritizes frequent short consistent reads and writes for business operations.

D:

Streaming workloads continuously process arriving records for low-latency decisions. That principle applies to the separate requirement: A fraud monitor must recognize a spike in card declines within seconds of each event. It may be true in that setting, but does not specifically explain why Classify the workload as online transaction processing with ACID integrity. is the best fit here. The relevant reason is OLTP prioritizes frequent short consistent reads and writes for business operations.

Question 60

A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. If the team ignores the targeted approach (Classify the workload as online transaction processing with ACID integrity.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Running giant aggregates against the checkout workload may compete with operational writes.
  2. Treating a checkout as a periodically refreshed report risks inconsistent operational balances.
  3. Single-order transaction lookups do not by themselves produce the cross-period summary.
  4. Waiting for the next overnight batch would miss the detection-time requirement.

Explanation

Correct Answer

B:

Treating a checkout as a periodically refreshed report risks inconsistent operational balances. This risk follows from the exact scenario: A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. The reason is oLTP prioritizes frequent short consistent reads and writes for business operations. The direct mitigation is: Classify the workload as online transaction processing with ACID integrity.

Incorrect Answers

A:

Running giant aggregates against the checkout workload may compete with operational writes. This is a real potential problem in a different scenario: Leadership asks for five-year revenue trends by region using aggregated historical transactions. The present case instead concerns A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. With the targeted action omitted, the direct exposure is Treating a checkout as a periodically refreshed report risks inconsistent operational balances.

C:

Single-order transaction lookups do not by themselves produce the cross-period summary. This is a real potential problem in a different scenario: A retailer asks to analyze basket size across thousands of purchases, grouped by quarter and product category. The present case instead concerns A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. With the targeted action omitted, the direct exposure is Treating a checkout as a periodically refreshed report risks inconsistent operational balances.

D:

Waiting for the next overnight batch would miss the detection-time requirement. This is a real potential problem in a different scenario: A fraud monitor must recognize a spike in card declines within seconds of each event. The present case instead concerns A payment checkout must atomically debit inventory and create one order without leaving a partial transaction. With the targeted action omitted, the direct exposure is Treating a checkout as a periodically refreshed report risks inconsistent operational balances.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests

Purchase Individually

  • Premium File

    332 Questions & Answers
    Last Update: Nov 14, 2026

    $76.99
    $69.99
  • Training Course

    32 Lectures

    $43.99
    $39.99
  • Study Guide

    672 Pages

    $43.99
    $39.99

SPECIAL OFFER: GET 10% OFF
This is ONE TIME OFFER

You save
10%

Enter Your Email Address to Receive Your 10% Off Discount Code

SPECIAL OFFER: GET 10% OFF

You save
10%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@examlabs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your email address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports