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 9

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.

Question 81

A mobile platform needs geographically distributed JSON documents and flexible scaling of request workloads. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Evaluate a document-oriented NoSQL data store.
  2. Select Azure Database for MySQL.
  3. Consider Azure Cosmos DB for the distributed document workload.
  4. Use Azure Blob Storage for the object data.

Explanation

Correct Answer

C:

The requirement concerns Global document app. A managed globally distributed NoSQL service can serve document access patterns.

Incorrect Answers

A:

That action instead addresses Data store choice: Document access fits flexible per-customer attributes without a rigid normalized schema. It does not directly satisfy the described Global document app need.

B:

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 Global document app need.

D:

That action instead addresses Object blob archive: Objects can be stored and retrieved without requiring relational tables or a mounted file share. It does not directly satisfy the described Global document app need.

Question 82

A data professional makes this decision: Consider Azure Cosmos DB for the distributed document workload. Which outcome is the most direct expected result?

  1. Document access fits flexible per-customer attributes without a rigid normalized schema.
  2. The application can retain its MySQL-oriented database interactions on a managed platform.
  3. Objects can be stored and retrieved without requiring relational tables or a mounted file share.
  4. A managed globally distributed NoSQL service can serve document access patterns.

Explanation

Correct Answer

D:

This is the expected outcome for Global document app: A managed globally distributed NoSQL service can serve document access patterns.

Incorrect Answers

A:

This result would follow the different Data store choice decision (Evaluate a document-oriented NoSQL data store.) rather than the specified design.

B:

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 blob archive decision (Use Azure Blob Storage for the object data.) rather than the specified design.

Question 83

A mobile platform needs geographically distributed JSON documents and flexible scaling of request workloads. Someone instead proposes: Select Azure Database for MySQL. Which alternative is the best correction for the original requirement?

  1. Consider Azure Cosmos DB for the distributed document workload.
  2. Evaluate a document-oriented NoSQL data store.
  3. Select Azure Database for MySQL.
  4. Use Azure Blob Storage for the object data.

Explanation

Correct Answer

A:

This correction addresses Global document app. A managed globally distributed NoSQL service can serve document access patterns.

Incorrect Answers

B:

This choice is for Data store choice, not the specific requirement. Document access fits flexible per-customer attributes without a rigid normalized schema.

C:

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

D:

This choice is for Object blob archive, not the specific requirement. Objects can be stored and retrieved without requiring relational tables or a mounted file share.

Question 84

A data architect recommends this approach: Consider Azure Cosmos DB for the distributed document workload. Which situation most clearly calls for that approach?

  1. A company must store millions of documents and pictures in cloud storage without mounting a shared file system.
  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 team wants to retrieve single customer documents with variable fields and does not need multi-table relational joins.

Explanation

Correct Answer

B:

This situation calls for Global document app. A managed globally distributed NoSQL service can serve document access patterns.

Incorrect Answers

A:

The other situation is better matched to Use Azure Blob Storage for the object data. Objects can be stored and retrieved without requiring relational tables or a mounted file share.

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.

D:

The other situation is better matched to Evaluate a document-oriented NoSQL data store. Document access fits flexible per-customer attributes without a rigid normalized schema.

Question 85

An organization must control the guest operating system and SQL Server instance settings while running the database in Azure. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Store the raw analytical files in an Azure Data Lake Storage Gen2 account.
  2. Choose Azure SQL Database as a managed relational datastore.
  3. Host SQL Server on Azure Virtual Machines.
  4. Use a database with indexed records and query capabilities.

Explanation

Correct Answer

C:

The requirement concerns SQL Server host control. The customer retains instance and operating-system control in the infrastructure service model.

Incorrect Answers

A:

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 SQL Server host control need.

B:

That action instead addresses Managed relational database: The service supports SQL-based relational operations without the team operating database virtual machines. It does not directly satisfy the described SQL Server host control need.

D:

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 SQL Server host control need.

Question 86

A data professional makes this decision: Host SQL Server on Azure Virtual Machines. Which outcome is the most direct expected result?

  1. Individual rows can be updated and queried without replacing whole flat files.
  2. The service supports SQL-based relational operations without the team operating database virtual machines.
  3. Lake-oriented object storage preserves files for later processing across diverse formats.
  4. The customer retains instance and operating-system control in the infrastructure service model.

Explanation

Correct Answer

D:

This is the expected outcome for SQL Server host control: The customer retains instance and operating-system control in the infrastructure service model.

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.

B:

This result would follow the different Managed relational database decision (Choose Azure SQL Database as a managed relational datastore.) rather than the specified design.

C:

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 87

An organization must control the guest operating system and SQL Server instance settings while running the database in Azure. Someone instead proposes: Store the raw analytical files in an Azure Data Lake Storage Gen2 account. Which alternative is the best correction for the original requirement?

  1. Host SQL Server on Azure Virtual Machines.
  2. Choose Azure SQL Database as a managed relational datastore.
  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:

This correction addresses SQL Server host control. The customer retains instance and operating-system control in the infrastructure service model.

Incorrect Answers

B:

This choice is for Managed relational database, not the specific requirement. The service supports SQL-based relational operations without the team operating database virtual machines.

C:

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

D:

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

Question 88

A data architect recommends this approach: Host SQL Server on Azure Virtual Machines. 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. An organization must control the guest operating system and SQL Server instance settings while running the database in Azure.
  3. A booking app needs normalized tables, SQL queries and a managed Azure relational platform.
  4. A data science group needs to hold raw structured and unstructured source files until later transformation.

Explanation

Correct Answer

B:

This situation calls for SQL Server host control. The customer retains instance and operating-system control in the infrastructure service model.

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.

C:

The other situation is better matched to Choose Azure SQL Database as a managed relational datastore. The service supports SQL-based relational operations without the team operating database virtual machines.

D:

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 89

An existing SQL Server application needs broad instance-level compatibility but less infrastructure administration than managing a virtual machine. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

C:

The requirement concerns Lift-and-shift SQL features. Managed Instance supports many SQL Server instance features in a managed Azure service.

Incorrect Answers

A:

That action instead addresses Cloud file sharing: Clients can access shared directories through a familiar network file protocol. It does not directly satisfy the described Lift-and-shift SQL features need.

B:

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 Lift-and-shift SQL features need.

D:

That action instead addresses SQL analytics warehouse: A warehouse organizes historical integrated data for large analytical queries. It does not directly satisfy the described Lift-and-shift SQL features need.

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.