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 34

Question 330

A data professional makes this decision: Evaluate Azure SQL Managed Instance for compatible managed-instance behavior. Which outcome is the most direct expected result?

  1. The workload can retain broad SQL Server compatibility with managed platform operations.
  2. A restored database reflects its state at a selected prior time.
  3. The existing MySQL-oriented application can use a compatible managed database engine.
  4. The deployment can align with its required SQL Server edition and infrastructure model.

Explanation

Correct Answer

A:

This is the expected outcome for Managed Instance compatibility: The workload can retain broad SQL Server compatibility with managed platform operations.

Incorrect Answers

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.

C:

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

D:

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.

Question 331

A migration uses SQL Server instance-level features unavailable in a simple single Azure SQL Database deployment. Someone instead proposes: Select Azure Database for MySQL Flexible Server. Which alternative is the best correction for the original requirement?

  1. Compare supported SQL Server on Azure VM images and licensing options.
  2. Evaluate Azure SQL Managed Instance for compatible managed-instance behavior.
  3. Select Azure Database for MySQL Flexible Server.
  4. Perform a supported point-in-time restore from Azure SQL Database backups.

Explanation

Correct Answer

B:

This correction addresses Managed Instance compatibility. The workload can retain broad SQL Server compatibility with managed platform operations.

Incorrect Answers

A:

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.

C:

This choice is for Managed MySQL, not the specific requirement. The existing MySQL-oriented application can use a compatible managed database engine.

D:

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

Question 332

A data architect recommends this approach: Evaluate Azure SQL Managed Instance for compatible managed-instance behavior. Which situation most clearly calls for that approach?

  1. A company requires SQL Server edition and license flexibility and is prepared to manage database infrastructure on its Azure servers.
  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

C:

This situation calls for Managed Instance compatibility. The workload can retain broad SQL Server compatibility with managed platform operations.

Incorrect Answers

A:

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.

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.

D:

The other situation is better matched to Select Azure Database for MySQL Flexible Server. The existing MySQL-oriented application can use a compatible managed database engine.

Question 333

A legacy SQL Server workload requires custom Windows services and administrative access to the database server operating system. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Deploy SQL Server on an Azure virtual machine.
  2. Choose a managed MySQL engine instead of Azure SQL Database.
  3. Use the managed PostgreSQL service's supported backup and restore functionality.
  4. Use database roles or explicit SQL permissions scoped to read access.

Explanation

Correct Answer

A:

The requirement concerns SQL Server on VM. The organization can customize OS and SQL Server instance configuration.

Incorrect Answers

B:

That action instead addresses Engine compatibility: Engine compatibility reduces unnecessary query and driver changes. It does not directly satisfy the described SQL Server on VM need.

C:

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 SQL Server on VM need.

D:

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

Question 334

A data professional makes this decision: Deploy SQL Server on an Azure virtual machine. Which outcome is the most direct expected result?

  1. Reporting identities can query authorized data without broad modification rights.
  2. The organization can customize OS and SQL Server instance configuration.
  3. Engine compatibility reduces unnecessary query and driver changes.
  4. Recovery can use the service-managed backup mechanism within its configured limits.

Explanation

Correct Answer

B:

This is the expected outcome for SQL Server on VM: The organization can customize OS and SQL Server instance configuration.

Incorrect Answers

A:

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 Engine compatibility decision (Choose a managed MySQL engine instead of Azure SQL Database.) 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 335

A legacy SQL Server workload requires custom Windows services and administrative access to the database server operating system. Someone instead proposes: Choose a managed MySQL engine instead of Azure SQL Database. Which alternative is the best correction for the original requirement?

  1. Choose a managed MySQL engine instead of Azure SQL Database.
  2. Use database roles or explicit SQL permissions scoped to read access.
  3. Deploy SQL Server on an Azure virtual machine.
  4. Use the managed PostgreSQL service's supported backup and restore functionality.

Explanation

Correct Answer

C:

This correction addresses SQL Server on VM. The organization can customize OS and SQL Server instance configuration.

Incorrect Answers

A:

This choice is for Engine compatibility, not the specific requirement. Engine compatibility reduces unnecessary query and driver changes.

B:

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

D:

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

Question 336

A data architect recommends this approach: Deploy SQL Server on an Azure virtual machine. 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 team wants to move a MySQL app to Azure while preserving its SQL dialect rather than rewriting it for Microsoft SQL Server.
  3. An Azure Database for PostgreSQL workload needs operational recovery after accidental data loss.
  4. A legacy SQL Server workload requires custom Windows services and administrative access to the database server operating system.

Explanation

Correct Answer

D:

This situation calls for SQL Server on VM. The organization can customize OS and SQL Server instance configuration.

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 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 Use the managed PostgreSQL service's supported backup and restore functionality. Recovery can use the service-managed backup mechanism within its configured limits.

Question 337

A software provider runs dozens of Azure SQL databases whose utilization peaks at different times. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Configure supported Microsoft Entra authentication for Azure SQL.
  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

C:

The requirement concerns SQL elastic pool. Databases can share a pool of provisioned compute resources.

Incorrect Answers

A:

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

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 SQL elastic pool 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 elastic pool need.

Question 338

A data professional makes this decision: Place suitable Azure SQL databases in an elastic pool. Which outcome is the most direct expected result?

  1. Authorized identities can use centralized identity management for database connections.
  2. The engineer can run authorized SQL statements against the managed database.
  3. The customer focuses more on schema, access and workload than guest OS maintenance.
  4. Databases can share a pool of provisioned compute resources.

Explanation

Correct Answer

D:

This is the expected outcome for SQL elastic pool: Databases can share a pool of provisioned compute resources.

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.

B:

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.

C:

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.

Question 339

A software provider runs dozens of Azure SQL databases whose utilization peaks at different times. Someone instead proposes: Treat Azure SQL Database as platform as a service with provider-managed host patching. Which alternative is the best correction for the original requirement?

  1. Place suitable Azure SQL databases in an elastic pool.
  2. Treat Azure SQL Database as platform as a service with provider-managed host patching.
  3. Connect using an appropriate SQL client such as SQL Server Management Studio.
  4. Configure supported Microsoft Entra authentication for Azure SQL.

Explanation

Correct Answer

A:

This correction addresses SQL elastic pool. Databases can share a pool of provisioned compute resources.

Incorrect Answers

B:

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

C:

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

D:

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

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.