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 2

Question 10

A legal department archives scanned contract images and audio depositions without searchable data columns. A team proposes: Classify the originals as unstructured binary content and retain metadata separately. Which observation would BEST demonstrate that this exact requirement was met?

  1. The schema validates each record and SQL can filter Salary as a numeric field.
  2. Two valid events with different property sets can be ingested without fabricating empty fixed columns.
  3. A join retrieves each order with its related product without duplicating every product description.
  4. The original image and audio bytes remain accessible even though their contents are not relational rows.

Explanation

Correct Answer

D:

The original image and audio bytes remain accessible even though their contents are not relational rows. Unstructured files do not naturally follow a fixed row-and-column schema. It is tied to this case: A legal department archives scanned contract images and audio depositions without searchable data columns.

Incorrect Answers

A:

The schema validates each record and SQL can filter Salary as a numeric field. This would validate a different scenario: A payroll import contains fixed columns EmployeeId, Department, and Salary with a predictable type for every row. The proposed change here is Classify the originals as unstructured binary content and retain metadata separately. and its decisive acceptance check is The original image and audio bytes remain accessible even though their contents are not relational rows.

B:

Two valid events with different property sets can be ingested without fabricating empty fixed columns. This would validate a different scenario: A device uploads JSON telemetry in which some events include an optional batteryLevel property. The proposed change here is Classify the originals as unstructured binary content and retain metadata separately. and its decisive acceptance check is The original image and audio bytes remain accessible even though their contents are not relational rows.

C:

A join retrieves each order with its related product without duplicating every product description. This would validate a different scenario: An invoice database has a Products table and a separate Orders table linked by product identifiers. The proposed change here is Classify the originals as unstructured binary content and retain metadata separately. and its decisive acceptance check is The original image and audio bytes remain accessible even though their contents are not relational rows.

Question 11

During an architecture review, the team proposes: Classify the originals as unstructured binary content and retain metadata separately. The requirement is: A legal department archives scanned contract images and audio depositions without searchable data columns. Which technical explanation BEST justifies this specific recommendation?

  1. Unstructured files do not naturally follow a fixed row-and-column schema.
  2. Structured data has a predefined schema with consistent field types.
  3. Semi-structured data has recognizable tags or keys but does not require one fixed column schema.
  4. Related relational tables preserve entities and associations through shared keys.

Explanation

Correct Answer

A:

Unstructured files do not naturally follow a fixed row-and-column schema. Evidence would be: The original image and audio bytes remain accessible even though their contents are not relational rows. The choice avoids this risk: Trying to impose simple numeric columns on raw media does not preserve its content.

Incorrect Answers

B:

Structured data has a predefined schema with consistent field types. That principle applies to the separate requirement: A payroll import contains fixed columns EmployeeId, Department, and Salary with a predictable type for every row. It may be true in that setting, but does not specifically explain why Classify the originals as unstructured binary content and retain metadata separately. is the best fit here. The relevant reason is Unstructured files do not naturally follow a fixed row-and-column schema.

C:

Semi-structured data has recognizable tags or keys but does not require one fixed column schema. That principle applies to the separate requirement: A device uploads JSON telemetry in which some events include an optional batteryLevel property. It may be true in that setting, but does not specifically explain why Classify the originals as unstructured binary content and retain metadata separately. is the best fit here. The relevant reason is Unstructured files do not naturally follow a fixed row-and-column schema.

D:

Related relational tables preserve entities and associations through shared keys. That principle applies to the separate requirement: An invoice database has a Products table and a separate Orders table linked by product identifiers. It may be true in that setting, but does not specifically explain why Classify the originals as unstructured binary content and retain metadata separately. is the best fit here. The relevant reason is Unstructured files do not naturally follow a fixed row-and-column schema.

Question 12

A legal department archives scanned contract images and audio depositions without searchable data columns. If the team ignores the targeted approach (Classify the originals as unstructured binary content and retain metadata separately.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Treating typed columns as free-form text loses reliable validation and comparisons.
  2. Trying to impose simple numeric columns on raw media does not preserve its content.
  3. A rigid identical-column assumption can reject legitimate event variants.
  4. Copying complete product details into each order can introduce update anomalies.

Explanation

Correct Answer

B:

Trying to impose simple numeric columns on raw media does not preserve its content. This risk follows from the exact scenario: A legal department archives scanned contract images and audio depositions without searchable data columns. The reason is unstructured files do not naturally follow a fixed row-and-column schema. The direct mitigation is: Classify the originals as unstructured binary content and retain metadata separately.

Incorrect Answers

A:

Treating typed columns as free-form text loses reliable validation and comparisons. This is a real potential problem in a different scenario: A payroll import contains fixed columns EmployeeId, Department, and Salary with a predictable type for every row. The present case instead concerns A legal department archives scanned contract images and audio depositions without searchable data columns. With the targeted action omitted, the direct exposure is Trying to impose simple numeric columns on raw media does not preserve its content.

C:

A rigid identical-column assumption can reject legitimate event variants. This is a real potential problem in a different scenario: A device uploads JSON telemetry in which some events include an optional batteryLevel property. The present case instead concerns A legal department archives scanned contract images and audio depositions without searchable data columns. With the targeted action omitted, the direct exposure is Trying to impose simple numeric columns on raw media does not preserve its content.

D:

Copying complete product details into each order can introduce update anomalies. This is a real potential problem in a different scenario: An invoice database has a Products table and a separate Orders table linked by product identifiers. The present case instead concerns A legal department archives scanned contract images and audio depositions without searchable data columns. With the targeted action omitted, the direct exposure is Trying to impose simple numeric columns on raw media does not preserve its content.

Question 13

A product feed uses XML tags to describe different attributes for clothing and electronics. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Treat each event as semi-structured JSON with optional fields.
  2. Use the existing relational table structure for repeated order-to-product lookups.
  3. Handle the messages as unstructured text requiring extraction before tabular analysis.
  4. Recognize the feed as semi-structured records with tags describing each field.

Explanation

Correct Answer

D:

Recognize the feed as semi-structured records with tags describing each field. This directly addresses the case: A product feed uses XML tags to describe different attributes for clothing and electronics. The deciding technical reason is that xML elements provide an explicit structure even when records differ in shape. Verify the solution by checking: The parser reads category-dependent tags without requiring identical elements in every product.

Incorrect Answers

A:

Treat each event as semi-structured JSON with optional fields. This is a legitimate approach for a different problem: A device uploads JSON telemetry in which some events include an optional batteryLevel property. Semi-structured data has recognizable tags or keys but does not require one fixed column schema. It does not directly satisfy the present constraint: A product feed uses XML tags to describe different attributes for clothing and electronics. The needed outcome is: The parser reads category-dependent tags without requiring identical elements in every product.

B:

Use the existing relational table structure for repeated order-to-product lookups. This is a legitimate approach for a different problem: An invoice database has a Products table and a separate Orders table linked by product identifiers. Related relational tables preserve entities and associations through shared keys. It does not directly satisfy the present constraint: A product feed uses XML tags to describe different attributes for clothing and electronics. The needed outcome is: The parser reads category-dependent tags without requiring identical elements in every product.

C:

Handle the messages as unstructured text requiring extraction before tabular analysis. This is a legitimate approach for a different problem: A marketing team receives plain-text customer emails with no standardized key-value delimiters. Unstructured natural language must be processed to derive consistent analyzable fields. It does not directly satisfy the present constraint: A product feed uses XML tags to describe different attributes for clothing and electronics. The needed outcome is: The parser reads category-dependent tags without requiring identical elements in every product.

Question 14

A product feed uses XML tags to describe different attributes for clothing and electronics. A team proposes: Recognize the feed as semi-structured records with tags describing each field. Which observation would BEST demonstrate that this exact requirement was met?

  1. The parser reads category-dependent tags without requiring identical elements in every product.
  2. Two valid events with different property sets can be ingested without fabricating empty fixed columns.
  3. A join retrieves each order with its related product without duplicating every product description.
  4. A text-processing step extracts usable concepts without pretending every email is a fixed SQL row.

Explanation

Correct Answer

A:

The parser reads category-dependent tags without requiring identical elements in every product. XML elements provide an explicit structure even when records differ in shape. It is tied to this case: A product feed uses XML tags to describe different attributes for clothing and electronics.

Incorrect Answers

B:

Two valid events with different property sets can be ingested without fabricating empty fixed columns. This would validate a different scenario: A device uploads JSON telemetry in which some events include an optional batteryLevel property. The proposed change here is Recognize the feed as semi-structured records with tags describing each field. and its decisive acceptance check is The parser reads category-dependent tags without requiring identical elements in every product.

C:

A join retrieves each order with its related product without duplicating every product description. This would validate a different scenario: An invoice database has a Products table and a separate Orders table linked by product identifiers. The proposed change here is Recognize the feed as semi-structured records with tags describing each field. and its decisive acceptance check is The parser reads category-dependent tags without requiring identical elements in every product.

D:

A text-processing step extracts usable concepts without pretending every email is a fixed SQL row. This would validate a different scenario: A marketing team receives plain-text customer emails with no standardized key-value delimiters. The proposed change here is Recognize the feed as semi-structured records with tags describing each field. and its decisive acceptance check is The parser reads category-dependent tags without requiring identical elements in every product.

Question 15

During an architecture review, the team proposes: Recognize the feed as semi-structured records with tags describing each field. The requirement is: A product feed uses XML tags to describe different attributes for clothing and electronics. Which technical explanation BEST justifies this specific recommendation?

  1. Semi-structured data has recognizable tags or keys but does not require one fixed column schema.
  2. XML elements provide an explicit structure even when records differ in shape.
  3. Related relational tables preserve entities and associations through shared keys.
  4. Unstructured natural language must be processed to derive consistent analyzable fields.

Explanation

Correct Answer

B:

XML elements provide an explicit structure even when records differ in shape. Evidence would be: The parser reads category-dependent tags without requiring identical elements in every product. The choice avoids this risk: Assuming fixed relational fields can discard category-specific attributes.

Incorrect Answers

A:

Semi-structured data has recognizable tags or keys but does not require one fixed column schema. That principle applies to the separate requirement: A device uploads JSON telemetry in which some events include an optional batteryLevel property. It may be true in that setting, but does not specifically explain why Recognize the feed as semi-structured records with tags describing each field. is the best fit here. The relevant reason is XML elements provide an explicit structure even when records differ in shape.

C:

Related relational tables preserve entities and associations through shared keys. That principle applies to the separate requirement: An invoice database has a Products table and a separate Orders table linked by product identifiers. It may be true in that setting, but does not specifically explain why Recognize the feed as semi-structured records with tags describing each field. is the best fit here. The relevant reason is XML elements provide an explicit structure even when records differ in shape.

D:

Unstructured natural language must be processed to derive consistent analyzable fields. That principle applies to the separate requirement: A marketing team receives plain-text customer emails with no standardized key-value delimiters. It may be true in that setting, but does not specifically explain why Recognize the feed as semi-structured records with tags describing each field. is the best fit here. The relevant reason is XML elements provide an explicit structure even when records differ in shape.

Question 16

A product feed uses XML tags to describe different attributes for clothing and electronics. If the team ignores the targeted approach (Recognize the feed as semi-structured records with tags describing each field.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. A rigid identical-column assumption can reject legitimate event variants.
  2. Copying complete product details into each order can introduce update anomalies.
  3. Assuming fixed relational fields can discard category-specific attributes.
  4. Directly casting arbitrary prose to mandatory typed columns causes malformed records.

Explanation

Correct Answer

C:

Assuming fixed relational fields can discard category-specific attributes. This risk follows from the exact scenario: A product feed uses XML tags to describe different attributes for clothing and electronics. The reason is xML elements provide an explicit structure even when records differ in shape. The direct mitigation is: Recognize the feed as semi-structured records with tags describing each field.

Incorrect Answers

A:

A rigid identical-column assumption can reject legitimate event variants. This is a real potential problem in a different scenario: A device uploads JSON telemetry in which some events include an optional batteryLevel property. The present case instead concerns A product feed uses XML tags to describe different attributes for clothing and electronics. With the targeted action omitted, the direct exposure is Assuming fixed relational fields can discard category-specific attributes.

B:

Copying complete product details into each order can introduce update anomalies. This is a real potential problem in a different scenario: An invoice database has a Products table and a separate Orders table linked by product identifiers. The present case instead concerns A product feed uses XML tags to describe different attributes for clothing and electronics. With the targeted action omitted, the direct exposure is Assuming fixed relational fields can discard category-specific attributes.

D:

Directly casting arbitrary prose to mandatory typed columns causes malformed records. This is a real potential problem in a different scenario: A marketing team receives plain-text customer emails with no standardized key-value delimiters. The present case instead concerns A product feed uses XML tags to describe different attributes for clothing and electronics. With the targeted action omitted, the direct exposure is Assuming fixed relational fields can discard category-specific attributes.

Question 17

An invoice database has a Products table and a separate Orders table linked by product identifiers. Which solution or configuration choice MOST directly satisfies the stated requirement without changing unrelated behavior?

  1. Use the existing relational table structure for repeated order-to-product lookups.
  2. Recognize the feed as semi-structured records with tags describing each field.
  3. Classify the request log as semi-structured data and preserve its nested key hierarchy.
  4. Handle the messages as unstructured text requiring extraction before tabular analysis.

Explanation

Correct Answer

A:

Use the existing relational table structure for repeated order-to-product lookups. This directly addresses the case: An invoice database has a Products table and a separate Orders table linked by product identifiers. The deciding technical reason is that related relational tables preserve entities and associations through shared keys. Verify the solution by checking: A join retrieves each order with its related product without duplicating every product description.

Incorrect Answers

B:

Recognize the feed as semi-structured records with tags describing each field. This is a legitimate approach for a different problem: A product feed uses XML tags to describe different attributes for clothing and electronics. XML elements provide an explicit structure even when records differ in shape. It does not directly satisfy the present constraint: An invoice database has a Products table and a separate Orders table linked by product identifiers. The needed outcome is: A join retrieves each order with its related product without duplicating every product description.

C:

Classify the request log as semi-structured data and preserve its nested key hierarchy. This is a legitimate approach for a different problem: An application exports newline-delimited JSON records for each API request including a variable nested context object. JSON supports hierarchical objects and optional fields under a semi-structured model. It does not directly satisfy the present constraint: An invoice database has a Products table and a separate Orders table linked by product identifiers. The needed outcome is: A join retrieves each order with its related product without duplicating every product description.

D:

Handle the messages as unstructured text requiring extraction before tabular analysis. This is a legitimate approach for a different problem: A marketing team receives plain-text customer emails with no standardized key-value delimiters. Unstructured natural language must be processed to derive consistent analyzable fields. It does not directly satisfy the present constraint: An invoice database has a Products table and a separate Orders table linked by product identifiers. The needed outcome is: A join retrieves each order with its related product without duplicating every product description.

Question 18

An invoice database has a Products table and a separate Orders table linked by product identifiers. A team proposes: Use the existing relational table structure for repeated order-to-product lookups. Which observation would BEST demonstrate that this exact requirement was met?

  1. The parser reads category-dependent tags without requiring identical elements in every product.
  2. A join retrieves each order with its related product without duplicating every product description.
  3. An ingest job parses optional nested properties while retaining each complete JSON event.
  4. A text-processing step extracts usable concepts without pretending every email is a fixed SQL row.

Explanation

Correct Answer

B:

A join retrieves each order with its related product without duplicating every product description. Related relational tables preserve entities and associations through shared keys. It is tied to this case: An invoice database has a Products table and a separate Orders table linked by product identifiers.

Incorrect Answers

A:

The parser reads category-dependent tags without requiring identical elements in every product. This would validate a different scenario: A product feed uses XML tags to describe different attributes for clothing and electronics. The proposed change here is Use the existing relational table structure for repeated order-to-product lookups. and its decisive acceptance check is A join retrieves each order with its related product without duplicating every product description.

C:

An ingest job parses optional nested properties while retaining each complete JSON event. This would validate a different scenario: An application exports newline-delimited JSON records for each API request including a variable nested context object. The proposed change here is Use the existing relational table structure for repeated order-to-product lookups. and its decisive acceptance check is A join retrieves each order with its related product without duplicating every product description.

D:

A text-processing step extracts usable concepts without pretending every email is a fixed SQL row. This would validate a different scenario: A marketing team receives plain-text customer emails with no standardized key-value delimiters. The proposed change here is Use the existing relational table structure for repeated order-to-product lookups. and its decisive acceptance check is A join retrieves each order with its related product without duplicating every product description.

Question 19

During an architecture review, the team proposes: Use the existing relational table structure for repeated order-to-product lookups. The requirement is: An invoice database has a Products table and a separate Orders table linked by product identifiers. Which technical explanation BEST justifies this specific recommendation?

  1. XML elements provide an explicit structure even when records differ in shape.
  2. JSON supports hierarchical objects and optional fields under a semi-structured model.
  3. Related relational tables preserve entities and associations through shared keys.
  4. Unstructured natural language must be processed to derive consistent analyzable fields.

Explanation

Correct Answer

C:

Related relational tables preserve entities and associations through shared keys. Evidence would be: A join retrieves each order with its related product without duplicating every product description. The choice avoids this risk: Copying complete product details into each order can introduce update anomalies.

Incorrect Answers

A:

XML elements provide an explicit structure even when records differ in shape. That principle applies to the separate requirement: A product feed uses XML tags to describe different attributes for clothing and electronics. It may be true in that setting, but does not specifically explain why Use the existing relational table structure for repeated order-to-product lookups. is the best fit here. The relevant reason is Related relational tables preserve entities and associations through shared keys.

B:

JSON supports hierarchical objects and optional fields under a semi-structured model. That principle applies to the separate requirement: An application exports newline-delimited JSON records for each API request including a variable nested context object. It may be true in that setting, but does not specifically explain why Use the existing relational table structure for repeated order-to-product lookups. is the best fit here. The relevant reason is Related relational tables preserve entities and associations through shared keys.

D:

Unstructured natural language must be processed to derive consistent analyzable fields. That principle applies to the separate requirement: A marketing team receives plain-text customer emails with no standardized key-value delimiters. It may be true in that setting, but does not specifically explain why Use the existing relational table structure for repeated order-to-product lookups. is the best fit here. The relevant reason is Related relational tables preserve entities and associations through shared keys.

Question 20

An invoice database has a Products table and a separate Orders table linked by product identifiers. If the team ignores the targeted approach (Use the existing relational table structure for repeated order-to-product lookups.), which consequence or limitation MOST directly follows from leaving that requirement unaddressed?

  1. Assuming fixed relational fields can discard category-specific attributes.
  2. Flattening every event into one mandatory column list risks losing nested context.
  3. Directly casting arbitrary prose to mandatory typed columns causes malformed records.
  4. Copying complete product details into each order can introduce update anomalies.

Explanation

Correct Answer

D:

Copying complete product details into each order can introduce update anomalies. This risk follows from the exact scenario: An invoice database has a Products table and a separate Orders table linked by product identifiers. The reason is related relational tables preserve entities and associations through shared keys. The direct mitigation is: Use the existing relational table structure for repeated order-to-product lookups.

Incorrect Answers

A:

Assuming fixed relational fields can discard category-specific attributes. This is a real potential problem in a different scenario: A product feed uses XML tags to describe different attributes for clothing and electronics. The present case instead concerns An invoice database has a Products table and a separate Orders table linked by product identifiers. With the targeted action omitted, the direct exposure is Copying complete product details into each order can introduce update anomalies.

B:

Flattening every event into one mandatory column list risks losing nested context. This is a real potential problem in a different scenario: An application exports newline-delimited JSON records for each API request including a variable nested context object. The present case instead concerns An invoice database has a Products table and a separate Orders table linked by product identifiers. With the targeted action omitted, the direct exposure is Copying complete product details into each order can introduce update anomalies.

C:

Directly casting arbitrary prose to mandatory typed columns causes malformed records. This is a real potential problem in a different scenario: A marketing team receives plain-text customer emails with no standardized key-value delimiters. The present case instead concerns An invoice database has a Products table and a separate Orders table linked by product identifiers. With the targeted action omitted, the direct exposure is Copying complete product details into each order can introduce update anomalies.

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