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 21

Question 200

A data architect recommends this approach: Have a database administrator investigate SQL performance and indexing. Which situation most clearly calls for that approach?

  1. A company needs scheduled ingestion pipelines that clean and combine data from several systems.
  2. Two departments calculate gross margin differently despite reading identical source data.
  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

C:

This situation calls for Query tuning. The operational database can be tuned against its access patterns.

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 analyst work with stakeholders to define the business measure consistently. Reports share a documented metric interpretation rather than conflicting figures.

D:

The other situation is better matched to Have the data analyst explore trends and present findings with appropriate visuals. Patterns in curated data are translated into actionable business context.

Question 201

Raw sales records contain inconsistent units and duplicated identifiers across feeds. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Have the DBA monitor database capacity and operational health.
  2. Assign report and insight creation to a data analyst.
  3. Assign database account and permission administration to the DBA.
  4. Have a data engineer develop cleaning and standardization rules in the pipeline.

Explanation

Correct Answer

D:

The requirement concerns Quality transformations. Curated datasets have more consistent meaning before reporting.

Incorrect Answers

A:

That action instead addresses Infrastructure capacity: Capacity issues can be identified and addressed before affecting workload availability. It does not directly satisfy the described Quality transformations need.

B:

That action instead addresses Report designer: Business stakeholders receive visual interpretations of the prepared data. It does not directly satisfy the described Quality transformations need.

C:

That action instead addresses Access maintenance: Database access can be controlled under least-privilege operations. It does not directly satisfy the described Quality transformations need.

Question 202

A data professional makes this decision: Have a data engineer develop cleaning and standardization rules in the pipeline. Which outcome is the most direct expected result?

  1. Curated datasets have more consistent meaning before reporting.
  2. Database access can be controlled under least-privilege operations.
  3. Capacity issues can be identified and addressed before affecting workload availability.
  4. Business stakeholders receive visual interpretations of the prepared data.

Explanation

Correct Answer

A:

This is the expected outcome for Quality transformations: Curated datasets have more consistent meaning before reporting.

Incorrect Answers

B:

This result would follow the different Access maintenance decision (Assign database account and permission administration to the DBA.) rather than the specified design.

C:

This result would follow the different Infrastructure capacity decision (Have the DBA monitor database capacity and operational health.) rather than the specified design.

D:

This result would follow the different Report designer decision (Assign report and insight creation to a data analyst.) rather than the specified design.

Question 203

Raw sales records contain inconsistent units and duplicated identifiers across feeds. Someone instead proposes: Assign database account and permission administration to the DBA. Which alternative is the best correction for the original requirement?

  1. Assign report and insight creation to a data analyst.
  2. Have a data engineer develop cleaning and standardization rules in the pipeline.
  3. Have the DBA monitor database capacity and operational health.
  4. Assign database account and permission administration to the DBA.

Explanation

Correct Answer

B:

This correction addresses Quality transformations. Curated datasets have more consistent meaning before reporting.

Incorrect Answers

A:

This choice is for Report designer, not the specific requirement. Business stakeholders receive visual interpretations of the prepared data.

C:

This choice is for Infrastructure capacity, not the specific requirement. Capacity issues can be identified and addressed before affecting workload availability.

D:

This choice is for Access maintenance, not the specific requirement. Database access can be controlled under least-privilege operations.

Question 204

A data architect recommends this approach: Have a data engineer develop cleaning and standardization rules in the pipeline. Which situation most clearly calls for that approach?

  1. Executives need interactive KPI reports and suitable charts built from curated datasets.
  2. A production database user has excessive permissions and unused privileged logins.
  3. Raw sales records contain inconsistent units and duplicated identifiers across feeds.
  4. Database storage growth and resource utilization are causing service-level alerts.

Explanation

Correct Answer

C:

This situation calls for Quality transformations. Curated datasets have more consistent meaning before reporting.

Incorrect Answers

A:

The other situation is better matched to Assign report and insight creation to a data analyst. Business stakeholders receive visual interpretations of the prepared data.

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.

D:

The other situation is better matched to Have the DBA monitor database capacity and operational health. Capacity issues can be identified and addressed before affecting workload availability.

Question 205

Two departments calculate gross margin differently despite reading identical source data. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Have a database administrator investigate SQL performance and indexing.
  2. Have a data engineer manage schema changes in the ingestion and transformation process.
  3. Assign database protection and restore responsibilities to the database administrator.
  4. Have a data analyst work with stakeholders to define the business measure consistently.

Explanation

Correct Answer

D:

The requirement concerns Metric definition. Reports share a documented metric interpretation rather than conflicting figures.

Incorrect Answers

A:

That action instead addresses Query tuning: The operational database can be tuned against its access patterns. It does not directly satisfy the described Metric definition need.

B:

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

C:

That action instead addresses Database backup ownership: Database availability and recoverability become part of the DBA's managed duties. It does not directly satisfy the described Metric definition need.

Question 206

A data professional makes this decision: Have a data analyst work with stakeholders to define the business measure consistently. Which outcome is the most direct expected result?

  1. Reports share a documented metric interpretation rather than conflicting figures.
  2. Database availability and recoverability become part of the DBA's managed duties.
  3. The operational database can be tuned against its access patterns.
  4. Changes to upstream data are handled systematically for downstream consumers.

Explanation

Correct Answer

A:

This is the expected outcome for Metric definition: Reports share a documented metric interpretation rather than conflicting figures.

Incorrect Answers

B:

This result would follow the different Database backup ownership decision (Assign database protection and restore responsibilities to the database administrator.) rather than the specified design.

C:

This result would follow the different Query tuning decision (Have a database administrator investigate SQL performance and indexing.) rather than the specified design.

D:

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.

Question 207

Two departments calculate gross margin differently despite reading identical source data. Someone instead proposes: Have a data engineer manage schema changes in the ingestion and transformation process. Which alternative is the best correction for the original requirement?

  1. Assign database protection and restore responsibilities to the database administrator.
  2. Have a data analyst work with stakeholders to define the business measure consistently.
  3. Have a data engineer manage schema changes in the ingestion and transformation process.
  4. Have a database administrator investigate SQL performance and indexing.

Explanation

Correct Answer

B:

This correction addresses Metric definition. Reports share a documented metric interpretation rather than conflicting figures.

Incorrect Answers

A:

This choice is for Database backup ownership, not the specific requirement. Database availability and recoverability become part of the DBA's managed duties.

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 Query tuning, not the specific requirement. The operational database can be tuned against its access patterns.

Question 208

A data architect recommends this approach: Have a data analyst work with stakeholders to define the business measure consistently. 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 warehouse pipeline needs new source columns mapped without breaking downstream dashboards.
  3. Two departments calculate gross margin differently despite reading identical source data.
  4. A relational workload has slow queries because indexes and execution plans have not been evaluated.

Explanation

Correct Answer

C:

This situation calls for Metric definition. Reports share a documented metric interpretation rather than conflicting figures.

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 Have a data engineer manage schema changes in the ingestion and transformation process. Changes to upstream data are handled systematically for downstream consumers.

D:

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 209

A production database user has excessive permissions and unused privileged logins. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Assign ingestion and transformation pipeline development to a data engineer.
  2. Have the data analyst explore trends and present findings with appropriate visuals.
  3. Have a data engineer develop cleaning and standardization rules in the pipeline.
  4. Assign database account and permission administration to the DBA.

Explanation

Correct Answer

D:

The requirement concerns Access maintenance. Database access can be controlled under least-privilege operations.

Incorrect Answers

A:

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

B:

That action instead addresses Analytical storytelling: Patterns in curated data are translated into actionable business context. It does not directly satisfy the described Access maintenance need.

C:

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

Question 210

A data professional makes this decision: Assign database account and permission administration to the DBA. Which outcome is the most direct expected result?

  1. Database access can be controlled under least-privilege operations.
  2. Reusable data processing workflows populate the analytical platform.
  3. Patterns in curated data are translated into actionable business context.
  4. Curated datasets have more consistent meaning before reporting.

Explanation

Correct Answer

A:

This is the expected outcome for Access maintenance: Database access can be controlled under least-privilege operations.

Incorrect Answers

B:

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

C:

This result would follow the different Analytical storytelling decision (Have the data analyst explore trends and present findings with appropriate visuals.) 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.