Microsoft DP-900 Dumps
Microsoft DP-900 Practice Test 75
Question 740
At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: A
Assume configuring a storage account alone creates a daily ingestion workflow. The scenario is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. This undermines the mechanism: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. Instead: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins. This concerns another issue: At Harborcrest Transport thousands of vehicles emit location updates. In the stated case—At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Display hundreds of daily values as separate indistinguishable pie slices. This concerns another issue: At Meadowport Media analysts inspect daily subscription signups. In the stated case—At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Reappend the entire transaction history each hour with no deduplication. This concerns another issue: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. In the stated case—At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Question 741
At Cedarwood Commerce many source systems require monitored ingestion schedules. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: A
Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. This works because: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. The scenario is: At Cedarwood Commerce many source systems require monitored ingestion schedules. Verify the outcome by: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.
Use a star schema with fact and dimension tables for understandable report filters and aggregations. This addresses a different situation: At Pinecrest Retail product-category reporting relies on many transactions. The present case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. The relevant action here is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. This addresses a different situation: At Silverpoint Banking an event publisher retries after a brief timeout. The present case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. The relevant action here is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Choose a bar chart for comparing distinct categories with a common quantitative scale. This addresses a different situation: At Cedarbank Logistics supervisors compare delivery counts among depots. The present case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. The relevant action here is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Question 742
At Cedarwood Commerce many source systems require monitored ingestion schedules. The team proposes this approach: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. Which technical principle explains the choice?
Answer & Explanations
Correct answer: B
The semantic model defines shared data types, relationships and measures so reports interpret business figures consistently. That explains a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The current case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. The actual mechanism is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.
Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. This principle supports the intervention: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. The relevant scenario is: At Cedarwood Commerce many source systems require monitored ingestion schedules. Verify the result by: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.
Windowed streaming computations aggregate events over bounded time intervals as new data arrives. That explains a separate situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The current case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. The actual mechanism is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.
Idempotent processing produces the same final state after repeated delivery of an identical event. That explains a separate situation: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The current case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. The actual mechanism is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.
Question 743
At Cedarwood Commerce many source systems require monitored ingestion schedules. After implementing this approach—Use Azure Data Factory for managed movement and orchestration between supported source and destination systems—which result would most directly confirm success?
Answer & Explanations
Correct answer: A
Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history. This tests the targeted action: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. The reason is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. The reported case is: At Cedarwood Commerce many source systems require monitored ingestion schedules.
Update two fictional source records and confirm the second pipeline run imports only eligible changes. This tests a separate situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The observed case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. Use this acceptance check instead: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.
Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed. This tests a separate situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The observed case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. Use this acceptance check instead: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.
Plot fictional daily traffic for three months and verify the audience can follow growth and declines. This tests a separate situation: At Meadowport Media analysts inspect daily subscription signups. The observed case is: At Cedarwood Commerce many source systems require monitored ingestion schedules. Use this acceptance check instead: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.
Question 744
At Cedarwood Commerce many source systems require monitored ingestion schedules. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: C
Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. This concerns another issue: At Cedarcrest Finance regional managers should see only their branch transactions. In the stated case—At Cedarwood Commerce many source systems require monitored ingestion schedules—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Treat each retransmission as a brand-new purchase. This concerns another issue: At Silverpoint Banking an event publisher retries after a brief timeout. In the stated case—At Cedarwood Commerce many source systems require monitored ingestion schedules—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Assume configuring a storage account alone creates a daily ingestion workflow. The scenario is: At Cedarwood Commerce many source systems require monitored ingestion schedules. This undermines the mechanism: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. Instead: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Schedule a single weekly batch while promising a dashboard accurate every ten minutes. This concerns another issue: At Harborland Retail nightly inventory analytics satisfy finance but not emergency stock alerts. In the stated case—At Cedarwood Commerce many source systems require monitored ingestion schedules—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
Question 745
At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: C
Create a Power BI semantic model with clear tables and relationships before writing executive visualizations. This addresses a different situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The present case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The relevant action here is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Add validation and a quarantine destination for records failing an agreed data quality rule. This addresses a different situation: At Meadowfield Retail some supplier feeds contain negative quantities. The present case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The relevant action here is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. This works because: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. The scenario is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. Verify the outcome by: Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. This addresses a different situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The present case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The relevant action here is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Question 746
At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The team proposes this approach: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. Which technical principle explains the choice?
Answer & Explanations
Correct answer: C
Position along a time axis makes change and seasonality easier to compare across ordered periods. That explains a separate situation: At Meadowport Media analysts inspect daily subscription signups. The current case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The actual mechanism is: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.
A lakehouse combines lake-style file storage with table organization and analytical query access. That explains a separate situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The current case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The actual mechanism is: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.
Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. This principle supports the intervention: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. The relevant scenario is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. Verify the result by: Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. That explains a separate situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The current case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The actual mechanism is: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.
Question 747
At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. After implementing this approach—Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration—which result would most directly confirm success?
Answer & Explanations
Correct answer: C
Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table. This tests a separate situation: At Meadowfield Retail some supplier feeds contain negative quantities. The observed case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. Use this acceptance check instead: Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions. This tests a separate situation: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The observed case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. Use this acceptance check instead: Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination. This tests the targeted action: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. The reason is: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. The reported case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics.
Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination. This tests a separate situation: At Pinebrook Facilities sensors send readings to an event hub. The observed case is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. Use this acceptance check instead: Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
Question 748
At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: A
Assume creating a Power BI chart automatically ingests all missing source history into Fabric. The scenario is: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. This undermines the mechanism: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. Instead: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Discard raw source files before checking whether transformations are repeatable. This concerns another issue: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. In the stated case—At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics—reject: Assume creating a Power BI chart automatically ingests all missing source history into Fabric. The safer response is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins. This concerns another issue: At Harborcrest Transport thousands of vehicles emit location updates. In the stated case—At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics—reject: Assume creating a Power BI chart automatically ingests all missing source history into Fabric. The safer response is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Connect unrelated tables by matching display names that are not stable unique keys. This concerns another issue: At Harborfield Commerce sales facts reference a product dimension. In the stated case—At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics—reject: Assume creating a Power BI chart automatically ingests all missing source history into Fabric. The safer response is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Question 749
At Silverlake Travel analysts move approved data into a OneLake-backed project. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: D
Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. This addresses a different situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The present case is: At Silverlake Travel analysts move approved data into a OneLake-backed project. The relevant action here is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. This addresses a different situation: At Silvercrest Commerce executives compare sales performance across regions. The present case is: At Silverlake Travel analysts move approved data into a OneLake-backed project. The relevant action here is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Choose event-time windows when late-arriving sensor measurements must be attributed to their occurrence time rather than receipt time. This addresses a different situation: At Meadowport Transit buses upload buffered GPS events after reconnecting. The present case is: At Silverlake Travel analysts move approved data into a OneLake-backed project. The relevant action here is: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. This works because: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. The scenario is: At Silverlake Travel analysts move approved data into a OneLake-backed project. Verify the outcome by: Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
Question 750
At Silverlake Travel analysts move approved data into a OneLake-backed project. The team proposes this approach: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. Which technical principle explains the choice?
Answer & Explanations
Correct answer: B
Model relationships propagate filter context between related tables according to direction and cardinality. That explains a separate situation: At Harborfield Commerce sales facts reference a product dimension. The current case is: At Silverlake Travel analysts move approved data into a OneLake-backed project. The actual mechanism is: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.
Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. This principle supports the intervention: Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. The relevant scenario is: At Silverlake Travel analysts move approved data into a OneLake-backed project. Verify the result by: Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
Partitioned event ingestion supports parallel consumers while independent groups track their own reading positions. That explains a separate situation: At Oakcrest Mobility live tracking and reporting consume the same event source. The current case is: At Silverlake Travel analysts move approved data into a OneLake-backed project. The actual mechanism is: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.
Databricks supplies managed Apache Spark data processing capable of parallel transformations and notebook workflows. That explains a separate situation: At Harborland Energy billions of sensor readings require transformation. The current case is: At Silverlake Travel analysts move approved data into a OneLake-backed project. The actual mechanism is: Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.
Microsoft Azure Data Fundamentals (DP-900) Practice Tests
- Microsoft DP-900 Practice Test 73 - 10 Questions (Last Reviewed 03-Nov-2026)
- Microsoft DP-900 Practice Test 74 - 10 Questions (Last Reviewed 02-Nov-2026)
- Microsoft DP-900 Practice Test 75 - 10 Questions (Last Reviewed 01-Nov-2026)
- Microsoft DP-900 Practice Test 76 - 10 Questions (Last Reviewed 31-Oct-2026)
- Microsoft DP-900 Practice Test 77 - 10 Questions (Last Reviewed 30-Oct-2026)