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 26

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.

Question 251

A shop repeats a customer's phone number on every line-item row, causing inconsistent updates. Someone instead proposes: Add a WHERE condition on invoice due date. Which alternative is the best correction for the original requirement?

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

Explanation

Correct Answer

C:

This correction addresses Normalize duplicate contacts. The same contact detail no longer needs editing in every purchased item row.

Incorrect Answers

A:

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

B:

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

D:

This choice is for Primary key, not the specific requirement. Each employee row gains a unique non-null identifier for referencing records.

Question 252

A data architect recommends this approach: Store customer contact data once and reference its key from order records. 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. An employee database needs a stable value that uniquely identifies every row even when multiple people share a surname.
  3. A query must show only invoices whose due date is earlier than today.
  4. A shop repeats a customer's phone number on every line-item row, causing inconsistent updates.

Explanation

Correct Answer

D:

This situation calls for Normalize duplicate contacts. The same contact detail no longer needs editing in every purchased item row.

Incorrect Answers

A:

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

B:

The other situation is better matched to Define a primary key on the employee identifier column. Each employee row gains a unique non-null identifier for referencing records.

C:

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

Question 253

Students can attend several courses, and each course has many enrolled students. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use ORDER BY created_at DESC in the SELECT query.
  2. Create a foreign key from orders to the referenced customer primary key.
  3. Execute CREATE TABLE with the required column definitions and constraints.
  4. Create an enrollment junction table containing student and course foreign keys.

Explanation

Correct Answer

D:

The requirement concerns Junction table. A many-to-many relationship is modeled with linking rows.

Incorrect Answers

A:

That action instead addresses ORDER BY: The result is sorted from newest to oldest timestamps. It does not directly satisfy the described Junction table need.

B:

That action instead addresses Foreign key: The relationship can enforce referential integrity between child and parent rows. It does not directly satisfy the described Junction table need.

C:

That action instead addresses CREATE TABLE: A schema object exists to store rows subject to specified column types. It does not directly satisfy the described Junction table need.

Question 254

A data professional makes this decision: Create an enrollment junction table containing student and course foreign keys. Which outcome is the most direct expected result?

  1. A many-to-many relationship is modeled with linking rows.
  2. The result is sorted from newest to oldest timestamps.
  3. A schema object exists to store rows subject to specified column types.
  4. The relationship can enforce referential integrity between child and parent rows.

Explanation

Correct Answer

A:

This is the expected outcome for Junction table: A many-to-many relationship is modeled with linking rows.

Incorrect Answers

B:

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

C:

This result would follow the different CREATE TABLE decision (Execute CREATE TABLE with the required column definitions and constraints.) rather than the specified design.

D:

This result would follow the different Foreign key decision (Create a foreign key from orders to the referenced customer primary key.) rather than the specified design.

Question 255

Students can attend several courses, and each course has many enrolled students. Someone instead proposes: Use ORDER BY created_at DESC in the SELECT query. Which alternative is the best correction for the original requirement?

  1. Create a foreign key from orders to the referenced customer primary key.
  2. Create an enrollment junction table containing student and course foreign keys.
  3. Use ORDER BY created_at DESC in the SELECT query.
  4. Execute CREATE TABLE with the required column definitions and constraints.

Explanation

Correct Answer

B:

This correction addresses Junction table. A many-to-many relationship is modeled with linking rows.

Incorrect Answers

A:

This choice is for Foreign key, not the specific requirement. The relationship can enforce referential integrity between child and parent rows.

C:

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

D:

This choice is for CREATE TABLE, not the specific requirement. A schema object exists to store rows subject to specified column types.

Question 256

A data architect recommends this approach: Create an enrollment junction table containing student and course foreign keys. Which situation most clearly calls for that approach?

  1. A supervisor wants the latest support ticket displayed first in a query result.
  2. A newly developed application requires a relational table with typed columns and a primary key.
  3. Students can attend several courses, and each course has many enrolled students.
  4. An order record must refer only to a customer identifier that exists in the customer table.

Explanation

Correct Answer

C:

This situation calls for Junction table. A many-to-many relationship is modeled with linking 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 Execute CREATE TABLE with the required column definitions and constraints. A schema object exists to store rows subject to specified column types.

D:

The other situation is better matched to Create a foreign key from orders to the referenced customer primary key. The relationship can enforce referential integrity between child and parent rows.

Question 257

Each employee has at most one separate confidential benefits profile requiring access restrictions. 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. Add a unique constraint on the login email column.
  4. Create a database view for the approved SELECT projection.

Explanation

Correct Answer

B:

The requirement concerns One-to-one relation. The optional profile can remain separate while retaining a one-to-one association.

Incorrect Answers

A:

That action instead addresses GROUP BY: Input rows are aggregated into departmental totals. It does not directly satisfy the described One-to-one relation need.

C:

That action instead addresses Unique constraint: Duplicate email values are prevented while the primary key remains independent. It does not directly satisfy the described One-to-one relation need.

D:

That action instead addresses View abstraction: Consumers can query a named logical representation of the data. It does not directly satisfy the described One-to-one relation need.

Question 258

A data professional makes this decision: Relate the benefits row to the employee through a unique foreign key. Which outcome is the most direct expected result?

  1. Input rows are aggregated into departmental totals.
  2. Duplicate email values are prevented while the primary key remains independent.
  3. The optional profile can remain separate while retaining a one-to-one association.
  4. Consumers can query a named logical representation of the data.

Explanation

Correct Answer

C:

This is the expected outcome for One-to-one relation: The optional profile can remain separate while retaining a one-to-one association.

Incorrect Answers

A:

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

B:

This result would follow the different Unique constraint decision (Add a unique constraint on the login email column.) 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 259

Each employee has at most one separate confidential benefits profile requiring access restrictions. Someone instead proposes: Use GROUP BY department with SUM(amount). 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. Create a database view for the approved SELECT projection.
  4. Relate the benefits row to the employee through a unique foreign key.

Explanation

Correct Answer

D:

This correction addresses One-to-one relation. The optional profile can remain separate while retaining a one-to-one association.

Incorrect Answers

A:

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

B:

This choice is for Unique constraint, not the specific requirement. Duplicate email values are prevented while the primary key remains independent.

C:

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

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.