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 31

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.

Question 301

A newly developed application requires a relational table with typed columns and a primary key. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Execute CREATE TABLE with the required column definitions and constraints.
  2. Store customer contact data once and reference its key from order records.
  3. Define a primary key on the employee identifier column.
  4. Use ORDER BY created_at DESC in the SELECT query.

Explanation

Correct Answer

A:

The requirement concerns CREATE TABLE. A schema object exists to store rows subject to specified column types.

Incorrect Answers

B:

That action instead addresses Normalize duplicate contacts: The same contact detail no longer needs editing in every purchased item row. It does not directly satisfy the described CREATE TABLE 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 CREATE TABLE need.

D:

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

Question 302

A data professional makes this decision: Execute CREATE TABLE with the required column definitions and constraints. Which outcome is the most direct expected result?

  1. The same contact detail no longer needs editing in every purchased item row.
  2. A schema object exists to store rows subject to specified column types.
  3. Each employee row gains a unique non-null identifier for referencing records.
  4. The result is sorted from newest to oldest timestamps.

Explanation

Correct Answer

B:

This is the expected outcome for CREATE TABLE: A schema object exists to store rows subject to specified column types.

Incorrect Answers

A:

This result would follow the different Normalize duplicate contacts decision (Store customer contact data once and reference its key from order records.) rather than the specified design.

C:

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

D:

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

Question 303

A newly developed application requires a relational table with typed columns and a primary key. Someone instead proposes: Define a primary key on the employee identifier column. Which alternative is the best correction for the original requirement?

  1. Store customer contact data once and reference its key from order records.
  2. Define a primary key on the employee identifier column.
  3. Execute CREATE TABLE with the required column definitions and constraints.
  4. Use ORDER BY created_at DESC in the SELECT query.

Explanation

Correct Answer

C:

This correction addresses CREATE TABLE. A schema object exists to store rows subject to specified column types.

Incorrect Answers

A:

This choice is for Normalize duplicate contacts, not the specific requirement. The same contact detail no longer needs editing in every purchased item row.

B:

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

D:

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

Question 304

A data architect recommends this approach: Execute CREATE TABLE with the required column definitions and constraints. Which situation most clearly calls for that approach?

  1. An employee database needs a stable value that uniquely identifies every row even when multiple people share a surname.
  2. A supervisor wants the latest support ticket displayed first in a query result.
  3. A shop repeats a customer's phone number on every line-item row, causing inconsistent updates.
  4. A newly developed application requires a relational table with typed columns and a primary key.

Explanation

Correct Answer

D:

This situation calls for CREATE TABLE. A schema object exists to store rows subject to specified column types.

Incorrect Answers

A:

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.

B:

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.

C:

The other situation is better matched to Store customer contact data once and reference its key from order records. The same contact detail no longer needs editing in every purchased item row.

Question 305

Multiple analysts need a saved query that exposes only approved fields from several underlying tables. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Create an enrollment junction table containing student and course foreign keys.
  2. Create a database view for the approved SELECT projection.
  3. Create a foreign key from orders to the referenced customer primary key.
  4. Use GROUP BY department with SUM(amount).

Explanation

Correct Answer

B:

The requirement concerns View abstraction. Consumers can query a named logical representation of the data.

Incorrect Answers

A:

That action instead addresses Junction table: A many-to-many relationship is modeled with linking rows. It does not directly satisfy the described View abstraction need.

C:

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

D:

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

Question 306

A data professional makes this decision: Create a database view for the approved SELECT projection. Which outcome is the most direct expected result?

  1. A many-to-many relationship is modeled with linking rows.
  2. Input rows are aggregated into departmental totals.
  3. Consumers can query a named logical representation of the data.
  4. The relationship can enforce referential integrity between child and parent rows.

Explanation

Correct Answer

C:

This is the expected outcome for View abstraction: Consumers can query a named logical representation of the data.

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.

B:

This result would follow the different GROUP BY decision (Use GROUP BY department with SUM(amount).) 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 307

Multiple analysts need a saved query that exposes only approved fields from several underlying tables. Someone instead proposes: Create a foreign key from orders to the referenced customer primary key. Which alternative is the best correction for the original requirement?

  1. Use GROUP BY department with SUM(amount).
  2. Create a foreign key from orders to the referenced customer primary key.
  3. Create an enrollment junction table containing student and course foreign keys.
  4. Create a database view for the approved SELECT projection.

Explanation

Correct Answer

D:

This correction addresses View abstraction. Consumers can query a named logical representation of the data.

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 Foreign key, not the specific requirement. The relationship can enforce referential integrity between child and parent rows.

C:

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

Question 308

A data architect recommends this approach: Create a database view for the approved SELECT projection. Which situation most clearly calls for that approach?

  1. Multiple analysts need a saved query that exposes only approved fields from several underlying tables.
  2. An order record must refer only to a customer identifier that exists in the customer table.
  3. Students can attend several courses, and each course has many enrolled students.
  4. A finance analyst needs the total invoiced amount summarized separately for each department.

Explanation

Correct Answer

A:

This situation calls for View abstraction. Consumers can query a named logical representation of the data.

Incorrect Answers

B:

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.

C:

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.

D:

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

Question 309

A frequently used customer search filters on account number but performs full table scans. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Create an appropriate index on the account-number lookup column.
  2. Use HAVING to filter groups by the aggregate expense.
  3. Add a unique constraint on the login email column.
  4. Relate the benefits row to the employee through a unique foreign key.

Explanation

Correct Answer

A:

The requirement concerns Index search. The database can locate matching values more efficiently at a storage and write cost.

Incorrect Answers

B:

That action instead addresses HAVING filter: Groups below the total threshold are removed after aggregation. It does not directly satisfy the described Index search 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 Index search need.

D:

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 Index search need.

Question 310

A data professional makes this decision: Create an appropriate index on the account-number lookup column. Which outcome is the most direct expected result?

  1. The optional profile can remain separate while retaining a one-to-one association.
  2. The database can locate matching values more efficiently at a storage and write cost.
  3. Groups below the total threshold are removed after aggregation.
  4. Duplicate email values are prevented while the primary key remains independent.

Explanation

Correct Answer

B:

This is the expected outcome for Index search: The database can locate matching values more efficiently at a storage and write cost.

Incorrect Answers

A:

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.

C:

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 Unique constraint decision (Add a unique constraint on the login email column.) rather than the specified design.