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 73

Question 720

A data architect recommends this approach: Configure supported event-retention settings in the ingestion service. 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. An application detects repeated failures occurring within the previous ten minutes on a moving basis.
  3. A security team wants fast time-series analytics and KQL querying over continuously arriving operational logs in Fabric.
  4. A streaming consumer may stop for hours and needs to replay recent events after recovery.

Explanation

Correct Answer

D:

This situation calls for Stream retention. Consumers can read retained events again within the configured window.

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 Use sliding-window stream analytics. Each evaluation considers a rolling recent time period.

C:

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 721

A hospital operations team needs an alert soon after equipment emits a critical error event, not the next morning. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Create event-driven alerting with suitable processing and notification latency.
  2. Define a late-arrival policy and event-time handling for the stream.
  3. Query the supported Eventhouse KQL database with Kusto Query Language.
  4. Use Azure Event Hubs as an event streaming ingestion service.

Explanation

Correct Answer

A:

The requirement concerns Near real-time alerts. Time-sensitive conditions can be acted on as events arrive.

Incorrect Answers

B:

That action instead addresses Late-arriving data: Delayed records can be processed according to documented temporal rules. It does not directly satisfy the described Near real-time alerts need.

C:

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 Near real-time alerts need.

D:

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 Near real-time alerts need.

Question 722

A data professional makes this decision: Create event-driven alerting with suitable processing and notification latency. Which outcome is the most direct expected result?

  1. Delayed records can be processed according to documented temporal rules.
  2. Time-sensitive conditions can be acted on as events arrive.
  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 Near real-time alerts: Time-sensitive conditions can be acted on as events arrive.

Incorrect Answers

A:

This result would follow the different Late-arriving data decision (Define a late-arrival policy and event-time handling for the stream.) 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 723

A hospital operations team needs an alert soon after equipment emits a critical error event, not the next morning. Someone instead proposes: Use Azure Event Hubs as an event streaming ingestion service. Which alternative is the best correction for the original requirement?

  1. Define a late-arrival policy and event-time handling for the stream.
  2. Query the supported Eventhouse KQL database with Kusto Query Language.
  3. Create event-driven alerting with suitable processing and notification latency.
  4. Use Azure Event Hubs as an event streaming ingestion service.

Explanation

Correct Answer

C:

This correction addresses Near real-time alerts. Time-sensitive conditions can be acted on as events arrive.

Incorrect Answers

A:

This choice is for Late-arriving data, not the specific requirement. Delayed records can be processed according to documented temporal rules.

B:

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

D:

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

Question 724

A data architect recommends this approach: Create event-driven alerting with suitable processing and notification latency. Which situation most clearly calls for that approach?

  1. Mobile devices reconnect after network outages, so some event timestamps precede the ingestion time by several minutes.
  2. Thousands of devices emit telemetry through producers that need a highly scalable event-ingestion endpoint.
  3. An analyst needs to search recent high-volume telemetry by timestamp and error code inside an Eventhouse.
  4. A hospital operations team needs an alert soon after equipment emits a critical error event, not the next morning.

Explanation

Correct Answer

D:

This situation calls for Near real-time alerts. Time-sensitive conditions can be acted on as events arrive.

Incorrect Answers

A:

The other situation is better matched to Define a late-arrival policy and event-time handling for the stream. Delayed records can be processed according to documented temporal rules.

B:

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.

C:

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.

Question 725

A product team needs both a live count of active sessions and a monthly historical usage summary. 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. Combine streaming summaries for live indicators with durable historical analytical storage.
  4. Use event-time timestamps instead of relying solely on arrival time.

Explanation

Correct Answer

C:

The requirement concerns Historical versus live. The live and long-term analytical questions can be served by complementary data paths.

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 Historical versus live 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 Historical versus live need.

D:

That action instead addresses Event timestamp: Time-based aggregations reflect the source event occurrence where supported. It does not directly satisfy the described Historical versus live need.

Question 726

A data professional makes this decision: Combine streaming summaries for live indicators with durable historical analytical storage. Which outcome is the most direct expected result?

  1. Operators can inspect near-real-time event trends on visual tiles.
  2. Time-based aggregations reflect the source event occurrence where supported.
  3. The service supports device identity and message exchange in an IoT solution.
  4. The live and long-term analytical questions can be served by complementary data paths.

Explanation

Correct Answer

D:

This is the expected outcome for Historical versus live: The live and long-term analytical questions can be served by complementary data paths.

Incorrect Answers

A:

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.

B:

This result would follow the different Event timestamp decision (Use event-time timestamps instead of relying solely on arrival time.) rather than the specified design.

C:

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.

Question 727

A product team needs both a live count of active sessions and a monthly historical usage summary. Someone instead proposes: Use Azure IoT Hub for device-oriented ingestion and management. Which alternative is the best correction for the original requirement?

  1. Combine streaming summaries for live indicators with durable historical analytical storage.
  2. Use event-time timestamps instead of relying solely on arrival time.
  3. Build a Fabric Real-Time Dashboard over the supported streaming analytical data.
  4. Use Azure IoT Hub for device-oriented ingestion and management.

Explanation

Correct Answer

A:

This correction addresses Historical versus live. The live and long-term analytical questions can be served by complementary data paths.

Incorrect Answers

B:

This choice is for Event timestamp, not the specific requirement. Time-based aggregations reflect the source event occurrence where supported.

C:

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

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 728

A data architect recommends this approach: Combine streaming summaries for live indicators with durable historical analytical storage. Which situation most clearly calls for that approach?

  1. An operations center needs interactive visuals from a KQL-backed event source with frequent refreshes.
  2. A product team needs both a live count of active sessions and a monthly historical usage summary.
  3. A manufacturer needs device-aware cloud connectivity and controlled communication with registered industrial sensors.
  4. A pipeline must compute metrics based on when transactions occurred rather than when the collector received them.

Explanation

Correct Answer

B:

This situation calls for Historical versus live. The live and long-term analytical questions can be served by complementary data paths.

Incorrect Answers

A:

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.

C:

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.

D:

The other situation is better matched to Use event-time timestamps instead of relying solely on arrival time. Time-based aggregations reflect the source event occurrence where supported.

Question 729

A company needs an interactive multipage collection of sales visuals with filters and drilldown over an analytical model. Which data concept, Azure service, or design decision most directly satisfies the requirement?

  1. Use a bar chart with categories and a common numeric scale.
  2. Model the data as a star schema with facts and dimensions.
  3. Use a Power BI table visual.
  4. Create a Power BI report with the required report pages.

Explanation

Correct Answer

D:

The requirement concerns Power BI report. Users can explore related visuals and filter the modeled data interactively.

Incorrect Answers

A:

That action instead addresses Bar category comparison: Relative magnitudes across many labeled categories can be compared. It does not directly satisfy the described Power BI report need.

B:

That action instead addresses Star schema: A clear fact-to-dimension design supports understandable analytical filtering. It does not directly satisfy the described Power BI report need.

C:

That action instead addresses Table detail: Precise row and column values can be reviewed directly. It does not directly satisfy the described Power BI report need.

Question 730

A data professional makes this decision: Create a Power BI report with the required report pages. Which outcome is the most direct expected result?

  1. Users can explore related visuals and filter the modeled data interactively.
  2. Precise row and column values can be reviewed directly.
  3. A clear fact-to-dimension design supports understandable analytical filtering.
  4. Relative magnitudes across many labeled categories can be compared.

Explanation

Correct Answer

A:

This is the expected outcome for Power BI report: Users can explore related visuals and filter the modeled data interactively.

Incorrect Answers

B:

This result would follow the different Table detail decision (Use a Power BI table visual.) rather than the specified design.

C:

This result would follow the different Star schema decision (Model the data as a star schema with facts and dimensions.) rather than the specified design.

D:

This result would follow the different Bar category comparison decision (Use a bar chart with categories and a common numeric scale.) rather than the specified design.