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 39

Question 380

A data architect recommends this approach: Configure supported Microsoft Entra authentication for Azure SQL. Which situation most clearly calls for that approach?

  1. An architect assumes Azure SQL Database requires the customer to install operating-system patches on the database host.
  2. An Azure Database for PostgreSQL workload needs operational recovery after accidental data loss.
  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

C:

This situation calls for SQL authentication mode. Authorized identities can use centralized identity management for database connections.

Incorrect Answers

A:

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.

B:

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.

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 381

An IT manager assumes a single Azure SQL Database requires the team to manually configure cluster-level host failover. 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. Plan for the customer to maintain the guest operating system on its SQL VM.

Explanation

Correct Answer

A:

The requirement concerns Managed high availability. Database host resilience is delivered by the managed Azure SQL platform.

Incorrect Answers

B:

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 Managed high availability 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 Managed high availability need.

D:

That action instead addresses IaaS patching: Virtual machine ownership retains OS lifecycle responsibilities. It does not directly satisfy the described Managed high availability need.

Question 382

A data professional makes this decision: Rely on the managed service's built-in platform availability features subject to the chosen tier. Which outcome is the most direct expected result?

  1. Databases can share a pool of provisioned compute resources.
  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. Virtual machine ownership retains OS lifecycle responsibilities.

Explanation

Correct Answer

B:

This is the expected outcome for Managed high availability: Database host resilience is delivered by the managed Azure SQL platform.

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.

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 IaaS patching decision (Plan for the customer to maintain the guest operating system on its SQL VM.) rather than the specified design.

Question 383

An IT manager assumes a single Azure SQL Database requires the team to manually configure cluster-level host failover. Someone instead proposes: Connect using an appropriate SQL client such as SQL Server Management Studio. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses Managed high availability. Database host resilience is delivered by the managed Azure SQL platform.

Incorrect Answers

A:

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

B:

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

D:

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

Question 384

A data architect recommends this approach: Rely on the managed service's built-in platform availability features subject to the chosen tier. 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 enterprise hosts SQL Server in its own Azure VM and asks who schedules guest OS updates.
  3. A software provider runs dozens of Azure SQL databases whose utilization peaks at different times.
  4. An IT manager assumes a single Azure SQL Database requires the team to manually configure cluster-level host failover.

Explanation

Correct Answer

D:

This situation calls for Managed high availability. Database host resilience is delivered by the managed Azure SQL platform.

Incorrect Answers

A:

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.

B:

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.

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 385

Two apps each require an isolated database lifecycle and independent schema but can share the same administrative logical server. 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. Use Azure SQL Database automated backups and its supported restore mechanisms.
  3. Evaluate Azure SQL Database compute and service-tier scaling options.
  4. Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.

Explanation

Correct Answer

A:

The requirement concerns SQL DB deployment model. Each application's database remains a distinct managed database resource.

Incorrect Answers

B:

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 SQL DB deployment model 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 SQL DB deployment model need.

D:

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 SQL DB deployment model need.

Question 386

A data professional makes this decision: Create separate Azure SQL databases under an appropriate logical server. Which outcome is the most direct expected result?

  1. The database's supported compute capacity can be adjusted for demand.
  2. Each application's database remains a distinct managed database resource.
  3. Managed backups support point-in-time recovery according to service retention policy.
  4. Compute can scale with demand and potentially pause during suitable inactivity.

Explanation

Correct Answer

B:

This is the expected outcome for SQL DB deployment model: Each application's database remains a distinct managed database resource.

Incorrect Answers

A:

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 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 Azure SQL serverless decision (Evaluate the serverless compute tier for the appropriate Azure SQL Database workload.) rather than the specified design.

Question 387

Two apps each require an isolated database lifecycle and independent schema but can share the same administrative logical server. Someone instead proposes: Evaluate Azure SQL Database compute and service-tier scaling options. Which alternative is the best correction for the original 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. Use Azure SQL Database automated backups and its supported restore mechanisms.

Explanation

Correct Answer

C:

This correction addresses SQL DB deployment model. Each application's database remains a distinct managed database resource.

Incorrect Answers

A:

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

B:

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

D:

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

Question 388

A data architect recommends this approach: Create separate Azure SQL databases under an appropriate logical 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. A small single Azure SQL Database workload is idle overnight and needs automatic compute scaling rather than fixed always-on allocation.
  3. A managed SQL app's production workload needs more resources than its current provisioned tier allows.
  4. Two apps each require an isolated database lifecycle and independent schema but can share the same administrative logical server.

Explanation

Correct Answer

D:

This situation calls for SQL DB deployment model. Each application's database remains a distinct managed database resource.

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 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 Evaluate Azure SQL Database compute and service-tier scaling options. The database's supported compute capacity can be adjusted for demand.

Question 389

An application uses cross-database queries and instance-level SQL Agent jobs in an existing SQL Server environment. 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. Use Azure SQL Database as the managed database service.
  4. Select Azure Database for PostgreSQL Flexible Server.

Explanation

Correct Answer

B:

The requirement concerns Instance migration. Migration can preserve more familiar SQL Server instance behavior than a single database model.

Incorrect Answers

A:

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 Instance migration need.

C:

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 Instance migration need.

D:

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 Instance migration need.

Question 390

A data professional makes this decision: Assess Azure SQL Managed Instance as a migration target for supported instance-level features. Which outcome is the most direct expected result?

  1. Microsoft manages much of the platform infrastructure while the app queries SQL tables.
  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. The managed offering supports a PostgreSQL-based application without self-managing the server VM.

Explanation

Correct Answer

C:

This is the expected outcome for Instance migration: Migration can preserve more familiar SQL Server instance behavior than a single database model.

Incorrect Answers

A:

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.

B:

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.

D:

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