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 33

Question 320

A data architect recommends this approach: Roll back the uncommitted transaction rather than committing its partial changes. Which situation most clearly calls for that approach?

  1. A transaction updates inventory but later detects that payment authorization failed before commit.
  2. A sales review must list every customer including those who have not yet placed an order.
  3. A composite-key enrollment table repeats a student's name even though the name depends only on student ID.
  4. A supplier's street address has changed but its record identity must stay the same.

Explanation

Correct Answer

A:

This situation calls for Transaction rollback. Related uncommitted changes are undone to preserve transaction consistency.

Incorrect Answers

B:

The other situation is better matched to Use a LEFT OUTER JOIN from customers to orders. Unmatched customers remain in the output with null columns for orders.

C:

The other situation is better matched to Move attributes dependent on only part of the composite key to the correct entity table. Partial-key dependencies are reduced and updates become more consistent.

D:

The other situation is better matched to Use UPDATE with a WHERE clause targeting the supplier key. Only the selected existing row's address fields are modified.

Question 321

A bank must store currency amounts precisely instead of introducing binary floating-point rounding errors. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use an appropriate fixed-precision decimal type for monetary columns.
  2. Use DELETE with a WHERE predicate matching expired sessions.
  3. Move the transitive lookup attributes into a separate reference table.
  4. Use a SELECT statement projecting the required columns.

Explanation

Correct Answer

A:

The requirement concerns Relational data types. Stored values can represent defined decimal precision for financial calculations.

Incorrect Answers

B:

That action instead addresses DELETE selected: Matching rows are removed while other records remain. It does not directly satisfy the described Relational data types need.

C:

That action instead addresses Third normal form: Non-key attributes are less likely to introduce transitive update anomalies. It does not directly satisfy the described Relational data types need.

D:

That action instead addresses SELECT columns: The query reads selected fields and leaves stored rows unchanged. It does not directly satisfy the described Relational data types need.

Question 322

A data professional makes this decision: Use an appropriate fixed-precision decimal type for monetary columns. Which outcome is the most direct expected result?

  1. Non-key attributes are less likely to introduce transitive update anomalies.
  2. Stored values can represent defined decimal precision for financial calculations.
  3. The query reads selected fields and leaves stored rows unchanged.
  4. Matching rows are removed while other records remain.

Explanation

Correct Answer

B:

This is the expected outcome for Relational data types: Stored values can represent defined decimal precision for financial calculations.

Incorrect Answers

A:

This result would follow the different Third normal form decision (Move the transitive lookup attributes into a separate reference table.) rather than the specified design.

C:

This result would follow the different SELECT columns decision (Use a SELECT statement projecting the required columns.) rather than the specified design.

D:

This result would follow the different DELETE selected decision (Use DELETE with a WHERE predicate matching expired sessions.) rather than the specified design.

Question 323

A bank must store currency amounts precisely instead of introducing binary floating-point rounding errors. Someone instead proposes: Move the transitive lookup attributes into a separate reference table. Which alternative is the best correction for the original requirement?

  1. Move the transitive lookup attributes into a separate reference table.
  2. Use DELETE with a WHERE predicate matching expired sessions.
  3. Use an appropriate fixed-precision decimal type for monetary columns.
  4. Use a SELECT statement projecting the required columns.

Explanation

Correct Answer

C:

This correction addresses Relational data types. Stored values can represent defined decimal precision for financial calculations.

Incorrect Answers

A:

This choice is for Third normal form, not the specific requirement. Non-key attributes are less likely to introduce transitive update anomalies.

B:

This choice is for DELETE selected, not the specific requirement. Matching rows are removed while other records remain.

D:

This choice is for SELECT columns, not the specific requirement. The query reads selected fields and leaves stored rows unchanged.

Question 324

A data architect recommends this approach: Use an appropriate fixed-precision decimal type for monetary columns. Which situation most clearly calls for that approach?

  1. A query must retrieve a product name and list price without modifying the catalog.
  2. An order table repeats a shipping city description that depends on a postal code rather than the order key.
  3. A temporary table contains expired session rows that must be removed without clearing current sessions.
  4. A bank must store currency amounts precisely instead of introducing binary floating-point rounding errors.

Explanation

Correct Answer

D:

This situation calls for Relational data types. Stored values can represent defined decimal precision for financial calculations.

Incorrect Answers

A:

The other situation is better matched to Use a SELECT statement projecting the required columns. The query reads selected fields and leaves stored rows unchanged.

B:

The other situation is better matched to Move the transitive lookup attributes into a separate reference table. Non-key attributes are less likely to introduce transitive update anomalies.

C:

The other situation is better matched to Use DELETE with a WHERE predicate matching expired sessions. Matching rows are removed while other records remain.

Question 325

A startup needs a cloud-managed Microsoft SQL relational database without maintaining a guest operating system. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Assess Azure SQL Managed Instance as a migration target for supported instance-level features.
  2. Use Azure SQL Database as the managed database service.
  3. Use Azure SQL Database automated backups and its supported restore mechanisms.
  4. Select Azure Database for PostgreSQL Flexible Server.

Explanation

Correct Answer

B:

The requirement concerns Azure SQL Database PaaS. Microsoft manages much of the platform infrastructure while the app queries SQL tables.

Incorrect Answers

A:

That action instead addresses Instance migration: Migration can preserve more familiar SQL Server instance behavior than a single database model. It does not directly satisfy the described Azure SQL Database PaaS need.

C:

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 Azure SQL Database PaaS 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 Azure SQL Database PaaS need.

Question 326

A data professional makes this decision: Use Azure SQL Database as the managed database service. Which outcome is the most direct expected result?

  1. The managed offering supports a PostgreSQL-based application without self-managing the server VM.
  2. Managed backups support point-in-time recovery according to service retention policy.
  3. Microsoft manages much of the platform infrastructure while the app queries SQL tables.
  4. Migration can preserve more familiar SQL Server instance behavior than a single database model.

Explanation

Correct Answer

C:

This is the expected outcome for Azure SQL Database PaaS: Microsoft manages much of the platform infrastructure while the app queries SQL tables.

Incorrect Answers

A:

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

B:

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 Instance migration decision (Assess Azure SQL Managed Instance as a migration target for supported instance-level features.) rather than the specified design.

Question 327

A startup needs a cloud-managed Microsoft SQL relational database without maintaining a guest operating system. Someone instead proposes: Select Azure Database for PostgreSQL Flexible Server. Which alternative is the best correction for the original requirement?

  1. Assess Azure SQL Managed Instance as a migration target for supported instance-level features.
  2. Select Azure Database for PostgreSQL Flexible Server.
  3. Use Azure SQL Database automated backups and its supported restore mechanisms.
  4. Use Azure SQL Database as the managed database service.

Explanation

Correct Answer

D:

This correction addresses Azure SQL Database PaaS. Microsoft manages much of the platform infrastructure while the app queries SQL tables.

Incorrect Answers

A:

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

B:

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

C:

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

Question 328

A data architect recommends this approach: Use Azure SQL Database as the managed database service. 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. A web application depends on PostgreSQL drivers, functions and data types but the team wants Azure to manage the database infrastructure.
  3. An application uses cross-database queries and instance-level SQL Agent jobs in an existing SQL Server environment.
  4. An application team wants built-in managed backup capability for an Azure SQL Database rather than writing its own database backup agent.

Explanation

Correct Answer

A:

This situation calls for Azure SQL Database PaaS. Microsoft manages much of the platform infrastructure while the app queries SQL tables.

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 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.

D:

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.

Question 329

A migration uses SQL Server instance-level features unavailable in a simple single Azure SQL Database deployment. Which data concept, Azure service, or design decision most directly satisfies the requirement?

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

Explanation

Correct Answer

D:

The requirement concerns Managed Instance compatibility. The workload can retain broad SQL Server compatibility with managed platform operations.

Incorrect Answers

A:

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 Managed Instance compatibility need.

B:

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 Managed Instance compatibility 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 Managed Instance compatibility need.

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.