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 3

Question 20

A data architect recommends this approach: Classify the pictures as unstructured binary content. Which situation most clearly calls for that approach?

  1. A support team needs to store a collection of handwritten customer comments transcribed into unrestricted paragraphs.
  2. A media archive collects product photographs whose pixels cannot be meaningfully queried as rows and columns.
  3. An image-recognition pipeline ingests JPEG files rather than strings that can be split into delimited fields.
  4. 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.

Explanation

Correct Answer

B:

This situation calls for Raw image assets. The file contents need specialized interpretation rather than a predetermined tabular schema.

Incorrect Answers

A:

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 Treat JPEG as a binary media representation rather than a text table. A file decoder is needed to interpret the compressed image contents.

D:

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.

Question 21

A training platform stores recorded lessons as large video files with metadata maintained separately. 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

C:

The requirement concerns Video recordings. The audiovisual payload is not inherently a relational collection of 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 Video recordings 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 Video recordings need.

D:

That action instead addresses Schema enforcement: Invalid values are detected instead of silently corrupting typed fields. It does not directly satisfy the described Video recordings need.

Question 22

A data professional makes this decision: Treat the video streams as unstructured data and store searchable metadata independently. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

D:

This is the expected outcome for Video recordings: The audiovisual payload is not inherently a relational collection of typed fields.

Incorrect Answers

A:

This result would follow the different Schema enforcement decision (Apply a defined schema with data type validation before loading records.) rather than the specified design.

B:

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.

C:

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

Question 23

A training platform stores recorded lessons as large video files with metadata maintained separately. Someone instead proposes: Apply a defined schema with data type validation before loading records. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

A:

This correction addresses Video recordings. The audiovisual payload is not inherently a relational collection of typed fields.

Incorrect Answers

B:

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 Schema enforcement, not the specific requirement. Invalid values are detected instead of silently corrupting typed fields.

D:

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

Question 24

A data architect recommends this approach: Treat the video streams as unstructured data and store searchable metadata independently. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

B:

This situation calls for Video recordings. The audiovisual payload is not inherently a relational collection of typed fields.

Incorrect Answers

A:

The other situation is better matched to Apply a defined schema with data type validation before loading records. Invalid values are detected instead of silently corrupting typed fields.

C:

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.

D:

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.

Question 25

An analyst receives a text file containing values separated by commas and a single header row. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Choose a column-oriented analytical file format such as Parquet.
  2. Classify the JSON payloads as semi-structured data rather than a fixed table.
  3. Identify CSV as a delimited tabular file format.
  4. Model the measurements as structured time-series records with timestamps.

Explanation

Correct Answer

C:

The requirement concerns Delimited file. Each line corresponds to a record with positions defined by the header and delimiter.

Incorrect Answers

A:

That action instead addresses Parquet columnar file: Columnar storage can reduce unnecessary column reads in analytical scans. It does not directly satisfy the described Delimited file need.

B:

That action instead addresses Semi-structured JSON: Keys provide organization while records may have different optional attributes. It does not directly satisfy the described Delimited file need.

D:

That action instead addresses Time-series records: Readings can be filtered and aggregated by device and time interval. It does not directly satisfy the described Delimited file need.

Question 26

A data professional makes this decision: Identify CSV as a delimited tabular file format. Which outcome is the most direct expected result?

  1. Columnar storage can reduce unnecessary column reads in analytical scans.
  2. Readings can be filtered and aggregated by device and time interval.
  3. Keys provide organization while records may have different optional attributes.
  4. Each line corresponds to a record with positions defined by the header and delimiter.

Explanation

Correct Answer

D:

This is the expected outcome for Delimited file: Each line corresponds to a record with positions defined by the header and delimiter.

Incorrect Answers

A:

This result would follow the different Parquet columnar file decision (Choose a column-oriented analytical file format such as Parquet.) rather than the specified design.

B:

This result would follow the different Time-series records decision (Model the measurements as structured time-series records with timestamps.) rather than the specified design.

C:

This result would follow the different Semi-structured JSON decision (Classify the JSON payloads as semi-structured data rather than a fixed table.) rather than the specified design.

Question 27

An analyst receives a text file containing values separated by commas and a single header row. Someone instead proposes: Model the measurements as structured time-series records with timestamps. Which alternative is the best correction for the original requirement?

  1. Identify CSV as a delimited tabular file format.
  2. Choose a column-oriented analytical file format such as Parquet.
  3. Classify the JSON payloads as semi-structured data rather than a fixed table.
  4. Model the measurements as structured time-series records with timestamps.

Explanation

Correct Answer

A:

This correction addresses Delimited file. Each line corresponds to a record with positions defined by the header and delimiter.

Incorrect Answers

B:

This choice is for Parquet columnar file, not the specific requirement. Columnar storage can reduce unnecessary column reads in analytical scans.

C:

This choice is for Semi-structured JSON, not the specific requirement. Keys provide organization while records may have different optional attributes.

D:

This choice is for Time-series records, not the specific requirement. Readings can be filtered and aggregated by device and time interval.

Question 28

A data architect recommends this approach: Identify CSV as a delimited tabular file format. Which situation most clearly calls for that approach?

  1. An industrial system sends timestamped temperature measurements with a sensor identifier and numeric reading.
  2. An analyst receives a text file containing values separated by commas and a single header row.
  3. An application emits JSON events in which a base set of properties is present but optional device details vary between messages.
  4. An analytics group repeatedly scans only three columns from very wide historical fact files.

Explanation

Correct Answer

B:

This situation calls for Delimited file. Each line corresponds to a record with positions defined by the header and delimiter.

Incorrect Answers

A:

The other situation is better matched to Model the measurements as structured time-series records with timestamps. Readings can be filtered and aggregated by device and time interval.

C:

The other situation is better matched to Classify the JSON payloads as semi-structured data rather than a fixed table. Keys provide organization while records may have different optional attributes.

D:

The other situation is better matched to Choose a column-oriented analytical file format such as Parquet. Columnar storage can reduce unnecessary column reads in analytical scans.

Question 29

A telemetry provider must preserve nested arrays of sensor readings in a single transmitted event. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

B:

The requirement concerns JSON object versus CSV. JSON can encode nested objects and arrays without flattening them into columns.

Incorrect Answers

A:

That action instead addresses Data model cardinality: The relationship preserves a single customer entity while allowing multiple order rows. It does not directly satisfy the described JSON object versus CSV need.

C:

That action instead addresses Log event shape: Common fields can be searched without requiring identical optional attributes everywhere. It does not directly satisfy the described JSON object versus CSV need.

D:

That action instead addresses Nested document: Related objects and arrays can stay together even when individual records have different shapes. It does not directly satisfy the described JSON object versus CSV need.

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.