Microsoft DP-900 Dumps
Microsoft DP-900 Practice Test 78
Question 770
At Cedarbridge Media analysts combine raw events and curated advertising tables. The team proposes this approach: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. Which technical principle explains the choice?
Answer & Explanations
Correct answer: A
A lakehouse combines lake-style file storage with table organization and analytical query access. This principle supports the intervention: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. The relevant scenario is: At Cedarbridge Media analysts combine raw events and curated advertising tables. Verify the result by: Land sample JSON files and create a queryable curated table without discarding the original files.
Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. That explains a separate situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The current case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.
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 Cedarbridge Media analysts combine raw events and curated advertising tables. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.
Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. That explains a separate situation: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The current case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.
Question 771
At Cedarbridge Media analysts combine raw events and curated advertising tables. After implementing this approach—Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads—which result would most directly confirm success?
Answer & Explanations
Correct answer: B
Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history. This tests a separate situation: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The observed case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. Use this acceptance check instead: Land sample JSON files and create a queryable curated table without discarding the original files.
Land sample JSON files and create a queryable curated table without discarding the original files. This tests the targeted action: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. The reason is: A lakehouse combines lake-style file storage with table organization and analytical query access. The reported case is: At Cedarbridge Media analysts combine raw events and curated advertising tables.
Update a synthetic source record and verify the report reflects it after a configured refresh. This tests a separate situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The observed case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. Use this acceptance check instead: Land sample JSON files and create a queryable curated table without discarding the original files.
Publish synthetic events, consume them through a test consumer group and verify offsets advance. This tests a separate situation: At Harborcrest Transport thousands of vehicles emit location updates. The observed case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. Use this acceptance check instead: Land sample JSON files and create a queryable curated table without discarding the original files.
Question 772
At Cedarbridge Media analysts combine raw events and curated advertising tables. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: C
Assume a consumer can recover messages that have already aged out of the event stream. This concerns another issue: At Harborcrest Logistics a tracking processor is offline during a deployment. In the stated case—At Cedarbridge Media analysts combine raw events and curated advertising tables—reject: Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The safer response is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Build separate disconnected charts each using a different definition of sales. This concerns another issue: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. In the stated case—At Cedarbridge Media analysts combine raw events and curated advertising tables—reject: Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The safer response is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The scenario is: At Cedarbridge Media analysts combine raw events and curated advertising tables. This undermines the mechanism: A lakehouse combines lake-style file storage with table organization and analytical query access. Instead: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Label an unvalidated raw copy as a finished ETL process without a transformation step. This concerns another issue: At Cedarfield Finance external invoices need standard currency codes before reporting. In the stated case—At Cedarbridge Media analysts combine raw events and curated advertising tables—reject: Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The safer response is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Question 773
At Pineport Research scientists use files and SQL-accessible tables within one platform. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: D
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 Pineport Research scientists use files and SQL-accessible tables within one platform. The relevant action here is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. This addresses a different situation: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The present case is: At Pineport Research scientists use files and SQL-accessible tables within one platform. The relevant action here is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
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 Pineport Research scientists use files and SQL-accessible tables within one platform. The relevant action here is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. This works because: A lakehouse combines lake-style file storage with table organization and analytical query access. The scenario is: At Pineport Research scientists use files and SQL-accessible tables within one platform. Verify the outcome by: Land sample JSON files and create a queryable curated table without discarding the original files.
Question 774
At Pineport Research scientists use files and SQL-accessible tables within one platform. The team proposes this approach: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. Which technical principle explains the choice?
Answer & Explanations
Correct answer: C
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 Pineport Research scientists use files and SQL-accessible tables within one platform. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.
Import caches data in the Power BI model and requires refresh to reflect changed source rows. That explains a separate situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The current case is: At Pineport Research scientists use files and SQL-accessible tables within one platform. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.
A lakehouse combines lake-style file storage with table organization and analytical query access. This principle supports the intervention: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. The relevant scenario is: At Pineport Research scientists use files and SQL-accessible tables within one platform. Verify the result by: Land sample JSON files and create a queryable curated table without discarding the original files.
Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. That explains a separate situation: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The current case is: At Pineport Research scientists use files and SQL-accessible tables within one platform. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.
Question 775
At Pineport Research scientists use files and SQL-accessible tables within one platform. After implementing this approach—Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads—which result would most directly confirm success?
Answer & Explanations
Correct answer: D
Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination. This tests a separate situation: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The observed case is: At Pineport Research scientists use files and SQL-accessible tables within one platform. Use this acceptance check instead: Land sample JSON files and create a queryable curated table without discarding the original files.
Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination. This tests a separate situation: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The observed case is: At Pineport Research scientists use files and SQL-accessible tables within one platform. Use this acceptance check instead: Land sample JSON files and create a queryable curated table without discarding the original files.
Relate fictional sales facts to products and dates and verify filters affect the intended totals. This tests a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The observed case is: At Pineport Research scientists use files and SQL-accessible tables within one platform. Use this acceptance check instead: Land sample JSON files and create a queryable curated table without discarding the original files.
Land sample JSON files and create a queryable curated table without discarding the original files. This tests the targeted action: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. The reason is: A lakehouse combines lake-style file storage with table organization and analytical query access. The reported case is: At Pineport Research scientists use files and SQL-accessible tables within one platform.
Question 776
At Pineport Research scientists use files and SQL-accessible tables within one platform. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: B
Append duplicate transactions on every network retry without comparing event IDs. This concerns another issue: At Silverbrook Logistics pipelines reattempt delayed shipment messages. In the stated case—At Pineport Research scientists use files and SQL-accessible tables within one platform—reject: Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The safer response is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The scenario is: At Pineport Research scientists use files and SQL-accessible tables within one platform. This undermines the mechanism: A lakehouse combines lake-style file storage with table organization and analytical query access. Instead: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Present categories as an unlabeled geographic heatmap with no location meaning. This concerns another issue: At Cedarbank Logistics supervisors compare delivery counts among depots. In the stated case—At Pineport Research scientists use files and SQL-accessible tables within one platform—reject: Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The safer response is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
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 Pineport Research scientists use files and SQL-accessible tables within one platform—reject: Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. The safer response is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
Question 777
At Silvercrest Commerce executives compare sales performance across regions. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: A
Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. This works because: A warehouse supports curated structured models and analytic queries over integrated business entities. The scenario is: At Silvercrest Commerce executives compare sales performance across regions. Verify the outcome by: Load fictional sales and finance facts and verify both reports share a consistent date dimension.
Choose event partitions and consumer groups to scale ingestion and allow independent downstream applications. This addresses a different situation: At Oakcrest Mobility live tracking and reporting consume the same event source. The present case is: At Silvercrest Commerce executives compare sales performance across regions. The relevant action here is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
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 Silvercrest Commerce executives compare sales performance across regions. The relevant action here is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
Use a scatter plot when exploring whether two quantitative variables have an association. This addresses a different situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The present case is: At Silvercrest Commerce executives compare sales performance across regions. The relevant action here is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
Question 778
At Silvercrest Commerce executives compare sales performance across regions. The team proposes this approach: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. Which technical principle explains the choice?
Answer & Explanations
Correct answer: C
Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. That explains a separate situation: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The current case is: At Silvercrest Commerce executives compare sales performance across regions. The actual mechanism is: A warehouse supports curated structured models and analytic queries over integrated business entities.
Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. That explains a separate situation: At Pinebrook Facilities sensors send readings to an event hub. The current case is: At Silvercrest Commerce executives compare sales performance across regions. The actual mechanism is: A warehouse supports curated structured models and analytic queries over integrated business entities.
A warehouse supports curated structured models and analytic queries over integrated business entities. This principle supports the intervention: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. The relevant scenario is: At Silvercrest Commerce executives compare sales performance across regions. Verify the result by: Load fictional sales and finance facts and verify both reports share a consistent date dimension.
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 Silvercrest Commerce executives compare sales performance across regions. The actual mechanism is: A warehouse supports curated structured models and analytic queries over integrated business entities.
Question 779
At Silvercrest Commerce executives compare sales performance across regions. After implementing this approach—Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts—which result would most directly confirm success?
Answer & Explanations
Correct answer: C
Replay a fictional event with the same ID and confirm the sink counts it only once. This tests a separate situation: At Silverpoint Banking an event publisher retries after a brief timeout. The observed case is: At Silvercrest Commerce executives compare sales performance across regions. Use this acceptance check instead: Load fictional sales and finance facts and verify both reports share a consistent date dimension.
Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table. This tests a separate situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The observed case is: At Silvercrest Commerce executives compare sales performance across regions. Use this acceptance check instead: Load fictional sales and finance facts and verify both reports share a consistent date dimension.
Load fictional sales and finance facts and verify both reports share a consistent date dimension. This tests the targeted action: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. The reason is: A warehouse supports curated structured models and analytic queries over integrated business entities. The reported case is: At Silvercrest Commerce executives compare sales performance across regions.
Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims. This tests a separate situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The observed case is: At Silvercrest Commerce executives compare sales performance across regions. Use this acceptance check instead: Load fictional sales and finance facts and verify both reports share a consistent date dimension.
Question 780
At Silvercrest Commerce executives compare sales performance across regions. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: D
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 Silvercrest Commerce executives compare sales performance across regions—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
Present categories as an unlabeled geographic heatmap with no location meaning. This concerns another issue: At Cedarbank Logistics supervisors compare delivery counts among depots. In the stated case—At Silvercrest Commerce executives compare sales performance across regions—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
Place every descriptive product attribute into repeated transaction rows without a governed dimension model. This concerns another issue: At Pinecrest Retail product-category reporting relies on many transactions. In the stated case—At Silvercrest Commerce executives compare sales performance across regions—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The scenario is: At Silvercrest Commerce executives compare sales performance across regions. The likely failure is: Reports disagree on basic business totals. Instead: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
Microsoft Azure Data Fundamentals (DP-900) Practice Tests
- 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)
- Microsoft DP-900 Practice Test 78 - 10 Questions (Last Reviewed 29-Oct-2026)
- Microsoft DP-900 Practice Test 79 - 10 Questions (Last Reviewed 28-Oct-2026)
- Microsoft DP-900 Practice Test 80 - 10 Questions (Last Reviewed 27-Oct-2026)