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 13

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.

Question 121

Developers want indexed record updates and queryable customer transactions rather than overwriting entire CSV exports. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a database with indexed records and query capabilities.
  2. Use an analytical warehouse design rather than an OLTP database tuned for individual transactions.
  3. Use Azure Blob Storage for the object data.
  4. Host SQL Server on Azure Virtual Machines.

Explanation

Correct Answer

A:

The requirement concerns Database versus file. Individual rows can be updated and queried without replacing whole flat files.

Incorrect Answers

B:

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

C:

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 Database versus file need.

D:

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 Database versus file need.

Question 122

A data professional makes this decision: Use a database with indexed records and query capabilities. Which outcome is the most direct expected result?

  1. Objects can be stored and retrieved without requiring relational tables or a mounted file share.
  2. Individual rows can be updated and queried without replacing whole flat files.
  3. The customer retains instance and operating-system control in the infrastructure service model.
  4. A warehouse organizes historical integrated data for large analytical queries.

Explanation

Correct Answer

B:

This is the expected outcome for Database versus file: Individual rows can be updated and queried without replacing whole flat files.

Incorrect Answers

A:

This result would follow the different Object blob archive decision (Use Azure Blob Storage for the object data.) rather than the specified design.

C:

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

D:

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 123

Developers want indexed record updates and queryable customer transactions rather than overwriting entire CSV exports. Someone instead proposes: Use Azure Blob Storage for the object data. Which alternative is the best correction for the original requirement?

  1. Host SQL Server on Azure Virtual Machines.
  2. Use Azure Blob Storage for the object data.
  3. Use a database with indexed records and query capabilities.
  4. Use an analytical warehouse design rather than an OLTP database tuned for individual transactions.

Explanation

Correct Answer

C:

This correction addresses Database versus file. Individual rows can be updated and queried without replacing whole flat files.

Incorrect Answers

A:

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.

B:

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.

D:

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

Question 124

A data architect recommends this approach: Use a database with indexed records and query capabilities. 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 organization must control the guest operating system and SQL Server instance settings while running the database in Azure.
  3. A company must store millions of documents and pictures in cloud storage without mounting a shared file system.
  4. Developers want indexed record updates and queryable customer transactions rather than overwriting entire CSV exports.

Explanation

Correct Answer

D:

This situation calls for Database versus file. Individual rows can be updated and queried without replacing whole flat files.

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.

B:

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.

C:

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.

Question 125

An ETL pipeline needs directory-style access control and efficient directory operations within its cloud data lake. 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. Enable hierarchical namespace for Azure Data Lake Storage Gen2.
  4. Choose Azure SQL Database as a managed relational datastore.

Explanation

Correct Answer

C:

The requirement concerns Hierarchical namespace. File-system semantics such as directories and directory-level operations become available to analytics workloads.

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 Hierarchical namespace 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 Hierarchical namespace need.

D:

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 Hierarchical namespace need.

Question 126

A data professional makes this decision: Enable hierarchical namespace for Azure Data Lake Storage Gen2. Which outcome is the most direct expected result?

  1. The service supports SQL-based relational operations without the team operating database virtual machines.
  2. Managed Instance supports many SQL Server instance features in a managed Azure service.
  3. Large retained files can be managed independently of the operational relational schema.
  4. File-system semantics such as directories and directory-level operations become available to analytics workloads.

Explanation

Correct Answer

D:

This is the expected outcome for Hierarchical namespace: File-system semantics such as directories and directory-level operations become available to analytics workloads.

Incorrect Answers

A:

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

B:

This result would follow the different Lift-and-shift SQL features decision (Evaluate Azure SQL Managed Instance.) rather than the specified design.

C:

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.

Question 127

An ETL pipeline needs directory-style access control and efficient directory operations within its cloud data lake. Someone instead proposes: Choose Azure SQL Database as a managed relational datastore. Which alternative is the best correction for the original requirement?

  1. Enable hierarchical namespace for Azure Data Lake Storage Gen2.
  2. Choose Azure SQL Database as a managed relational datastore.
  3. Keep the exported audit artifacts in appropriately governed object storage.
  4. Evaluate Azure SQL Managed Instance.

Explanation

Correct Answer

A:

This correction addresses Hierarchical namespace. File-system semantics such as directories and directory-level operations become available to analytics workloads.

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 Transaction log archive, not the specific requirement. Large retained files can be managed independently of the operational relational schema.

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 128

A data architect recommends this approach: Enable hierarchical namespace for Azure Data Lake Storage Gen2. Which situation most clearly calls for that approach?

  1. An auditing service must retain immutable-like sequential audit exports separately from its transactional application tables.
  2. An ETL pipeline needs directory-style access control and efficient directory operations within its cloud data lake.
  3. An existing SQL Server application needs broad instance-level compatibility but less infrastructure administration than managing a virtual machine.
  4. A booking app needs normalized tables, SQL queries and a managed Azure relational platform.

Explanation

Correct Answer

B:

This situation calls for Hierarchical namespace. File-system semantics such as directories and directory-level operations become available to analytics workloads.

Incorrect Answers

A:

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 Evaluate Azure SQL Managed Instance. Managed Instance supports many SQL Server instance features in a managed Azure service.

D:

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.

Question 129

An archive has files accessed daily and other files rarely retrieved for years. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Select Azure Database for PostgreSQL.
  2. Use Azure Files to provide a managed SMB file share.
  3. Introduce a cache layer rather than repeatedly querying the persistent data store.
  4. Select suitable Azure Blob access tiers based on retrieval frequency and retention.

Explanation

Correct Answer

D:

The requirement concerns Object tiers. Storage costs and retrieval characteristics can be matched to the expected access patterns.

Incorrect Answers

A:

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 Object tiers need.

B:

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 Object tiers 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 Object tiers need.

Question 130

A data professional makes this decision: Select suitable Azure Blob access tiers based on retrieval frequency and retention. Which outcome is the most direct expected result?

  1. Storage costs and retrieval characteristics can be matched to the expected access patterns.
  2. A managed PostgreSQL service provides the compatible engine without self-managed database VMs.
  3. Clients can access shared directories through a familiar network file protocol.
  4. Frequently accessed values can be served faster while the authoritative database remains durable.

Explanation

Correct Answer

A:

This is the expected outcome for Object tiers: Storage costs and retrieval characteristics can be matched to the expected access patterns.

Incorrect Answers

B:

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 Cloud file sharing decision (Use Azure Files to provide a managed SMB file share.) rather than the specified design.

D:

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.