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 37

Question 360

A data architect recommends this approach: Treat Azure SQL Database as platform as a service with provider-managed host patching. Which situation most clearly calls for that approach?

  1. An Azure Database for PostgreSQL workload needs operational recovery after accidental data loss.
  2. A company wants centralized workforce sign-in to supported Azure SQL resources instead of distributing shared SQL passwords.
  3. A software provider runs dozens of Azure SQL databases whose utilization peaks at different times.
  4. An architect assumes Azure SQL Database requires the customer to install operating-system patches on the database host.

Explanation

Correct Answer

D:

This situation calls for Infrastructure responsibility. The customer focuses more on schema, access and workload than guest OS maintenance.

Incorrect Answers

A:

The other situation is better matched to Use the managed PostgreSQL service's supported backup and restore functionality. Recovery can use the service-managed backup mechanism within its configured limits.

B:

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.

C:

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 361

An enterprise hosts SQL Server in its own Azure VM and asks who schedules guest OS updates. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.
  2. Rely on the managed service's built-in platform availability features subject to the chosen tier.
  3. Connect using an appropriate SQL client such as SQL Server Management Studio.
  4. Plan for the customer to maintain the guest operating system on its SQL VM.

Explanation

Correct Answer

D:

The requirement concerns IaaS patching. Virtual machine ownership retains OS lifecycle responsibilities.

Incorrect Answers

A:

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 IaaS patching need.

B:

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 IaaS patching need.

C:

That action instead addresses SQL query tools: The engineer can run authorized SQL statements against the managed database. It does not directly satisfy the described IaaS patching need.

Question 362

A data professional makes this decision: Plan for the customer to maintain the guest operating system on its SQL VM. Which outcome is the most direct expected result?

  1. Virtual machine ownership retains OS lifecycle responsibilities.
  2. Database host resilience is delivered by the managed Azure SQL platform.
  3. The engineer can run authorized SQL statements against the managed database.
  4. Compute can scale with demand and potentially pause during suitable inactivity.

Explanation

Correct Answer

A:

This is the expected outcome for IaaS patching: Virtual machine ownership retains OS lifecycle responsibilities.

Incorrect Answers

B:

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.

C:

This result would follow the different SQL query tools decision (Connect using an appropriate SQL client such as SQL Server Management Studio.) rather than the specified design.

D:

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.

Question 363

An enterprise hosts SQL Server in its own Azure VM and asks who schedules guest OS updates. Someone instead proposes: Rely on the managed service's built-in platform availability features subject to the chosen tier. Which alternative is the best correction for the original requirement?

  1. Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.
  2. Plan for the customer to maintain the guest operating system on its SQL VM.
  3. Rely on the managed service's built-in platform availability features subject to the chosen tier.
  4. Connect using an appropriate SQL client such as SQL Server Management Studio.

Explanation

Correct Answer

B:

This correction addresses IaaS patching. Virtual machine ownership retains OS lifecycle responsibilities.

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.

C:

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

D:

This choice is for SQL query tools, not the specific requirement. The engineer can run authorized SQL statements against the managed database.

Question 364

A data architect recommends this approach: Plan for the customer to maintain the guest operating system on its SQL VM. Which situation most clearly calls for that approach?

  1. A small single Azure SQL Database workload is idle overnight and needs automatic compute scaling rather than fixed always-on allocation.
  2. An IT manager assumes a single Azure SQL Database requires the team to manually configure cluster-level host failover.
  3. An enterprise hosts SQL Server in its own Azure VM and asks who schedules guest OS updates.
  4. A data engineer wants to interactively write and execute T-SQL against an Azure SQL Database from a supported desktop client.

Explanation

Correct Answer

C:

This situation calls for IaaS patching. Virtual machine ownership retains OS lifecycle responsibilities.

Incorrect Answers

A:

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.

B:

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 Connect using an appropriate SQL client such as SQL Server Management Studio. The engineer can run authorized SQL statements against the managed database.

Question 365

An application team wants built-in managed backup capability for an Azure SQL Database rather than writing its own database backup agent. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Create separate Azure SQL databases under an appropriate logical server.
  2. Select Azure Database for PostgreSQL Flexible Server.
  3. Use Azure SQL Database automated backups and its supported restore mechanisms.
  4. Evaluate Azure SQL Database compute and service-tier scaling options.

Explanation

Correct Answer

C:

The requirement concerns Automated database backups. Managed backups support point-in-time recovery according to service retention policy.

Incorrect Answers

A:

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 Automated database backups need.

B:

That action instead addresses Managed PostgreSQL: The managed offering supports a PostgreSQL-based application without self-managing the server VM. It does not directly satisfy the described Automated database backups need.

D:

That action instead addresses Database scaling selection: The database's supported compute capacity can be adjusted for demand. It does not directly satisfy the described Automated database backups need.

Question 366

A data professional makes this decision: Use Azure SQL Database automated backups and its supported restore mechanisms. Which outcome is the most direct expected result?

  1. The managed offering supports a PostgreSQL-based application without self-managing the server VM.
  2. The database's supported compute capacity can be adjusted for demand.
  3. Each application's database remains a distinct managed database resource.
  4. Managed backups support point-in-time recovery according to service retention policy.

Explanation

Correct Answer

D:

This is the expected outcome for Automated database backups: Managed backups support point-in-time recovery according to service retention policy.

Incorrect Answers

A:

This result would follow the different Managed PostgreSQL decision (Select Azure Database for PostgreSQL Flexible Server.) rather than the specified design.

B:

This result would follow the different Database scaling selection decision (Evaluate Azure SQL Database compute and service-tier scaling options.) rather than the specified design.

C:

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.

Question 367

An application team wants built-in managed backup capability for an Azure SQL Database rather than writing its own database backup agent. Someone instead proposes: Create separate Azure SQL databases under an appropriate logical server. Which alternative is the best correction for the original requirement?

  1. Use Azure SQL Database automated backups and its supported restore mechanisms.
  2. Create separate Azure SQL databases under an appropriate logical server.
  3. Evaluate Azure SQL Database compute and service-tier scaling options.
  4. Select Azure Database for PostgreSQL Flexible Server.

Explanation

Correct Answer

A:

This correction addresses Automated database backups. Managed backups support point-in-time recovery according to service retention policy.

Incorrect Answers

B:

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

C:

This choice is for Database scaling selection, not the specific requirement. The database's supported compute capacity can be adjusted for demand.

D:

This choice is for Managed PostgreSQL, not the specific requirement. The managed offering supports a PostgreSQL-based application without self-managing the server VM.

Question 368

A data architect recommends this approach: Use Azure SQL Database automated backups and its supported restore mechanisms. Which situation most clearly calls for that approach?

  1. A managed SQL app's production workload needs more resources than its current provisioned tier allows.
  2. An application team wants built-in managed backup capability for an Azure SQL Database rather than writing its own database backup agent.
  3. Two apps each require an isolated database lifecycle and independent schema but can share the same administrative logical server.
  4. A web application depends on PostgreSQL drivers, functions and data types but the team wants Azure to manage the database infrastructure.

Explanation

Correct Answer

B:

This situation calls for Automated database backups. Managed backups support point-in-time recovery according to service retention policy.

Incorrect Answers

A:

The other situation is better matched to Evaluate Azure SQL Database compute and service-tier scaling options. The database's supported compute capacity can be adjusted for demand.

C:

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.

D:

The other situation is better matched to Select Azure Database for PostgreSQL Flexible Server. The managed offering supports a PostgreSQL-based application without self-managing the server VM.

Question 369

A production Azure SQL Database was accidentally changed and needs recovery to a point before the modification within backup retention. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Perform a supported point-in-time restore from Azure SQL Database backups.
  2. Assess Azure SQL Managed Instance as a migration target for supported instance-level features.
  3. Select Azure Database for MySQL Flexible Server.
  4. Use Azure SQL Database as the managed database service.

Explanation

Correct Answer

A:

The requirement concerns SQL Database restore. A restored database reflects its state at a selected prior time.

Incorrect Answers

B:

That action instead addresses Instance migration: Migration can preserve more familiar SQL Server instance behavior than a single database model. It does not directly satisfy the described SQL Database restore need.

C:

That action instead addresses Managed MySQL: The existing MySQL-oriented application can use a compatible managed database engine. It does not directly satisfy the described SQL Database restore need.

D:

That action instead addresses Azure SQL Database PaaS: Microsoft manages much of the platform infrastructure while the app queries SQL tables. It does not directly satisfy the described SQL Database restore need.

Question 370

A data professional makes this decision: Perform a supported point-in-time restore from Azure SQL Database backups. Which outcome is the most direct expected result?

  1. The existing MySQL-oriented application can use a compatible managed database engine.
  2. A restored database reflects its state at a selected prior time.
  3. Migration can preserve more familiar SQL Server instance behavior than a single database model.
  4. Microsoft manages much of the platform infrastructure while the app queries SQL tables.

Explanation

Correct Answer

B:

This is the expected outcome for SQL Database restore: A restored database reflects its state at a selected prior time.

Incorrect Answers

A:

This result would follow the different Managed MySQL decision (Select Azure Database for MySQL Flexible Server.) rather than the specified design.

C:

This result would follow the different Instance migration decision (Assess Azure SQL Managed Instance as a migration target for supported instance-level features.) rather than the specified design.

D:

This result would follow the different Azure SQL Database PaaS decision (Use Azure SQL Database as the managed database service.) rather than the specified design.