Question 370
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A warehouse analyst must query an external SQL source using an approved cloud connector. (2) A gateway-based source works for one developer but fails when a scheduled service job runs. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (2) Verify gateway mapping and the scheduled execution identity's data source authorization.
- (1) Create a Fabric connection with the supported source type and authorized credentials. | (2) Validate connection encryption and certificate trust for the updated source endpoint.
- (1) Standardize on an approved reusable Fabric connection where supported. | (2) Verify gateway mapping and the scheduled execution identity's data source authorization.
- (1) Create a Fabric connection with the supported source type and authorized credentials. | (2) Verify gateway mapping and the scheduled execution identity's data source authorization.
Explanation
Correct Answer
D:Requirement 1: A connection specifies source endpoint and authentication information for governed reuse. Requirement 2: Interactive success does not prove that the unattended job has equivalent access. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: A connection specifies source endpoint and authentication information for governed reuse. The substituted action, Move credentials into approved managed connections or secret storage and rotate the exposed secret., is suited to a different situation: An engineer stores a production database password as a literal in a notebook committed to Git. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Interactive success does not prove that the unattended job has equivalent access. The substituted action, Validate connection encryption and certificate trust for the updated source endpoint., is suited to a different situation: A connector returns encrypted-transport errors after a database certificate changes. It does not satisfy the specified requirement 2.
C:Misses requirement 1: A connection specifies source endpoint and authentication information for governed reuse. The substituted action, Standardize on an approved reusable Fabric connection where supported., is suited to a different situation: An analytics workspace has several datasets using separate copies of the same connection settings. It does not satisfy the specified requirement 1.
Question 371
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An analyst cannot tell which of several similarly named datasets is the endorsed financial source. (2) A BI engineer wants to discover lakehouse tables without copying their data into a local folder. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Check asset refresh history and data quality independently of catalog endorsement. | (2) Browse the authorized Fabric lakehouse and OneLake catalog assets.
- (1) Search the OneLake catalog and inspect item ownership and endorsements. | (2) Browse the authorized Fabric lakehouse and OneLake catalog assets.
- (1) Evaluate the item's access grants and OneLake data permissions separately from discovery. | (2) Browse the authorized Fabric lakehouse and OneLake catalog assets.
- (1) Search the OneLake catalog and inspect item ownership and endorsements. | (2) Publish meaningful item names, descriptions, ownership and endorsement metadata.
Explanation
Correct Answer
B:Requirement 1: Catalog metadata and endorsement help locate the intended governed data product. Requirement 2: Data discovery should precede unnecessary duplication of a managed dataset. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Catalog metadata and endorsement help locate the intended governed data product. The substituted action, Check asset refresh history and data quality independently of catalog endorsement., is suited to a different situation: An engineer opens a catalog and assumes an endorsement badge indicates latest successful refresh. It does not satisfy the specified requirement 1.
C:Misses requirement 1: Catalog metadata and endorsement help locate the intended governed data product. The substituted action, Evaluate the item's access grants and OneLake data permissions separately from discovery., is suited to a different situation: A team sees a catalog entry but its table is not readable under the user's identity. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Data discovery should precede unnecessary duplication of a managed dataset. The substituted action, Publish meaningful item names, descriptions, ownership and endorsement metadata., is suited to a different situation: A data steward wants consumers to find a trusted data product using consistent terminology. It does not satisfy the specified requirement 2.
Question 372
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An operations analyst needs to discover approved live event streams already available in Fabric. (2) A reporting requirement depends on second-level telemetry but the engineer selects a nightly CSV export. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Inspect Real-Time hub event source metadata and the producing contract. | (2) Evaluate a streaming event source available through Real-Time hub and its freshness contract.
- (1) Use Real-Time hub to locate the supported streams and event sources. | (2) Route an eligible event source into an Eventhouse or KQL database.
- (1) Apply source authorization and data-access controls before granting stream access. | (2) Evaluate a streaming event source available through Real-Time hub and its freshness contract.
- (1) Use Real-Time hub to locate the supported streams and event sources. | (2) Evaluate a streaming event source available through Real-Time hub and its freshness contract.
Explanation
Correct Answer
D:Requirement 1: Real-Time hub provides a discovery surface for streaming data sources. Requirement 2: A batch snapshot cannot satisfy continuous event-arrival latency. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Real-Time hub provides a discovery surface for streaming data sources. The substituted action, Inspect Real-Time hub event source metadata and the producing contract., is suited to a different situation: A streaming feed is present but the analyst cannot identify its event schema or owner. It does not satisfy the specified requirement 1.
B:Misses requirement 2: A batch snapshot cannot satisfy continuous event-arrival latency. The substituted action, Route an eligible event source into an Eventhouse or KQL database., is suited to a different situation: An events team wants to query continuously ingested sensor records with KQL. It does not satisfy the specified requirement 2.
C:Misses requirement 1: Real-Time hub provides a discovery surface for streaming data sources. The substituted action, Apply source authorization and data-access controls before granting stream access., is suited to a different situation: A published Real-Time hub stream contains restricted data and a user assumes discovery means unrestricted subscription. It does not satisfy the specified requirement 1.
Question 373
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A product team wants to analyze an existing Delta table owned by another Fabric workspace without copying it. (2) A shortcut points to an external object store but users are unexpectedly denied file access. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review supported shortcut write semantics and enforce approved source-owner change policy. | (2) Validate the shortcut connection identity and effective target storage permissions.
- (1) Create an authorized OneLake shortcut to the source table or folder. | (2) Validate the shortcut connection identity and effective target storage permissions.
- (1) Explain that a shortcut references source data and plan separate snapshots if immutability is needed. | (2) Validate the shortcut connection identity and effective target storage permissions.
- (1) Create an authorized OneLake shortcut to the source table or folder. | (2) Inspect shortcut definitions and original source ownership during catalog review.
Explanation
Correct Answer
B:Requirement 1: Shortcuts expose referenced data paths while avoiding a second physical copy. Requirement 2: Virtualized paths depend on authorization to the actual backing storage. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Shortcuts expose referenced data paths while avoiding a second physical copy. The substituted action, Review supported shortcut write semantics and enforce approved source-owner change policy., is suited to a different situation: An analytics pipeline writes modifications into a shortcut path and threatens source governance. It does not satisfy the specified requirement 1.
C:Misses requirement 1: Shortcuts expose referenced data paths while avoiding a second physical copy. The substituted action, Explain that a shortcut references source data and plan separate snapshots if immutability is needed., is suited to a different situation: A source table updates but consumers assume a shortcut creates an independent point-in-time snapshot. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Virtualized paths depend on authorization to the actual backing storage. The substituted action, Inspect shortcut definitions and original source ownership during catalog review., is suited to a different situation: A data steward wants to know which OneLake tables are shortcuts to another owner. It does not satisfy the specified requirement 2.
Question 374
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A PySpark engineering team needs flexible Delta ingestion and notebook transformations over files. (2) A finance team uses relational SQL modeling and stored procedures for a dimensional reporting store. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use a lakehouse with a clear Files and Tables organization. | (2) Choose a Fabric warehouse for the supported T-SQL warehouse workflow.
- (1) Choose a Fabric lakehouse for Spark-oriented Delta and file workloads. | (2) Match the relational dimensional workload to a warehouse or lakehouse instead.
- (1) Use a compatible Spark lakehouse or notebook for Spark-specific transformations. | (2) Choose a Fabric warehouse for the supported T-SQL warehouse workflow.
- (1) Choose a Fabric lakehouse for Spark-oriented Delta and file workloads. | (2) Choose a Fabric warehouse for the supported T-SQL warehouse workflow.
Explanation
Correct Answer
D:Requirement 1: Lakehouses combine OneLake tables and files with Spark-centric engineering workflows. Requirement 2: Warehouses are optimized for relational SQL analytics and supported database objects. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Lakehouses combine OneLake tables and files with Spark-centric engineering workflows. The substituted action, Use a lakehouse with a clear Files and Tables organization., is suited to a different situation: A team wants to retain raw binary source files alongside curated Delta tables for exploration. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Warehouses are optimized for relational SQL analytics and supported database objects. The substituted action, Match the relational dimensional workload to a warehouse or lakehouse instead., is suited to a different situation: An architect selects Eventhouse to store all financial dimensional tables without an event-analytics need. It does not satisfy the specified requirement 2.
C:Misses requirement 1: Lakehouses combine OneLake tables and files with Spark-centric engineering workflows. The substituted action, Use a compatible Spark lakehouse or notebook for Spark-specific transformations., is suited to a different situation: A warehouse user expects a full Spark notebook environment inside the T-SQL editor. It does not satisfy the specified requirement 1.
Question 375
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A factory produces millions of timestamped machine readings and analysts need low-latency time filtering. (2) A team ingests event records but assumes SQL stored procedures are the standard KQL database transformation interface. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Evaluate supported OneLake integration for Eventhouse data or semantic consumption. | (2) Choose KQL operators and supported update policies for event analytics.
- (1) Use an Eventhouse KQL database suited to telemetry queries. | (2) Choose KQL operators and supported update policies for event analytics.
- (1) Use a suitable KQL transformation or update-policy pattern while preserving raw source as required. | (2) Choose KQL operators and supported update policies for event analytics.
- (1) Use an Eventhouse KQL database suited to telemetry queries. | (2) Push selective time and severity predicates into the KQL query.
Explanation
Correct Answer
B:Requirement 1: KQL storage and indexing support operational time-series exploration. Requirement 2: KQL databases have different query and transformation semantics from T-SQL warehouses. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: KQL storage and indexing support operational time-series exploration. The substituted action, Evaluate supported OneLake integration for Eventhouse data or semantic consumption., is suited to a different situation: An event dataset needs to be visible to a semantic model without an unnecessary exported CSV copy. It does not satisfy the specified requirement 1.
C:Misses requirement 1: KQL storage and indexing support operational time-series exploration. The substituted action, Use a suitable KQL transformation or update-policy pattern while preserving raw source as required., is suited to a different situation: A developer must retain raw event details while creating a reusable normalized event representation. It does not satisfy the specified requirement 1.
D:Misses requirement 2: KQL databases have different query and transformation semantics from T-SQL warehouses. The substituted action, Push selective time and severity predicates into the KQL query., is suited to a different situation: A KQL query returns enormous results and an operator wants to inspect only recent high-severity events. It does not satisfy the specified requirement 2.
Question 376
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An internal SQL database must be copied nightly into a Fabric lakehouse for downstream transformations. (2) A pipeline reports success but a source export was only partially delivered. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Define explicit pipeline dependencies between Copy and notebook tasks. | (2) Compare landed counts and reconciliation evidence before promoting the output.
- (1) Configure a supported Fabric pipeline Copy activity with scheduling and validation. | (2) Add controlled retry and idempotent sink logic to the pipeline design.
- (1) Configure an eligible gateway or managed connectivity path for that source. | (2) Compare landed counts and reconciliation evidence before promoting the output.
- (1) Configure a supported Fabric pipeline Copy activity with scheduling and validation. | (2) Compare landed counts and reconciliation evidence before promoting the output.
Explanation
Correct Answer
D:Requirement 1: Data Factory pipelines orchestrate repeatable bounded source-to-target transfers. Requirement 2: Task success does not establish that the business extract was complete. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Data Factory pipelines orchestrate repeatable bounded source-to-target transfers. The substituted action, Define explicit pipeline dependencies between Copy and notebook tasks., is suited to a different situation: A data engineer wants a transformation notebook to run only after ingestion has finished. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Task success does not establish that the business extract was complete. The substituted action, Add controlled retry and idempotent sink logic to the pipeline design., is suited to a different situation: A scheduled copy fails intermittently and an engineer manually reruns it with duplicate output rows. It does not satisfy the specified requirement 2.
C:Misses requirement 1: Data Factory pipelines orchestrate repeatable bounded source-to-target transfers. The substituted action, Configure an eligible gateway or managed connectivity path for that source., is suited to a different situation: A pipeline accesses an on-premises source available only through approved network infrastructure. It does not satisfy the specified requirement 1.
Question 377
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) Business analysts want to ingest several CSV exports and standardize columns through a visual transformation interface. (2) A Power Query step casts a locale-specific date incorrectly and the dataflow writes nulls. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Centralize the supported transformations in a governed Dataflow Gen2 asset. | (2) Set the appropriate data type and locale conversion before loading the target.
- (1) Use Dataflow Gen2 with suitable Power Query transformations and an approved destination. | (2) Set the appropriate data type and locale conversion before loading the target.
- (1) Apply stable source keys and an idempotent load or deduplication strategy. | (2) Set the appropriate data type and locale conversion before loading the target.
- (1) Use Dataflow Gen2 with suitable Power Query transformations and an approved destination. | (2) Check the destination schema, connection credentials and write privileges.
Explanation
Correct Answer
B:Requirement 1: Dataflow Gen2 provides low-code shaping of supported source data. Requirement 2: Parsing rules must match source format rather than accepting silent type corruption. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Dataflow Gen2 provides low-code shaping of supported source data. The substituted action, Centralize the supported transformations in a governed Dataflow Gen2 asset., is suited to a different situation: A pipeline needs a reusable curated query but operators duplicated its M steps in every report. It does not satisfy the specified requirement 1.
C:Misses requirement 1: Dataflow Gen2 provides low-code shaping of supported source data. The substituted action, Apply stable source keys and an idempotent load or deduplication strategy., is suited to a different situation: A dataflow appends the same weekly extract twice after an operator replay. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Parsing rules must match source format rather than accepting silent type corruption. The substituted action, Check the destination schema, connection credentials and write privileges., is suited to a different situation: A Dataflow Gen2 transformation succeeds in preview but fails when publishing to a destination. It does not satisfy the specified requirement 2.
Question 378
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An analytics model needs direct access to eligible Delta tables with low-latency updates and no traditional Import copy. (2) An analyst expects a model to include a KQL stream directly without supported integration. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Add and validate the desired semantic model tables and relationships explicitly. | (2) Identify an eligible Eventhouse-to-OneLake or supported semantic connection path.
- (1) Evaluate Direct Lake integration with supported OneLake-backed tables. | (2) Review semantic model automatic updates and refresh or reframe behavior.
- (1) Prefer supported native OneLake and Direct Lake interfaces when they meet requirements. | (2) Identify an eligible Eventhouse-to-OneLake or supported semantic connection path.
- (1) Evaluate Direct Lake integration with supported OneLake-backed tables. | (2) Identify an eligible Eventhouse-to-OneLake or supported semantic connection path.
Explanation
Correct Answer
D:Requirement 1: Direct Lake queries Delta-backed columns without a full scheduled Import processing copy. Requirement 2: Source-to-model compatibility determines which event data can be consumed. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Direct Lake queries Delta-backed columns without a full scheduled Import processing copy. The substituted action, Add and validate the desired semantic model tables and relationships explicitly., is suited to a different situation: A modeling team connects a semantic model to a lakehouse but assumes every new source table is automatically modeled. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Source-to-model compatibility determines which event data can be consumed. The substituted action, Review semantic model automatic updates and refresh or reframe behavior., is suited to a different situation: A Direct Lake table updates in Delta but a user still sees an older framed version. It does not satisfy the specified requirement 2.
C:Misses requirement 1: Direct Lake queries Delta-backed columns without a full scheduled Import processing copy. The substituted action, Prefer supported native OneLake and Direct Lake interfaces when they meet requirements., is suited to a different situation: An integration proposal suggests converting all Delta source tables into CSV before building reports. It does not satisfy the specified requirement 1.
Question 379
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A scheduled data refresh fails after the original employee owner leaves the company. (2) An on-premises SQL connection works on the author's laptop but fails from Fabric cloud execution. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Inspect gateway and connection health before rewriting semantic calculations. | (2) Configure the supported on-premises data gateway and its data source mapping.
- (1) Replace person-bound authentication with an approved stable service identity where supported. | (2) Configure the supported on-premises data gateway and its data source mapping.
- (1) Update the governed shared connection credentials and test dependent items. | (2) Configure the supported on-premises data gateway and its data source mapping.
- (1) Replace person-bound authentication with an approved stable service identity where supported. | (2) Verify least-privilege database grants for the actual connection principal.
Explanation
Correct Answer
B:Requirement 1: Shared production refreshes should not rely on an employee's account lifecycle. Requirement 2: Fabric cloud execution requires an approved route to private on-premises systems. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Shared production refreshes should not rely on an employee's account lifecycle. The substituted action, Inspect gateway and connection health before rewriting semantic calculations., is suited to a different situation: A source connection intermittently fails during a gateway upgrade and users blame model DAX. It does not satisfy the specified requirement 1.
C:Misses requirement 1: Shared production refreshes should not rely on an employee's account lifecycle. The substituted action, Update the governed shared connection credentials and test dependent items., is suited to a different situation: A source password rotates and several downstream refresh tasks fail together. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Fabric cloud execution requires an approved route to private on-premises systems. The substituted action, Verify least-privilege database grants for the actual connection principal., is suited to a different situation: An administrator grants a gateway operator broad database permissions to fix an access error. It does not satisfy the specified requirement 2.
Question 380
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A reporting team repeats the same approved join in many warehouse queries and wants a reusable read interface. (2) A finance calculation returns a scalar tax category based on customer region in many SQL queries. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Define a suitable warehouse stored procedure with required execution privileges. | (2) Implement a supported SQL function when the scalar logic is appropriate.
- (1) Create a supported SQL view over the curated warehouse tables. | (2) Use a physical table or approved materialization workflow when persisted snapshots are required.
- (1) Verify procedure execution permissions and access to referenced objects. | (2) Implement a supported SQL function when the scalar logic is appropriate.
- (1) Create a supported SQL view over the curated warehouse tables. | (2) Implement a supported SQL function when the scalar logic is appropriate.
Explanation
Correct Answer
D:Requirement 1: Views centralize a reusable query definition without manually copying results. Requirement 2: Reusable functions can package common deterministic expressions for SQL consumers. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Views centralize a reusable query definition without manually copying results. The substituted action, Define a suitable warehouse stored procedure with required execution privileges., is suited to a different situation: An operations team needs a parameterized sequence of supported SQL updates run as one controlled operation. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Reusable functions can package common deterministic expressions for SQL consumers. The substituted action, Use a physical table or approved materialization workflow when persisted snapshots are required., is suited to a different situation: A developer writes a view and assumes its definition guarantees a materialized daily snapshot. It does not satisfy the specified requirement 2.
C:Misses requirement 1: Views centralize a reusable query definition without manually copying results. The substituted action, Verify procedure execution permissions and access to referenced objects., is suited to a different situation: A warehouse procedure works as an owner but fails under a service principal. It does not satisfy the specified requirement 1.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests