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 2

Question 10

A data professional makes this decision: Classify the JSON payloads as semi-structured data rather than a fixed table. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

A:

This is the expected outcome for Semi-structured JSON: Keys provide organization while records may have different optional attributes.

Incorrect Answers

B:

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.

C:

This result would follow the different Delimited file decision (Identify CSV as a delimited tabular file format.) rather than the specified design.

D:

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.

Question 11

An application emits JSON events in which a base set of properties is present but optional device details vary between messages. Someone instead proposes: Identify CSV as a delimited tabular file format. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

B:

This correction addresses Semi-structured JSON. Keys provide organization while records may have different optional attributes.

Incorrect Answers

A:

This choice is for Delimited file, not the specific requirement. Each line corresponds to a record with positions defined by the header and delimiter.

C:

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

D:

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

Question 12

A data architect recommends this approach: Classify the JSON payloads as semi-structured data rather than a fixed table. 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

C:

This situation calls for Semi-structured JSON. Keys provide organization while records may have different optional attributes.

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.

B:

The other situation is better matched to Identify CSV as a delimited tabular file format. Each line corresponds to a record with positions defined by the header and delimiter.

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 13

An online product catalog stores categories, localized descriptions and varying accessory arrays within each product item. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

D:

The requirement concerns Nested document. Related objects and arrays can stay together even when individual records have different shapes.

Incorrect Answers

A:

That action instead addresses JSON object versus CSV: JSON can encode nested objects and arrays without flattening them into columns. It does not directly satisfy the described Nested document need.

B:

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 Nested document 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 Nested document need.

Question 14

A data professional makes this decision: Use a nested document representation for the variable product attributes. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

A:

This is the expected outcome for Nested document: Related objects and arrays can stay together even when individual records have different shapes.

Incorrect Answers

B:

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.

C:

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

D:

This result would follow the different JSON object versus CSV decision (Prefer a JSON document to a flat CSV row for the nested event.) rather than the specified design.

Question 15

An online product catalog stores categories, localized descriptions and varying accessory arrays within each product item. Someone instead proposes: Prefer a JSON document to a flat CSV row for the nested event. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

B:

This correction addresses Nested document. Related objects and arrays can stay together even when individual records have different shapes.

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.

C:

This choice is for JSON object versus CSV, not the specific requirement. JSON can encode nested objects and arrays without flattening them into columns.

D:

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

Question 16

A data architect recommends this approach: Use a nested document representation for the variable product attributes. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

C:

This situation calls for Nested document. Related objects and arrays can stay together even when individual records have different shapes.

Incorrect Answers

A:

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.

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.

D:

The other situation is better matched to Prefer a JSON document to a flat CSV row for the nested event. JSON can encode nested objects and arrays without flattening them into columns.

Question 17

A media archive collects product photographs whose pixels cannot be meaningfully queried as rows and columns. 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. 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

C:

The requirement concerns Raw image assets. The file contents need specialized interpretation rather than a predetermined tabular schema.

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 Raw image assets need.

B:

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 Raw image assets need.

D:

That action instead addresses Binary versus textual: A file decoder is needed to interpret the compressed image contents. It does not directly satisfy the described Raw image assets need.

Question 18

A data professional makes this decision: Classify the pictures as unstructured binary content. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

D:

This is the expected outcome for Raw image assets: The file contents need specialized interpretation rather than a predetermined tabular schema.

Incorrect Answers

A:

This result would follow the different Binary versus textual decision (Treat JPEG as a binary media representation rather than a text table.) rather than the specified design.

B:

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.

C:

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.

Question 19

A media archive collects product photographs whose pixels cannot be meaningfully queried as rows and columns. Someone instead proposes: Treat JPEG as a binary media representation rather than a text table. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

A:

This correction addresses Raw image assets. The file contents need specialized interpretation rather than a predetermined tabular schema.

Incorrect Answers

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 Free-form text, not the specific requirement. Natural-language content may require text search or language processing for analysis.

D:

This choice is for Binary versus textual, not the specific requirement. A file decoder is needed to interpret the compressed image contents.

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.