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 27

Question 260

A data architect recommends this approach: Relate the benefits row to the employee through a unique foreign key. Which situation most clearly calls for that approach?

  1. Each employee has at most one separate confidential benefits profile requiring access restrictions.
  2. Multiple analysts need a saved query that exposes only approved fields from several underlying tables.
  3. A finance analyst needs the total invoiced amount summarized separately for each department.
  4. An account table permits separate account IDs but must reject two rows using the same login email.

Explanation

Correct Answer

A:

This situation calls for One-to-one relation. The optional profile can remain separate while retaining a one-to-one association.

Incorrect Answers

B:

The other situation is better matched to Create a database view for the approved SELECT projection. Consumers can query a named logical representation of the data.

C:

The other situation is better matched to Use GROUP BY department with SUM(amount). Input rows are aggregated into departmental totals.

D:

The other situation is better matched to Add a unique constraint on the login email column. Duplicate email values are prevented while the primary key remains independent.

Question 261

A report must list only orders that have a matching approved customer record. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use HAVING to filter groups by the aggregate expense.
  2. Use an INNER JOIN between orders and customers on their keys.
  3. Create an appropriate index on the account-number lookup column.
  4. Replace repeating product lists with atomic values represented in related rows.

Explanation

Correct Answer

B:

The requirement concerns INNER JOIN. Only matching combinations of rows appear in the result.

Incorrect Answers

A:

That action instead addresses HAVING filter: Groups below the total threshold are removed after aggregation. It does not directly satisfy the described INNER JOIN need.

C:

That action instead addresses Index search: The database can locate matching values more efficiently at a storage and write cost. It does not directly satisfy the described INNER JOIN need.

D:

That action instead addresses First normal form: The schema avoids storing multiple logical values in a single relational cell. It does not directly satisfy the described INNER JOIN need.

Question 262

A data professional makes this decision: Use an INNER JOIN between orders and customers on their keys. Which outcome is the most direct expected result?

  1. The schema avoids storing multiple logical values in a single relational cell.
  2. Groups below the total threshold are removed after aggregation.
  3. Only matching combinations of rows appear in the result.
  4. The database can locate matching values more efficiently at a storage and write cost.

Explanation

Correct Answer

C:

This is the expected outcome for INNER JOIN: Only matching combinations of rows appear in the result.

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 HAVING filter decision (Use HAVING to filter groups by the aggregate expense.) rather than the specified design.

D:

This result would follow the different Index search decision (Create an appropriate index on the account-number lookup column.) rather than the specified design.

Question 263

A report must list only orders that have a matching approved customer record. Someone instead proposes: Use HAVING to filter groups by the aggregate expense. Which alternative is the best correction for the original requirement?

  1. Create an appropriate index on the account-number lookup column.
  2. Use HAVING to filter groups by the aggregate expense.
  3. Replace repeating product lists with atomic values represented in related rows.
  4. Use an INNER JOIN between orders and customers on their keys.

Explanation

Correct Answer

D:

This correction addresses INNER JOIN. Only matching combinations of rows appear in the result.

Incorrect Answers

A:

This choice is for Index search, not the specific requirement. The database can locate matching values more efficiently at a storage and write cost.

B:

This choice is for HAVING filter, not the specific requirement. Groups below the total threshold are removed after aggregation.

C:

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

Question 264

A data architect recommends this approach: Use an INNER JOIN between orders and customers on their keys. Which situation most clearly calls for that approach?

  1. A report must list only orders that have a matching approved customer record.
  2. A frequently used customer search filters on account number but performs full table scans.
  3. A column contains a comma-separated list of all product IDs purchased in an order and makes queries awkward.
  4. A report must display only departments whose summed annual expense exceeds a threshold.

Explanation

Correct Answer

A:

This situation calls for INNER JOIN. Only matching combinations of rows appear in the result.

Incorrect Answers

B:

The other situation is better matched to Create an appropriate index on the account-number lookup column. The database can locate matching values more efficiently at a storage and write cost.

C:

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.

D:

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.

Question 265

A sales review must list every customer including those who have not yet placed an order. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a LEFT OUTER JOIN from customers to orders.
  2. Move attributes dependent on only part of the composite key to the correct entity table.
  3. Create a stored procedure encapsulating the routine.
  4. Use an INSERT statement specifying the new product values.

Explanation

Correct Answer

A:

The requirement concerns LEFT JOIN. Unmatched customers remain in the output with null columns for orders.

Incorrect Answers

B:

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

C:

That action instead addresses Stored procedure: The database can execute a named parameterized sequence of SQL operations. It does not directly satisfy the described LEFT JOIN need.

D:

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 LEFT JOIN need.

Question 266

A data professional makes this decision: Use a LEFT OUTER JOIN from customers to orders. Which outcome is the most direct expected result?

  1. The database can execute a named parameterized sequence of SQL operations.
  2. Unmatched customers remain in the output with null columns for orders.
  3. Partial-key dependencies are reduced and updates become more consistent.
  4. A new row is created without replacing the table's existing rows.

Explanation

Correct Answer

B:

This is the expected outcome for LEFT JOIN: Unmatched customers remain in the output with null columns for orders.

Incorrect Answers

A:

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

C:

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.

D:

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

Question 267

A sales review must list every customer including those who have not yet placed an order. Someone instead proposes: Use an INSERT statement specifying the new product values. 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 an INSERT statement specifying the new product values.
  3. Use a LEFT OUTER JOIN from customers to orders.
  4. Create a stored procedure encapsulating the routine.

Explanation

Correct Answer

C:

This correction addresses LEFT JOIN. Unmatched customers remain in the output with null columns for orders.

Incorrect Answers

A:

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

B:

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

D:

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

Question 268

A data architect recommends this approach: Use a LEFT OUTER JOIN from customers to orders. Which situation most clearly calls for that approach?

  1. An app needs to run a reusable parameterized SQL routine for a repeatable business operation.
  2. A new product with a valid identifier and price must be added to an existing table.
  3. A composite-key enrollment table repeats a student's name even though the name depends only on student ID.
  4. A sales review must list every customer including those who have not yet placed an order.

Explanation

Correct Answer

D:

This situation calls for LEFT JOIN. Unmatched customers remain in the output with null columns for orders.

Incorrect Answers

A:

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.

B:

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.

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.

Question 269

A query must retrieve a product name and list price without modifying the catalog. 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. Roll back the uncommitted transaction rather than committing its partial changes.
  3. Use a SELECT statement projecting the required columns.
  4. Move the transitive lookup attributes into a separate reference table.

Explanation

Correct Answer

C:

The requirement concerns SELECT columns. The query reads selected fields and leaves stored rows unchanged.

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 SELECT columns need.

B:

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

D:

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 SELECT columns need.

Question 270

A data professional makes this decision: Use a SELECT statement projecting the required columns. Which outcome is the most direct expected result?

  1. Non-key attributes are less likely to introduce transitive update anomalies.
  2. Related uncommitted changes are undone to preserve transaction consistency.
  3. Only the selected existing row's address fields are modified.
  4. The query reads selected fields and leaves stored rows unchanged.

Explanation

Correct Answer

D:

This is the expected outcome for SELECT columns: The query reads selected fields and leaves stored rows unchanged.

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.

B:

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.

C:

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