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 35

Question 340

A data architect recommends this approach: Place suitable Azure SQL databases in an elastic pool. Which situation most clearly calls for that approach?

  1. A company wants centralized workforce sign-in to supported Azure SQL resources instead of distributing shared SQL passwords.
  2. A software provider runs dozens of Azure SQL databases whose utilization peaks at different times.
  3. An architect assumes Azure SQL Database requires the customer to install operating-system patches on the database host.
  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

B:

This situation calls for SQL elastic pool. Databases can share a pool of provisioned compute resources.

Incorrect Answers

A:

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 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.

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 341

A small single Azure SQL Database workload is idle overnight and needs automatic compute scaling rather than fixed always-on allocation. 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. Plan for the customer to maintain the guest operating system on its SQL VM.
  3. Evaluate Azure SQL Database compute and service-tier scaling options.
  4. Rely on the managed service's built-in platform availability features subject to the chosen tier.

Explanation

Correct Answer

A:

The requirement concerns Azure SQL serverless. Compute can scale with demand and potentially pause during suitable inactivity.

Incorrect Answers

B:

That action instead addresses IaaS patching: Virtual machine ownership retains OS lifecycle responsibilities. It does not directly satisfy the described Azure SQL serverless need.

C:

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 Azure SQL serverless need.

D:

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 Azure SQL serverless need.

Question 342

A data professional makes this decision: Evaluate the serverless compute tier for the appropriate Azure SQL Database workload. Which outcome is the most direct expected result?

  1. Virtual machine ownership retains OS lifecycle responsibilities.
  2. Compute can scale with demand and potentially pause during suitable inactivity.
  3. The database's supported compute capacity can be adjusted for demand.
  4. Database host resilience is delivered by the managed Azure SQL platform.

Explanation

Correct Answer

B:

This is the expected outcome for Azure SQL serverless: Compute can scale with demand and potentially pause during suitable inactivity.

Incorrect Answers

A:

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.

C:

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.

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 343

A small single Azure SQL Database workload is idle overnight and needs automatic compute scaling rather than fixed always-on allocation. Someone instead proposes: Plan for the customer to maintain the guest operating system on its SQL VM. Which alternative is the best correction for the original requirement?

  1. Plan for the customer to maintain the guest operating system on its SQL VM.
  2. Rely on the managed service's built-in platform availability features subject to the chosen tier.
  3. Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.
  4. Evaluate Azure SQL Database compute and service-tier scaling options.

Explanation

Correct Answer

C:

This correction addresses Azure SQL serverless. Compute can scale with demand and potentially pause during suitable inactivity.

Incorrect Answers

A:

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

B:

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 Database scaling selection, not the specific requirement. The database's supported compute capacity can be adjusted for demand.

Question 344

A data architect recommends this approach: Evaluate the serverless compute tier for the appropriate Azure SQL Database workload. 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 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 small single Azure SQL Database workload is idle overnight and needs automatic compute scaling rather than fixed always-on allocation.

Explanation

Correct Answer

D:

This situation calls for Azure SQL serverless. Compute can scale with demand and potentially pause during suitable inactivity.

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.

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.

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 345

A web application depends on PostgreSQL drivers, functions and data types but the team wants Azure to manage the database infrastructure. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use Azure SQL Database automated backups and its supported restore mechanisms.
  2. Use Azure SQL Database as the managed database service.
  3. Create separate Azure SQL databases under an appropriate logical server.
  4. Select Azure Database for PostgreSQL Flexible Server.

Explanation

Correct Answer

D:

The requirement concerns Managed PostgreSQL. The managed offering supports a PostgreSQL-based application without self-managing the server VM.

Incorrect Answers

A:

That action instead addresses Automated database backups: Managed backups support point-in-time recovery according to service retention policy. It does not directly satisfy the described Managed PostgreSQL need.

B:

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 Managed PostgreSQL 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 Managed PostgreSQL need.

Question 346

A data professional makes this decision: Select Azure Database for PostgreSQL Flexible Server. Which outcome is the most direct expected result?

  1. The managed offering supports a PostgreSQL-based application without self-managing the server VM.
  2. Microsoft manages much of the platform infrastructure while the app queries SQL tables.
  3. Managed backups support point-in-time recovery according to service retention policy.
  4. Each application's database remains a distinct managed database resource.

Explanation

Correct Answer

A:

This is the expected outcome for Managed PostgreSQL: The managed offering supports a PostgreSQL-based application without self-managing the server VM.

Incorrect Answers

B:

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.

C:

This result would follow the different Automated database backups decision (Use Azure SQL Database automated backups and its supported restore mechanisms.) rather than the specified design.

D:

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 347

A web application depends on PostgreSQL drivers, functions and data types but the team wants Azure to manage the database infrastructure. Someone instead proposes: Use Azure SQL Database automated backups and its supported restore mechanisms. Which alternative is the best correction for the original requirement?

  1. Use Azure SQL Database automated backups and its supported restore mechanisms.
  2. Select Azure Database for PostgreSQL Flexible Server.
  3. Use Azure SQL Database as the managed database service.
  4. Create separate Azure SQL databases under an appropriate logical server.

Explanation

Correct Answer

B:

This correction addresses Managed PostgreSQL. The managed offering supports a PostgreSQL-based application without self-managing the server VM.

Incorrect Answers

A:

This choice is for Automated database backups, not the specific requirement. Managed backups support point-in-time recovery according to service retention policy.

C:

This choice is for Azure SQL Database PaaS, not the specific requirement. Microsoft manages much of the platform infrastructure while the app queries SQL tables.

D:

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

Question 348

A data architect recommends this approach: Select Azure Database for PostgreSQL Flexible Server. Which situation most clearly calls for that approach?

  1. An application team wants built-in managed backup capability for an Azure SQL Database rather than writing its own database backup agent.
  2. Two apps each require an isolated database lifecycle and independent schema but can share the same administrative logical server.
  3. A web application depends on PostgreSQL drivers, functions and data types but the team wants Azure to manage the database infrastructure.
  4. A startup needs a cloud-managed Microsoft SQL relational database without maintaining a guest operating system.

Explanation

Correct Answer

C:

This situation calls for Managed PostgreSQL. The managed offering supports a PostgreSQL-based application without self-managing the server VM.

Incorrect Answers

A:

The other situation is better matched to Use Azure SQL Database automated backups and its supported restore mechanisms. Managed backups support point-in-time recovery according to service retention policy.

B:

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 Use Azure SQL Database as the managed database service. Microsoft manages much of the platform infrastructure while the app queries SQL tables.

Question 349

An ecommerce site uses MySQL-specific connectors and seeks an Azure-managed relational backend. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

A:

The requirement concerns Managed MySQL. The existing MySQL-oriented application can use a compatible managed database engine.

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 Managed MySQL need.

C:

That action instead addresses SQL Database restore: A restored database reflects its state at a selected prior time. It does not directly satisfy the described Managed MySQL need.

D:

That action instead addresses Managed Instance compatibility: The workload can retain broad SQL Server compatibility with managed platform operations. It does not directly satisfy the described Managed MySQL need.

Question 350

A data professional makes this decision: Select Azure Database for MySQL Flexible Server. Which outcome is the most direct expected result?

  1. Migration can preserve more familiar SQL Server instance behavior than a single database model.
  2. The existing MySQL-oriented application can use a compatible managed database engine.
  3. The workload can retain broad SQL Server compatibility with managed platform operations.
  4. A restored database reflects its state at a selected prior time.

Explanation

Correct Answer

B:

This is the expected outcome for Managed MySQL: The existing MySQL-oriented application can use a compatible managed database engine.

Incorrect Answers

A:

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.

C:

This result would follow the different Managed Instance compatibility decision (Evaluate Azure SQL Managed Instance for compatible managed-instance behavior.) rather than the specified design.

D:

This result would follow the different SQL Database restore decision (Perform a supported point-in-time restore from Azure SQL Database backups.) rather than the specified design.