McAfee-Secured Website

Exam Bundle

Exam Code: DP-900

Exam Name Microsoft Azure Data Fundamentals

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: Azure Data Fundamentals

Microsoft DP-900 Bundle $25.00

100% Microsoft DP-900 Guaranteed Success With Testking Training Materials

Get Real DP-900 Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

  • Questions & Answers

    DP-900 Questions & Answers

    332 Questions & Answers

    The ultimate exam preparation tool, Questions & Answers mirrors the actual DP-900 exam while allowing you to hone and measure every aspect of your test-taking ability.

  • DP-900 Video Course

    DP-900 Video Course

    32 Video Lectures

    DP-900 Video Course is developed by Microsoft Professionals to help you pass the DP-900 exam.

    Description

    This course will improve your knowledge and skills required to pass Microsoft Azure Data Fundamentals exam.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Total Cost: $164.98
Bundle Price: $139.98

Purchase Individually

  • Questions & Answers

    Questions & Answers

    332 Questions

    $124.99
  • DP-900 Video Course

    Video Course

    32 Video Lectures

    $39.99

Microsoft DP-900 Practice Test 4

Question 30

A data professional makes this decision: Prefer a JSON document to a flat CSV row for the nested event. Which outcome is the most direct expected result?

  1. Common fields can be searched without requiring identical optional attributes everywhere.
  2. Related objects and arrays can stay together even when individual records have different shapes.
  3. JSON can encode nested objects and arrays without flattening them into columns.
  4. The relationship preserves a single customer entity while allowing multiple order rows.

Explanation

Correct Answer

C:

This is the expected outcome for JSON object versus CSV: JSON can encode nested objects and arrays without flattening them into columns.

Incorrect Answers

A:

This result would follow the different Log event shape decision (Recognize these event documents as semi-structured logs.) rather than the specified design.

B:

This result would follow the different Nested document decision (Use a nested document representation for the variable product attributes.) rather than the specified design.

D:

This result would follow the different Data model cardinality decision (Represent the customer-to-orders association as a one-to-many relationship.) rather than the specified design.

Question 31

A telemetry provider must preserve nested arrays of sensor readings in a single transmitted event. Someone instead proposes: Recognize these event documents as semi-structured logs. Which alternative is the best correction for the original requirement?

  1. Represent the customer-to-orders association as a one-to-many relationship.
  2. Recognize these event documents as semi-structured logs.
  3. Use a nested document representation for the variable product attributes.
  4. Prefer a JSON document to a flat CSV row for the nested event.

Explanation

Correct Answer

D:

This correction addresses JSON object versus CSV. JSON can encode nested objects and arrays without flattening them into columns.

Incorrect Answers

A:

This choice is for Data model cardinality, not the specific requirement. The relationship preserves a single customer entity while allowing multiple order rows.

B:

This choice is for Log event shape, not the specific requirement. Common fields can be searched without requiring identical optional attributes everywhere.

C:

This choice is for Nested document, not the specific requirement. Related objects and arrays can stay together even when individual records have different shapes.

Question 32

A data architect recommends this approach: Prefer a JSON document to a flat CSV row for the nested event. Which situation most clearly calls for that approach?

  1. A telemetry provider must preserve nested arrays of sensor readings in a single transmitted event.
  2. Application logs contain timestamps and severity but occasionally include additional request identifiers and exception properties.
  3. A store has one customer record associated with many distinct orders, each belonging to one customer.
  4. An online product catalog stores categories, localized descriptions and varying accessory arrays within each product item.

Explanation

Correct Answer

A:

This situation calls for JSON object versus CSV. JSON can encode nested objects and arrays without flattening them into columns.

Incorrect Answers

B:

The other situation is better matched to Recognize these event documents as semi-structured logs. Common fields can be searched without requiring identical optional attributes everywhere.

C:

The other situation is better matched to Represent the customer-to-orders association as a one-to-many relationship. The relationship preserves a single customer entity while allowing multiple order rows.

D:

The other situation is better matched to Use a nested document representation for the variable product attributes. Related objects and arrays can stay together even when individual records have different shapes.

Question 33

An image-recognition pipeline ingests JPEG files rather than strings that can be split into delimited fields. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Classify the comments as unstructured text rather than imposing fixed numeric columns.
  2. Treat JPEG as a binary media representation rather than a text table.
  3. Classify the pictures as unstructured binary content.
  4. Represent each entity as relational tables with defined columns and keys.

Explanation

Correct Answer

B:

The requirement concerns Binary versus textual. A file decoder is needed to interpret the compressed image contents.

Incorrect Answers

A:

That action instead addresses Free-form text: Natural-language content may require text search or language processing for analysis. It does not directly satisfy the described Binary versus textual need.

C:

That action instead addresses Raw image assets: The file contents need specialized interpretation rather than a predetermined tabular schema. It does not directly satisfy the described Binary versus textual need.

D:

That action instead addresses Relational rows: Structured rows support consistent types, constraints and joins across related business entities. It does not directly satisfy the described Binary versus textual need.

Question 34

A data professional makes this decision: Treat JPEG as a binary media representation rather than a text table. Which outcome is the most direct expected result?

  1. The file contents need specialized interpretation rather than a predetermined tabular schema.
  2. Natural-language content may require text search or language processing for analysis.
  3. A file decoder is needed to interpret the compressed image contents.
  4. Structured rows support consistent types, constraints and joins across related business entities.

Explanation

Correct Answer

C:

This is the expected outcome for Binary versus textual: A file decoder is needed to interpret the compressed image contents.

Incorrect Answers

A:

This result would follow the different Raw image assets decision (Classify the pictures as unstructured binary content.) rather than the specified design.

B:

This result would follow the different Free-form text decision (Classify the comments as unstructured text rather than imposing fixed numeric columns.) rather than the specified design.

D:

This result would follow the different Relational rows decision (Represent each entity as relational tables with defined columns and keys.) rather than the specified design.

Question 35

An image-recognition pipeline ingests JPEG files rather than strings that can be split into delimited fields. Someone instead proposes: Classify the comments as unstructured text rather than imposing fixed numeric columns. Which alternative is the best correction for the original requirement?

  1. Classify the comments as unstructured text rather than imposing fixed numeric columns.
  2. Represent each entity as relational tables with defined columns and keys.
  3. Classify the pictures as unstructured binary content.
  4. Treat JPEG as a binary media representation rather than a text table.

Explanation

Correct Answer

D:

This correction addresses Binary versus textual. A file decoder is needed to interpret the compressed image contents.

Incorrect Answers

A:

This choice is for Free-form text, not the specific requirement. Natural-language content may require text search or language processing for analysis.

B:

This choice is for Relational rows, not the specific requirement. Structured rows support consistent types, constraints and joins across related business entities.

C:

This choice is for Raw image assets, not the specific requirement. The file contents need specialized interpretation rather than a predetermined tabular schema.

Question 36

A data architect recommends this approach: Treat JPEG as a binary media representation rather than a text table. Which situation most clearly calls for that approach?

  1. An image-recognition pipeline ingests JPEG files rather than strings that can be split into delimited fields.
  2. A support team needs to store a collection of handwritten customer comments transcribed into unrestricted paragraphs.
  3. A retailer records each sale as a transaction with an order identifier, customer identifier and a fixed set of columns, then joins orders to customers.
  4. A media archive collects product photographs whose pixels cannot be meaningfully queried as rows and columns.

Explanation

Correct Answer

A:

This situation calls for Binary versus textual. A file decoder is needed to interpret the compressed image contents.

Incorrect Answers

B:

The other situation is better matched to Classify the comments as unstructured text rather than imposing fixed numeric columns. Natural-language content may require text search or language processing for analysis.

C:

The other situation is better matched to Represent each entity as relational tables with defined columns and keys. Structured rows support consistent types, constraints and joins across related business entities.

D:

The other situation is better matched to Classify the pictures as unstructured binary content. The file contents need specialized interpretation rather than a predetermined tabular schema.

Question 37

A financial import rejects an amount containing alphabetic characters and a date in an invalid format. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Treat the export as structured data with a documented tabular schema.
  2. Treat XML as a semi-structured hierarchical format.
  3. Treat the video streams as unstructured data and store searchable metadata independently.
  4. Apply a defined schema with data type validation before loading records.

Explanation

Correct Answer

D:

The requirement concerns Schema enforcement. Invalid values are detected instead of silently corrupting typed fields.

Incorrect Answers

A:

That action instead addresses Structured schema: Known field types and names enable predictable validation and SQL-style processing. It does not directly satisfy the described Schema enforcement need.

B:

That action instead addresses XML hierarchy: Tags identify fields while nested and optional elements describe variable structures. It does not directly satisfy the described Schema enforcement need.

C:

That action instead addresses Video recordings: The audiovisual payload is not inherently a relational collection of typed fields. It does not directly satisfy the described Schema enforcement need.

Question 38

A data professional makes this decision: Apply a defined schema with data type validation before loading records. Which outcome is the most direct expected result?

  1. Invalid values are detected instead of silently corrupting typed fields.
  2. The audiovisual payload is not inherently a relational collection of typed fields.
  3. Tags identify fields while nested and optional elements describe variable structures.
  4. Known field types and names enable predictable validation and SQL-style processing.

Explanation

Correct Answer

A:

This is the expected outcome for Schema enforcement: Invalid values are detected instead of silently corrupting typed fields.

Incorrect Answers

B:

This result would follow the different Video recordings decision (Treat the video streams as unstructured data and store searchable metadata independently.) rather than the specified design.

C:

This result would follow the different XML hierarchy decision (Treat XML as a semi-structured hierarchical format.) rather than the specified design.

D:

This result would follow the different Structured schema decision (Treat the export as structured data with a documented tabular schema.) rather than the specified design.

Question 39

A financial import rejects an amount containing alphabetic characters and a date in an invalid format. Someone instead proposes: Treat XML as a semi-structured hierarchical format. Which alternative is the best correction for the original requirement?

  1. Treat XML as a semi-structured hierarchical format.
  2. Apply a defined schema with data type validation before loading records.
  3. Treat the export as structured data with a documented tabular schema.
  4. Treat the video streams as unstructured data and store searchable metadata independently.

Explanation

Correct Answer

B:

This correction addresses Schema enforcement. Invalid values are detected instead of silently corrupting typed fields.

Incorrect Answers

A:

This choice is for XML hierarchy, not the specific requirement. Tags identify fields while nested and optional elements describe variable structures.

C:

This choice is for Structured schema, not the specific requirement. Known field types and names enable predictable validation and SQL-style processing.

D:

This choice is for Video recordings, not the specific requirement. The audiovisual payload is not inherently a relational collection of typed fields.

Question 40

A data architect recommends this approach: Apply a defined schema with data type validation before loading records. Which situation most clearly calls for that approach?

  1. A training platform stores recorded lessons as large video files with metadata maintained separately.
  2. An integration partner sends XML orders containing nested line items and optional discount elements.
  3. A financial import rejects an amount containing alphabetic characters and a date in an invalid format.
  4. A payroll export has employee number, payment date and numeric amount in every record and must be validated before import.

Explanation

Correct Answer

C:

This situation calls for Schema enforcement. Invalid values are detected instead of silently corrupting typed fields.

Incorrect Answers

A:

The other situation is better matched to Treat the video streams as unstructured data and store searchable metadata independently. The audiovisual payload is not inherently a relational collection of typed fields.

B:

The other situation is better matched to Treat XML as a semi-structured hierarchical format. Tags identify fields while nested and optional elements describe variable structures.

D:

The other situation is better matched to Treat the export as structured data with a documented tabular schema. Known field types and names enable predictable validation and SQL-style processing.