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 36

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.

Question 351

An ecommerce site uses MySQL-specific connectors and seeks an Azure-managed relational backend. Someone instead proposes: Perform a supported point-in-time restore from Azure SQL Database backups. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses Managed MySQL. The existing MySQL-oriented application can use a compatible managed database engine.

Incorrect Answers

A:

This choice is for Managed Instance compatibility, not the specific requirement. The workload can retain broad SQL Server compatibility with managed platform operations.

B:

This choice is for SQL Database restore, not the specific requirement. A restored database reflects its state at a selected prior time.

D:

This choice is for Instance migration, not the specific requirement. Migration can preserve more familiar SQL Server instance behavior than a single database model.

Question 352

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

  1. An application uses cross-database queries and instance-level SQL Agent jobs in an existing SQL Server environment.
  2. A production Azure SQL Database was accidentally changed and needs recovery to a point before the modification within backup retention.
  3. A migration uses SQL Server instance-level features unavailable in a simple single Azure SQL Database deployment.
  4. An ecommerce site uses MySQL-specific connectors and seeks an Azure-managed relational backend.

Explanation

Correct Answer

D:

This situation calls for Managed MySQL. The existing MySQL-oriented application can use a compatible managed database engine.

Incorrect Answers

A:

The other situation is better matched to Assess Azure SQL Managed Instance as a migration target for supported instance-level features. Migration can preserve more familiar SQL Server instance behavior than a single database model.

B:

The other situation is better matched to Perform a supported point-in-time restore from Azure SQL Database backups. A restored database reflects its state at a selected prior time.

C:

The other situation is better matched to Evaluate Azure SQL Managed Instance for compatible managed-instance behavior. The workload can retain broad SQL Server compatibility with managed platform operations.

Question 353

A team wants to move a MySQL app to Azure while preserving its SQL dialect rather than rewriting it for Microsoft SQL Server. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Compare supported SQL Server on Azure VM images and licensing options.
  2. Deploy SQL Server on an Azure virtual machine.
  3. Use database roles or explicit SQL permissions scoped to read access.
  4. Choose a managed MySQL engine instead of Azure SQL Database.

Explanation

Correct Answer

D:

The requirement concerns Engine compatibility. Engine compatibility reduces unnecessary query and driver changes.

Incorrect Answers

A:

That action instead addresses SQL on VM licensing: The deployment can align with its required SQL Server edition and infrastructure model. It does not directly satisfy the described Engine compatibility need.

B:

That action instead addresses SQL Server on VM: The organization can customize OS and SQL Server instance configuration. It does not directly satisfy the described Engine compatibility need.

C:

That action instead addresses SQL security access: Reporting identities can query authorized data without broad modification rights. It does not directly satisfy the described Engine compatibility need.

Question 354

A data professional makes this decision: Choose a managed MySQL engine instead of Azure SQL Database. Which outcome is the most direct expected result?

  1. Engine compatibility reduces unnecessary query and driver changes.
  2. Reporting identities can query authorized data without broad modification rights.
  3. The deployment can align with its required SQL Server edition and infrastructure model.
  4. The organization can customize OS and SQL Server instance configuration.

Explanation

Correct Answer

A:

This is the expected outcome for Engine compatibility: Engine compatibility reduces unnecessary query and driver changes.

Incorrect Answers

B:

This result would follow the different SQL security access decision (Use database roles or explicit SQL permissions scoped to read access.) rather than the specified design.

C:

This result would follow the different SQL on VM licensing decision (Compare supported SQL Server on Azure VM images and licensing options.) rather than the specified design.

D:

This result would follow the different SQL Server on VM decision (Deploy SQL Server on an Azure virtual machine.) rather than the specified design.

Question 355

A team wants to move a MySQL app to Azure while preserving its SQL dialect rather than rewriting it for Microsoft SQL Server. Someone instead proposes: Use database roles or explicit SQL permissions scoped to read access. Which alternative is the best correction for the original requirement?

  1. Use database roles or explicit SQL permissions scoped to read access.
  2. Choose a managed MySQL engine instead of Azure SQL Database.
  3. Compare supported SQL Server on Azure VM images and licensing options.
  4. Deploy SQL Server on an Azure virtual machine.

Explanation

Correct Answer

B:

This correction addresses Engine compatibility. Engine compatibility reduces unnecessary query and driver changes.

Incorrect Answers

A:

This choice is for SQL security access, not the specific requirement. Reporting identities can query authorized data without broad modification rights.

C:

This choice is for SQL on VM licensing, not the specific requirement. The deployment can align with its required SQL Server edition and infrastructure model.

D:

This choice is for SQL Server on VM, not the specific requirement. The organization can customize OS and SQL Server instance configuration.

Question 356

A data architect recommends this approach: Choose a managed MySQL engine instead of Azure SQL Database. Which situation most clearly calls for that approach?

  1. A finance database uses Azure SQL and must grant reporting users read access without permissions to modify source tables.
  2. A company requires SQL Server edition and license flexibility and is prepared to manage database infrastructure on its Azure servers.
  3. A team wants to move a MySQL app to Azure while preserving its SQL dialect rather than rewriting it for Microsoft SQL Server.
  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 Engine compatibility. Engine compatibility reduces unnecessary query and driver changes.

Incorrect Answers

A:

The other situation is better matched to Use database roles or explicit SQL permissions scoped to read access. Reporting identities can query authorized data without broad modification rights.

B:

The other situation is better matched to Compare supported SQL Server on Azure VM images and licensing options. The deployment can align with its required SQL Server edition and infrastructure model.

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 357

An architect assumes Azure SQL Database requires the customer to install operating-system patches on the database host. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Treat Azure SQL Database as platform as a service with provider-managed host patching.
  2. Use the managed PostgreSQL service's supported backup and restore functionality.
  3. Configure supported Microsoft Entra authentication for Azure SQL.
  4. Place suitable Azure SQL databases in an elastic pool.

Explanation

Correct Answer

A:

The requirement concerns Infrastructure responsibility. The customer focuses more on schema, access and workload than guest OS maintenance.

Incorrect Answers

B:

That action instead addresses PostgreSQL backups: Recovery can use the service-managed backup mechanism within its configured limits. It does not directly satisfy the described Infrastructure responsibility need.

C:

That action instead addresses SQL authentication mode: Authorized identities can use centralized identity management for database connections. It does not directly satisfy the described Infrastructure responsibility need.

D:

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

Question 358

A data professional makes this decision: Treat Azure SQL Database as platform as a service with provider-managed host patching. Which outcome is the most direct expected result?

  1. Authorized identities can use centralized identity management for database connections.
  2. The customer focuses more on schema, access and workload than guest OS maintenance.
  3. Databases can share a pool of provisioned compute resources.
  4. Recovery can use the service-managed backup mechanism within its configured limits.

Explanation

Correct Answer

B:

This is the expected outcome for Infrastructure responsibility: The customer focuses more on schema, access and workload than guest OS maintenance.

Incorrect Answers

A:

This result would follow the different SQL authentication mode decision (Configure supported Microsoft Entra authentication for Azure SQL.) rather than the specified design.

C:

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

D:

This result would follow the different PostgreSQL backups decision (Use the managed PostgreSQL service's supported backup and restore functionality.) rather than the specified design.

Question 359

An architect assumes Azure SQL Database requires the customer to install operating-system patches on the database host. Someone instead proposes: Configure supported Microsoft Entra authentication for Azure SQL. Which alternative is the best correction for the original requirement?

  1. Place suitable Azure SQL databases in an elastic pool.
  2. Configure supported Microsoft Entra authentication for Azure SQL.
  3. Treat Azure SQL Database as platform as a service with provider-managed host patching.
  4. Use the managed PostgreSQL service's supported backup and restore functionality.

Explanation

Correct Answer

C:

This correction addresses Infrastructure responsibility. The customer focuses more on schema, access and workload than guest OS maintenance.

Incorrect Answers

A:

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

B:

This choice is for SQL authentication mode, not the specific requirement. Authorized identities can use centralized identity management for database connections.

D:

This choice is for PostgreSQL backups, not the specific requirement. Recovery can use the service-managed backup mechanism within its configured limits.

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.