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 71

Question 700

A data architect recommends this approach: Use tumbling or other appropriate streaming window aggregation. Which situation most clearly calls for that approach?

  1. A historical tax report needs the previous day's complete sales after the reporting period closes.
  2. A real-time pipeline falls behind when a sudden campaign multiplies incoming messages tenfold.
  3. A sensor processor must calculate the average temperature for each five-minute time window.
  4. A security team wants fast time-series analytics and KQL querying over continuously arriving operational logs in Fabric.

Explanation

Correct Answer

C:

This situation calls for Windowed aggregation. Continuous events are grouped into explicit bounded time intervals.

Incorrect Answers

A:

The other situation is better matched to Use scheduled batch processing for the finalized dataset. A bounded set of records is processed when the period is complete.

B:

The other situation is better matched to Scale the ingestion and processing capacity for expected event throughput. The streaming workflow can absorb higher event volume within service limits.

D:

The other situation is better matched to Use an Eventhouse with a KQL database. Real-time-oriented event records can be indexed and queried with KQL.

Question 701

An application detects repeated failures occurring within the previous ten minutes on a moving basis. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use sliding-window stream analytics.
  2. Use Azure Event Hubs as an event streaming ingestion service.
  3. Configure supported event-retention settings in the ingestion service.
  4. Query the supported Eventhouse KQL database with Kusto Query Language.

Explanation

Correct Answer

A:

The requirement concerns Sliding window. Each evaluation considers a rolling recent time period.

Incorrect Answers

B:

That action instead addresses Event Hubs ingestion: Many producers can send event data for downstream consumers to process. It does not directly satisfy the described Sliding window need.

C:

That action instead addresses Stream retention: Consumers can read retained events again within the configured window. It does not directly satisfy the described Sliding window need.

D:

That action instead addresses Real-time KQL: Recent event data can be filtered and summarized using KQL operators. It does not directly satisfy the described Sliding window need.

Question 702

A data professional makes this decision: Use sliding-window stream analytics. Which outcome is the most direct expected result?

  1. Consumers can read retained events again within the configured window.
  2. Each evaluation considers a rolling recent time period.
  3. Recent event data can be filtered and summarized using KQL operators.
  4. Many producers can send event data for downstream consumers to process.

Explanation

Correct Answer

B:

This is the expected outcome for Sliding window: Each evaluation considers a rolling recent time period.

Incorrect Answers

A:

This result would follow the different Stream retention decision (Configure supported event-retention settings in the ingestion service.) rather than the specified design.

C:

This result would follow the different Real-time KQL decision (Query the supported Eventhouse KQL database with Kusto Query Language.) rather than the specified design.

D:

This result would follow the different Event Hubs ingestion decision (Use Azure Event Hubs as an event streaming ingestion service.) rather than the specified design.

Question 703

An application detects repeated failures occurring within the previous ten minutes on a moving basis. Someone instead proposes: Configure supported event-retention settings in the ingestion service. Which alternative is the best correction for the original requirement?

  1. Configure supported event-retention settings in the ingestion service.
  2. Use Azure Event Hubs as an event streaming ingestion service.
  3. Use sliding-window stream analytics.
  4. Query the supported Eventhouse KQL database with Kusto Query Language.

Explanation

Correct Answer

C:

This correction addresses Sliding window. Each evaluation considers a rolling recent time period.

Incorrect Answers

A:

This choice is for Stream retention, not the specific requirement. Consumers can read retained events again within the configured window.

B:

This choice is for Event Hubs ingestion, not the specific requirement. Many producers can send event data for downstream consumers to process.

D:

This choice is for Real-time KQL, not the specific requirement. Recent event data can be filtered and summarized using KQL operators.

Question 704

A data architect recommends this approach: Use sliding-window stream analytics. Which situation most clearly calls for that approach?

  1. A streaming consumer may stop for hours and needs to replay recent events after recovery.
  2. An analyst needs to search recent high-volume telemetry by timestamp and error code inside an Eventhouse.
  3. Thousands of devices emit telemetry through producers that need a highly scalable event-ingestion endpoint.
  4. An application detects repeated failures occurring within the previous ten minutes on a moving basis.

Explanation

Correct Answer

D:

This situation calls for Sliding window. Each evaluation considers a rolling recent time period.

Incorrect Answers

A:

The other situation is better matched to Configure supported event-retention settings in the ingestion service. Consumers can read retained events again within the configured window.

B:

The other situation is better matched to Query the supported Eventhouse KQL database with Kusto Query Language. Recent event data can be filtered and summarized using KQL operators.

C:

The other situation is better matched to Use Azure Event Hubs as an event streaming ingestion service. Many producers can send event data for downstream consumers to process.

Question 705

Mobile devices reconnect after network outages, so some event timestamps precede the ingestion time by several minutes. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Build a Fabric Real-Time Dashboard over the supported streaming analytical data.
  2. Use Azure IoT Hub for device-oriented ingestion and management.
  3. Define a late-arrival policy and event-time handling for the stream.
  4. Create event-driven alerting with suitable processing and notification latency.

Explanation

Correct Answer

C:

The requirement concerns Late-arriving data. Delayed records can be processed according to documented temporal rules.

Incorrect Answers

A:

That action instead addresses Fabric real-time dashboard: Operators can inspect near-real-time event trends on visual tiles. It does not directly satisfy the described Late-arriving data need.

B:

That action instead addresses IoT Hub device management: The service supports device identity and message exchange in an IoT solution. It does not directly satisfy the described Late-arriving data need.

D:

That action instead addresses Near real-time alerts: Time-sensitive conditions can be acted on as events arrive. It does not directly satisfy the described Late-arriving data need.

Question 706

A data professional makes this decision: Define a late-arrival policy and event-time handling for the stream. Which outcome is the most direct expected result?

  1. The service supports device identity and message exchange in an IoT solution.
  2. Time-sensitive conditions can be acted on as events arrive.
  3. Operators can inspect near-real-time event trends on visual tiles.
  4. Delayed records can be processed according to documented temporal rules.

Explanation

Correct Answer

D:

This is the expected outcome for Late-arriving data: Delayed records can be processed according to documented temporal rules.

Incorrect Answers

A:

This result would follow the different IoT Hub device management decision (Use Azure IoT Hub for device-oriented ingestion and management.) rather than the specified design.

B:

This result would follow the different Near real-time alerts decision (Create event-driven alerting with suitable processing and notification latency.) rather than the specified design.

C:

This result would follow the different Fabric real-time dashboard decision (Build a Fabric Real-Time Dashboard over the supported streaming analytical data.) rather than the specified design.

Question 707

Mobile devices reconnect after network outages, so some event timestamps precede the ingestion time by several minutes. Someone instead proposes: Create event-driven alerting with suitable processing and notification latency. Which alternative is the best correction for the original requirement?

  1. Define a late-arrival policy and event-time handling for the stream.
  2. Build a Fabric Real-Time Dashboard over the supported streaming analytical data.
  3. Create event-driven alerting with suitable processing and notification latency.
  4. Use Azure IoT Hub for device-oriented ingestion and management.

Explanation

Correct Answer

A:

This correction addresses Late-arriving data. Delayed records can be processed according to documented temporal rules.

Incorrect Answers

B:

This choice is for Fabric real-time dashboard, not the specific requirement. Operators can inspect near-real-time event trends on visual tiles.

C:

This choice is for Near real-time alerts, not the specific requirement. Time-sensitive conditions can be acted on as events arrive.

D:

This choice is for IoT Hub device management, not the specific requirement. The service supports device identity and message exchange in an IoT solution.

Question 708

A data architect recommends this approach: Define a late-arrival policy and event-time handling for the stream. Which situation most clearly calls for that approach?

  1. A hospital operations team needs an alert soon after equipment emits a critical error event, not the next morning.
  2. Mobile devices reconnect after network outages, so some event timestamps precede the ingestion time by several minutes.
  3. An operations center needs interactive visuals from a KQL-backed event source with frequent refreshes.
  4. A manufacturer needs device-aware cloud connectivity and controlled communication with registered industrial sensors.

Explanation

Correct Answer

B:

This situation calls for Late-arriving data. Delayed records can be processed according to documented temporal rules.

Incorrect Answers

A:

The other situation is better matched to Create event-driven alerting with suitable processing and notification latency. Time-sensitive conditions can be acted on as events arrive.

C:

The other situation is better matched to Build a Fabric Real-Time Dashboard over the supported streaming analytical data. Operators can inspect near-real-time event trends on visual tiles.

D:

The other situation is better matched to Use Azure IoT Hub for device-oriented ingestion and management. The service supports device identity and message exchange in an IoT solution.

Question 709

A pipeline must compute metrics based on when transactions occurred rather than when the collector received them. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Configure a supported Fabric Activator rule for the event condition.
  2. Combine streaming summaries for live indicators with durable historical analytical storage.
  3. Use Azure Stream Analytics for stream processing where appropriate.
  4. Use event-time timestamps instead of relying solely on arrival time.

Explanation

Correct Answer

D:

The requirement concerns Event timestamp. Time-based aggregations reflect the source event occurrence where supported.

Incorrect Answers

A:

That action instead addresses Fabric Activator: A rule can initiate a response when incoming data meets a threshold. It does not directly satisfy the described Event timestamp need.

B:

That action instead addresses Historical versus live: The live and long-term analytical questions can be served by complementary data paths. It does not directly satisfy the described Event timestamp need.

C:

That action instead addresses Azure Stream Analytics: Continuous queries can transform incoming event streams into derived outputs. It does not directly satisfy the described Event timestamp need.

Question 710

A data professional makes this decision: Use event-time timestamps instead of relying solely on arrival time. Which outcome is the most direct expected result?

  1. Time-based aggregations reflect the source event occurrence where supported.
  2. The live and long-term analytical questions can be served by complementary data paths.
  3. Continuous queries can transform incoming event streams into derived outputs.
  4. A rule can initiate a response when incoming data meets a threshold.

Explanation

Correct Answer

A:

This is the expected outcome for Event timestamp: Time-based aggregations reflect the source event occurrence where supported.

Incorrect Answers

B:

This result would follow the different Historical versus live decision (Combine streaming summaries for live indicators with durable historical analytical storage.) rather than the specified design.

C:

This result would follow the different Azure Stream Analytics decision (Use Azure Stream Analytics for stream processing where appropriate.) rather than the specified design.

D:

This result would follow the different Fabric Activator decision (Configure a supported Fabric Activator rule for the event condition.) rather than the specified design.