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 28

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.

Question 271

A query must retrieve a product name and list price without modifying the catalog. Someone instead proposes: Use UPDATE with a WHERE clause targeting the supplier key. Which alternative is the best correction for the original requirement?

  1. Use a SELECT statement projecting the required columns.
  2. Move the transitive lookup attributes into a separate reference table.
  3. Use UPDATE with a WHERE clause targeting the supplier key.
  4. Roll back the uncommitted transaction rather than committing its partial changes.

Explanation

Correct Answer

A:

This correction addresses SELECT columns. The query reads selected fields and leaves stored rows unchanged.

Incorrect Answers

B:

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

C:

This choice is for UPDATE row, not the specific requirement. Only the selected existing row's address fields are modified.

D:

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

Question 272

A data architect recommends this approach: Use a SELECT statement projecting the required columns. 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. An order table repeats a shipping city description that depends on a postal code rather than the order key.

Explanation

Correct Answer

B:

This situation calls for SELECT columns. The query reads selected fields and leaves stored rows unchanged.

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.

C:

The other situation is better matched to Use UPDATE with a WHERE clause targeting the supplier key. Only the selected existing row's address fields are modified.

D:

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.

Question 273

A query must show only invoices whose due date is earlier than today. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use an appropriate fixed-precision decimal type for monetary columns.
  2. Use DELETE with a WHERE predicate matching expired sessions.
  3. Store customer contact data once and reference its key from order records.
  4. Add a WHERE condition on invoice due date.

Explanation

Correct Answer

D:

The requirement concerns WHERE predicate. Rows not satisfying the filter are excluded before aggregation.

Incorrect Answers

A:

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

B:

That action instead addresses DELETE selected: Matching rows are removed while other records remain. It does not directly satisfy the described WHERE predicate need.

C:

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 WHERE predicate need.

Question 274

A data professional makes this decision: Add a WHERE condition on invoice due date. Which outcome is the most direct expected result?

  1. Rows not satisfying the filter are excluded before aggregation.
  2. Stored values can represent defined decimal precision for financial calculations.
  3. The same contact detail no longer needs editing in every purchased item row.
  4. Matching rows are removed while other records remain.

Explanation

Correct Answer

A:

This is the expected outcome for WHERE predicate: Rows not satisfying the filter are excluded before aggregation.

Incorrect Answers

B:

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.

C:

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.

D:

This result would follow the different DELETE selected decision (Use DELETE with a WHERE predicate matching expired sessions.) rather than the specified design.

Question 275

A query must show only invoices whose due date is earlier than today. Someone instead proposes: Use DELETE with a WHERE predicate matching expired sessions. Which alternative is the best correction for the original requirement?

  1. Store customer contact data once and reference its key from order records.
  2. Add a WHERE condition on invoice due date.
  3. Use DELETE with a WHERE predicate matching expired sessions.
  4. Use an appropriate fixed-precision decimal type for monetary columns.

Explanation

Correct Answer

B:

This correction addresses WHERE predicate. Rows not satisfying the filter are excluded before aggregation.

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.

C:

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

D:

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

Question 276

A data architect recommends this approach: Add a WHERE condition on invoice due date. Which situation most clearly calls for that approach?

  1. A bank must store currency amounts precisely instead of introducing binary floating-point rounding errors.
  2. A temporary table contains expired session rows that must be removed without clearing current sessions.
  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

C:

This situation calls for WHERE predicate. Rows not satisfying the filter are excluded before aggregation.

Incorrect Answers

A:

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.

B:

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

D:

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 277

A supervisor wants the latest support ticket displayed first in a query result. 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. Use ORDER BY created_at DESC in the SELECT query.
  3. Execute CREATE TABLE with the required column definitions and constraints.
  4. Define a primary key on the employee identifier column.

Explanation

Correct Answer

B:

The requirement concerns ORDER BY. The result is sorted from newest to oldest timestamps.

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 ORDER BY 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 ORDER BY need.

D:

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 ORDER BY need.

Question 278

A data professional makes this decision: Use ORDER BY created_at DESC in the SELECT query. Which outcome is the most direct expected result?

  1. A many-to-many relationship is modeled with linking rows.
  2. Each employee row gains a unique non-null identifier for referencing records.
  3. The result is sorted from newest to oldest timestamps.
  4. A schema object exists to store rows subject to specified column types.

Explanation

Correct Answer

C:

This is the expected outcome for ORDER BY: The result is sorted from newest to oldest timestamps.

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 Primary key decision (Define a primary key on the employee identifier column.) rather than the specified design.

D:

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

Question 279

A supervisor wants the latest support ticket displayed first in a query result. Someone instead proposes: Execute CREATE TABLE with the required column definitions and constraints. Which alternative is the best correction for the original requirement?

  1. Create an enrollment junction table containing student and course foreign keys.
  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

D:

This correction addresses ORDER BY. The result is sorted from newest to oldest timestamps.

Incorrect Answers

A:

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

B:

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

C:

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

Question 280

A data architect recommends this approach: Use ORDER BY created_at DESC in the SELECT query. Which situation most clearly calls for that approach?

  1. A supervisor wants the latest support ticket displayed first in a query result.
  2. An employee database needs a stable value that uniquely identifies every row even when multiple people share a surname.
  3. Students can attend several courses, and each course has many enrolled students.
  4. A newly developed application requires a relational table with typed columns and a primary key.

Explanation

Correct Answer

A:

This situation calls for ORDER BY. The result is sorted from newest to oldest timestamps.

Incorrect Answers

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 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 Execute CREATE TABLE with the required column definitions and constraints. A schema object exists to store rows subject to specified column types.