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 15

Question 140

A data architect recommends this approach: Classify the checkout application as an online transactional processing workload. Which situation most clearly calls for that approach?

  1. An online storefront commits a few order and payment rows per customer request with immediate consistency expectations.
  2. A monitoring application must detect an over-temperature event within seconds of receiving sensor data.
  3. A nightly job extracts source records, cleans mismatched categories and loads curated rows for reporting.
  4. An order system must prevent a line item from referring to a product that does not exist.

Explanation

Correct Answer

A:

This situation calls for OLTP checkout. Many short atomic reads and writes characterize OLTP activity.

Incorrect Answers

B:

The other situation is better matched to Choose a streaming or near-real-time analytical processing pattern. Events are evaluated continuously rather than waiting for an overnight job.

C:

The other situation is better matched to Classify the workflow as extract-transform-load data integration. Source data is transformed before arriving in the analytical target.

D:

The other situation is better matched to Enforce referential integrity through relational key constraints. Invalid relationships are rejected rather than leaving orphaned references.

Question 141

Executives aggregate five years of sales by month, region and product to find long-term trends. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Classify the workflow as extract-load-transform.
  2. Classify the task as an analytical or OLAP workload.
  3. Optimize primarily for transactional write and point-read patterns.
  4. Use transactional concurrency control appropriate for the database.

Explanation

Correct Answer

B:

The requirement concerns OLAP sales trends. Large scans and grouped historical summaries dominate rather than individual order updates.

Incorrect Answers

A:

That action instead addresses ELT pattern: Transformation occurs after ingestion using the target environment's compute. It does not directly satisfy the described OLAP sales trends need.

C:

That action instead addresses Read-write ratio: Operational data access remains responsive under many short transactions. It does not directly satisfy the described OLAP sales trends need.

D:

That action instead addresses Concurrent users: Concurrent operations can be isolated while preserving valid committed state. It does not directly satisfy the described OLAP sales trends need.

Question 142

A data professional makes this decision: Classify the task as an analytical or OLAP workload. Which outcome is the most direct expected result?

  1. Operational data access remains responsive under many short transactions.
  2. Transformation occurs after ingestion using the target environment's compute.
  3. Large scans and grouped historical summaries dominate rather than individual order updates.
  4. Concurrent operations can be isolated while preserving valid committed state.

Explanation

Correct Answer

C:

This is the expected outcome for OLAP sales trends: Large scans and grouped historical summaries dominate rather than individual order updates.

Incorrect Answers

A:

This result would follow the different Read-write ratio decision (Optimize primarily for transactional write and point-read patterns.) rather than the specified design.

B:

This result would follow the different ELT pattern decision (Classify the workflow as extract-load-transform.) rather than the specified design.

D:

This result would follow the different Concurrent users decision (Use transactional concurrency control appropriate for the database.) rather than the specified design.

Question 143

Executives aggregate five years of sales by month, region and product to find long-term trends. Someone instead proposes: Use transactional concurrency control appropriate for the database. Which alternative is the best correction for the original requirement?

  1. Optimize primarily for transactional write and point-read patterns.
  2. Classify the workflow as extract-load-transform.
  3. Use transactional concurrency control appropriate for the database.
  4. Classify the task as an analytical or OLAP workload.

Explanation

Correct Answer

D:

This correction addresses OLAP sales trends. Large scans and grouped historical summaries dominate rather than individual order updates.

Incorrect Answers

A:

This choice is for Read-write ratio, not the specific requirement. Operational data access remains responsive under many short transactions.

B:

This choice is for ELT pattern, not the specific requirement. Transformation occurs after ingestion using the target environment's compute.

C:

This choice is for Concurrent users, not the specific requirement. Concurrent operations can be isolated while preserving valid committed state.

Question 144

A data architect recommends this approach: Classify the task as an analytical or OLAP workload. Which situation most clearly calls for that approach?

  1. Executives aggregate five years of sales by month, region and product to find long-term trends.
  2. A reservation service has thousands of small inserts and updates each minute but relatively few historical aggregation queries.
  3. A platform copies raw files into a scalable analytical store, then performs SQL transformations inside that store.
  4. Hundreds of shoppers update separate shopping baskets at the same time without interfering with one another.

Explanation

Correct Answer

A:

This situation calls for OLAP sales trends. Large scans and grouped historical summaries dominate rather than individual order updates.

Incorrect Answers

B:

The other situation is better matched to Optimize primarily for transactional write and point-read patterns. Operational data access remains responsive under many short transactions.

C:

The other situation is better matched to Classify the workflow as extract-load-transform. Transformation occurs after ingestion using the target environment's compute.

D:

The other situation is better matched to Use transactional concurrency control appropriate for the database. Concurrent operations can be isolated while preserving valid committed state.

Question 145

A bank transfer must debit one account and credit another or leave both balances unchanged. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Describe the solution as short-interval batch processing.
  2. Use a database transaction with atomic commit or rollback.
  3. Separate analytical reporting compute or store from the OLTP path.
  4. Treat the workload as analytical reporting over accumulated history.

Explanation

Correct Answer

B:

The requirement concerns Atomic transaction. Related changes succeed together or none are committed.

Incorrect Answers

A:

That action instead addresses Microbatch trend: Records are grouped into periodic batches rather than analyzed individually on arrival. It does not directly satisfy the described Atomic transaction need.

C:

That action instead addresses Reporting replica: Heavy historical reads no longer contend as directly with transactional requests. It does not directly satisfy the described Atomic transaction need.

D:

That action instead addresses Historical dashboard: Read-heavy aggregations can use analytical storage and compute patterns. It does not directly satisfy the described Atomic transaction need.

Question 146

A data professional makes this decision: Use a database transaction with atomic commit or rollback. Which outcome is the most direct expected result?

  1. Heavy historical reads no longer contend as directly with transactional requests.
  2. Records are grouped into periodic batches rather than analyzed individually on arrival.
  3. Related changes succeed together or none are committed.
  4. Read-heavy aggregations can use analytical storage and compute patterns.

Explanation

Correct Answer

C:

This is the expected outcome for Atomic transaction: Related changes succeed together or none are committed.

Incorrect Answers

A:

This result would follow the different Reporting replica decision (Separate analytical reporting compute or store from the OLTP path.) rather than the specified design.

B:

This result would follow the different Microbatch trend decision (Describe the solution as short-interval batch processing.) rather than the specified design.

D:

This result would follow the different Historical dashboard decision (Treat the workload as analytical reporting over accumulated history.) rather than the specified design.

Question 147

A bank transfer must debit one account and credit another or leave both balances unchanged. Someone instead proposes: Treat the workload as analytical reporting over accumulated history. Which alternative is the best correction for the original requirement?

  1. Separate analytical reporting compute or store from the OLTP path.
  2. Describe the solution as short-interval batch processing.
  3. Treat the workload as analytical reporting over accumulated history.
  4. Use a database transaction with atomic commit or rollback.

Explanation

Correct Answer

D:

This correction addresses Atomic transaction. Related changes succeed together or none are committed.

Incorrect Answers

A:

This choice is for Reporting replica, not the specific requirement. Heavy historical reads no longer contend as directly with transactional requests.

B:

This choice is for Microbatch trend, not the specific requirement. Records are grouped into periodic batches rather than analyzed individually on arrival.

C:

This choice is for Historical dashboard, not the specific requirement. Read-heavy aggregations can use analytical storage and compute patterns.

Question 148

A data architect recommends this approach: Use a database transaction with atomic commit or rollback. Which situation most clearly calls for that approach?

  1. A bank transfer must debit one account and credit another or leave both balances unchanged.
  2. A service combines each five-minute set of incoming measurements into a summary before storing it.
  3. Operational queries slow down when reports scan large portions of a busy order-processing database.
  4. An operations team reads hourly sales totals for the last decade but almost never edits individual old sales.

Explanation

Correct Answer

A:

This situation calls for Atomic transaction. Related changes succeed together or none are committed.

Incorrect Answers

B:

The other situation is better matched to Describe the solution as short-interval batch processing. Records are grouped into periodic batches rather than analyzed individually on arrival.

C:

The other situation is better matched to Separate analytical reporting compute or store from the OLTP path. Heavy historical reads no longer contend as directly with transactional requests.

D:

The other situation is better matched to Treat the workload as analytical reporting over accumulated history. Read-heavy aggregations can use analytical storage and compute patterns.

Question 149

An order system must prevent a line item from referring to a product that does not exist. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Classify the checkout application as an online transactional processing workload.
  2. Enforce referential integrity through relational key constraints.
  3. Classify the workflow as extract-transform-load data integration.
  4. Choose a streaming or near-real-time analytical processing pattern.

Explanation

Correct Answer

B:

The requirement concerns Consistency constraint. Invalid relationships are rejected rather than leaving orphaned references.

Incorrect Answers

A:

That action instead addresses OLTP checkout: Many short atomic reads and writes characterize OLTP activity. It does not directly satisfy the described Consistency constraint need.

C:

That action instead addresses ETL processing: Source data is transformed before arriving in the analytical target. It does not directly satisfy the described Consistency constraint need.

D:

That action instead addresses Stream anomaly: Events are evaluated continuously rather than waiting for an overnight job. It does not directly satisfy the described Consistency constraint need.

Question 150

A data professional makes this decision: Enforce referential integrity through relational key constraints. Which outcome is the most direct expected result?

  1. Source data is transformed before arriving in the analytical target.
  2. Events are evaluated continuously rather than waiting for an overnight job.
  3. Invalid relationships are rejected rather than leaving orphaned references.
  4. Many short atomic reads and writes characterize OLTP activity.

Explanation

Correct Answer

C:

This is the expected outcome for Consistency constraint: Invalid relationships are rejected rather than leaving orphaned references.

Incorrect Answers

A:

This result would follow the different ETL processing decision (Classify the workflow as extract-transform-load data integration.) rather than the specified design.

B:

This result would follow the different Stream anomaly decision (Choose a streaming or near-real-time analytical processing pattern.) rather than the specified design.

D:

This result would follow the different OLTP checkout decision (Classify the checkout application as an online transactional processing workload.) rather than the specified design.