You save $69.98
A source warehouse exposes a stable SQL endpoint, and the team wants to avoid pulling all rows into Power BI every hour. The team plans to implement this change: Consider DirectQuery when querying an appropriate external/SQL endpoint without importing the full dataset. Which result best verifies the intended outcome?
DirectQuery sends queries to the source at report time, trading freshness for source load and response time. This evidence exercises the actual success condition rather than only confirming that a resource exists.
That observation would verify a different goal: Two authorized semantic models query the curated Delta rows without manual file copies. It does not demonstrate the specific required result: A new committed source value appears in a model query without an Import refresh.
That observation would verify a different goal: A Spark notebook processes the source data and writes a queryable Delta table. It does not demonstrate the specific required result: A new committed source value appears in a model query without an Import refresh.
That observation would verify a different goal: The analyst's SELECT statement returns the correct curated rows without editing Delta files. It does not demonstrate the specific required result: A new committed source value appears in a model query without an Import refresh.
An operations team wants streaming telemetry available in Fabric's event-oriented analytics store. Which implementation decision best addresses the stated requirement?
Eventstream carries event data into real-time destinations such as an Eventhouse. The proposed action directly targets the problem described in the scenario.
Enable a supported Eventhouse data availability/integration path to OneLake as appropriate. is an approach for a different requirement: Eventhouse and OneLake integration can make compatible event data available for cross-workload analytics. In the present case, eventstream carries event data into real-time destinations such as an Eventhouse.
Use Dataflow Gen2 with supported connectors and Power Query transformations. is an approach for a different requirement: Dataflow Gen2 supports low-code data preparation and destination loading within Fabric. In the present case, eventstream carries event data into real-time destinations such as an Eventhouse.
Use a supported OneLake shortcut where access and data format are compatible. is an approach for a different requirement: Shortcuts expose referenced data through OneLake without requiring a full duplicate copy. In the present case, eventstream carries event data into real-time destinations such as an Eventhouse.
A reporting query should retain only customer groups whose total sales exceed a budget threshold. Which implementation decision best addresses the stated requirement?
HAVING filters groups based on aggregate expressions, unlike pre-group row filtering. The proposed action directly targets the problem described in the scenario.
Write a T-SQL query using SUM and GROUP BY Region with the appropriate filters. is an approach for a different requirement: SQL grouping computes measures over the chosen set of grouping keys. In the present case, hAVING filters groups based on aggregate expressions, unlike pre-group row filtering.
Use Fabric's Visual query editor for the supported select, filter and aggregate operations. is an approach for a different requirement: The visual editor represents common relational operations without requiring typed SQL. In the present case, hAVING filters groups based on aggregate expressions, unlike pre-group row filtering.
Apply a SQL WHERE predicate on the typed order date. is an approach for a different requirement: WHERE filters rows before they contribute to downstream grouping or presentation. In the present case, hAVING filters groups based on aggregate expressions, unlike pre-group row filtering.
A lakehouse contains separate first and last name fields but a downstream report requires full display names. The team plans to implement this change: Create a transformation expression that concatenates name components with null handling. Which result best verifies the intended outcome?
Enrichment should handle optional source fields explicitly to avoid unexpected null results. This evidence exercises the actual success condition rather than only confirming that a resource exists.
That observation would verify a different goal: A test row with known revenue and cost yields the correct gross margin value. It does not demonstrate the specific required result: Known test names produce the agreed display format even when middle names are absent.
That observation would verify a different goal: Result columns exactly match the data contract and excluded private fields are absent. It does not demonstrate the specific required result: Known test names produce the agreed display format even when middle names are absent.
That observation would verify a different goal: Different test inputs produce the expected scalar or table-valued function results. It does not demonstrate the specific required result: Known test names produce the agreed display format even when middle names are absent.
A team wants repeatable parameter-driven staging-to-curated operations rather than pasting SQL interactively. Which implementation decision best addresses the stated requirement?
Stored procedures package supported SQL operations for repeatable execution. The proposed action directly targets the problem described in the scenario.
Define an appropriate supported SQL function for reusable argument-driven logic. is an approach for a different requirement: Functions encapsulate reusable expressions that can be invoked by compatible queries. In the present case, stored procedures package supported SQL operations for repeatable execution.
Create a T-SQL view for the reusable query projection. is an approach for a different requirement: A view provides a queryable logical definition without becoming a separately materialized full copy by default. In the present case, stored procedures package supported SQL operations for repeatable execution.
Create a transformation expression that concatenates name components with null handling. is an approach for a different requirement: Enrichment should handle optional source fields explicitly to avoid unexpected null results. In the present case, stored procedures package supported SQL operations for repeatable execution.
A security operations team queries millions of timestamped logs with Kusto Query Language. The team plans to implement this change: Choose Eventhouse with KQL database storage for real-time/event-style analytical workloads. Which result best verifies the intended outcome?
Eventhouse is designed to ingest and analyze event or log data efficiently with KQL. This evidence exercises the actual success condition rather than only confirming that a resource exists.
That observation would verify a different goal: Two authorized semantic models query the curated Delta rows without manual file copies. It does not demonstrate the specific required result: A KQL time-window query over recent telemetry meets the stated interactive-analysis requirement.
That observation would verify a different goal: The model reports the correct current data and telemetry shows the expected Direct Lake execution path. It does not demonstrate the specific required result: A KQL time-window query over recent telemetry meets the stated interactive-analysis requirement.
That observation would verify a different goal: A new committed source value appears in a model query without an Import refresh. It does not demonstrate the specific required result: A KQL time-window query over recent telemetry meets the stated interactive-analysis requirement.
A pipeline compares strings rather than true date values and produces incorrect month boundaries. Which implementation decision best addresses the stated requirement?
Typed dates support correct chronological comparisons; lexical string ordering does not. The proposed action directly targets the problem described in the scenario.
Filter transaction rows on the relevant typed date range before aggregation. is an approach for a different requirement: A WHERE predicate changes the qualifying row set; a descriptive title does not. In the present case, typed dates support correct chronological comparisons; lexical string ordering does not.
Explicitly detect nulls and apply an agreed missing-value handling policy. is an approach for a different requirement: Null means absent or unknown and should not be silently confused with numerical zero or a legitimate category. In the present case, typed dates support correct chronological comparisons; lexical string ordering does not.
Use a conformed date dimension related to the relevant fact date keys. is an approach for a different requirement: Shared dimensions provide consistent slicing across multiple facts when relationships are correctly modeled. In the present case, typed dates support correct chronological comparisons; lexical string ordering does not.
A project lead asks for all governed datasets already available to the team before making new copies. Which implementation decision best addresses the stated requirement?
Catalog discovery exposes accessible organizational data assets without first moving their contents. The proposed action directly targets the problem described in the scenario.
Use OneLake catalog for analytical items and Real-Time hub for live streams, matching the resource type. is an approach for a different requirement: Different discovery surfaces are optimized for stored analytical assets and continuously arriving events. In the present case, catalog discovery exposes accessible organizational data assets without first moving their contents.
Inspect source schema, connector settings and ingestion logs before rewriting downstream model measures. is an approach for a different requirement: Ingestion failures after source changes are often schema-contract issues, not report calculation problems. In the present case, catalog discovery exposes accessible organizational data assets without first moving their contents.
Use a supported OneLake shortcut where access and data format are compatible. is an approach for a different requirement: Shortcuts expose referenced data through OneLake without requiring a full duplicate copy. In the present case, catalog discovery exposes accessible organizational data assets without first moving their contents.
An analytics store receives hundreds of duplicate line items and users only need totals per product and month. The team plans to implement this change: Group by the desired grain and calculate SUM or COUNT aggregations. Which result best verifies the intended outcome?
Aggregations reduce detail at a documented grain and support efficient summaries. This evidence exercises the actual success condition rather than only confirming that a resource exists.
That observation would verify a different goal: The order amount totals reconcile after the shipment information is attached. It does not demonstrate the specific required result: Summed monthly totals reconcile to the detailed source fact rows.
That observation would verify a different goal: A selected day's summary equals the aggregate of underlying raw rows. It does not demonstrate the specific required result: Summed monthly totals reconcile to the detailed source fact rows.
That observation would verify a different goal: The new date field matches source timestamps for boundary cases and the intended timezone. It does not demonstrate the specific required result: Summed monthly totals reconcile to the detailed source fact rows.
A device operations dashboard queries streaming logs using a SQL GROUP BY against a KQL database. The team plans to implement this change: Write a KQL query with a datetime filter and summarize by a suitable category. Which result best verifies the intended outcome?
KQL supports time-aware event exploration and summarize aggregations on KQL data. This evidence exercises the actual success condition rather than only confirming that a resource exists.
That observation would verify a different goal: The generated query returns the expected monthly totals and selected columns. It does not demonstrate the specific required result: A query returns only events inside the defined one-hour window and correct category counts.
That observation would verify a different goal: A monthly selection returns the correct prior-year comparable amount. It does not demonstrate the specific required result: A query returns only events inside the defined one-hour window and correct category counts.
That observation would verify a different goal: The result contains one count per hour and totals reconcile to the raw events. It does not demonstrate the specific required result: A query returns only events inside the defined one-hour window and correct category counts.
The company wants a warehouse enrichment step before its BI model is published. The team plans to implement this change: Create a typed derived expression for revenue minus cost in the transformation layer. Which result best verifies the intended outcome?
A consistent derived column makes the business calculation reusable at the intended grain. This evidence exercises the actual success condition rather than only confirming that a resource exists.
That observation would verify a different goal: Known test names produce the agreed display format even when middle names are absent. It does not demonstrate the specific required result: A test row with known revenue and cost yields the correct gross margin value.
That observation would verify a different goal: The report groups all known country synonyms into the single approved code. It does not demonstrate the specific required result: A test row with known revenue and cost yields the correct gross margin value.
That observation would verify a different goal: The transformed output contains one row per intended nested item with all parent keys retained. It does not demonstrate the specific required result: A test row with known revenue and cost yields the correct gross margin value.
Please check your mailbox for a message from support@examlabs.com and follow the directions.
