Question 650
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A warehouse analyst must query an external SQL source using an approved cloud connector. (2) An engineer stores a production database password as a literal in a notebook committed to Git. (3) An analytics workspace has several datasets using separate copies of the same connection settings. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Verify gateway mapping and the scheduled execution identity's data source authorization. | (2) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (3) Standardize on an approved reusable Fabric connection where supported.
- (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. | (3) Standardize on an approved reusable Fabric connection where supported.
- (1) Create a Fabric connection with the supported source type and authorized credentials. | (2) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (3) 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) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (3) Standardize on an approved reusable Fabric connection where supported.
Explanation
Correct Answer
D:Requirement 1: A connection specifies source endpoint and authentication information for governed reuse. Requirement 2: Source code is not a secure place for long-lived production credentials. Requirement 3: Central connection ownership simplifies credential rotation and consistent configuration. 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, Verify gateway mapping and the scheduled execution identity's data source authorization., is suited to a different situation: A gateway-based source works for one developer but fails when a scheduled service job runs. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Source code is not a secure place for long-lived production credentials. 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 3: Central connection ownership simplifies credential rotation and consistent configuration. The substituted action, Verify gateway mapping and the scheduled execution identity's data source authorization., is suited to a different situation: A gateway-based source works for one developer but fails when a scheduled service job runs. It does not satisfy the specified requirement 3.
Question 651
A Microsoft Fabric analytics team faces 3 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 team sees a catalog entry but its table is not readable under the user's identity. (3) An engineer opens a catalog and assumes an endorsement badge indicates latest successful refresh. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Search the OneLake catalog and inspect item ownership and endorsements. | (2) Evaluate the item's access grants and OneLake data permissions separately from discovery. | (3) Browse the authorized Fabric lakehouse and OneLake catalog assets.
- (1) Search the OneLake catalog and inspect item ownership and endorsements. | (2) Evaluate the item's access grants and OneLake data permissions separately from discovery. | (3) Check asset refresh history and data quality independently of catalog endorsement.
- (1) Browse the authorized Fabric lakehouse and OneLake catalog assets. | (2) Evaluate the item's access grants and OneLake data permissions separately from discovery. | (3) Check asset refresh history and data quality independently of catalog endorsement.
- (1) Search the OneLake catalog and inspect item ownership and endorsements. | (2) Publish meaningful item names, descriptions, ownership and endorsement metadata. | (3) Check asset refresh history and data quality independently of catalog endorsement.
Explanation
Correct Answer
B:Requirement 1: Catalog metadata and endorsement help locate the intended governed data product. Requirement 2: Being able to discover metadata does not automatically authorize reading restricted rows. Requirement 3: Discoverability and freshness are different operational properties. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Discoverability and freshness are different operational properties. The substituted action, Browse the authorized Fabric lakehouse and OneLake catalog assets., is suited to a different situation: A BI engineer wants to discover lakehouse tables without copying their data into a local folder. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Catalog metadata and endorsement help locate the intended governed data product. The substituted action, Browse the authorized Fabric lakehouse and OneLake catalog assets., is suited to a different situation: A BI engineer wants to discover lakehouse tables without copying their data into a local folder. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Being able to discover metadata does not automatically authorize reading restricted rows. 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 652
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) An operations analyst needs to discover approved live event streams already available in Fabric. (2) A streaming feed is present but the analyst cannot identify its event schema or owner. (3) A published Real-Time hub stream contains restricted data and a user assumes discovery means unrestricted subscription. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Evaluate a streaming event source available through Real-Time hub and its freshness contract. | (2) Inspect Real-Time hub event source metadata and the producing contract. | (3) Apply source authorization and data-access controls before granting stream access.
- (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. | (3) Apply source authorization and data-access controls before granting stream access.
- (1) Use Real-Time hub to locate the supported streams and event sources. | (2) Inspect Real-Time hub event source metadata and the producing contract. | (3) 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) Inspect Real-Time hub event source metadata and the producing contract. | (3) Apply source authorization and data-access controls before granting stream access.
Explanation
Correct Answer
D:Requirement 1: Real-Time hub provides a discovery surface for streaming data sources. Requirement 2: Stream discovery needs schema and ownership verification before downstream transformations. Requirement 3: Visibility of a live source in a catalog is not an authorization bypass. 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, Evaluate a streaming event source available through Real-Time hub and its freshness contract., is suited to a different situation: A reporting requirement depends on second-level telemetry but the engineer selects a nightly CSV export. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Stream discovery needs schema and ownership verification before downstream transformations. 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 3: Visibility of a live source in a catalog is not an authorization bypass. The substituted action, Evaluate a streaming event source available through Real-Time hub and its freshness contract., is suited to a different situation: A reporting requirement depends on second-level telemetry but the engineer selects a nightly CSV export. It does not satisfy the specified requirement 3.
Question 653
A Microsoft Fabric analytics team faces 3 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 source table updates but consumers assume a shortcut creates an independent point-in-time snapshot. (3) An analytics pipeline writes modifications into a shortcut path and threatens source governance. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Create an authorized OneLake shortcut to the source table or folder. | (2) Explain that a shortcut references source data and plan separate snapshots if immutability is needed. | (3) Validate the shortcut connection identity and effective target storage permissions.
- (1) Create an authorized OneLake shortcut to the source table or folder. | (2) Explain that a shortcut references source data and plan separate snapshots if immutability is needed. | (3) Review supported shortcut write semantics and enforce approved source-owner change policy.
- (1) Validate the shortcut connection identity and effective target storage permissions. | (2) Explain that a shortcut references source data and plan separate snapshots if immutability is needed. | (3) Review supported shortcut write semantics and enforce approved source-owner change policy.
- (1) Create an authorized OneLake shortcut to the source table or folder. | (2) Inspect shortcut definitions and original source ownership during catalog review. | (3) Review supported shortcut write semantics and enforce approved source-owner change policy.
Explanation
Correct Answer
B:Requirement 1: Shortcuts expose referenced data paths while avoiding a second physical copy. Requirement 2: Shortcuts are references rather than automatic historical backups. Requirement 3: Access through a shortcut should not silently authorize modification of the original source. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Access through a shortcut should not silently authorize modification of the original source. The substituted action, Validate the shortcut connection identity and effective target storage permissions., is suited to a different situation: A shortcut points to an external object store but users are unexpectedly denied file access. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Shortcuts expose referenced data paths while avoiding a second physical copy. The substituted action, Validate the shortcut connection identity and effective target storage permissions., is suited to a different situation: A shortcut points to an external object store but users are unexpectedly denied file access. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Shortcuts are references rather than automatic historical backups. 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 654
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A PySpark engineering team needs flexible Delta ingestion and notebook transformations over files. (2) A team wants to retain raw binary source files alongside curated Delta tables for exploration. (3) A warehouse user expects a full Spark notebook environment inside the T-SQL editor. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Choose a Fabric warehouse for the supported T-SQL warehouse workflow. | (2) Use a lakehouse with a clear Files and Tables organization. | (3) Use a compatible Spark lakehouse or notebook for Spark-specific transformations.
- (1) Choose a Fabric lakehouse for Spark-oriented Delta and file workloads. | (2) Match the relational dimensional workload to a warehouse or lakehouse instead. | (3) Use a compatible Spark lakehouse or notebook for Spark-specific transformations.
- (1) Choose a Fabric lakehouse for Spark-oriented Delta and file workloads. | (2) Use a lakehouse with a clear Files and Tables organization. | (3) Choose a Fabric warehouse for the supported T-SQL warehouse workflow.
- (1) Choose a Fabric lakehouse for Spark-oriented Delta and file workloads. | (2) Use a lakehouse with a clear Files and Tables organization. | (3) Use a compatible Spark lakehouse or notebook for Spark-specific transformations.
Explanation
Correct Answer
D:Requirement 1: Lakehouses combine OneLake tables and files with Spark-centric engineering workflows. Requirement 2: Lakehouse Files and Tables support raw assets and managed analytical tables together. Requirement 3: SQL warehouse tools and Spark notebook runtimes expose different authoring capabilities. 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, Choose a Fabric warehouse for the supported T-SQL warehouse workflow., is suited to a different situation: A finance team uses relational SQL modeling and stored procedures for a dimensional reporting store. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Lakehouse Files and Tables support raw assets and managed analytical tables together. 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 3: SQL warehouse tools and Spark notebook runtimes expose different authoring capabilities. The substituted action, Choose a Fabric warehouse for the supported T-SQL warehouse workflow., is suited to a different situation: A finance team uses relational SQL modeling and stored procedures for a dimensional reporting store. It does not satisfy the specified requirement 3.
Question 655
A Microsoft Fabric analytics team faces 3 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 developer must retain raw event details while creating a reusable normalized event representation. (3) An event dataset needs to be visible to a semantic model without an unnecessary exported CSV copy. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Use an Eventhouse KQL database suited to telemetry queries. | (2) Use a suitable KQL transformation or update-policy pattern while preserving raw source as required. | (3) Choose KQL operators and supported update policies for event analytics.
- (1) Use an Eventhouse KQL database suited to telemetry queries. | (2) Use a suitable KQL transformation or update-policy pattern while preserving raw source as required. | (3) Evaluate supported OneLake integration for Eventhouse data or semantic consumption.
- (1) Choose KQL operators and supported update policies for event analytics. | (2) Use a suitable KQL transformation or update-policy pattern while preserving raw source as required. | (3) Evaluate supported OneLake integration for Eventhouse data or semantic consumption.
- (1) Use an Eventhouse KQL database suited to telemetry queries. | (2) Push selective time and severity predicates into the KQL query. | (3) Evaluate supported OneLake integration for Eventhouse data or semantic consumption.
Explanation
Correct Answer
B:Requirement 1: KQL storage and indexing support operational time-series exploration. Requirement 2: Ingestion transformations should be observable and consistent with event schema contracts. Requirement 3: Integration features can expose governed analytical data without manual file replication. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Integration features can expose governed analytical data without manual file replication. The substituted action, Choose KQL operators and supported update policies for event analytics., is suited to a different situation: A team ingests event records but assumes SQL stored procedures are the standard KQL database transformation interface. It does not satisfy the specified requirement 3.
C:Misses requirement 1: KQL storage and indexing support operational time-series exploration. The substituted action, Choose KQL operators and supported update policies for event analytics., is suited to a different situation: A team ingests event records but assumes SQL stored procedures are the standard KQL database transformation interface. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Ingestion transformations should be observable and consistent with event schema contracts. 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 656
A Microsoft Fabric analytics team faces 3 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 data engineer wants a transformation notebook to run only after ingestion has finished. (3) A pipeline accesses an on-premises source available only through approved network infrastructure. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Compare landed counts and reconciliation evidence before promoting the output. | (2) Define explicit pipeline dependencies between Copy and notebook tasks. | (3) Configure an eligible gateway or managed connectivity path for that source.
- (1) Configure a supported Fabric pipeline Copy activity with scheduling and validation. | (2) Add controlled retry and idempotent sink logic to the pipeline design. | (3) Configure an eligible gateway or managed connectivity path for that source.
- (1) Configure a supported Fabric pipeline Copy activity with scheduling and validation. | (2) Define explicit pipeline dependencies between Copy and notebook tasks. | (3) Compare landed counts and reconciliation evidence before promoting the output.
- (1) Configure a supported Fabric pipeline Copy activity with scheduling and validation. | (2) Define explicit pipeline dependencies between Copy and notebook tasks. | (3) Configure an eligible gateway or managed connectivity path for that source.
Explanation
Correct Answer
D:Requirement 1: Data Factory pipelines orchestrate repeatable bounded source-to-target transfers. Requirement 2: Dependency ordering prevents consumers from reading half-landed data. Requirement 3: Network reachability is a prerequisite to successful authenticated ingestion. 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, Compare landed counts and reconciliation evidence before promoting the output., is suited to a different situation: A pipeline reports success but a source export was only partially delivered. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Dependency ordering prevents consumers from reading half-landed data. 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 3: Network reachability is a prerequisite to successful authenticated ingestion. The substituted action, Compare landed counts and reconciliation evidence before promoting the output., is suited to a different situation: A pipeline reports success but a source export was only partially delivered. It does not satisfy the specified requirement 3.
Question 657
A Microsoft Fabric analytics team faces 3 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 dataflow appends the same weekly extract twice after an operator replay. (3) A pipeline needs a reusable curated query but operators duplicated its M steps in every report. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Use Dataflow Gen2 with suitable Power Query transformations and an approved destination. | (2) Apply stable source keys and an idempotent load or deduplication strategy. | (3) 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) Apply stable source keys and an idempotent load or deduplication strategy. | (3) Centralize the supported transformations in a governed Dataflow Gen2 asset.
- (1) Set the appropriate data type and locale conversion before loading the target. | (2) Apply stable source keys and an idempotent load or deduplication strategy. | (3) Centralize the supported transformations in a governed Dataflow Gen2 asset.
- (1) Use Dataflow Gen2 with suitable Power Query transformations and an approved destination. | (2) Check the destination schema, connection credentials and write privileges. | (3) Centralize the supported transformations in a governed Dataflow Gen2 asset.
Explanation
Correct Answer
B:Requirement 1: Dataflow Gen2 provides low-code shaping of supported source data. Requirement 2: Re-running an ingestion flow must not accidentally multiply source records. Requirement 3: Reusable transformation logic reduces drift between data consumers. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Reusable transformation logic reduces drift between data consumers. The substituted action, Set the appropriate data type and locale conversion before loading the target., is suited to a different situation: A Power Query step casts a locale-specific date incorrectly and the dataflow writes nulls. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Dataflow Gen2 provides low-code shaping of supported source data. The substituted action, Set the appropriate data type and locale conversion before loading the target., is suited to a different situation: A Power Query step casts a locale-specific date incorrectly and the dataflow writes nulls. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Re-running an ingestion flow must not accidentally multiply source records. 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 658
A Microsoft Fabric analytics team faces 3 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) A modeling team connects a semantic model to a lakehouse but assumes every new source table is automatically modeled. (3) An integration proposal suggests converting all Delta source tables into CSV before building reports. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Identify an eligible Eventhouse-to-OneLake or supported semantic connection path. | (2) Add and validate the desired semantic model tables and relationships explicitly. | (3) Prefer supported native OneLake and Direct Lake interfaces when they meet requirements.
- (1) Evaluate Direct Lake integration with supported OneLake-backed tables. | (2) Review semantic model automatic updates and refresh or reframe behavior. | (3) Prefer supported native OneLake and Direct Lake interfaces when they meet requirements.
- (1) Evaluate Direct Lake integration with supported OneLake-backed tables. | (2) Add and validate the desired semantic model tables and relationships explicitly. | (3) Identify an eligible Eventhouse-to-OneLake or supported semantic connection path.
- (1) Evaluate Direct Lake integration with supported OneLake-backed tables. | (2) Add and validate the desired semantic model tables and relationships explicitly. | (3) Prefer supported native OneLake and Direct Lake interfaces when they meet requirements.
Explanation
Correct Answer
D:Requirement 1: Direct Lake queries Delta-backed columns without a full scheduled Import processing copy. Requirement 2: Data existence in OneLake does not guarantee its inclusion in the model. Requirement 3: Native governed integration can avoid unnecessary extract copies and reduce staleness. 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, Identify an eligible Eventhouse-to-OneLake or supported semantic connection path., is suited to a different situation: An analyst expects a model to include a KQL stream directly without supported integration. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Data existence in OneLake does not guarantee its inclusion in the model. 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 3: Native governed integration can avoid unnecessary extract copies and reduce staleness. The substituted action, Identify an eligible Eventhouse-to-OneLake or supported semantic connection path., is suited to a different situation: An analyst expects a model to include a KQL stream directly without supported integration. It does not satisfy the specified requirement 3.
Question 659
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A scheduled data refresh fails after the original employee owner leaves the company. (2) A source password rotates and several downstream refresh tasks fail together. (3) A source connection intermittently fails during a gateway upgrade and users blame model DAX. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Replace person-bound authentication with an approved stable service identity where supported. | (2) Update the governed shared connection credentials and test dependent items. | (3) 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) Update the governed shared connection credentials and test dependent items. | (3) Inspect gateway and connection health before rewriting semantic calculations.
- (1) Configure the supported on-premises data gateway and its data source mapping. | (2) Update the governed shared connection credentials and test dependent items. | (3) Inspect gateway and connection health before rewriting semantic calculations.
- (1) Replace person-bound authentication with an approved stable service identity where supported. | (2) Verify least-privilege database grants for the actual connection principal. | (3) Inspect gateway and connection health before rewriting semantic calculations.
Explanation
Correct Answer
B:Requirement 1: Shared production refreshes should not rely on an employee's account lifecycle. Requirement 2: Centralized credential management simplifies restoring multiple consumers. Requirement 3: Transport and credentials must be ruled out before changing analytical logic. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Transport and credentials must be ruled out before changing analytical logic. The substituted action, Configure the supported on-premises data gateway and its data source mapping., is suited to a different situation: An on-premises SQL connection works on the author's laptop but fails from Fabric cloud execution. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Shared production refreshes should not rely on an employee's account lifecycle. The substituted action, Configure the supported on-premises data gateway and its data source mapping., is suited to a different situation: An on-premises SQL connection works on the author's laptop but fails from Fabric cloud execution. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Centralized credential management simplifies restoring multiple consumers. 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 660
A Microsoft Fabric analytics team faces 3 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) An operations team needs a parameterized sequence of supported SQL updates run as one controlled operation. (3) A warehouse procedure works as an owner but fails under a service principal. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Implement a supported SQL function when the scalar logic is appropriate. | (2) Define a suitable warehouse stored procedure with required execution privileges. | (3) Verify procedure execution permissions and access to referenced objects.
- (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. | (3) Verify procedure execution permissions and access to referenced objects.
- (1) Create a supported SQL view over the curated warehouse tables. | (2) Define a suitable warehouse stored procedure with required execution privileges. | (3) Implement a supported SQL function when the scalar logic is appropriate.
- (1) Create a supported SQL view over the curated warehouse tables. | (2) Define a suitable warehouse stored procedure with required execution privileges. | (3) Verify procedure execution permissions and access to referenced objects.
Explanation
Correct Answer
D:Requirement 1: Views centralize a reusable query definition without manually copying results. Requirement 2: Stored procedures encapsulate supported parameterized T-SQL operations. Requirement 3: Executing a stored procedure depends on both object grants and effective security context. 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, Implement a supported SQL function when the scalar logic is appropriate., is suited to a different situation: A finance calculation returns a scalar tax category based on customer region in many SQL queries. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Stored procedures encapsulate supported parameterized T-SQL operations. 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 3: Executing a stored procedure depends on both object grants and effective security context. The substituted action, Implement a supported SQL function when the scalar logic is appropriate., is suited to a different situation: A finance calculation returns a scalar tax category based on customer region in many SQL queries. It does not satisfy the specified requirement 3.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests