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 7

Question 60

A data architect recommends this approach: Choose a column-oriented analytical file format such as Parquet. Which situation most clearly calls for that approach?

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

Explanation

Correct Answer

A:

This situation calls for Parquet columnar file. Columnar storage can reduce unnecessary column reads in analytical scans.

Incorrect Answers

B:

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.

C:

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 Model the measurements as structured time-series records with timestamps. Readings can be filtered and aggregated by device and time interval.

Question 61

A store has one customer record associated with many distinct orders, each belonging to one customer. 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. Use a nested document representation for the variable product attributes.
  3. Recognize these event documents as semi-structured logs.
  4. Represent the customer-to-orders association as a one-to-many relationship.

Explanation

Correct Answer

D:

The requirement concerns Data model cardinality. The relationship preserves a single customer entity while allowing multiple order rows.

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 Data model cardinality need.

B:

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 Data model cardinality 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 Data model cardinality need.

Question 62

A data professional makes this decision: Represent the customer-to-orders association as a one-to-many relationship. Which outcome is the most direct expected result?

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

Explanation

Correct Answer

A:

This is the expected outcome for Data model cardinality: The relationship preserves a single customer entity while allowing multiple order rows.

Incorrect Answers

B:

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

C:

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.

D:

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

Question 63

A store has one customer record associated with many distinct orders, each belonging to one customer. Someone instead proposes: Use a nested document representation for the variable product attributes. Which alternative is the best correction for the original requirement?

  1. Use a nested document representation for the variable product attributes.
  2. Represent the customer-to-orders association as a one-to-many relationship.
  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 Data model cardinality. The relationship preserves a single customer entity while allowing multiple order rows.

Incorrect Answers

A:

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

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 64

A data architect recommends this approach: Represent the customer-to-orders association as a one-to-many relationship. 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

C:

This situation calls for Data model cardinality. The relationship preserves a single customer entity while allowing multiple order rows.

Incorrect Answers

A:

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.

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 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 65

A company must store millions of documents and pictures in cloud storage without mounting a shared file system. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use Azure Blob Storage for the object data.
  2. Consider Azure Cosmos DB for the distributed document workload.
  3. Use a database with indexed records and query capabilities.
  4. Store the raw analytical files in an Azure Data Lake Storage Gen2 account.

Explanation

Correct Answer

A:

The requirement concerns Object blob archive. Objects can be stored and retrieved without requiring relational tables or a mounted file share.

Incorrect Answers

B:

That action instead addresses Global document app: A managed globally distributed NoSQL service can serve document access patterns. It does not directly satisfy the described Object blob archive need.

C:

That action instead addresses Database versus file: Individual rows can be updated and queried without replacing whole flat files. It does not directly satisfy the described Object blob archive need.

D:

That action instead addresses Analytical data lake: Lake-oriented object storage preserves files for later processing across diverse formats. It does not directly satisfy the described Object blob archive need.

Question 66

A data professional makes this decision: Use Azure Blob Storage for the object data. Which outcome is the most direct expected result?

  1. Individual rows can be updated and queried without replacing whole flat files.
  2. Objects can be stored and retrieved without requiring relational tables or a mounted file share.
  3. A managed globally distributed NoSQL service can serve document access patterns.
  4. Lake-oriented object storage preserves files for later processing across diverse formats.

Explanation

Correct Answer

B:

This is the expected outcome for Object blob archive: Objects can be stored and retrieved without requiring relational tables or a mounted file share.

Incorrect Answers

A:

This result would follow the different Database versus file decision (Use a database with indexed records and query capabilities.) rather than the specified design.

C:

This result would follow the different Global document app decision (Consider Azure Cosmos DB for the distributed document workload.) rather than the specified design.

D:

This result would follow the different Analytical data lake decision (Store the raw analytical files in an Azure Data Lake Storage Gen2 account.) rather than the specified design.

Question 67

A company must store millions of documents and pictures in cloud storage without mounting a shared file system. Someone instead proposes: Consider Azure Cosmos DB for the distributed document workload. Which alternative is the best correction for the original requirement?

  1. Use a database with indexed records and query capabilities.
  2. Store the raw analytical files in an Azure Data Lake Storage Gen2 account.
  3. Use Azure Blob Storage for the object data.
  4. Consider Azure Cosmos DB for the distributed document workload.

Explanation

Correct Answer

C:

This correction addresses Object blob archive. Objects can be stored and retrieved without requiring relational tables or a mounted file share.

Incorrect Answers

A:

This choice is for Database versus file, not the specific requirement. Individual rows can be updated and queried without replacing whole flat files.

B:

This choice is for Analytical data lake, not the specific requirement. Lake-oriented object storage preserves files for later processing across diverse formats.

D:

This choice is for Global document app, not the specific requirement. A managed globally distributed NoSQL service can serve document access patterns.

Question 68

A data architect recommends this approach: Use Azure Blob Storage for the object data. Which situation most clearly calls for that approach?

  1. Developers want indexed record updates and queryable customer transactions rather than overwriting entire CSV exports.
  2. A mobile platform needs geographically distributed JSON documents and flexible scaling of request workloads.
  3. A data science group needs to hold raw structured and unstructured source files until later transformation.
  4. A company must store millions of documents and pictures in cloud storage without mounting a shared file system.

Explanation

Correct Answer

D:

This situation calls for Object blob archive. Objects can be stored and retrieved without requiring relational tables or a mounted file share.

Incorrect Answers

A:

The other situation is better matched to Use a database with indexed records and query capabilities. Individual rows can be updated and queried without replacing whole flat files.

B:

The other situation is better matched to Consider Azure Cosmos DB for the distributed document workload. A managed globally distributed NoSQL service can serve document access patterns.

C:

The other situation is better matched to Store the raw analytical files in an Azure Data Lake Storage Gen2 account. Lake-oriented object storage preserves files for later processing across diverse formats.

Question 69

A booking app needs normalized tables, SQL queries and a managed Azure relational platform. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use an analytical warehouse design rather than an OLTP database tuned for individual transactions.
  2. Host SQL Server on Azure Virtual Machines.
  3. Enable hierarchical namespace for Azure Data Lake Storage Gen2.
  4. Choose Azure SQL Database as a managed relational datastore.

Explanation

Correct Answer

D:

The requirement concerns Managed relational database. The service supports SQL-based relational operations without the team operating database virtual machines.

Incorrect Answers

A:

That action instead addresses SQL analytics warehouse: A warehouse organizes historical integrated data for large analytical queries. It does not directly satisfy the described Managed relational database need.

B:

That action instead addresses SQL Server host control: The customer retains instance and operating-system control in the infrastructure service model. It does not directly satisfy the described Managed relational database need.

C:

That action instead addresses Hierarchical namespace: File-system semantics such as directories and directory-level operations become available to analytics workloads. It does not directly satisfy the described Managed relational database need.

Question 70

A data professional makes this decision: Choose Azure SQL Database as a managed relational datastore. Which outcome is the most direct expected result?

  1. The service supports SQL-based relational operations without the team operating database virtual machines.
  2. File-system semantics such as directories and directory-level operations become available to analytics workloads.
  3. A warehouse organizes historical integrated data for large analytical queries.
  4. The customer retains instance and operating-system control in the infrastructure service model.

Explanation

Correct Answer

A:

This is the expected outcome for Managed relational database: The service supports SQL-based relational operations without the team operating database virtual machines.

Incorrect Answers

B:

This result would follow the different Hierarchical namespace decision (Enable hierarchical namespace for Azure Data Lake Storage Gen2.) rather than the specified design.

C:

This result would follow the different SQL analytics warehouse decision (Use an analytical warehouse design rather than an OLTP database tuned for individual transactions.) rather than the specified design.

D:

This result would follow the different SQL Server host control decision (Host SQL Server on Azure Virtual Machines.) rather than the specified design.