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 40

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.

Question 391

An application uses cross-database queries and instance-level SQL Agent jobs in an existing SQL Server environment. Someone instead proposes: Use Azure SQL Database as the managed database service. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

D:

This correction addresses Instance migration. Migration can preserve more familiar SQL Server instance behavior than a single database model.

Incorrect Answers

A:

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

B:

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

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.

Question 392

A data architect recommends this approach: Assess Azure SQL Managed Instance as a migration target for supported instance-level features. 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 web application depends on PostgreSQL drivers, functions and data types but the team wants Azure to manage the database infrastructure.
  3. A production Azure SQL Database was accidentally changed and needs recovery to a point before the modification within backup retention.
  4. A startup needs a cloud-managed Microsoft SQL relational database without maintaining a guest operating system.

Explanation

Correct Answer

A:

This situation calls for Instance migration. Migration can preserve more familiar SQL Server instance behavior than a single database model.

Incorrect Answers

B:

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.

C:

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

Question 393

A company requires SQL Server edition and license flexibility and is prepared to manage database infrastructure on its Azure servers. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use database roles or explicit SQL permissions scoped to read access.
  2. Evaluate Azure SQL Managed Instance for compatible managed-instance behavior.
  3. Select Azure Database for MySQL Flexible Server.
  4. Compare supported SQL Server on Azure VM images and licensing options.

Explanation

Correct Answer

D:

The requirement concerns SQL on VM licensing. The deployment can align with its required SQL Server edition and infrastructure model.

Incorrect Answers

A:

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

B:

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

Question 394

A data professional makes this decision: Compare supported SQL Server on Azure VM images and licensing options. Which outcome is the most direct expected result?

  1. The deployment can align with its required SQL Server edition and infrastructure model.
  2. The workload can retain broad SQL Server compatibility with managed platform operations.
  3. The existing MySQL-oriented application can use a compatible managed database engine.
  4. Reporting identities can query authorized data without broad modification rights.

Explanation

Correct Answer

A:

This is the expected outcome for SQL on VM licensing: The deployment can align with its required SQL Server edition and infrastructure model.

Incorrect Answers

B:

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.

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 security access decision (Use database roles or explicit SQL permissions scoped to read access.) rather than the specified design.

Question 395

A company requires SQL Server edition and license flexibility and is prepared to manage database infrastructure on its Azure servers. Someone instead proposes: Evaluate Azure SQL Managed Instance for compatible managed-instance behavior. Which alternative is the best correction for the original requirement?

  1. Select Azure Database for MySQL Flexible Server.
  2. Compare supported SQL Server on Azure VM images and licensing options.
  3. Evaluate Azure SQL Managed Instance for compatible managed-instance behavior.
  4. Use database roles or explicit SQL permissions scoped to read access.

Explanation

Correct Answer

B:

This correction addresses SQL on VM licensing. The deployment can align with its required SQL Server edition and infrastructure model.

Incorrect Answers

A:

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

C:

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

D:

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

Question 396

A data architect recommends this approach: Compare supported SQL Server on Azure VM images and licensing options. Which situation most clearly calls for that approach?

  1. A migration uses SQL Server instance-level features unavailable in a simple single Azure SQL Database deployment.
  2. A finance database uses Azure SQL and must grant reporting users read access without permissions to modify source tables.
  3. A company requires SQL Server edition and license flexibility and is prepared to manage database infrastructure on its Azure servers.
  4. An ecommerce site uses MySQL-specific connectors and seeks an Azure-managed relational backend.

Explanation

Correct Answer

C:

This situation calls for SQL on VM licensing. The deployment can align with its required SQL Server edition and infrastructure model.

Incorrect Answers

A:

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.

B:

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.

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 397

An Azure Database for PostgreSQL workload needs operational recovery after accidental data loss. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Configure supported Microsoft Entra authentication for Azure SQL.
  2. Use the managed PostgreSQL service's supported backup and restore functionality.
  3. Deploy SQL Server on an Azure virtual machine.
  4. Choose a managed MySQL engine instead of Azure SQL Database.

Explanation

Correct Answer

B:

The requirement concerns PostgreSQL backups. Recovery can use the service-managed backup mechanism within its configured limits.

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

C:

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

D:

That action instead addresses Engine compatibility: Engine compatibility reduces unnecessary query and driver changes. It does not directly satisfy the described PostgreSQL backups need.

Question 398

A data professional makes this decision: Use the managed PostgreSQL service's supported backup and restore functionality. Which outcome is the most direct expected result?

  1. The organization can customize OS and SQL Server instance configuration.
  2. Engine compatibility reduces unnecessary query and driver changes.
  3. Recovery can use the service-managed backup mechanism within its configured limits.
  4. Authorized identities can use centralized identity management for database connections.

Explanation

Correct Answer

C:

This is the expected outcome for PostgreSQL backups: Recovery can use the service-managed backup mechanism within its configured limits.

Incorrect Answers

A:

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

B:

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 SQL authentication mode decision (Configure supported Microsoft Entra authentication for Azure SQL.) rather than the specified design.

Question 399

An Azure Database for PostgreSQL workload needs operational recovery after accidental data loss. Someone instead proposes: Deploy SQL Server on an Azure virtual machine. Which alternative is the best correction for the original requirement?

  1. Deploy SQL Server on an Azure virtual machine.
  2. Choose a managed MySQL engine instead of Azure SQL Database.
  3. Configure supported Microsoft Entra authentication for Azure SQL.
  4. Use the managed PostgreSQL service's supported backup and restore functionality.

Explanation

Correct Answer

D:

This correction addresses PostgreSQL backups. Recovery can use the service-managed backup mechanism within its configured limits.

Incorrect Answers

A:

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

B:

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

C:

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

Question 400

A data architect recommends this approach: Use the managed PostgreSQL service's supported backup and restore functionality. Which situation most clearly calls for that approach?

  1. An Azure Database for PostgreSQL workload needs operational recovery after accidental data loss.
  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. 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

A:

This situation calls for PostgreSQL backups. Recovery can use the service-managed backup mechanism within its configured limits.

Incorrect Answers

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 Configure supported Microsoft Entra authentication for Azure SQL. Authorized identities can use centralized identity management for database connections.

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.