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 25

Question 240

A data architect recommends this approach: Replace repeating product lists with atomic values represented in related rows. Which situation most clearly calls for that approach?

  1. A report must list only orders that have a matching approved customer record.
  2. A report must display only departments whose summed annual expense exceeds a threshold.
  3. A column contains a comma-separated list of all product IDs purchased in an order and makes queries awkward.
  4. An app needs to run a reusable parameterized SQL routine for a repeatable business operation.

Explanation

Correct Answer

C:

This situation calls for First normal form. The schema avoids storing multiple logical values in a single relational cell.

Incorrect Answers

A:

The other situation is better matched to Use an INNER JOIN between orders and customers on their keys. Only matching combinations of rows appear in the result.

B:

The other situation is better matched to Use HAVING to filter groups by the aggregate expense. Groups below the total threshold are removed after aggregation.

D:

The other situation is better matched to Create a stored procedure encapsulating the routine. The database can execute a named parameterized sequence of SQL operations.

Question 241

A composite-key enrollment table repeats a student's name even though the name depends only on student ID. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use an INSERT statement specifying the new product values.
  2. Roll back the uncommitted transaction rather than committing its partial changes.
  3. Use a LEFT OUTER JOIN from customers to orders.
  4. Move attributes dependent on only part of the composite key to the correct entity table.

Explanation

Correct Answer

D:

The requirement concerns Second normal form. Partial-key dependencies are reduced and updates become more consistent.

Incorrect Answers

A:

That action instead addresses INSERT row: A new row is created without replacing the table's existing rows. It does not directly satisfy the described Second normal form need.

B:

That action instead addresses Transaction rollback: Related uncommitted changes are undone to preserve transaction consistency. It does not directly satisfy the described Second normal form need.

C:

That action instead addresses LEFT JOIN: Unmatched customers remain in the output with null columns for orders. It does not directly satisfy the described Second normal form need.

Question 242

A data professional makes this decision: Move attributes dependent on only part of the composite key to the correct entity table. Which outcome is the most direct expected result?

  1. Partial-key dependencies are reduced and updates become more consistent.
  2. A new row is created without replacing the table's existing rows.
  3. Unmatched customers remain in the output with null columns for orders.
  4. Related uncommitted changes are undone to preserve transaction consistency.

Explanation

Correct Answer

A:

This is the expected outcome for Second normal form: Partial-key dependencies are reduced and updates become more consistent.

Incorrect Answers

B:

This result would follow the different INSERT row decision (Use an INSERT statement specifying the new product values.) rather than the specified design.

C:

This result would follow the different LEFT JOIN decision (Use a LEFT OUTER JOIN from customers to orders.) rather than the specified design.

D:

This result would follow the different Transaction rollback decision (Roll back the uncommitted transaction rather than committing its partial changes.) rather than the specified design.

Question 243

A composite-key enrollment table repeats a student's name even though the name depends only on student ID. Someone instead proposes: Use a LEFT OUTER JOIN from customers to orders. Which alternative is the best correction for the original requirement?

  1. Roll back the uncommitted transaction rather than committing its partial changes.
  2. Move attributes dependent on only part of the composite key to the correct entity table.
  3. Use a LEFT OUTER JOIN from customers to orders.
  4. Use an INSERT statement specifying the new product values.

Explanation

Correct Answer

B:

This correction addresses Second normal form. Partial-key dependencies are reduced and updates become more consistent.

Incorrect Answers

A:

This choice is for Transaction rollback, not the specific requirement. Related uncommitted changes are undone to preserve transaction consistency.

C:

This choice is for LEFT JOIN, not the specific requirement. Unmatched customers remain in the output with null columns for orders.

D:

This choice is for INSERT row, not the specific requirement. A new row is created without replacing the table's existing rows.

Question 244

A data architect recommends this approach: Move attributes dependent on only part of the composite key to the correct entity table. Which situation most clearly calls for that approach?

  1. A new product with a valid identifier and price must be added to an existing table.
  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 transaction updates inventory but later detects that payment authorization failed before commit.

Explanation

Correct Answer

C:

This situation calls for Second normal form. Partial-key dependencies are reduced and updates become more consistent.

Incorrect Answers

A:

The other situation is better matched to Use an INSERT statement specifying the new product values. A new row is created without replacing the table's existing rows.

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.

D:

The other situation is better matched to Roll back the uncommitted transaction rather than committing its partial changes. Related uncommitted changes are undone to preserve transaction consistency.

Question 245

An order table repeats a shipping city description that depends on a postal code rather than the order key. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use UPDATE with a WHERE clause targeting the supplier key.
  2. Move the transitive lookup attributes into a separate reference table.
  3. Use a SELECT statement projecting the required columns.
  4. Use an appropriate fixed-precision decimal type for monetary columns.

Explanation

Correct Answer

B:

The requirement concerns Third normal form. Non-key attributes are less likely to introduce transitive update anomalies.

Incorrect Answers

A:

That action instead addresses UPDATE row: Only the selected existing row's address fields are modified. It does not directly satisfy the described Third normal form need.

C:

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

D:

That action instead addresses Relational data types: Stored values can represent defined decimal precision for financial calculations. It does not directly satisfy the described Third normal form need.

Question 246

A data professional makes this decision: Move the transitive lookup attributes into a separate reference table. Which outcome is the most direct expected result?

  1. The query reads selected fields and leaves stored rows unchanged.
  2. Only the selected existing row's address fields are modified.
  3. Non-key attributes are less likely to introduce transitive update anomalies.
  4. Stored values can represent defined decimal precision for financial calculations.

Explanation

Correct Answer

C:

This is the expected outcome for Third normal form: Non-key attributes are less likely to introduce transitive update anomalies.

Incorrect Answers

A:

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

B:

This result would follow the different UPDATE row decision (Use UPDATE with a WHERE clause targeting the supplier key.) rather than the specified design.

D:

This result would follow the different Relational data types decision (Use an appropriate fixed-precision decimal type for monetary columns.) rather than the specified design.

Question 247

An order table repeats a shipping city description that depends on a postal code rather than the order key. Someone instead proposes: Use a SELECT statement projecting the required columns. Which alternative is the best correction for the original requirement?

  1. Use a SELECT statement projecting the required columns.
  2. Use UPDATE with a WHERE clause targeting the supplier key.
  3. Use an appropriate fixed-precision decimal type for monetary columns.
  4. Move the transitive lookup attributes into a separate reference table.

Explanation

Correct Answer

D:

This correction addresses Third normal form. Non-key attributes are less likely to introduce transitive update anomalies.

Incorrect Answers

A:

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

B:

This choice is for UPDATE row, not the specific requirement. Only the selected existing row's address fields are modified.

C:

This choice is for Relational data types, not the specific requirement. Stored values can represent defined decimal precision for financial calculations.

Question 248

A data architect recommends this approach: Move the transitive lookup attributes into a separate reference table. Which situation most clearly calls for that approach?

  1. An order table repeats a shipping city description that depends on a postal code rather than the order key.
  2. A query must retrieve a product name and list price without modifying the catalog.
  3. A bank must store currency amounts precisely instead of introducing binary floating-point rounding errors.
  4. A supplier's street address has changed but its record identity must stay the same.

Explanation

Correct Answer

A:

This situation calls for Third normal form. Non-key attributes are less likely to introduce transitive update anomalies.

Incorrect Answers

B:

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.

C:

The other situation is better matched to Use an appropriate fixed-precision decimal type for monetary columns. Stored values can represent defined decimal precision for financial calculations.

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 249

A shop repeats a customer's phone number on every line-item row, causing inconsistent updates. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Store customer contact data once and reference its key from order records.
  2. Add a WHERE condition on invoice due date.
  3. Define a primary key on the employee identifier column.
  4. Use DELETE with a WHERE predicate matching expired sessions.

Explanation

Correct Answer

A:

The requirement concerns Normalize duplicate contacts. The same contact detail no longer needs editing in every purchased item row.

Incorrect Answers

B:

That action instead addresses WHERE predicate: Rows not satisfying the filter are excluded before aggregation. It does not directly satisfy the described Normalize duplicate contacts need.

C:

That action instead addresses Primary key: Each employee row gains a unique non-null identifier for referencing records. It does not directly satisfy the described Normalize duplicate contacts need.

D:

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

Question 250

A data professional makes this decision: Store customer contact data once and reference its key from order records. Which outcome is the most direct expected result?

  1. Matching rows are removed while other records remain.
  2. The same contact detail no longer needs editing in every purchased item row.
  3. Rows not satisfying the filter are excluded before aggregation.
  4. Each employee row gains a unique non-null identifier for referencing records.

Explanation

Correct Answer

B:

This is the expected outcome for Normalize duplicate contacts: The same contact detail no longer needs editing in every purchased item row.

Incorrect Answers

A:

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

C:

This result would follow the different WHERE predicate decision (Add a WHERE condition on invoice due date.) rather than the specified design.

D:

This result would follow the different Primary key decision (Define a primary key on the employee identifier column.) rather than the specified design.