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 38

Question 370

A data professional makes this decision: Perform a supported point-in-time restore from Azure SQL Database backups. Which outcome is the most direct expected result?

  1. The existing MySQL-oriented application can use a compatible managed database engine.
  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. Microsoft manages much of the platform infrastructure while the app queries SQL tables.

Explanation

Correct Answer

B:

This is the expected outcome for SQL Database restore: A restored database reflects its state at a selected prior time.

Incorrect Answers

A:

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

C:

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.

D:

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.

Question 371

A production Azure SQL Database was accidentally changed and needs recovery to a point before the modification within backup retention. Someone instead proposes: Assess Azure SQL Managed Instance as a migration target for supported instance-level features. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses SQL Database restore. A restored database reflects its state at a selected prior time.

Incorrect Answers

A:

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.

B:

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 Instance migration, not the specific requirement. Migration can preserve more familiar SQL Server instance behavior than a single database model.

Question 372

A data architect recommends this approach: Perform a supported point-in-time restore from Azure SQL Database backups. Which situation most clearly calls for that approach?

  1. A startup needs a cloud-managed Microsoft SQL relational database without maintaining a guest operating system.
  2. An ecommerce site uses MySQL-specific connectors and seeks an Azure-managed relational backend.
  3. An application uses cross-database queries and instance-level SQL Agent jobs in an existing SQL Server environment.
  4. A production Azure SQL Database was accidentally changed and needs recovery to a point before the modification within backup retention.

Explanation

Correct Answer

D:

This situation calls for SQL Database restore. A restored database reflects its state at a selected prior time.

Incorrect Answers

A:

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.

B:

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.

C:

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.

Question 373

A finance database uses Azure SQL and must grant reporting users read access without permissions to modify source tables. 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. Compare supported SQL Server on Azure VM images and licensing options.
  4. Choose a managed MySQL engine instead of Azure SQL Database.

Explanation

Correct Answer

A:

The requirement concerns SQL security access. Reporting identities can query authorized data without broad modification rights.

Incorrect Answers

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 security access need.

C:

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 SQL security access need.

D:

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

Question 374

A data professional makes this decision: Use database roles or explicit SQL permissions scoped to read access. Which outcome is the most direct expected result?

  1. The deployment can align with its required SQL Server edition and infrastructure model.
  2. Reporting identities can query authorized data without broad modification rights.
  3. The workload can retain broad SQL Server compatibility with managed platform operations.
  4. Engine compatibility reduces unnecessary query and driver changes.

Explanation

Correct Answer

B:

This is the expected outcome for SQL security access: Reporting identities can query authorized data without broad modification rights.

Incorrect Answers

A:

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.

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

Question 375

A finance database uses Azure SQL and must grant reporting users read access without permissions to modify source tables. Someone instead proposes: Compare supported SQL Server on Azure VM images and licensing options. Which alternative is the best correction for the original requirement?

  1. Evaluate Azure SQL Managed Instance for compatible managed-instance behavior.
  2. Compare supported SQL Server on Azure VM images and licensing options.
  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

C:

This correction addresses SQL security access. Reporting identities can query authorized data without broad modification rights.

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 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 Engine compatibility, not the specific requirement. Engine compatibility reduces unnecessary query and driver changes.

Question 376

A data architect recommends this approach: Use database roles or explicit SQL permissions scoped to read access. 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 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 finance database uses Azure SQL and must grant reporting users read access without permissions to modify source tables.

Explanation

Correct Answer

D:

This situation calls for SQL security access. Reporting identities can query authorized data without broad modification rights.

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 Compare supported SQL Server on Azure VM images and licensing options. The deployment can align with its required SQL Server edition and infrastructure model.

C:

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.

Question 377

A company wants centralized workforce sign-in to supported Azure SQL resources instead of distributing shared SQL passwords. 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. Deploy SQL Server on an Azure virtual machine.
  3. Use the managed PostgreSQL service's supported backup and restore functionality.
  4. Configure supported Microsoft Entra authentication for Azure SQL.

Explanation

Correct Answer

D:

The requirement concerns SQL authentication mode. Authorized identities can use centralized identity management for database connections.

Incorrect Answers

A:

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 authentication mode 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 SQL authentication mode 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 authentication mode need.

Question 378

A data professional makes this decision: Configure supported Microsoft Entra authentication for Azure SQL. 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. Recovery can use the service-managed backup mechanism within its configured limits.
  4. The organization can customize OS and SQL Server instance configuration.

Explanation

Correct Answer

A:

This is the expected outcome for SQL authentication mode: Authorized identities can use centralized identity management for database connections.

Incorrect Answers

B:

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.

C:

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.

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 379

A company wants centralized workforce sign-in to supported Azure SQL resources instead of distributing shared SQL passwords. Someone instead proposes: Use the managed PostgreSQL service's supported backup and restore functionality. Which alternative is the best correction for the original requirement?

  1. Use the managed PostgreSQL service's supported backup and restore functionality.
  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. Deploy SQL Server on an Azure virtual machine.

Explanation

Correct Answer

B:

This correction addresses SQL authentication mode. Authorized identities can use centralized identity management for database connections.

Incorrect Answers

A:

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

C:

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

D:

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

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.