Question 460
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A report exposes restricted PII columns when analysts need only revenue totals. (2) A Spark transformation filters by local server date instead of UTC event date and drops midnight transactions. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Project only the approved columns and apply data security to the source. | (2) Normalize temporal boundaries and filter against the intended business timezone.
- (1) Push an appropriate date filter before expensive joins and aggregation. | (2) Normalize temporal boundaries and filter against the intended business timezone.
- (1) Project only the approved columns and apply data security to the source. | (2) Normalize approved status case or use suitable collation semantics before filtering.
- (1) Parenthesize the intended logical predicates and test boundary rows. | (2) Normalize temporal boundaries and filter against the intended business timezone.
Explanation
Correct Answer
A:Requirement 1: Column minimization reduces data movement but does not replace authorization. Requirement 2: Date filters need consistent event-time interpretation. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Column minimization reduces data movement but does not replace authorization. The substituted action, Push an appropriate date filter before expensive joins and aggregation., is suited to a different situation: An analytics query scans all transaction years although only last week's records are required. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Date filters need consistent event-time interpretation. The substituted action, Normalize approved status case or use suitable collation semantics before filtering., is suited to a different situation: A dataflow uses a case-sensitive comparison but source statuses differ only by capitalization. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Column minimization reduces data movement but does not replace authorization. The substituted action, Parenthesize the intended logical predicates and test boundary rows., is suited to a different situation: A SQL WHERE condition combines `AND` and `OR` and incorrectly includes unapproved customer types. It does not satisfy the specified requirement 1.
Question 461
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A pipeline restarts after a partial failure and applies the same incremental batch twice. (2) An upsert receives a delete event but the target table retains the obsolete row. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use idempotent merge logic and persisted source progress state. | (2) Include trusted source namespace and entity key in the match predicate.
- (1) Coordinate backfill boundaries and source sequence ordering before applying changes. | (2) Handle source delete semantics explicitly in the CDC merge contract.
- (1) Use idempotent merge logic and persisted source progress state. | (2) Handle source delete semantics explicitly in the CDC merge contract.
- (1) Use a governed MERGE or supported CDC apply pattern keyed by source identity. | (2) Handle source delete semantics explicitly in the CDC merge contract.
Explanation
Correct Answer
C:Requirement 1: Replay safety protects business totals from duplicate side effects. Requirement 2: Inserts and updates alone cannot represent removals from the source. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Inserts and updates alone cannot represent removals from the source. The substituted action, Include trusted source namespace and entity key in the match predicate., is suited to a different situation: A warehouse MERGE update uses an ambiguous business key shared by independent vendors. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Replay safety protects business totals from duplicate side effects. The substituted action, Coordinate backfill boundaries and source sequence ordering before applying changes., is suited to a different situation: A historical backfill starts before the current CDC watermark and overwrites newer target values. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Replay safety protects business totals from duplicate side effects. The substituted action, Use a governed MERGE or supported CDC apply pattern keyed by source identity., is suited to a different situation: A dimension receives inserts and updates from a CDC feed and append-only writes create duplicate keys. It does not satisfy the specified requirement 1.
Question 462
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A researcher wants Python and Spark operations over large nested Delta data. (2) A team writes a `CREATE TABLE AS SELECT` query against a lakehouse SQL analytics endpoint and expects a writable warehouse. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use a lakehouse notebook and PySpark transformation path. | (2) Choose the supported writable warehouse or Spark pathway for the intended operation.
- (1) Run the transformation in the Fabric warehouse SQL environment. | (2) Choose the supported writable warehouse or Spark pathway for the intended operation.
- (1) Use a lakehouse notebook and PySpark transformation path. | (2) Use the supported lakehouse SQL analytics endpoint for compatible querying.
- (1) Designate an authoritative transformation owner and govern the produced gold table. | (2) Choose the supported writable warehouse or Spark pathway for the intended operation.
Explanation
Correct Answer
A:Requirement 1: Spark is suited to programmatic distributed processing of semi-structured tables. Requirement 2: Read-oriented SQL analytics endpoints and warehouse SQL authoring have different write capabilities. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Spark is suited to programmatic distributed processing of semi-structured tables. The substituted action, Run the transformation in the Fabric warehouse SQL environment., is suited to a different situation: A modeler needs supported T-SQL stored procedures over a relational dimensional warehouse. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Read-oriented SQL analytics endpoints and warehouse SQL authoring have different write capabilities. The substituted action, Use the supported lakehouse SQL analytics endpoint for compatible querying., is suited to a different situation: An ETL job produces Delta tables through Spark but analysts need read-only T-SQL exploration. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Spark is suited to programmatic distributed processing of semi-structured tables. The substituted action, Designate an authoritative transformation owner and govern the produced gold table., is suited to a different situation: A business wants one published gold table and two engineering teams each materialize inconsistent transformations. It does not satisfy the specified requirement 1.
Question 463
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A data consumer needs the sum of invoiced revenue grouped by product category through a GUI. (2) A graphical query returns unexpected rows because a filter was applied to the wrong field. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Add a grouped aggregate in the Visual query editor. | (2) Use an eligible visual join or relationship operation and validate join keys.
- (1) Materialize results with a supported persistence workflow if point-in-time storage is required. | (2) Inspect the editor's generated logic and correct the filter field and operator.
- (1) Add a grouped aggregate in the Visual query editor. | (2) Inspect the editor's generated logic and correct the filter field and operator.
- (1) Use the supported Visual query editor to apply interactive filters. | (2) Inspect the editor's generated logic and correct the filter field and operator.
Explanation
Correct Answer
C:Requirement 1: Grouping and aggregation can be composed visually for common analytical questions. Requirement 2: Visual authoring still requires checking the effective predicate semantics. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Visual authoring still requires checking the effective predicate semantics. The substituted action, Use an eligible visual join or relationship operation and validate join keys., is suited to a different situation: An analyst wants to compare two governed tables interactively without copying either into Excel. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Grouping and aggregation can be composed visually for common analytical questions. The substituted action, Materialize results with a supported persistence workflow if point-in-time storage is required., is suited to a different situation: A team assumes a saved visual query is a durable physical table snapshot. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Grouping and aggregation can be composed visually for common analytical questions. The substituted action, Use the supported Visual query editor to apply interactive filters., is suited to a different situation: A citizen analyst wants to filter a Fabric warehouse table without writing a SQL statement. It does not satisfy the specified requirement 1.
Question 464
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A manager wants departments with total sales above an aggregate threshold. (2) A SQL result displays individual product names but uses SUM without grouping them. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use GROUP BY followed by HAVING on the aggregate. | (2) Add the intended GROUP BY columns or restructure the aggregation.
- (1) Apply the date condition in SQL WHERE before GROUP BY. | (2) Add the intended GROUP BY columns or restructure the aggregation.
- (1) Use GROUP BY followed by HAVING on the aggregate. | (2) Select the region column with DISTINCT where appropriate.
- (1) Sort the aggregate descending and apply a supported top-row limit. | (2) Add the intended GROUP BY columns or restructure the aggregation.
Explanation
Correct Answer
A:Requirement 1: HAVING filters grouped results rather than individual source rows. Requirement 2: Nonaggregated selected columns must be compatible with the grouping semantics. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: HAVING filters grouped results rather than individual source rows. The substituted action, Apply the date condition in SQL WHERE before GROUP BY., is suited to a different situation: A sales analyst wants only transactions from the last quarter before computing sums. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Nonaggregated selected columns must be compatible with the grouping semantics. The substituted action, Select the region column with DISTINCT where appropriate., is suited to a different situation: A query needs unique regions represented in a customer table rather than every repeated row. It does not satisfy the specified requirement 2.
D:Misses requirement 1: HAVING filters grouped results rather than individual source rows. The substituted action, Sort the aggregate descending and apply a supported top-row limit., is suited to a different situation: A report needs the ten largest revenue customers after aggregation. It does not satisfy the specified requirement 1.
Question 465
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A model requires the latest shipment per order without relying on arbitrary first-row selection. (2) A product manager needs current-month revenue compared with the prior month in SQL. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use ROW_NUMBER over order partitions with a deterministic descending timestamp and tie-breaker. | (2) Specify the correct ORDER BY columns in the window definition.
- (1) Divide the regional SUM by a windowed SUM over the complete summary. | (2) Use an appropriate LAG window after aggregating monthly totals.
- (1) Use ROW_NUMBER over order partitions with a deterministic descending timestamp and tie-breaker. | (2) Use an appropriate LAG window after aggregating monthly totals.
- (1) Use a SQL window SUM partitioned by customer and ordered by transaction time. | (2) Use an appropriate LAG window after aggregating monthly totals.
Explanation
Correct Answer
C:Requirement 1: Window ranking identifies a stable preferred row in each business group. Requirement 2: Window offset functions compare adjacent ordered summary periods. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Window offset functions compare adjacent ordered summary periods. The substituted action, Specify the correct ORDER BY columns in the window definition., is suited to a different situation: A report accidentally uses ROW_NUMBER without ordering and declares results reproducible. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Window ranking identifies a stable preferred row in each business group. The substituted action, Divide the regional SUM by a windowed SUM over the complete summary., is suited to a different situation: A SQL analyst wants each region's contribution percentage of all revenue while retaining region rows. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Window ranking identifies a stable preferred row in each business group. The substituted action, Use a SQL window SUM partitioned by customer and ordered by transaction time., is suited to a different situation: A finance analyst wants each transaction alongside its customer's running spending total. It does not satisfy the specified requirement 1.
Question 466
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An incident analyst wants only timestamp, host and message columns from a verbose telemetry table. (2) An event query returns case-mismatched service names and the analyst uses the wrong KQL string operator. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Apply KQL `project` to select the required fields. | (2) Choose the intended case-sensitive or case-insensitive KQL comparison operator.
- (1) Use KQL `where` conditions on timestamp, service and severity. | (2) Choose the intended case-sensitive or case-insensitive KQL comparison operator.
- (1) Apply KQL `project` to select the required fields. | (2) Extract the dynamic property and convert it to the expected scalar type.
- (1) Rewrite the request with the supported KQL pipe operators and `take` or `top`. | (2) Choose the intended case-sensitive or case-insensitive KQL comparison operator.
Explanation
Correct Answer
A:Requirement 1: Projection reduces irrelevant columns and improves output readability. Requirement 2: KQL string operators encode case semantics that affect matching. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Projection reduces irrelevant columns and improves output readability. The substituted action, Use KQL `where` conditions on timestamp, service and severity., is suited to a different situation: A support team needs error events from one service over the last 24 hours in Eventhouse. It does not satisfy the specified requirement 1.
C:Misses requirement 2: KQL string operators encode case semantics that affect matching. The substituted action, Extract the dynamic property and convert it to the expected scalar type., is suited to a different situation: A telemetry table contains a JSON-like dynamic property bag and users need its error code. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Projection reduces irrelevant columns and improves output readability. The substituted action, Rewrite the request with the supported KQL pipe operators and `take` or `top`., is suited to a different situation: An analyst tries to execute T-SQL `SELECT TOP` syntax directly in a KQL-only query interface. It does not satisfy the specified requirement 1.
Question 467
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An operations team needs an average temperature for each device over one-hour intervals. (2) A query shows a spike but the team needs to exclude missing measurement values from its mean. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Apply KQL summarize with `avg()` and a one-hour time bin per device. | (2) Calculate failures and total events per day then divide with appropriate numeric conversion.
- (1) Generate or align the required time bins and fill absence deliberately. | (2) Filter invalid or null measurements before computing a KQL average.
- (1) Apply KQL summarize with `avg()` and a one-hour time bin per device. | (2) Filter invalid or null measurements before computing a KQL average.
- (1) Use KQL `summarize count()` with `bin(timestamp, 5m)` and facility. | (2) Filter invalid or null measurements before computing a KQL average.
Explanation
Correct Answer
C:Requirement 1: Combining time bins and device groups yields meaningful time-series summaries. Requirement 2: Bad input records can distort aggregated sensor statistics. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Bad input records can distort aggregated sensor statistics. The substituted action, Calculate failures and total events per day then divide with appropriate numeric conversion., is suited to a different situation: An analyst wants to compare each day's failure rate rather than only total failures. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Combining time bins and device groups yields meaningful time-series summaries. The substituted action, Generate or align the required time bins and fill absence deliberately., is suited to a different situation: A KQL timeseries chart is missing zero-activity intervals and stakeholders infer no time passed. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Combining time bins and device groups yields meaningful time-series summaries. The substituted action, Use KQL `summarize count()` with `bin(timestamp, 5m)` and facility., is suited to a different situation: A sensor feed needs event counts in five-minute buckets grouped by facility. It does not satisfy the specified requirement 1.
Question 468
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A business KPI needs revenue for one approved sales channel regardless of the chart's other channel values. (2) A manager wants revenue share by category relative to all visible categories. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use CALCULATE with an explicit channel filter and validate filter interaction. | (2) Define a DAX denominator using an appropriate ALLSELECTED or context-removal function.
- (1) Define a DAX measure using SUM over the modeled revenue column. | (2) Define a DAX denominator using an appropriate ALLSELECTED or context-removal function.
- (1) Use CALCULATE with an explicit channel filter and validate filter interaction. | (2) Use SUMX over the relevant fact rows for row-wise multiplication.
- (1) Inspect CALCULATE filters and context-removal functions for unintended overrides. | (2) Define a DAX denominator using an appropriate ALLSELECTED or context-removal function.
Explanation
Correct Answer
A:Requirement 1: CALCULATE modifies evaluation context to constrain the measure. Requirement 2: Percent of visible total needs a deliberate denominator filter context. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: CALCULATE modifies evaluation context to constrain the measure. The substituted action, Define a DAX measure using SUM over the modeled revenue column., is suited to a different situation: A report needs total revenue that respects slicers and model relationships. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Percent of visible total needs a deliberate denominator filter context. The substituted action, Use SUMX over the relevant fact rows for row-wise multiplication., is suited to a different situation: A DAX measure sums each row's price times quantity but the fact table has no precomputed extended amount. It does not satisfy the specified requirement 2.
D:Misses requirement 1: CALCULATE modifies evaluation context to constrain the measure. The substituted action, Inspect CALCULATE filters and context-removal functions for unintended overrides., is suited to a different situation: A user filters the report to one year and a measure unexpectedly ignores the year slicer. It does not satisfy the specified requirement 1.
Question 469
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A DAX measure returns identical sales across every dimension row despite valid relationships. (2) A calculation needs a dimension value from the related one-side table for each fact row. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Inspect the filter propagation paths and any ALL or REMOVEFILTERS calls. | (2) Use USERELATIONSHIP within CALCULATE when the inactive shipping-date relationship is appropriate.
- (1) Use an appropriate COUNTROWS or DISTINCTCOUNT expression for the intended grain. | (2) Use an appropriate RELATED expression in a row context with a valid relationship.
- (1) Inspect the filter propagation paths and any ALL or REMOVEFILTERS calls. | (2) Use an appropriate RELATED expression in a row context with a valid relationship.
- (1) Use a measure for slicer-responsive calculations instead of a static calculated column. | (2) Use an appropriate RELATED expression in a row context with a valid relationship.
Explanation
Correct Answer
C:Requirement 1: Incorrect context or relationship direction can prevent row-level dimensional filters. Requirement 2: RELATED relies on relationships and row context rather than arbitrary text matching. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: RELATED relies on relationships and row context rather than arbitrary text matching. The substituted action, Use USERELATIONSHIP within CALCULATE when the inactive shipping-date relationship is appropriate., is suited to a different situation: A report contains two date relationships, one active and one inactive, and needs shipping-date revenue. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Incorrect context or relationship direction can prevent row-level dimensional filters. The substituted action, Use an appropriate COUNTROWS or DISTINCTCOUNT expression for the intended grain., is suited to a different situation: A DAX expression counts customers after a filter but an engineer uses COUNT on a nonnumeric text field incorrectly. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Incorrect context or relationship direction can prevent row-level dimensional filters. The substituted action, Use a measure for slicer-responsive calculations instead of a static calculated column., is suited to a different situation: A developer creates a calculated column expecting it to change with each report slicer. It does not satisfy the specified requirement 1.
Question 470
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An incident team needs subsecond exploratory filtering over timestamped Eventhouse telemetry. (2) A Power BI analyst wants a KPI evaluated under report slicers and semantic model relationships. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Choose KQL queries against the KQL database. | (2) Define the metric as a DAX measure in the semantic model.
- (1) Choose the supported T-SQL environment for warehouse relational querying. | (2) Define the metric as a DAX measure in the semantic model.
- (1) Choose KQL queries against the KQL database. | (2) Put the DAX logic in a semantic model or supported DAX query interface.
- (1) Translate the aggregation to KQL `summarize` syntax for Eventhouse. | (2) Define the metric as a DAX measure in the semantic model.
Explanation
Correct Answer
A:Requirement 1: KQL is optimized for event-stream and time-series analysis patterns. Requirement 2: DAX understands model filter context and report interactions. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: KQL is optimized for event-stream and time-series analysis patterns. The substituted action, Choose the supported T-SQL environment for warehouse relational querying., is suited to a different situation: An engineer needs transactional SQL joins and view definitions in a Fabric warehouse. It does not satisfy the specified requirement 1.
C:Misses requirement 2: DAX understands model filter context and report interactions. The substituted action, Put the DAX logic in a semantic model or supported DAX query interface., is suited to a different situation: A team tries to run a DAX `CALCULATE` expression as if it were a Fabric warehouse stored procedure. It does not satisfy the specified requirement 2.
D:Misses requirement 1: KQL is optimized for event-stream and time-series analysis patterns. The substituted action, Translate the aggregation to KQL `summarize` syntax for Eventhouse., is suited to a different situation: A developer copies a SQL `GROUP BY` query directly into KQL and gets parser errors. It does not satisfy the specified requirement 1.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests