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 8

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.

Question 71

A booking app needs normalized tables, SQL queries and a managed Azure relational platform. Someone instead proposes: Host SQL Server on Azure Virtual Machines. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

B:

This correction addresses Managed relational database. The service supports SQL-based relational operations without the team operating database virtual machines.

Incorrect Answers

A:

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

C:

This choice is for SQL Server host control, not the specific requirement. The customer retains instance and operating-system control in the infrastructure service model.

D:

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.

Question 72

A data architect recommends this approach: Choose Azure SQL Database as a managed relational datastore. Which situation most clearly calls for that approach?

  1. An organization must control the guest operating system and SQL Server instance settings while running the database in Azure.
  2. An ETL pipeline needs directory-style access control and efficient directory operations within its cloud data lake.
  3. A booking app needs normalized tables, SQL queries and a managed Azure relational platform.
  4. A finance department repeatedly aggregates billions of rows from many operational systems for reporting.

Explanation

Correct Answer

C:

This situation calls for Managed relational database. The service supports SQL-based relational operations without the team operating database virtual machines.

Incorrect Answers

A:

The other situation is better matched to Host SQL Server on Azure Virtual Machines. The customer retains instance and operating-system control in the infrastructure service model.

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.

D:

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.

Question 73

Several Windows virtual machines must read and write the same departmental files over the SMB protocol. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Evaluate Azure SQL Managed Instance.
  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. Use Azure Files to provide a managed SMB file share.

Explanation

Correct Answer

D:

The requirement concerns Cloud file sharing. Clients can access shared directories through a familiar network file protocol.

Incorrect Answers

A:

That action instead addresses Lift-and-shift SQL features: Managed Instance supports many SQL Server instance features in a managed Azure service. It does not directly satisfy the described Cloud file sharing need.

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 Cloud file sharing 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 Cloud file sharing need.

Question 74

A data professional makes this decision: Use Azure Files to provide a managed SMB file share. Which outcome is the most direct expected result?

  1. Clients can access shared directories through a familiar network file protocol.
  2. Large retained files can be managed independently of the operational relational schema.
  3. Storage costs and retrieval characteristics can be matched to the expected access patterns.
  4. Managed Instance supports many SQL Server instance features in a managed Azure service.

Explanation

Correct Answer

A:

This is the expected outcome for Cloud file sharing: Clients can access shared directories through a familiar network file protocol.

Incorrect Answers

B:

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 Lift-and-shift SQL features decision (Evaluate Azure SQL Managed Instance.) rather than the specified design.

Question 75

Several Windows virtual machines must read and write the same departmental files over the SMB protocol. Someone instead proposes: Evaluate Azure SQL Managed Instance. Which alternative is the best correction for the original requirement?

  1. Keep the exported audit artifacts in appropriately governed object storage.
  2. Use Azure Files to provide a managed SMB file share.
  3. Select suitable Azure Blob access tiers based on retrieval frequency and retention.
  4. Evaluate Azure SQL Managed Instance.

Explanation

Correct Answer

B:

This correction addresses Cloud file sharing. Clients can access shared directories through a familiar network file protocol.

Incorrect Answers

A:

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

C:

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 Lift-and-shift SQL features, not the specific requirement. Managed Instance supports many SQL Server instance features in a managed Azure service.

Question 76

A data architect recommends this approach: Use Azure Files to provide a managed SMB file share. Which situation most clearly calls for that approach?

  1. An existing SQL Server application needs broad instance-level compatibility but less infrastructure administration than managing a virtual machine.
  2. An archive has files accessed daily and other files rarely retrieved for years.
  3. Several Windows virtual machines must read and write the same departmental files over the SMB protocol.
  4. An auditing service must retain immutable-like sequential audit exports separately from its transactional application tables.

Explanation

Correct Answer

C:

This situation calls for Cloud file sharing. Clients can access shared directories through a familiar network file protocol.

Incorrect Answers

A:

The other situation is better matched to Evaluate Azure SQL Managed Instance. Managed Instance supports many SQL Server instance features in a managed Azure service.

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.

D:

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.

Question 77

An application keeps a large collection of simple entities with partition and row keys rather than relational joins. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Consider Azure Table Storage for the key-attribute entities.
  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 PostgreSQL.

Explanation

Correct Answer

A:

The requirement concerns Wide key-attribute records. The table service supports scalable non-relational key-based access patterns.

Incorrect Answers

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 Wide key-attribute records 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 Wide key-attribute records need.

D:

That action instead addresses Open-source PostgreSQL: A managed PostgreSQL service provides the compatible engine without self-managed database VMs. It does not directly satisfy the described Wide key-attribute records need.

Question 78

A data professional makes this decision: Consider Azure Table Storage for the key-attribute entities. Which outcome is the most direct expected result?

  1. Raw inputs remain available when transformations must be rerun or audited.
  2. The table service supports scalable non-relational key-based access patterns.
  3. Frequently accessed values can be served faster while the authoritative database remains durable.
  4. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.

Explanation

Correct Answer

B:

This is the expected outcome for Wide key-attribute records: The table service supports scalable non-relational key-based access patterns.

Incorrect Answers

A:

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.

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 Open-source PostgreSQL decision (Select Azure Database for PostgreSQL.) rather than the specified design.

Question 79

An application keeps a large collection of simple entities with partition and row keys rather than relational joins. Someone instead proposes: Select Azure Database for PostgreSQL. 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 PostgreSQL.
  3. Consider Azure Table Storage for the key-attribute entities.
  4. Land the original files in durable object storage before downstream processing.

Explanation

Correct Answer

C:

This correction addresses Wide key-attribute records. The table service supports scalable non-relational key-based access patterns.

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.

B:

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

D:

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

Question 80

A data architect recommends this approach: Consider Azure Table Storage for the key-attribute entities. Which situation most clearly calls for that approach?

  1. A batch pipeline receives hourly device exports and must keep originals for reproducible transformations.
  2. A web application needs to repeatedly fetch the same short-lived reference lookups with minimal network round trips.
  3. A service is written for PostgreSQL semantics and drivers and the team wants a managed cloud offering.
  4. An application keeps a large collection of simple entities with partition and row keys rather than relational joins.

Explanation

Correct Answer

D:

This situation calls for Wide key-attribute records. The table service supports scalable non-relational key-based access patterns.

Incorrect Answers

A:

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.

B:

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.

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.