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 10

Question 90

A data professional makes this decision: Evaluate Azure SQL Managed Instance. Which outcome is the most direct expected result?

  1. File-system semantics such as directories and directory-level operations become available to analytics workloads.
  2. Clients can access shared directories through a familiar network file protocol.
  3. A warehouse organizes historical integrated data for large analytical queries.
  4. Managed Instance supports many SQL Server instance features in a managed Azure service.

Explanation

Correct Answer

D:

This is the expected outcome for Lift-and-shift SQL features: Managed Instance supports many SQL Server instance features in a managed Azure service.

Incorrect Answers

A:

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

B:

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.

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.

Question 91

An existing SQL Server application needs broad instance-level compatibility but less infrastructure administration than managing a virtual machine. Someone instead proposes: Use an analytical warehouse design rather than an OLTP database tuned for individual transactions. Which alternative is the best correction for the original requirement?

  1. Evaluate Azure SQL Managed Instance.
  2. Enable hierarchical namespace for Azure Data Lake Storage Gen2.
  3. Use Azure Files to provide a managed SMB file share.
  4. Use an analytical warehouse design rather than an OLTP database tuned for individual transactions.

Explanation

Correct Answer

A:

This correction addresses Lift-and-shift SQL features. Managed Instance supports many SQL Server instance features in a managed Azure service.

Incorrect Answers

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.

C:

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

D:

This choice is for SQL analytics warehouse, not the specific requirement. A warehouse organizes historical integrated data for large analytical queries.

Question 92

A data architect recommends this approach: Evaluate Azure SQL Managed Instance. Which situation most clearly calls for that approach?

  1. A finance department repeatedly aggregates billions of rows from many operational systems for reporting.
  2. An existing SQL Server application needs broad instance-level compatibility but less infrastructure administration than managing a virtual machine.
  3. Several Windows virtual machines must read and write the same departmental files over the SMB protocol.
  4. An ETL pipeline needs directory-style access control and efficient directory operations within its cloud data lake.

Explanation

Correct Answer

B:

This situation calls for Lift-and-shift SQL features. Managed Instance supports many SQL Server instance features in a managed Azure service.

Incorrect Answers

A:

The other situation is better matched to Use an analytical warehouse design rather than an OLTP database tuned for individual transactions. A warehouse organizes historical integrated data for large analytical queries.

C:

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.

D:

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.

Question 93

A service is written for PostgreSQL semantics and drivers and the team wants a managed cloud offering. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Select Azure Database for PostgreSQL.
  2. Keep the exported audit artifacts in appropriately governed object storage.
  3. Select suitable Azure Blob access tiers based on retrieval frequency and retention.
  4. Consider Azure Table Storage for the key-attribute entities.

Explanation

Correct Answer

A:

The requirement concerns Open-source PostgreSQL. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

Incorrect Answers

B:

That action instead addresses Transaction log archive: Large retained files can be managed independently of the operational relational schema. It does not directly satisfy the described Open-source PostgreSQL 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 Open-source PostgreSQL need.

D:

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 Open-source PostgreSQL need.

Question 94

A data professional makes this decision: Select Azure Database for PostgreSQL. Which outcome is the most direct expected result?

  1. Large retained files can be managed independently of the operational relational schema.
  2. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.
  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 Open-source PostgreSQL: A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

Incorrect Answers

A:

This result would follow the different Transaction log archive decision (Keep the exported audit artifacts in appropriately governed object storage.) 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 95

A service is written for PostgreSQL semantics and drivers and the team wants a managed cloud offering. Someone instead proposes: Keep the exported audit artifacts in appropriately governed object storage. Which alternative is the best correction for the original requirement?

  1. Select suitable Azure Blob access tiers based on retrieval frequency and retention.
  2. Consider Azure Table Storage for the key-attribute entities.
  3. Select Azure Database for PostgreSQL.
  4. Keep the exported audit artifacts in appropriately governed object storage.

Explanation

Correct Answer

C:

This correction addresses Open-source PostgreSQL. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

Incorrect Answers

A:

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

B:

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

D:

This choice is for Transaction log archive, not the specific requirement. Large retained files can be managed independently of the operational relational schema.

Question 96

A data architect recommends this approach: Select Azure Database for PostgreSQL. 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 auditing service must retain immutable-like sequential audit exports separately from its transactional application tables.
  3. An archive has files accessed daily and other files rarely retrieved for years.
  4. A service is written for PostgreSQL semantics and drivers and the team wants a managed cloud offering.

Explanation

Correct Answer

D:

This situation calls for Open-source PostgreSQL. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

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 Keep the exported audit artifacts in appropriately governed object storage. Large retained files can be managed independently of the operational relational schema.

C:

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.

Question 97

A website depends on MySQL client compatibility while moving database operations to a managed Azure service. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Consider Azure Cosmos DB for the distributed document workload.
  2. Land the original files in durable object storage before downstream processing.
  3. Introduce a cache layer rather than repeatedly querying the persistent data store.
  4. Select Azure Database for MySQL.

Explanation

Correct Answer

D:

The requirement concerns Open-source MySQL. The application can retain its MySQL-oriented database interactions on a managed platform.

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 Open-source MySQL need.

B:

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 Open-source MySQL need.

C:

That action instead addresses Low latency cache: Frequently accessed values can be served faster while the authoritative database remains durable. It does not directly satisfy the described Open-source MySQL need.

Question 98

A data professional makes this decision: Select Azure Database for MySQL. Which outcome is the most direct expected result?

  1. The application can retain its MySQL-oriented database interactions on a managed platform.
  2. A managed globally distributed NoSQL service can serve document access patterns.
  3. Frequently accessed values can be served faster while the authoritative database remains durable.
  4. Raw inputs remain available when transformations must be rerun or audited.

Explanation

Correct Answer

A:

This is the expected outcome for Open-source MySQL: The application can retain its MySQL-oriented database interactions on a managed platform.

Incorrect Answers

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 Low latency cache decision (Introduce a cache layer rather than repeatedly querying the persistent data store.) rather than the specified design.

D:

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 99

A website depends on MySQL client compatibility while moving database operations to a managed Azure service. Someone instead proposes: Introduce a cache layer rather than repeatedly querying the persistent data store. Which alternative is the best correction for the original requirement?

  1. Introduce a cache layer rather than repeatedly querying the persistent data store.
  2. Select Azure Database for MySQL.
  3. Land the original files in durable object storage before downstream processing.
  4. Consider Azure Cosmos DB for the distributed document workload.

Explanation

Correct Answer

B:

This correction addresses Open-source MySQL. The application can retain its MySQL-oriented database interactions on a managed platform.

Incorrect Answers

A:

This choice is for Low latency cache, not the specific requirement. Frequently accessed values can be served faster while the authoritative database remains durable.

C:

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

D:

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

Question 100

A data architect recommends this approach: Select Azure Database for MySQL. Which situation most clearly calls for that approach?

  1. A web application needs to repeatedly fetch the same short-lived reference lookups with minimal network round trips.
  2. A mobile platform needs geographically distributed JSON documents and flexible scaling of request workloads.
  3. A website depends on MySQL client compatibility while moving database operations to a managed Azure service.
  4. A batch pipeline receives hourly device exports and must keep originals for reproducible transformations.

Explanation

Correct Answer

C:

This situation calls for Open-source MySQL. The application can retain its MySQL-oriented database interactions on a managed platform.

Incorrect Answers

A:

The other situation is better matched to Introduce a cache layer rather than repeatedly querying the persistent data store. Frequently accessed values can be served faster while the authoritative database remains durable.

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.

D:

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.