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 24

Question 230

A data professional makes this decision: Create a foreign key from orders to the referenced customer primary key. Which outcome is the most direct expected result?

  1. A many-to-many relationship is modeled with linking rows.
  2. The relationship can enforce referential integrity between child and parent rows.
  3. The result is sorted from newest to oldest timestamps.
  4. Consumers can query a named logical representation of the data.

Explanation

Correct Answer

B:

This is the expected outcome for Foreign key: The relationship can enforce referential integrity between child and parent rows.

Incorrect Answers

A:

This result would follow the different Junction table decision (Create an enrollment junction table containing student and course foreign keys.) rather than the specified design.

C:

This result would follow the different ORDER BY decision (Use ORDER BY created_at DESC in the SELECT query.) rather than the specified design.

D:

This result would follow the different View abstraction decision (Create a database view for the approved SELECT projection.) rather than the specified design.

Question 231

An order record must refer only to a customer identifier that exists in the customer table. Someone instead proposes: Create an enrollment junction table containing student and course foreign keys. Which alternative is the best correction for the original requirement?

  1. Create a database view for the approved SELECT projection.
  2. Use ORDER BY created_at DESC in the SELECT query.
  3. Create a foreign key from orders to the referenced customer primary key.
  4. Create an enrollment junction table containing student and course foreign keys.

Explanation

Correct Answer

C:

This correction addresses Foreign key. The relationship can enforce referential integrity between child and parent rows.

Incorrect Answers

A:

This choice is for View abstraction, not the specific requirement. Consumers can query a named logical representation of the data.

B:

This choice is for ORDER BY, not the specific requirement. The result is sorted from newest to oldest timestamps.

D:

This choice is for Junction table, not the specific requirement. A many-to-many relationship is modeled with linking rows.

Question 232

A data architect recommends this approach: Create a foreign key from orders to the referenced customer primary key. Which situation most clearly calls for that approach?

  1. A supervisor wants the latest support ticket displayed first in a query result.
  2. Students can attend several courses, and each course has many enrolled students.
  3. Multiple analysts need a saved query that exposes only approved fields from several underlying tables.
  4. An order record must refer only to a customer identifier that exists in the customer table.

Explanation

Correct Answer

D:

This situation calls for Foreign key. The relationship can enforce referential integrity between child and parent rows.

Incorrect Answers

A:

The other situation is better matched to Use ORDER BY created_at DESC in the SELECT query. The result is sorted from newest to oldest timestamps.

B:

The other situation is better matched to Create an enrollment junction table containing student and course foreign keys. A many-to-many relationship is modeled with linking rows.

C:

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.

Question 233

An account table permits separate account IDs but must reject two rows using the same login email. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use GROUP BY department with SUM(amount).
  2. Relate the benefits row to the employee through a unique foreign key.
  3. Create an appropriate index on the account-number lookup column.
  4. Add a unique constraint on the login email column.

Explanation

Correct Answer

D:

The requirement concerns Unique constraint. Duplicate email values are prevented while the primary key remains independent.

Incorrect Answers

A:

That action instead addresses GROUP BY: Input rows are aggregated into departmental totals. It does not directly satisfy the described Unique constraint need.

B:

That action instead addresses One-to-one relation: The optional profile can remain separate while retaining a one-to-one association. It does not directly satisfy the described Unique constraint 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 Unique constraint need.

Question 234

A data professional makes this decision: Add a unique constraint on the login email column. Which outcome is the most direct expected result?

  1. Duplicate email values are prevented while the primary key remains independent.
  2. Input rows are aggregated into departmental totals.
  3. The optional profile can remain separate while retaining a one-to-one association.
  4. The database can locate matching values more efficiently at a storage and write cost.

Explanation

Correct Answer

A:

This is the expected outcome for Unique constraint: Duplicate email values are prevented while the primary key remains independent.

Incorrect Answers

B:

This result would follow the different GROUP BY decision (Use GROUP BY department with SUM(amount).) rather than the specified design.

C:

This result would follow the different One-to-one relation decision (Relate the benefits row to the employee through a unique foreign key.) 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 235

An account table permits separate account IDs but must reject two rows using the same login email. Someone instead proposes: Relate the benefits row to the employee through a unique foreign key. Which alternative is the best correction for the original requirement?

  1. Use GROUP BY department with SUM(amount).
  2. Add a unique constraint on the login email column.
  3. Relate the benefits row to the employee through a unique foreign key.
  4. Create an appropriate index on the account-number lookup column.

Explanation

Correct Answer

B:

This correction addresses Unique constraint. Duplicate email values are prevented while the primary key remains independent.

Incorrect Answers

A:

This choice is for GROUP BY, not the specific requirement. Input rows are aggregated into departmental totals.

C:

This choice is for One-to-one relation, not the specific requirement. The optional profile can remain separate while retaining a one-to-one association.

D:

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

Question 236

A data architect recommends this approach: Add a unique constraint on the login email column. Which situation most clearly calls for that approach?

  1. Each employee has at most one separate confidential benefits profile requiring access restrictions.
  2. A finance analyst needs the total invoiced amount summarized separately for each department.
  3. An account table permits separate account IDs but must reject two rows using the same login email.
  4. A frequently used customer search filters on account number but performs full table scans.

Explanation

Correct Answer

C:

This situation calls for Unique constraint. Duplicate email values are prevented while the primary key remains independent.

Incorrect Answers

A:

The other situation is better matched to Relate the benefits row to the employee through a unique foreign key. The optional profile can remain separate while retaining a one-to-one association.

B:

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 Create an appropriate index on the account-number lookup column. The database can locate matching values more efficiently at a storage and write cost.

Question 237

A column contains a comma-separated list of all product IDs purchased in an order and makes queries awkward. 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 a stored procedure encapsulating the routine.
  4. Replace repeating product lists with atomic values represented in related rows.

Explanation

Correct Answer

D:

The requirement concerns First normal form. The schema avoids storing multiple logical values in a single relational cell.

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 First normal form need.

B:

That action instead addresses INNER JOIN: Only matching combinations of rows appear in the result. It does not directly satisfy the described First normal form 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 First normal form need.

Question 238

A data professional makes this decision: Replace repeating product lists with atomic values represented in related rows. 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. The database can execute a named parameterized sequence of SQL operations.
  4. Only matching combinations of rows appear in the result.

Explanation

Correct Answer

A:

This is the expected outcome for First normal form: The schema avoids storing multiple logical values in a single relational cell.

Incorrect Answers

B:

This result would follow the different HAVING filter decision (Use HAVING to filter groups by the aggregate expense.) 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.

D:

This result would follow the different INNER JOIN decision (Use an INNER JOIN between orders and customers on their keys.) rather than the specified design.

Question 239

A column contains a comma-separated list of all product IDs purchased in an order and makes queries awkward. Someone instead proposes: Use an INNER JOIN between orders and customers on their keys. Which alternative is the best correction for the original requirement?

  1. Use HAVING to filter groups by the aggregate expense.
  2. Replace repeating product lists with atomic values represented in related rows.
  3. Create a stored procedure encapsulating the routine.
  4. Use an INNER JOIN between orders and customers on their keys.

Explanation

Correct Answer

B:

This correction addresses First normal form. The schema avoids storing multiple logical values in a single relational cell.

Incorrect Answers

A:

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

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 INNER JOIN, not the specific requirement. Only matching combinations of rows appear in the result.

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.