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 12

Question 110

A data professional makes this decision: Keep the exported audit artifacts in appropriately governed object storage. Which outcome is the most direct expected result?

  1. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.
  2. Large retained files can be managed independently of the operational relational schema.
  3. File-system semantics such as directories and directory-level operations become available to analytics workloads.
  4. Clients can access shared directories through a familiar network file protocol.

Explanation

Correct Answer

B:

This is the expected outcome for Transaction log archive: Large retained files can be managed independently of the operational relational schema.

Incorrect Answers

A:

This result would follow the different Open-source PostgreSQL decision (Select Azure Database for PostgreSQL.) rather than the specified design.

C:

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

D:

This result would follow the different Cloud file sharing decision (Use Azure Files to provide a managed SMB file share.) rather than the specified design.

Question 111

An auditing service must retain immutable-like sequential audit exports separately from its transactional application tables. Someone instead proposes: Enable hierarchical namespace for Azure Data Lake Storage Gen2. Which alternative is the best correction for the original requirement?

  1. Use Azure Files to provide a managed SMB file share.
  2. Enable hierarchical namespace for Azure Data Lake Storage Gen2.
  3. Keep the exported audit artifacts in appropriately governed object storage.
  4. Select Azure Database for PostgreSQL.

Explanation

Correct Answer

C:

This correction addresses Transaction log archive. Large retained files can be managed independently of the operational relational schema.

Incorrect Answers

A:

This choice is for Cloud file sharing, not the specific requirement. Clients can access shared directories through a familiar network file protocol.

B:

This choice is for Hierarchical namespace, not the specific requirement. File-system semantics such as directories and directory-level operations become available to analytics workloads.

D:

This choice is for Open-source PostgreSQL, not the specific requirement. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

Question 112

A data architect recommends this approach: Keep the exported audit artifacts in appropriately governed object storage. Which situation most clearly calls for that approach?

  1. Several Windows virtual machines must read and write the same departmental files over the SMB protocol.
  2. An ETL pipeline needs directory-style access control and efficient directory operations within its cloud data lake.
  3. A service is written for PostgreSQL semantics and drivers and the team wants a managed cloud offering.
  4. An auditing service must retain immutable-like sequential audit exports separately from its transactional application tables.

Explanation

Correct Answer

D:

This situation calls for Transaction log archive. Large retained files can be managed independently of the operational relational schema.

Incorrect Answers

A:

The other situation is better matched to Use Azure Files to provide a managed SMB file share. Clients can access shared directories through a familiar network file protocol.

B:

The other situation is better matched to Enable hierarchical namespace for Azure Data Lake Storage Gen2. File-system semantics such as directories and directory-level operations become available to analytics workloads.

C:

The other situation is better matched to Select Azure Database for PostgreSQL. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

Question 113

A web application needs to repeatedly fetch the same short-lived reference lookups with minimal network round trips. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Introduce a cache layer rather than repeatedly querying the persistent data store.
  2. Consider Azure Table Storage for the key-attribute entities.
  3. Select suitable Azure Blob access tiers based on retrieval frequency and retention.
  4. Select Azure Database for MySQL.

Explanation

Correct Answer

A:

The requirement concerns Low latency cache. Frequently accessed values can be served faster while the authoritative database remains durable.

Incorrect Answers

B:

That action instead addresses Wide key-attribute records: The table service supports scalable non-relational key-based access patterns. It does not directly satisfy the described Low latency cache need.

C:

That action instead addresses Object tiers: Storage costs and retrieval characteristics can be matched to the expected access patterns. It does not directly satisfy the described Low latency cache need.

D:

That action instead addresses Open-source MySQL: The application can retain its MySQL-oriented database interactions on a managed platform. It does not directly satisfy the described Low latency cache need.

Question 114

A data professional makes this decision: Introduce a cache layer rather than repeatedly querying the persistent data store. Which outcome is the most direct expected result?

  1. The application can retain its MySQL-oriented database interactions on a managed platform.
  2. Frequently accessed values can be served faster while the authoritative database remains durable.
  3. Storage costs and retrieval characteristics can be matched to the expected access patterns.
  4. The table service supports scalable non-relational key-based access patterns.

Explanation

Correct Answer

B:

This is the expected outcome for Low latency cache: Frequently accessed values can be served faster while the authoritative database remains durable.

Incorrect Answers

A:

This result would follow the different Open-source MySQL decision (Select Azure Database for MySQL.) rather than the specified design.

C:

This result would follow the different Object tiers decision (Select suitable Azure Blob access tiers based on retrieval frequency and retention.) rather than the specified design.

D:

This result would follow the different Wide key-attribute records decision (Consider Azure Table Storage for the key-attribute entities.) rather than the specified design.

Question 115

A web application needs to repeatedly fetch the same short-lived reference lookups with minimal network round trips. Someone instead proposes: Select suitable Azure Blob access tiers based on retrieval frequency and retention. Which alternative is the best correction for the original requirement?

  1. Consider Azure Table Storage for the key-attribute entities.
  2. Select suitable Azure Blob access tiers based on retrieval frequency and retention.
  3. Introduce a cache layer rather than repeatedly querying the persistent data store.
  4. Select Azure Database for MySQL.

Explanation

Correct Answer

C:

This correction addresses Low latency cache. Frequently accessed values can be served faster while the authoritative database remains durable.

Incorrect Answers

A:

This choice is for Wide key-attribute records, not the specific requirement. The table service supports scalable non-relational key-based access patterns.

B:

This choice is for Object tiers, not the specific requirement. Storage costs and retrieval characteristics can be matched to the expected access patterns.

D:

This choice is for Open-source MySQL, not the specific requirement. The application can retain its MySQL-oriented database interactions on a managed platform.

Question 116

A data architect recommends this approach: Introduce a cache layer rather than repeatedly querying the persistent data store. Which situation most clearly calls for that approach?

  1. An application keeps a large collection of simple entities with partition and row keys rather than relational joins.
  2. An archive has files accessed daily and other files rarely retrieved for years.
  3. A website depends on MySQL client compatibility while moving database operations to a managed Azure service.
  4. A web application needs to repeatedly fetch the same short-lived reference lookups with minimal network round trips.

Explanation

Correct Answer

D:

This situation calls for Low latency cache. Frequently accessed values can be served faster while the authoritative database remains durable.

Incorrect Answers

A:

The other situation is better matched to Consider Azure Table Storage for the key-attribute entities. The table service supports scalable non-relational key-based access patterns.

B:

The other situation is better matched to Select suitable Azure Blob access tiers based on retrieval frequency and retention. Storage costs and retrieval characteristics can be matched to the expected access patterns.

C:

The other situation is better matched to Select Azure Database for MySQL. The application can retain its MySQL-oriented database interactions on a managed platform.

Question 117

A team wants to retrieve single customer documents with variable fields and does not need multi-table relational joins. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Consider Azure Cosmos DB for the distributed document workload.
  2. Store the raw analytical files in an Azure Data Lake Storage Gen2 account.
  3. Evaluate a document-oriented NoSQL data store.
  4. Land the original files in durable object storage before downstream processing.

Explanation

Correct Answer

C:

The requirement concerns Data store choice. Document access fits flexible per-customer attributes without a rigid normalized schema.

Incorrect Answers

A:

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 Data store choice need.

B:

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 Data store choice need.

D:

That action instead addresses Event payload landing: Raw inputs remain available when transformations must be rerun or audited. It does not directly satisfy the described Data store choice need.

Question 118

A data professional makes this decision: Evaluate a document-oriented NoSQL data store. Which outcome is the most direct expected result?

  1. Lake-oriented object storage preserves files for later processing across diverse formats.
  2. A managed globally distributed NoSQL service can serve document access patterns.
  3. Raw inputs remain available when transformations must be rerun or audited.
  4. Document access fits flexible per-customer attributes without a rigid normalized schema.

Explanation

Correct Answer

D:

This is the expected outcome for Data store choice: Document access fits flexible per-customer attributes without a rigid normalized schema.

Incorrect Answers

A:

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.

B:

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

C:

This result would follow the different Event payload landing decision (Land the original files in durable object storage before downstream processing.) rather than the specified design.

Question 119

A team wants to retrieve single customer documents with variable fields and does not need multi-table relational joins. Someone instead proposes: Land the original files in durable object storage before downstream processing. Which alternative is the best correction for the original requirement?

  1. Evaluate a document-oriented NoSQL data store.
  2. Land the original files in durable object storage before downstream processing.
  3. Store the raw analytical files in an Azure Data Lake Storage Gen2 account.
  4. Consider Azure Cosmos DB for the distributed document workload.

Explanation

Correct Answer

A:

This correction addresses Data store choice. Document access fits flexible per-customer attributes without a rigid normalized schema.

Incorrect Answers

B:

This choice is for Event payload landing, not the specific requirement. Raw inputs remain available when transformations must be rerun or audited.

C:

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 120

A data architect recommends this approach: Evaluate a document-oriented NoSQL data store. Which situation most clearly calls for that approach?

  1. A data science group needs to hold raw structured and unstructured source files until later transformation.
  2. A team wants to retrieve single customer documents with variable fields and does not need multi-table relational joins.
  3. A batch pipeline receives hourly device exports and must keep originals for reproducible transformations.
  4. A mobile platform needs geographically distributed JSON documents and flexible scaling of request workloads.

Explanation

Correct Answer

B:

This situation calls for Data store choice. Document access fits flexible per-customer attributes without a rigid normalized schema.

Incorrect Answers

A:

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.

C:

The other situation is better matched to Land the original files in durable object storage before downstream processing. Raw inputs remain available when transformations must be rerun or audited.

D:

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.