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 23

Question 220

A data architect recommends this approach: Have the data analyst explore trends and present findings with appropriate visuals. Which situation most clearly calls for that approach?

  1. A production SQL service needs someone to configure backup policies and plan database restoration.
  2. A production database user has excessive permissions and unused privileged logins.
  3. A relational workload has slow queries because indexes and execution plans have not been evaluated.
  4. A marketing executive wants an explanation of why regional conversion rates changed across quarters.

Explanation

Correct Answer

D:

This situation calls for Analytical storytelling. Patterns in curated data are translated into actionable business context.

Incorrect Answers

A:

The other situation is better matched to Assign database protection and restore responsibilities to the database administrator. Database availability and recoverability become part of the DBA's managed duties.

B:

The other situation is better matched to Assign database account and permission administration to the DBA. Database access can be controlled under least-privilege operations.

C:

The other situation is better matched to Have a database administrator investigate SQL performance and indexing. The operational database can be tuned against its access patterns.

Question 221

Database storage growth and resource utilization are causing service-level alerts. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Have a data engineer manage schema changes in the ingestion and transformation process.
  2. Assign ingestion and transformation pipeline development to a data engineer.
  3. Have a data engineer develop cleaning and standardization rules in the pipeline.
  4. Have the DBA monitor database capacity and operational health.

Explanation

Correct Answer

D:

The requirement concerns Infrastructure capacity. Capacity issues can be identified and addressed before affecting workload availability.

Incorrect Answers

A:

That action instead addresses Schema evolution: Changes to upstream data are handled systematically for downstream consumers. It does not directly satisfy the described Infrastructure capacity need.

B:

That action instead addresses Pipeline author: Reusable data processing workflows populate the analytical platform. It does not directly satisfy the described Infrastructure capacity need.

C:

That action instead addresses Quality transformations: Curated datasets have more consistent meaning before reporting. It does not directly satisfy the described Infrastructure capacity need.

Question 222

A data professional makes this decision: Have the DBA monitor database capacity and operational health. Which outcome is the most direct expected result?

  1. Capacity issues can be identified and addressed before affecting workload availability.
  2. Changes to upstream data are handled systematically for downstream consumers.
  3. Reusable data processing workflows populate the analytical platform.
  4. Curated datasets have more consistent meaning before reporting.

Explanation

Correct Answer

A:

This is the expected outcome for Infrastructure capacity: Capacity issues can be identified and addressed before affecting workload availability.

Incorrect Answers

B:

This result would follow the different Schema evolution decision (Have a data engineer manage schema changes in the ingestion and transformation process.) rather than the specified design.

C:

This result would follow the different Pipeline author decision (Assign ingestion and transformation pipeline development to a data engineer.) rather than the specified design.

D:

This result would follow the different Quality transformations decision (Have a data engineer develop cleaning and standardization rules in the pipeline.) rather than the specified design.

Question 223

Database storage growth and resource utilization are causing service-level alerts. Someone instead proposes: Assign ingestion and transformation pipeline development to a data engineer. Which alternative is the best correction for the original requirement?

  1. Assign ingestion and transformation pipeline development to a data engineer.
  2. Have the DBA monitor database capacity and operational health.
  3. Have a data engineer manage schema changes in the ingestion and transformation process.
  4. Have a data engineer develop cleaning and standardization rules in the pipeline.

Explanation

Correct Answer

B:

This correction addresses Infrastructure capacity. Capacity issues can be identified and addressed before affecting workload availability.

Incorrect Answers

A:

This choice is for Pipeline author, not the specific requirement. Reusable data processing workflows populate the analytical platform.

C:

This choice is for Schema evolution, not the specific requirement. Changes to upstream data are handled systematically for downstream consumers.

D:

This choice is for Quality transformations, not the specific requirement. Curated datasets have more consistent meaning before reporting.

Question 224

A data architect recommends this approach: Have the DBA monitor database capacity and operational health. Which situation most clearly calls for that approach?

  1. A company needs scheduled ingestion pipelines that clean and combine data from several systems.
  2. Raw sales records contain inconsistent units and duplicated identifiers across feeds.
  3. Database storage growth and resource utilization are causing service-level alerts.
  4. A warehouse pipeline needs new source columns mapped without breaking downstream dashboards.

Explanation

Correct Answer

C:

This situation calls for Infrastructure capacity. Capacity issues can be identified and addressed before affecting workload availability.

Incorrect Answers

A:

The other situation is better matched to Assign ingestion and transformation pipeline development to a data engineer. Reusable data processing workflows populate the analytical platform.

B:

The other situation is better matched to Have a data engineer develop cleaning and standardization rules in the pipeline. Curated datasets have more consistent meaning before reporting.

D:

The other situation is better matched to Have a data engineer manage schema changes in the ingestion and transformation process. Changes to upstream data are handled systematically for downstream consumers.

Question 225

An employee database needs a stable value that uniquely identifies every row even when multiple people share a surname. 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. Add a WHERE condition on invoice due date.
  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

D:

The requirement concerns Primary key. Each employee row gains a unique non-null identifier for referencing records.

Incorrect Answers

A:

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 Primary key need.

B:

That action instead addresses WHERE predicate: Rows not satisfying the filter are excluded before aggregation. It does not directly satisfy the described Primary key 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 Primary key need.

Question 226

A data professional makes this decision: Define a primary key on the employee identifier column. Which outcome is the most direct expected result?

  1. Each employee row gains a unique non-null identifier for referencing records.
  2. Rows not satisfying the filter are excluded before aggregation.
  3. The same contact detail no longer needs editing in every purchased item row.
  4. A schema object exists to store rows subject to specified column types.

Explanation

Correct Answer

A:

This is the expected outcome for Primary key: Each employee row gains a unique non-null identifier for referencing records.

Incorrect Answers

B:

This result would follow the different WHERE predicate decision (Add a WHERE condition on invoice due date.) 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 CREATE TABLE decision (Execute CREATE TABLE with the required column definitions and constraints.) rather than the specified design.

Question 227

An employee database needs a stable value that uniquely identifies every row even when multiple people share a surname. Someone instead proposes: Store customer contact data once and reference its key from order records. 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. Add a WHERE condition on invoice due date.
  4. Execute CREATE TABLE with the required column definitions and constraints.

Explanation

Correct Answer

B:

This correction addresses Primary key. Each employee row gains a unique non-null identifier for referencing records.

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 WHERE predicate, not the specific requirement. Rows not satisfying the filter are excluded before aggregation.

D:

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

Question 228

A data architect recommends this approach: Define a primary key on the employee identifier column. Which situation most clearly calls for that approach?

  1. A shop repeats a customer's phone number on every line-item row, causing inconsistent updates.
  2. A newly developed application requires a relational table with typed columns and a primary key.
  3. An employee database needs a stable value that uniquely identifies every row even when multiple people share a surname.
  4. A query must show only invoices whose due date is earlier than today.

Explanation

Correct Answer

C:

This situation calls for Primary key. Each employee row gains a unique non-null identifier for referencing records.

Incorrect Answers

A:

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.

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 Add a WHERE condition on invoice due date. Rows not satisfying the filter are excluded before aggregation.

Question 229

An order record must refer only to a customer identifier that exists in the customer table. Which data concept, Azure service, or design decision most directly satisfies the 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. Create a database view for the approved SELECT projection.
  4. Use ORDER BY created_at DESC in the SELECT query.

Explanation

Correct Answer

A:

The requirement concerns Foreign key. The relationship can enforce referential integrity between child and parent rows.

Incorrect Answers

B:

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

C:

That action instead addresses View abstraction: Consumers can query a named logical representation of the data. It does not directly satisfy the described Foreign key need.

D:

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

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.