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 30

Question 290

A data professional makes this decision: Use an INSERT statement specifying the new product values. Which outcome is the most direct expected result?

  1. The schema avoids storing multiple logical values in a single relational cell.
  2. Unmatched customers remain in the output with null columns for orders.
  3. The database can execute a named parameterized sequence of SQL operations.
  4. A new row is created without replacing the table's existing rows.

Explanation

Correct Answer

D:

This is the expected outcome for INSERT row: A new row is created without replacing the table's existing rows.

Incorrect Answers

A:

This result would follow the different First normal form decision (Replace repeating product lists with atomic values represented in related rows.) rather than the specified design.

B:

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

C:

This result would follow the different Stored procedure decision (Create a stored procedure encapsulating the routine.) rather than the specified design.

Question 291

A new product with a valid identifier and price must be added to an existing table. Someone instead proposes: Create a stored procedure encapsulating the routine. Which alternative is the best correction for the original requirement?

  1. Use an INSERT statement specifying the new product values.
  2. Replace repeating product lists with atomic values represented in related rows.
  3. Create a stored procedure encapsulating the routine.
  4. Use a LEFT OUTER JOIN from customers to orders.

Explanation

Correct Answer

A:

This correction addresses INSERT row. A new row is created without replacing the table's existing rows.

Incorrect Answers

B:

This choice is for First normal form, not the specific requirement. The schema avoids storing multiple logical values in a single relational cell.

C:

This choice is for Stored procedure, not the specific requirement. The database can execute a named parameterized sequence of SQL operations.

D:

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

Question 292

A data architect recommends this approach: Use an INSERT statement specifying the new product values. Which situation most clearly calls for that approach?

  1. A column contains a comma-separated list of all product IDs purchased in an order and makes queries awkward.
  2. A new product with a valid identifier and price must be added to an existing table.
  3. A sales review must list every customer including those who have not yet placed an order.
  4. An app needs to run a reusable parameterized SQL routine for a repeatable business operation.

Explanation

Correct Answer

B:

This situation calls for INSERT row. A new row is created without replacing the table's existing rows.

Incorrect Answers

A:

The other situation is better matched to Replace repeating product lists with atomic values represented in related rows. The schema avoids storing multiple logical values in a single relational cell.

C:

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 Create a stored procedure encapsulating the routine. The database can execute a named parameterized sequence of SQL operations.

Question 293

A supplier's street address has changed but its record identity must stay the same. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a SELECT statement projecting the required columns.
  2. Roll back the uncommitted transaction rather than committing its partial changes.
  3. Move attributes dependent on only part of the composite key to the correct entity table.
  4. Use UPDATE with a WHERE clause targeting the supplier key.

Explanation

Correct Answer

D:

The requirement concerns UPDATE row. Only the selected existing row's address fields are modified.

Incorrect Answers

A:

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

B:

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

C:

That action instead addresses Second normal form: Partial-key dependencies are reduced and updates become more consistent. It does not directly satisfy the described UPDATE row need.

Question 294

A data professional makes this decision: Use UPDATE with a WHERE clause targeting the supplier key. Which outcome is the most direct expected result?

  1. Only the selected existing row's address fields are modified.
  2. Partial-key dependencies are reduced and updates become more consistent.
  3. Related uncommitted changes are undone to preserve transaction consistency.
  4. The query reads selected fields and leaves stored rows unchanged.

Explanation

Correct Answer

A:

This is the expected outcome for UPDATE row: Only the selected existing row's address fields are modified.

Incorrect Answers

B:

This result would follow the different Second normal form decision (Move attributes dependent on only part of the composite key to the correct entity table.) rather than the specified design.

C:

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.

D:

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

Question 295

A supplier's street address has changed but its record identity must stay the same. Someone instead proposes: Roll back the uncommitted transaction rather than committing its partial changes. Which alternative is the best correction for the original requirement?

  1. Move attributes dependent on only part of the composite key to the correct entity table.
  2. Use UPDATE with a WHERE clause targeting the supplier key.
  3. Use a SELECT statement projecting the required columns.
  4. Roll back the uncommitted transaction rather than committing its partial changes.

Explanation

Correct Answer

B:

This correction addresses UPDATE row. Only the selected existing row's address fields are modified.

Incorrect Answers

A:

This choice is for Second normal form, not the specific requirement. Partial-key dependencies are reduced and updates become more consistent.

C:

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

D:

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

Question 296

A data architect recommends this approach: Use UPDATE with a WHERE clause targeting the supplier key. Which situation most clearly calls for that approach?

  1. A transaction updates inventory but later detects that payment authorization failed before commit.
  2. A query must retrieve a product name and list price without modifying the catalog.
  3. A supplier's street address has changed but its record identity must stay the same.
  4. A composite-key enrollment table repeats a student's name even though the name depends only on student ID.

Explanation

Correct Answer

C:

This situation calls for UPDATE row. Only the selected existing row's address fields are modified.

Incorrect Answers

A:

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.

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.

D:

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.

Question 297

A temporary table contains expired session rows that must be removed without clearing current sessions. Which data concept, Azure service, or design decision most directly satisfies the 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. Add a WHERE condition on invoice due date.

Explanation

Correct Answer

B:

The requirement concerns DELETE selected. Matching rows are removed while other records remain.

Incorrect Answers

A:

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 DELETE selected need.

C:

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

D:

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

Question 298

A data professional makes this decision: Use DELETE with a WHERE predicate matching expired sessions. Which outcome is the most direct expected result?

  1. Stored values can represent defined decimal precision for financial calculations.
  2. Non-key attributes are less likely to introduce transitive update anomalies.
  3. Matching rows are removed while other records remain.
  4. Rows not satisfying the filter are excluded before aggregation.

Explanation

Correct Answer

C:

This is the expected outcome for DELETE selected: Matching rows are removed while other records remain.

Incorrect Answers

A:

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.

B:

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.

D:

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

Question 299

A temporary table contains expired session rows that must be removed without clearing current sessions. Someone instead proposes: Use an appropriate fixed-precision decimal type for monetary columns. Which alternative is the best correction for the original requirement?

  1. Use an appropriate fixed-precision decimal type for monetary columns.
  2. Add a WHERE condition on invoice due date.
  3. Move the transitive lookup attributes into a separate reference table.
  4. Use DELETE with a WHERE predicate matching expired sessions.

Explanation

Correct Answer

D:

This correction addresses DELETE selected. Matching rows are removed while other records remain.

Incorrect Answers

A:

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

B:

This choice is for WHERE predicate, not the specific requirement. Rows not satisfying the filter are excluded before aggregation.

C:

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

Question 300

A data architect recommends this approach: Use DELETE with a WHERE predicate matching expired sessions. Which situation most clearly calls for that approach?

  1. A temporary table contains expired session rows that must be removed without clearing current sessions.
  2. A query must show only invoices whose due date is earlier than today.
  3. An order table repeats a shipping city description that depends on a postal code rather than the order key.
  4. A bank must store currency amounts precisely instead of introducing binary floating-point rounding errors.

Explanation

Correct Answer

A:

This situation calls for DELETE selected. Matching rows are removed while other records remain.

Incorrect Answers

B:

The other situation is better matched to Add a WHERE condition on invoice due date. Rows not satisfying the filter are excluded before aggregation.

C:

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.

D:

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.