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 41

Question 400

A data architect recommends this approach: Use the managed PostgreSQL service's supported backup and restore functionality. Which situation most clearly calls for that approach?

  1. An Azure Database for PostgreSQL workload needs operational recovery after accidental data loss.
  2. A team wants to move a MySQL app to Azure while preserving its SQL dialect rather than rewriting it for Microsoft SQL Server.
  3. A company wants centralized workforce sign-in to supported Azure SQL resources instead of distributing shared SQL passwords.
  4. A legacy SQL Server workload requires custom Windows services and administrative access to the database server operating system.

Explanation

Correct Answer

A:

This situation calls for PostgreSQL backups. Recovery can use the service-managed backup mechanism within its configured limits.

Incorrect Answers

B:

The other situation is better matched to Choose a managed MySQL engine instead of Azure SQL Database. Engine compatibility reduces unnecessary query and driver changes.

C:

The other situation is better matched to Configure supported Microsoft Entra authentication for Azure SQL. Authorized identities can use centralized identity management for database connections.

D:

The other situation is better matched to Deploy SQL Server on an Azure virtual machine. The organization can customize OS and SQL Server instance configuration.

Question 401

A data engineer wants to interactively write and execute T-SQL against an Azure SQL Database from a supported desktop client. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Rely on the managed service's built-in platform availability features subject to the chosen tier.
  2. Connect using an appropriate SQL client such as SQL Server Management Studio.
  3. Place suitable Azure SQL databases in an elastic pool.
  4. Treat Azure SQL Database as platform as a service with provider-managed host patching.

Explanation

Correct Answer

B:

The requirement concerns SQL query tools. The engineer can run authorized SQL statements against the managed database.

Incorrect Answers

A:

That action instead addresses Managed high availability: Database host resilience is delivered by the managed Azure SQL platform. It does not directly satisfy the described SQL query tools need.

C:

That action instead addresses SQL elastic pool: Databases can share a pool of provisioned compute resources. It does not directly satisfy the described SQL query tools need.

D:

That action instead addresses Infrastructure responsibility: The customer focuses more on schema, access and workload than guest OS maintenance. It does not directly satisfy the described SQL query tools need.

Question 402

A data professional makes this decision: Connect using an appropriate SQL client such as SQL Server Management Studio. Which outcome is the most direct expected result?

  1. Databases can share a pool of provisioned compute resources.
  2. The customer focuses more on schema, access and workload than guest OS maintenance.
  3. The engineer can run authorized SQL statements against the managed database.
  4. Database host resilience is delivered by the managed Azure SQL platform.

Explanation

Correct Answer

C:

This is the expected outcome for SQL query tools: The engineer can run authorized SQL statements against the managed database.

Incorrect Answers

A:

This result would follow the different SQL elastic pool decision (Place suitable Azure SQL databases in an elastic pool.) rather than the specified design.

B:

This result would follow the different Infrastructure responsibility decision (Treat Azure SQL Database as platform as a service with provider-managed host patching.) rather than the specified design.

D:

This result would follow the different Managed high availability decision (Rely on the managed service's built-in platform availability features subject to the chosen tier.) rather than the specified design.

Question 403

A data engineer wants to interactively write and execute T-SQL against an Azure SQL Database from a supported desktop client. Someone instead proposes: Place suitable Azure SQL databases in an elastic pool. Which alternative is the best correction for the original requirement?

  1. Rely on the managed service's built-in platform availability features subject to the chosen tier.
  2. Place suitable Azure SQL databases in an elastic pool.
  3. Treat Azure SQL Database as platform as a service with provider-managed host patching.
  4. Connect using an appropriate SQL client such as SQL Server Management Studio.

Explanation

Correct Answer

D:

This correction addresses SQL query tools. The engineer can run authorized SQL statements against the managed database.

Incorrect Answers

A:

This choice is for Managed high availability, not the specific requirement. Database host resilience is delivered by the managed Azure SQL platform.

B:

This choice is for SQL elastic pool, not the specific requirement. Databases can share a pool of provisioned compute resources.

C:

This choice is for Infrastructure responsibility, not the specific requirement. The customer focuses more on schema, access and workload than guest OS maintenance.

Question 404

A data architect recommends this approach: Connect using an appropriate SQL client such as SQL Server Management Studio. Which situation most clearly calls for that approach?

  1. A data engineer wants to interactively write and execute T-SQL against an Azure SQL Database from a supported desktop client.
  2. An architect assumes Azure SQL Database requires the customer to install operating-system patches on the database host.
  3. An IT manager assumes a single Azure SQL Database requires the team to manually configure cluster-level host failover.
  4. A software provider runs dozens of Azure SQL databases whose utilization peaks at different times.

Explanation

Correct Answer

A:

This situation calls for SQL query tools. The engineer can run authorized SQL statements against the managed database.

Incorrect Answers

B:

The other situation is better matched to Treat Azure SQL Database as platform as a service with provider-managed host patching. The customer focuses more on schema, access and workload than guest OS maintenance.

C:

The other situation is better matched to Rely on the managed service's built-in platform availability features subject to the chosen tier. Database host resilience is delivered by the managed Azure SQL platform.

D:

The other situation is better matched to Place suitable Azure SQL databases in an elastic pool. Databases can share a pool of provisioned compute resources.

Question 405

A managed SQL app's production workload needs more resources than its current provisioned tier allows. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Evaluate Azure SQL Database compute and service-tier scaling options.
  2. Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.
  3. Create separate Azure SQL databases under an appropriate logical server.
  4. Plan for the customer to maintain the guest operating system on its SQL VM.

Explanation

Correct Answer

A:

The requirement concerns Database scaling selection. The database's supported compute capacity can be adjusted for demand.

Incorrect Answers

B:

That action instead addresses Azure SQL serverless: Compute can scale with demand and potentially pause during suitable inactivity. It does not directly satisfy the described Database scaling selection need.

C:

That action instead addresses SQL DB deployment model: Each application's database remains a distinct managed database resource. It does not directly satisfy the described Database scaling selection need.

D:

That action instead addresses IaaS patching: Virtual machine ownership retains OS lifecycle responsibilities. It does not directly satisfy the described Database scaling selection need.

Question 406

A data professional makes this decision: Evaluate Azure SQL Database compute and service-tier scaling options. Which outcome is the most direct expected result?

  1. Each application's database remains a distinct managed database resource.
  2. The database's supported compute capacity can be adjusted for demand.
  3. Compute can scale with demand and potentially pause during suitable inactivity.
  4. Virtual machine ownership retains OS lifecycle responsibilities.

Explanation

Correct Answer

B:

This is the expected outcome for Database scaling selection: The database's supported compute capacity can be adjusted for demand.

Incorrect Answers

A:

This result would follow the different SQL DB deployment model decision (Create separate Azure SQL databases under an appropriate logical server.) rather than the specified design.

C:

This result would follow the different Azure SQL serverless decision (Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.) rather than the specified design.

D:

This result would follow the different IaaS patching decision (Plan for the customer to maintain the guest operating system on its SQL VM.) rather than the specified design.

Question 407

A managed SQL app's production workload needs more resources than its current provisioned tier allows. Someone instead proposes: Evaluate the serverless compute tier for the appropriate Azure SQL Database workload. Which alternative is the best correction for the original requirement?

  1. Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.
  2. Create separate Azure SQL databases under an appropriate logical server.
  3. Evaluate Azure SQL Database compute and service-tier scaling options.
  4. Plan for the customer to maintain the guest operating system on its SQL VM.

Explanation

Correct Answer

C:

This correction addresses Database scaling selection. The database's supported compute capacity can be adjusted for demand.

Incorrect Answers

A:

This choice is for Azure SQL serverless, not the specific requirement. Compute can scale with demand and potentially pause during suitable inactivity.

B:

This choice is for SQL DB deployment model, not the specific requirement. Each application's database remains a distinct managed database resource.

D:

This choice is for IaaS patching, not the specific requirement. Virtual machine ownership retains OS lifecycle responsibilities.

Question 408

A data architect recommends this approach: Evaluate Azure SQL Database compute and service-tier scaling options. Which situation most clearly calls for that approach?

  1. Two apps each require an isolated database lifecycle and independent schema but can share the same administrative logical server.
  2. A small single Azure SQL Database workload is idle overnight and needs automatic compute scaling rather than fixed always-on allocation.
  3. An enterprise hosts SQL Server in its own Azure VM and asks who schedules guest OS updates.
  4. A managed SQL app's production workload needs more resources than its current provisioned tier allows.

Explanation

Correct Answer

D:

This situation calls for Database scaling selection. The database's supported compute capacity can be adjusted for demand.

Incorrect Answers

A:

The other situation is better matched to Create separate Azure SQL databases under an appropriate logical server. Each application's database remains a distinct managed database resource.

B:

The other situation is better matched to Evaluate the serverless compute tier for the appropriate Azure SQL Database workload. Compute can scale with demand and potentially pause during suitable inactivity.

C:

The other situation is better matched to Plan for the customer to maintain the guest operating system on its SQL VM. Virtual machine ownership retains OS lifecycle responsibilities.

Question 409

An app stores user-uploaded photos and must access each through an HTTP-based object storage API. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use container access configuration and authorization appropriate to each dataset.
  2. Configure Azure Files with supported NFS capabilities.
  3. Select locally redundant storage for the stated availability scope.
  4. Use Azure Blob Storage as the object store.

Explanation

Correct Answer

D:

The requirement concerns Blob object media. Application code can retrieve binary blobs using object names and supported access methods.

Incorrect Answers

A:

That action instead addresses Container access scope: Public content exposure and private object access can be controlled separately. It does not directly satisfy the described Blob object media need.

B:

That action instead addresses NFS share: Linux workloads can mount the file share using network file-system semantics. It does not directly satisfy the described Blob object media need.

C:

That action instead addresses Storage redundancy LRS: Data is replicated within a single-region storage infrastructure boundary. It does not directly satisfy the described Blob object media need.

Question 410

A data professional makes this decision: Use Azure Blob Storage as the object store. Which outcome is the most direct expected result?

  1. Application code can retrieve binary blobs using object names and supported access methods.
  2. Data is replicated within a single-region storage infrastructure boundary.
  3. Public content exposure and private object access can be controlled separately.
  4. Linux workloads can mount the file share using network file-system semantics.

Explanation

Correct Answer

A:

This is the expected outcome for Blob object media: Application code can retrieve binary blobs using object names and supported access methods.

Incorrect Answers

B:

This result would follow the different Storage redundancy LRS decision (Select locally redundant storage for the stated availability scope.) rather than the specified design.

C:

This result would follow the different Container access scope decision (Use container access configuration and authorization appropriate to each dataset.) rather than the specified design.

D:

This result would follow the different NFS share decision (Configure Azure Files with supported NFS capabilities.) rather than the specified design.