Microsoft Fabric Data Engineer DP-700 Batch Stores, Transformation Engines Practice Test

 

Topic 06 covers batch stores, transformation engines, shortcuts and mirroring for Microsoft DP-700 practice. Study each scenario and select the best answer. For broader exam preparation, review the Microsoft DP-700 Exam Dumps page.

Question 1

A data engineer must correct a design for a healthcare operations workspace. The decisive requirement is that the solution needs Delta tables, files, notebooks, and Spark processing in one engineering workspace. Which choice best addresses it?

1. Use a OneLake shortcut when data should remain at its current location and be referenced without copying
2. Use a Lakehouse for Spark-centric open-table engineering
3. Use a Fabric Warehouse for relational T-SQL analytics and dimensional serving
4. Use Eventhouse for high-volume time-oriented event analytics
5. Use a mirrored database when an operational database must stay continuously available in Fabric without building custom ingestion

Correct Answer: B

Correct Answer

Answer B is correct because Lakehouse combines OneLake files/tables with Spark-oriented engineering access. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the source data is already in an accessible open location and duplication is undesirable. Specifically, shortcuts expose existing data through OneLake without moving the underlying data, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the primary consumers use SQL, relational schemas, and warehouse-style analytical modeling. Specifically, Warehouse is optimized for relational analytical workloads and T-SQL, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the workload is dominated by rapid event ingestion, KQL exploration, and time-series queries. Specifically, Eventhouse is designed for real-time event analytics and KQL, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the team wants an analytics-ready synchronized representation of an external database with minimal pipeline engineering. Specifically, mirroring brings the source database/catalog into Fabric and keeps it synchronized according to source support, which does not resolve the decisive condition in this scenario.

Question 2

For an IoT operations solution, the organization has fixed the following constraint: the primary consumers use SQL, relational schemas, and warehouse-style analytical modeling. Which action best satisfies the requirement?

1. Use Eventhouse for high-volume time-oriented event analytics
2. Use a mirrored database when an operational database must stay continuously available in Fabric without building custom ingestion
3. Use a OneLake shortcut when data should remain at its current location and be referenced without copying
4. Use a Lakehouse for Spark-centric open-table engineering
5. Use a Fabric Warehouse for relational T-SQL analytics and dimensional serving

Correct Answer: E

Correct Answer

Answer E is correct because Warehouse is optimized for relational analytical workloads and T-SQL. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the workload is dominated by rapid event ingestion, KQL exploration, and time-series queries. Specifically, Eventhouse is designed for real-time event analytics and KQL, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the team wants an analytics-ready synchronized representation of an external database with minimal pipeline engineering. Specifically, mirroring brings the source database/catalog into Fabric and keeps it synchronized according to source support, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the source data is already in an accessible open location and duplication is undesirable. Specifically, shortcuts expose existing data through OneLake without moving the underlying data, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the solution needs Delta tables, files, notebooks, and Spark processing in one engineering workspace. Specifically, Lakehouse combines OneLake files/tables with Spark-oriented engineering access, which does not resolve the decisive condition in this scenario.

Question 3

During an operational design review for a product usage analytics pipeline, engineers confirm that the workload is dominated by rapid event ingestion, KQL exploration, and time-series queries. What should they do?

1. Use a Lakehouse for Spark-centric open-table engineering
2. Use a Fabric Warehouse for relational T-SQL analytics and dimensional serving
3. Use Eventhouse for high-volume time-oriented event analytics
4. Use a mirrored database when an operational database must stay continuously available in Fabric without building custom ingestion
5. Use a OneLake shortcut when data should remain at its current location and be referenced without copying

Correct Answer: C

Correct Answer

Answer C is correct because Eventhouse is designed for real-time event analytics and KQL. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the solution needs Delta tables, files, notebooks, and Spark processing in one engineering workspace. Specifically, Lakehouse combines OneLake files/tables with Spark-oriented engineering access, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the primary consumers use SQL, relational schemas, and warehouse-style analytical modeling. Specifically, Warehouse is optimized for relational analytical workloads and T-SQL, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the team wants an analytics-ready synchronized representation of an external database with minimal pipeline engineering. Specifically, mirroring brings the source database/catalog into Fabric and keeps it synchronized according to source support, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the source data is already in an accessible open location and duplication is undesirable. Specifically, shortcuts expose existing data through OneLake without moving the underlying data, which does not resolve the decisive condition in this scenario.

Question 4

After a recent change in a customer-analytics environment, the team determines that the team wants an analytics-ready synchronized representation of an external database with minimal pipeline engineering. Which implementation should be selected?

1. Use a mirrored database when an operational database must stay continuously available in Fabric without building custom ingestion
2. Use a OneLake shortcut when data should remain at its current location and be referenced without copying
3. Use a Lakehouse for Spark-centric open-table engineering
4. Use a Fabric Warehouse for relational T-SQL analytics and dimensional serving
5. Use Eventhouse for high-volume time-oriented event analytics

Correct Answer: A

Correct Answer

Answer A is correct because mirroring brings the source database/catalog into Fabric and keeps it synchronized according to source support.

Incorrect Answers

Answer B is incorrect because this action is appropriate when the source data is already in an accessible open location and duplication is undesirable. Specifically, shortcuts expose existing data through OneLake without moving the underlying data, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the solution needs Delta tables, files, notebooks, and Spark processing in one engineering workspace. Specifically, Lakehouse combines OneLake files/tables with Spark-oriented engineering access, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the primary consumers use SQL, relational schemas, and warehouse-style analytical modeling. Specifically, Warehouse is optimized for relational analytical workloads and T-SQL, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the workload is dominated by rapid event ingestion, KQL exploration, and time-series queries. Specifically, Eventhouse is designed for real-time event analytics and KQL, which does not resolve the decisive condition in this scenario.

Question 5

A Fabric engineering team is reviewing an internal finance data estate. The source data is already in an accessible open location and duplication is undesirable Which action is most appropriate?

1. Use a Fabric Warehouse for relational T-SQL analytics and dimensional serving
2. Use Eventhouse for high-volume time-oriented event analytics
3. Use a mirrored database when an operational database must stay continuously available in Fabric without building custom ingestion
4. Use a OneLake shortcut when data should remain at its current location and be referenced without copying
5. Use a Lakehouse for Spark-centric open-table engineering

Correct Answer: D

Correct Answer

Answer D is correct because shortcuts expose existing data through OneLake without moving the underlying data. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the primary consumers use SQL, relational schemas, and warehouse-style analytical modeling. Specifically, Warehouse is optimized for relational analytical workloads and T-SQL, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the workload is dominated by rapid event ingestion, KQL exploration, and time-series queries. Specifically, Eventhouse is designed for real-time event analytics and KQL, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the team wants an analytics-ready synchronized representation of an external database with minimal pipeline engineering. Specifically, mirroring brings the source database/catalog into Fabric and keeps it synchronized according to source support, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the solution needs Delta tables, files, notebooks, and Spark processing in one engineering workspace. Specifically, Lakehouse combines OneLake files/tables with Spark-oriented engineering access, which does not resolve the decisive condition in this scenario.

Question 6

A data engineer must correct a design for a regulated retail analytics platform. The decisive requirement is that the transformation is mostly joins, filters, type changes, and business shaping owned by analysts familiar with Power Query. Which choice best addresses it?

1. Use a pipeline to orchestrate the chosen transformation rather than replacing it
2. Use Dataflow Gen2 for maintainable Power Query shaping
3. Use a notebook with PySpark for large-scale custom transformations
4. Use T-SQL for relational transformations inside a warehouse
5. Use KQL for event/time-series transformations in Eventhouse

Correct Answer: B

Correct Answer

Answer B is correct because Dataflow Gen2 is the low-code Power Query transformation experience. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the transformation engine is correct but it must run in sequence with copies and validations. Specifically, pipelines coordinate activities while the actual transformation stays in its best-fit engine, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the workload needs code libraries, distributed Spark processing, and custom transformation logic. Specifically, notebooks provide code-first distributed Spark execution, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the source and target are relational warehouse tables and the logic is naturally set-based SQL. Specifically, T-SQL keeps relational transformations close to the warehouse engine, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the data is event-oriented and the transformation relies on KQL operators and time semantics. Specifically, KQL is native to Eventhouse real-time analytics, which does not resolve the decisive condition in this scenario.

Question 7

For a real-time telemetry service, the organization has fixed the following constraint: the workload needs code libraries, distributed Spark processing, and custom transformation logic. Which action best satisfies the requirement?

1. Use T-SQL for relational transformations inside a warehouse
2. Use KQL for event/time-series transformations in Eventhouse
3. Use a pipeline to orchestrate the chosen transformation rather than replacing it
4. Use Dataflow Gen2 for maintainable Power Query shaping
5. Use a notebook with PySpark for large-scale custom transformations

Correct Answer: E

Correct Answer

Answer E is correct because notebooks provide code-first distributed Spark execution. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the source and target are relational warehouse tables and the logic is naturally set-based SQL. Specifically, T-SQL keeps relational transformations close to the warehouse engine, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the data is event-oriented and the transformation relies on KQL operators and time semantics. Specifically, KQL is native to Eventhouse real-time analytics, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the transformation engine is correct but it must run in sequence with copies and validations. Specifically, pipelines coordinate activities while the actual transformation stays in its best-fit engine, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the transformation is mostly joins, filters, type changes, and business shaping owned by analysts familiar with Power Query. Specifically, Dataflow Gen2 is the low-code Power Query transformation experience, which does not resolve the decisive condition in this scenario.

Question 8

During an operational design review for a global manufacturing data product, engineers confirm that the source and target are relational warehouse tables and the logic is naturally set-based SQL. What should they do?

1. Use Dataflow Gen2 for maintainable Power Query shaping
2. Use a notebook with PySpark for large-scale custom transformations
3. Use T-SQL for relational transformations inside a warehouse
4. Use KQL for event/time-series transformations in Eventhouse
5. Use a pipeline to orchestrate the chosen transformation rather than replacing it

Correct Answer: C

Correct Answer

Answer C is correct because T-SQL keeps relational transformations close to the warehouse engine. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the transformation is mostly joins, filters, type changes, and business shaping owned by analysts familiar with Power Query. Specifically, Dataflow Gen2 is the low-code Power Query transformation experience, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the workload needs code libraries, distributed Spark processing, and custom transformation logic. Specifically, notebooks provide code-first distributed Spark execution, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the data is event-oriented and the transformation relies on KQL operators and time semantics. Specifically, KQL is native to Eventhouse real-time analytics, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the transformation engine is correct but it must run in sequence with copies and validations. Specifically, pipelines coordinate activities while the actual transformation stays in its best-fit engine, which does not resolve the decisive condition in this scenario.

Question 9

After a recent change in a governed self-service analytics domain, the team determines that the data is event-oriented and the transformation relies on KQL operators and time semantics. Which implementation should be selected?

1. Use KQL for event/time-series transformations in Eventhouse
2. Use a pipeline to orchestrate the chosen transformation rather than replacing it
3. Use Dataflow Gen2 for maintainable Power Query shaping
4. Use a notebook with PySpark for large-scale custom transformations
5. Use T-SQL for relational transformations inside a warehouse

Correct Answer: A

Correct Answer

Answer A is correct because KQL is native to Eventhouse real-time analytics. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer B is incorrect because this action is appropriate when the transformation engine is correct but it must run in sequence with copies and validations. Specifically, pipelines coordinate activities while the actual transformation stays in its best-fit engine, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the transformation is mostly joins, filters, type changes, and business shaping owned by analysts familiar with Power Query. Specifically, Dataflow Gen2 is the low-code Power Query transformation experience, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the workload needs code libraries, distributed Spark processing, and custom transformation logic. Specifically, notebooks provide code-first distributed Spark execution, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the source and target are relational warehouse tables and the logic is naturally set-based SQL. Specifically, T-SQL keeps relational transformations close to the warehouse engine, which does not resolve the decisive condition in this scenario.

Question 10

A Fabric engineering team is reviewing a financial reporting workspace. The transformation engine is correct but it must run in sequence with copies and validations Which action is most appropriate?

1. Use a notebook with PySpark for large-scale custom transformations
2. Use T-SQL for relational transformations inside a warehouse
3. Use KQL for event/time-series transformations in Eventhouse
4. Use a pipeline to orchestrate the chosen transformation rather than replacing it
5. Use Dataflow Gen2 for maintainable Power Query shaping

Correct Answer: D

Correct Answer

Answer D is correct because pipelines coordinate activities while the actual transformation stays in its best-fit engine. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the workload needs code libraries, distributed Spark processing, and custom transformation logic. Specifically, notebooks provide code-first distributed Spark execution, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the source and target are relational warehouse tables and the logic is naturally set-based SQL. Specifically, T-SQL keeps relational transformations close to the warehouse engine, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the data is event-oriented and the transformation relies on KQL operators and time semantics. Specifically, KQL is native to Eventhouse real-time analytics, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the transformation is mostly joins, filters, type changes, and business shaping owned by analysts familiar with Power Query. Specifically, Dataflow Gen2 is the low-code Power Query transformation experience, which does not resolve the decisive condition in this scenario.

Question 11

A data engineer must correct a design for a multi-team Fabric deployment. The decisive requirement is that another workspace needs the table without making a second physical copy. Which choice best addresses it?

1. Use copy instead of a shortcut when compliance requires the data to reside in the Fabric region
2. Create an internal OneLake shortcut to the existing Fabric table
3. Create an external shortcut to open-format cloud storage
4. Create the shortcut in the Tables area when the Delta table must be queryable as a table
5. Use copy instead of a shortcut when complex transformation is required before consumption

Correct Answer: B

Correct Answer

Answer B is correct because an internal shortcut references the existing Fabric data through OneLake. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the source remains in another region and policy requires a local physical copy. Specifically, shortcuts leave data in the source location, so data movement is required for residency, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the data should remain in external object storage but appear in the Lakehouse namespace. Specifically, external shortcuts expose supported external storage without ingestion, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when an external Delta dataset must surface as a table to Fabric query experiences. Specifically, table shortcuts register the referenced table in the Lakehouse table area, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the incoming data needs joins, business-rule reshaping, and curated schema control before users query it. Specifically, shortcuts do not replace a transformation pipeline when data must be materially reshaped, which does not resolve the decisive condition in this scenario.

Question 12

For a logistics monitoring solution, the organization has fixed the following constraint: the data should remain in external object storage but appear in the Lakehouse namespace. Which action best satisfies the requirement?

1. Create the shortcut in the Tables area when the Delta table must be queryable as a table
2. Use copy instead of a shortcut when complex transformation is required before consumption
3. Use copy instead of a shortcut when compliance requires the data to reside in the Fabric region
4. Create an internal OneLake shortcut to the existing Fabric table
5. Create an external shortcut to open-format cloud storage

Correct Answer: E

Correct Answer

Answer E is correct because external shortcuts expose supported external storage without ingestion. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when an external Delta dataset must surface as a table to Fabric query experiences. Specifically, table shortcuts register the referenced table in the Lakehouse table area, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the incoming data needs joins, business-rule reshaping, and curated schema control before users query it. Specifically, shortcuts do not replace a transformation pipeline when data must be materially reshaped, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the source remains in another region and policy requires a local physical copy. Specifically, shortcuts leave data in the source location, so data movement is required for residency, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when another workspace needs the table without making a second physical copy. Specifically, an internal shortcut references the existing Fabric data through OneLake, which does not resolve the decisive condition in this scenario.

Question 13

During an operational design review for a regional supply-chain platform, engineers confirm that an external Delta dataset must surface as a table to Fabric query experiences. What should they do?

1. Create an internal OneLake shortcut to the existing Fabric table
2. Create an external shortcut to open-format cloud storage
3. Create the shortcut in the Tables area when the Delta table must be queryable as a table
4. Use copy instead of a shortcut when complex transformation is required before consumption
5. Use copy instead of a shortcut when compliance requires the data to reside in the Fabric region

Correct Answer: C

Correct Answer

Answer C is correct because table shortcuts register the referenced table in the Lakehouse table area. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when another workspace needs the table without making a second physical copy. Specifically, an internal shortcut references the existing Fabric data through OneLake, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the data should remain in external object storage but appear in the Lakehouse namespace. Specifically, external shortcuts expose supported external storage without ingestion, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the incoming data needs joins, business-rule reshaping, and curated schema control before users query it. Specifically, shortcuts do not replace a transformation pipeline when data must be materially reshaped, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the source remains in another region and policy requires a local physical copy. Specifically, shortcuts leave data in the source location, so data movement is required for residency, which does not resolve the decisive condition in this scenario.

Question 14

After a recent change in a shared business intelligence platform, the team determines that the incoming data needs joins, business-rule reshaping, and curated schema control before users query it. Which implementation should be selected?

1. Use copy instead of a shortcut when complex transformation is required before consumption
2. Use copy instead of a shortcut when compliance requires the data to reside in the Fabric region
3. Create an internal OneLake shortcut to the existing Fabric table
4. Create an external shortcut to open-format cloud storage
5. Create the shortcut in the Tables area when the Delta table must be queryable as a table

Correct Answer: A

Correct Answer

Answer A is correct because shortcuts do not replace a transformation pipeline when data must be materially reshaped. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer B is incorrect because this action is appropriate when the source remains in another region and policy requires a local physical copy. Specifically, shortcuts leave data in the source location, so data movement is required for residency, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when another workspace needs the table without making a second physical copy. Specifically, an internal shortcut references the existing Fabric data through OneLake, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the data should remain in external object storage but appear in the Lakehouse namespace. Specifically, external shortcuts expose supported external storage without ingestion, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when an external Delta dataset must surface as a table to Fabric query experiences. Specifically, table shortcuts register the referenced table in the Lakehouse table area, which does not resolve the decisive condition in this scenario.

Question 15

A Fabric engineering team is reviewing an enterprise lakehouse program. The source remains in another region and policy requires a local physical copy Which action is most appropriate?

1. Create an external shortcut to open-format cloud storage
2. Create the shortcut in the Tables area when the Delta table must be queryable as a table
3. Use copy instead of a shortcut when complex transformation is required before consumption
4. Use copy instead of a shortcut when compliance requires the data to reside in the Fabric region
5. Create an internal OneLake shortcut to the existing Fabric table

Correct Answer: D

Correct Answer

Answer D is correct because shortcuts leave data in the source location, so data movement is required for residency.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the data should remain in external object storage but appear in the Lakehouse namespace. Specifically, external shortcuts expose supported external storage without ingestion, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when an external Delta dataset must surface as a table to Fabric query experiences. Specifically, table shortcuts register the referenced table in the Lakehouse table area, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the incoming data needs joins, business-rule reshaping, and curated schema control before users query it. Specifically, shortcuts do not replace a transformation pipeline when data must be materially reshaped, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when another workspace needs the table without making a second physical copy. Specifically, an internal shortcut references the existing Fabric data through OneLake, which does not resolve the decisive condition in this scenario.

Question 16

A data engineer must correct a design for a healthcare operations workspace. The decisive requirement is that an entire supported database should appear in Fabric and stay synchronized without designing table-by-table copy logic. Which choice best addresses it?

1. Modify data in the source system and let mirroring propagate the change
2. Mirror the external operational database
3. Use a shortcut instead of mirroring for one open-format table
4. Mirror once in the producer workspace and create consumer shortcuts
5. Monitor the mirrored item because all dependent shortcuts share its health

Correct Answer: B

Correct Answer

Answer B is correct because database mirroring is designed to bring the source database/catalog into Fabric continuously. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when a consumer wants to update a read-only mirrored table exposed through a shortcut. Specifically, mirroring/shortcut consumption does not transfer write ownership; source changes must originate in the source system, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when only a single open-format table is needed and the team wants no replicated copy. Specifically, a shortcut is more granular and avoids adding the whole source catalog, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when several workspaces need the same mirrored source and duplicate mirroring would create unnecessary ownership and replication. Specifically, central mirroring plus shortcuts gives consumers one governed synchronized source, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when multiple downstream workspaces consume tables through shortcuts to one mirrored database. Specifically, a pause, deletion, or replication failure at the mirrored source affects every dependent shortcut, which does not resolve the decisive condition in this scenario.

Question 17

For an IoT operations solution, the organization has fixed the following constraint: only a single open-format table is needed and the team wants no replicated copy. Which action best satisfies the requirement?

1. Mirror once in the producer workspace and create consumer shortcuts
2. Monitor the mirrored item because all dependent shortcuts share its health
3. Modify data in the source system and let mirroring propagate the change
4. Mirror the external operational database
5. Use a shortcut instead of mirroring for one open-format table

Correct Answer: E

Correct Answer

Answer E is correct because a shortcut is more granular and avoids adding the whole source catalog. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when several workspaces need the same mirrored source and duplicate mirroring would create unnecessary ownership and replication. Specifically, central mirroring plus shortcuts gives consumers one governed synchronized source, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when multiple downstream workspaces consume tables through shortcuts to one mirrored database. Specifically, a pause, deletion, or replication failure at the mirrored source affects every dependent shortcut, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when a consumer wants to update a read-only mirrored table exposed through a shortcut. Specifically, mirroring/shortcut consumption does not transfer write ownership; source changes must originate in the source system, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when an entire supported database should appear in Fabric and stay synchronized without designing table-by-table copy logic. Specifically, database mirroring is designed to bring the source database/catalog into Fabric continuously, which does not resolve the decisive condition in this scenario.

Question 18

During an operational design review for a product usage analytics pipeline, engineers confirm that several workspaces need the same mirrored source and duplicate mirroring would create unnecessary ownership and replication. What should they do?

1. Mirror the external operational database
2. Use a shortcut instead of mirroring for one open-format table
3. Mirror once in the producer workspace and create consumer shortcuts
4. Monitor the mirrored item because all dependent shortcuts share its health
5. Modify data in the source system and let mirroring propagate the change

Correct Answer: C

Correct Answer

Answer C is correct because central mirroring plus shortcuts gives consumers one governed synchronized source. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when an entire supported database should appear in Fabric and stay synchronized without designing table-by-table copy logic. Specifically, database mirroring is designed to bring the source database/catalog into Fabric continuously, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when only a single open-format table is needed and the team wants no replicated copy. Specifically, a shortcut is more granular and avoids adding the whole source catalog, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when multiple downstream workspaces consume tables through shortcuts to one mirrored database. Specifically, a pause, deletion, or replication failure at the mirrored source affects every dependent shortcut, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when a consumer wants to update a read-only mirrored table exposed through a shortcut. Specifically, mirroring/shortcut consumption does not transfer write ownership; source changes must originate in the source system, which does not resolve the decisive condition in this scenario.

Question 19

After a recent change in a customer-analytics environment, the team determines that multiple downstream workspaces consume tables through shortcuts to one mirrored database. Which implementation should be selected?

1. Monitor the mirrored item because all dependent shortcuts share its health
2. Modify data in the source system and let mirroring propagate the change
3. Mirror the external operational database
4. Use a shortcut instead of mirroring for one open-format table
5. Mirror once in the producer workspace and create consumer shortcuts

Correct Answer: A

Correct Answer

Answer A is correct because a pause, deletion, or replication failure at the mirrored source affects every dependent shortcut.

Incorrect Answers

Answer B is incorrect because this action is appropriate when a consumer wants to update a read-only mirrored table exposed through a shortcut. Specifically, mirroring/shortcut consumption does not transfer write ownership; source changes must originate in the source system, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when an entire supported database should appear in Fabric and stay synchronized without designing table-by-table copy logic. Specifically, database mirroring is designed to bring the source database/catalog into Fabric continuously, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when only a single open-format table is needed and the team wants no replicated copy. Specifically, a shortcut is more granular and avoids adding the whole source catalog, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when several workspaces need the same mirrored source and duplicate mirroring would create unnecessary ownership and replication. Specifically, central mirroring plus shortcuts gives consumers one governed synchronized source, which does not resolve the decisive condition in this scenario.

Question 20

A Fabric engineering team is reviewing an internal finance data estate. A consumer wants to update a read-only mirrored table exposed through a shortcut Which action is most appropriate?

1. Use a shortcut instead of mirroring for one open-format table
2. Mirror once in the producer workspace and create consumer shortcuts
3. Monitor the mirrored item because all dependent shortcuts share its health
4. Modify data in the source system and let mirroring propagate the change
5. Mirror the external operational database

Correct Answer: D

Correct Answer

Answer D is correct because mirroring/shortcut consumption does not transfer write ownership; source changes must originate in the source system.

Incorrect Answers

Answer A is incorrect because this action is appropriate when only a single open-format table is needed and the team wants no replicated copy. Specifically, a shortcut is more granular and avoids adding the whole source catalog, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when several workspaces need the same mirrored source and duplicate mirroring would create unnecessary ownership and replication. Specifically, central mirroring plus shortcuts gives consumers one governed synchronized source, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when multiple downstream workspaces consume tables through shortcuts to one mirrored database. Specifically, a pause, deletion, or replication failure at the mirrored source affects every dependent shortcut, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when an entire supported database should appear in Fabric and stay synchronized without designing table-by-table copy logic. Specifically, database mirroring is designed to bring the source database/catalog into Fabric continuously, which does not resolve the decisive condition in this scenario.

Question 21

A data engineer must correct a design for a regulated retail analytics platform. The decisive requirement is that data must be moved on a specific cadence and the organization owns the ingestion window. Which choice best addresses it?

1. Use a copy path when schema ownership and Delta maintenance must be fully controlled locally
2. Use a pipeline or copy job when the team controls the movement schedule
3. Use a shortcut when freshness should follow the source without maintaining a copy job
4. Use mirroring for continuous supported database synchronization
5. Use Eventstream for continuous event ingress

Correct Answer: B

Correct Answer

Answer B is correct because data movement tools provide explicit scheduled or triggered movement. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the engineering team must own schema evolution, partitioning, maintenance, and transformation of the target table. Specifically, a local copied Delta table provides full target maintenance control that a shortcut does not, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the source is already queryable and consumers need the current source state with minimal movement overhead. Specifically, a shortcut references the live source rather than maintaining a copied replica, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the whole operational database must stay analytics-ready in Fabric with low pipeline engineering overhead. Specifically, mirroring provides continuous database/catalog integration for supported sources, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when events arrive continuously and must be routed to real-time destinations. Specifically, Eventstream is the streaming ingestion/movement experience, which does not resolve the decisive condition in this scenario.

Question 22

For a real-time telemetry service, the organization has fixed the following constraint: the source is already queryable and consumers need the current source state with minimal movement overhead. Which action best satisfies the requirement?

1. Use mirroring for continuous supported database synchronization
2. Use Eventstream for continuous event ingress
3. Use a copy path when schema ownership and Delta maintenance must be fully controlled locally
4. Use a pipeline or copy job when the team controls the movement schedule
5. Use a shortcut when freshness should follow the source without maintaining a copy job

Correct Answer: E

Correct Answer

Answer E is correct because a shortcut references the live source rather than maintaining a copied replica. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the whole operational database must stay analytics-ready in Fabric with low pipeline engineering overhead. Specifically, mirroring provides continuous database/catalog integration for supported sources, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when events arrive continuously and must be routed to real-time destinations. Specifically, Eventstream is the streaming ingestion/movement experience, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the engineering team must own schema evolution, partitioning, maintenance, and transformation of the target table. Specifically, a local copied Delta table provides full target maintenance control that a shortcut does not, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when data must be moved on a specific cadence and the organization owns the ingestion window. Specifically, data movement tools provide explicit scheduled or triggered movement, which does not resolve the decisive condition in this scenario.

Question 23

During an operational design review for a global manufacturing data product, engineers confirm that the whole operational database must stay analytics-ready in Fabric with low pipeline engineering overhead. What should they do?

1. Use a pipeline or copy job when the team controls the movement schedule
2. Use a shortcut when freshness should follow the source without maintaining a copy job
3. Use mirroring for continuous supported database synchronization
4. Use Eventstream for continuous event ingress
5. Use a copy path when schema ownership and Delta maintenance must be fully controlled locally

Correct Answer: C

Correct Answer

Answer C is correct because mirroring provides continuous database/catalog integration for supported sources. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when data must be moved on a specific cadence and the organization owns the ingestion window. Specifically, data movement tools provide explicit scheduled or triggered movement, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the source is already queryable and consumers need the current source state with minimal movement overhead. Specifically, a shortcut references the live source rather than maintaining a copied replica, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when events arrive continuously and must be routed to real-time destinations. Specifically, Eventstream is the streaming ingestion/movement experience, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the engineering team must own schema evolution, partitioning, maintenance, and transformation of the target table. Specifically, a local copied Delta table provides full target maintenance control that a shortcut does not, which does not resolve the decisive condition in this scenario.

Question 24

After a recent change in a governed self-service analytics domain, the team determines that events arrive continuously and must be routed to real-time destinations. Which implementation should be selected?

1. Use Eventstream for continuous event ingress
2. Use a copy path when schema ownership and Delta maintenance must be fully controlled locally
3. Use a pipeline or copy job when the team controls the movement schedule
4. Use a shortcut when freshness should follow the source without maintaining a copy job
5. Use mirroring for continuous supported database synchronization

Correct Answer: A

Correct Answer

Answer A is correct because Eventstream is the streaming ingestion/movement experience. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer B is incorrect because this action is appropriate when the engineering team must own schema evolution, partitioning, maintenance, and transformation of the target table. Specifically, a local copied Delta table provides full target maintenance control that a shortcut does not, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when data must be moved on a specific cadence and the organization owns the ingestion window. Specifically, data movement tools provide explicit scheduled or triggered movement, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the source is already queryable and consumers need the current source state with minimal movement overhead. Specifically, a shortcut references the live source rather than maintaining a copied replica, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the whole operational database must stay analytics-ready in Fabric with low pipeline engineering overhead. Specifically, mirroring provides continuous database/catalog integration for supported sources, which does not resolve the decisive condition in this scenario.

Question 25

A Fabric engineering team is reviewing a financial reporting workspace. The engineering team must own schema evolution, partitioning, maintenance, and transformation of the target table Which action is most appropriate?

1. Use a shortcut when freshness should follow the source without maintaining a copy job
2. Use mirroring for continuous supported database synchronization
3. Use Eventstream for continuous event ingress
4. Use a copy path when schema ownership and Delta maintenance must be fully controlled locally
5. Use a pipeline or copy job when the team controls the movement schedule

Correct Answer: D

Correct Answer

Answer D is correct because a local copied Delta table provides full target maintenance control that a shortcut does not.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the source is already queryable and consumers need the current source state with minimal movement overhead. Specifically, a shortcut references the live source rather than maintaining a copied replica, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the whole operational database must stay analytics-ready in Fabric with low pipeline engineering overhead. Specifically, mirroring provides continuous database/catalog integration for supported sources, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when events arrive continuously and must be routed to real-time destinations. Specifically, Eventstream is the streaming ingestion/movement experience, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when data must be moved on a specific cadence and the organization owns the ingestion window. Specifically, data movement tools provide explicit scheduled or triggered movement, which does not resolve the decisive condition in this scenario.

Question 26

A data engineer must correct a design for a multi-team Fabric deployment. The decisive requirement is that an internal shortcut resolves but a user receives access denied while another authorized user succeeds. Which choice best addresses it?

1. Use a delegated connection only when central identity behavior is required
2. Ensure the caller has read permission on the internal shortcut target
3. Use a governed cloud connection for an external shortcut
4. Repair or recreate the shortcut after the target path is moved
5. Delete the shortcut without deleting the target data

Correct Answer: B

Correct Answer

Answer B is correct because internal shortcut access uses the calling user identity against the target. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the organization wants all consumers to access the shortcut target through one governed connection identity. Specifically, delegated authentication intentionally replaces per-user pass-through for the target, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when external storage must be reached with centrally managed credentials rather than every consumer supplying credentials. Specifically, external shortcuts use the configured cloud connection for source access, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the shortcut object still exists but its source folder was renamed or relocated. Specifically, shortcuts can break when their target path changes because they are independent references, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the consumer workspace no longer needs the reference but the producer data must remain intact. Specifically, deleting a shortcut removes the reference and does not delete the source target, which does not resolve the decisive condition in this scenario.

Question 27

For a logistics monitoring solution, the organization has fixed the following constraint: external storage must be reached with centrally managed credentials rather than every consumer supplying credentials. Which action best satisfies the requirement?

1. Repair or recreate the shortcut after the target path is moved
2. Delete the shortcut without deleting the target data
3. Use a delegated connection only when central identity behavior is required
4. Ensure the caller has read permission on the internal shortcut target
5. Use a governed cloud connection for an external shortcut

Correct Answer: E

Correct Answer

Answer E is correct because external shortcuts use the configured cloud connection for source access. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when the shortcut object still exists but its source folder was renamed or relocated. Specifically, shortcuts can break when their target path changes because they are independent references, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the consumer workspace no longer needs the reference but the producer data must remain intact. Specifically, deleting a shortcut removes the reference and does not delete the source target, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the organization wants all consumers to access the shortcut target through one governed connection identity. Specifically, delegated authentication intentionally replaces per-user pass-through for the target, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when an internal shortcut resolves but a user receives access denied while another authorized user succeeds. Specifically, internal shortcut access uses the calling user identity against the target, which does not resolve the decisive condition in this scenario.

Question 28

During an operational design review for a regional supply-chain platform, engineers confirm that the shortcut object still exists but its source folder was renamed or relocated. What should they do?

1. Ensure the caller has read permission on the internal shortcut target
2. Use a governed cloud connection for an external shortcut
3. Repair or recreate the shortcut after the target path is moved
4. Delete the shortcut without deleting the target data
5. Use a delegated connection only when central identity behavior is required

Correct Answer: C

Correct Answer

Answer C is correct because shortcuts can break when their target path changes because they are independent references. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when an internal shortcut resolves but a user receives access denied while another authorized user succeeds. Specifically, internal shortcut access uses the calling user identity against the target, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when external storage must be reached with centrally managed credentials rather than every consumer supplying credentials. Specifically, external shortcuts use the configured cloud connection for source access, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when the consumer workspace no longer needs the reference but the producer data must remain intact. Specifically, deleting a shortcut removes the reference and does not delete the source target, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the organization wants all consumers to access the shortcut target through one governed connection identity. Specifically, delegated authentication intentionally replaces per-user pass-through for the target, which does not resolve the decisive condition in this scenario.

Question 29

After a recent change in a shared business intelligence platform, the team determines that the consumer workspace no longer needs the reference but the producer data must remain intact. Which implementation should be selected?

1. Delete the shortcut without deleting the target data
2. Use a delegated connection only when central identity behavior is required
3. Ensure the caller has read permission on the internal shortcut target
4. Use a governed cloud connection for an external shortcut
5. Repair or recreate the shortcut after the target path is moved

Correct Answer: A

Correct Answer

Answer A is correct because deleting a shortcut removes the reference and does not delete the source target. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer B is incorrect because this action is appropriate when the organization wants all consumers to access the shortcut target through one governed connection identity. Specifically, delegated authentication intentionally replaces per-user pass-through for the target, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when an internal shortcut resolves but a user receives access denied while another authorized user succeeds. Specifically, internal shortcut access uses the calling user identity against the target, which does not resolve the decisive condition in this scenario.

Answer D is incorrect because this action is appropriate when external storage must be reached with centrally managed credentials rather than every consumer supplying credentials. Specifically, external shortcuts use the configured cloud connection for source access, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when the shortcut object still exists but its source folder was renamed or relocated. Specifically, shortcuts can break when their target path changes because they are independent references, which does not resolve the decisive condition in this scenario.

Question 30

A Fabric engineering team is reviewing an enterprise lakehouse program. The organization wants all consumers to access the shortcut target through one governed connection identity Which action is most appropriate?

1. Use a governed cloud connection for an external shortcut
2. Repair or recreate the shortcut after the target path is moved
3. Delete the shortcut without deleting the target data
4. Use a delegated connection only when central identity behavior is required
5. Ensure the caller has read permission on the internal shortcut target

Correct Answer: D

Correct Answer

Answer D is correct because delegated authentication intentionally replaces per-user pass-through for the target. This directly addresses the relevant Fabric behavior while preserving the other stated constraints.

Incorrect Answers

Answer A is incorrect because this action is appropriate when external storage must be reached with centrally managed credentials rather than every consumer supplying credentials. Specifically, external shortcuts use the configured cloud connection for source access, which does not resolve the decisive condition in this scenario.

Answer B is incorrect because this action is appropriate when the shortcut object still exists but its source folder was renamed or relocated. Specifically, shortcuts can break when their target path changes because they are independent references, which does not resolve the decisive condition in this scenario.

Answer C is incorrect because this action is appropriate when the consumer workspace no longer needs the reference but the producer data must remain intact. Specifically, deleting a shortcut removes the reference and does not delete the source target, which does not resolve the decisive condition in this scenario.

Answer E is incorrect because this action is appropriate when an internal shortcut resolves but a user receives access denied while another authorized user succeeds. Specifically, internal shortcut access uses the calling user identity against the target, which does not resolve the decisive condition in this scenario.