Microsoft DP-700 Practice Test 21
Question 200
An architecture review requires physically relocating data to a particular compliance region. Why might a shortcut be unsuitable?
- Use the ADLS Gen2 DFS endpoint and valid container or folder path.
- Create an internal OneLake shortcut to the existing source table or folder.
- Copy or ingest the data into compliant storage rather than relying on a pointer to the remote location.
- Create a suitable Delta table shortcut under the lakehouse Tables area where table discovery is supported.
Explanation
Correct Answer
C:A shortcut leaves bytes in the original source region; catalog visibility is not physical residency. Inspect the actual storage location after the migration.
Incorrect Answers
A:ADLS Gen2 shortcuts require the DFS endpoint; an otherwise valid storage account name is not sufficient.
B:Shortcuts reference existing data, avoiding duplicate storage and separate ingestion pipelines.
D:Files paths do not automatically register as SQL analytics tables, even when they contain Delta-format files.
Question 201
An operational Azure SQL database changes throughout the day, and analysts need current tables without designing a custom incremental ETL. What should be evaluated?
- Inspect the mirror's replication status and source-side change-capture prerequisites.
- Use open mirroring APIs and supported change format rather than a database-specific replication connector.
- Measure source-to-mirror replication latency and ingestion health before tuning downstream reports.
- Configure supported Fabric database mirroring from the Azure SQL source.
Explanation
Correct Answer
D:Mirroring synchronizes supported source changes into queryable OneLake tables, reducing custom CDC pipeline work. Compare source commits with replicated rows.
Incorrect Answers
A:Replication health and source permissions determine whether changes continue to arrive; creating another shortcut won't repair a stalled mirror.
B:Open mirroring lets eligible producers supply table changes to mirrored data through an open interface.
C:A query cannot display changes that have not reached OneLake; distinguish source replication delay from report refresh delay.
Question 202
A Fabric SQL database's OneLake representation appears without an independently configured external mirror. What behavior should the engineer recognize?
- Understand that Fabric SQL database mirroring is configured automatically for this source type.
- Create downstream curated transformations over mirrored tables rather than treating source mirroring as a full ETL engine.
- Treat the operational source and the OneLake mirrored copy as separate systems with independent lifecycle rules.
- Inspect the mirror's replication status and source-side change-capture prerequisites.
Explanation
Correct Answer
A:Fabric SQL database has a built-in mirroring path; setup differs from external source mirroring. Inspect the automatically available mirrored representation.
Incorrect Answers
B:Mirroring focuses on synchronizing source changes; business enrichment and dimensional shaping require separate processing.
C:Replication provides an analytical representation; stopping synchronization does not imply deleting source database records.
D:Replication health and source permissions determine whether changes continue to arrive; creating another shortcut won't repair a stalled mirror.
Question 203
A mirror shows tables but stops reflecting recent source updates. What should be examined first?
- Treat the operational source and the OneLake mirrored copy as separate systems with independent lifecycle rules.
- Configure supported Fabric database mirroring from the Azure SQL source.
- Inspect the mirror's replication status and source-side change-capture prerequisites.
- Understand that Fabric SQL database mirroring is configured automatically for this source type.
Explanation
Correct Answer
C:Replication health and source permissions determine whether changes continue to arrive; creating another shortcut won't repair a stalled mirror. Compare the latest source change and mirror refresh state.
Incorrect Answers
A:Replication provides an analytical representation; stopping synchronization does not imply deleting source database records.
B:Mirroring synchronizes supported source changes into queryable OneLake tables, reducing custom CDC pipeline work.
D:Fabric SQL database has a built-in mirroring path; setup differs from external source mirroring.
Question 204
A team wants to query a remote catalog's table definitions without copying table contents into OneLake. Which mirroring category fits that request?
- Treat the operational source and the OneLake mirrored copy as separate systems with independent lifecycle rules.
- Evaluate metadata mirroring with supported shortcuts rather than database data replication.
- Measure source-to-mirror replication latency and ingestion health before tuning downstream reports.
- Create downstream curated transformations over mirrored tables rather than treating source mirroring as a full ETL engine.
Explanation
Correct Answer
B:Metadata mirroring synchronizes catalog structure while the underlying data remains in its source system. Verify that table access resolves through the shortcut.
Incorrect Answers
A:Replication provides an analytical representation; stopping synchronization does not imply deleting source database records.
C:A query cannot display changes that have not reached OneLake; distinguish source replication delay from report refresh delay.
D:Mirroring focuses on synchronizing source changes; business enrichment and dimensional shaping require separate processing.
Question 205
An application can emit changes as Delta-based open mirroring records to OneLake. Which Fabric integration pattern should be considered?
- Use open mirroring APIs and supported change format rather than a database-specific replication connector.
- Create downstream curated transformations over mirrored tables rather than treating source mirroring as a full ETL engine.
- Measure source-to-mirror replication latency and ingestion health before tuning downstream reports.
- Inspect the mirror's replication status and source-side change-capture prerequisites.
Explanation
Correct Answer
A:Open mirroring lets eligible producers supply table changes to mirrored data through an open interface. Test schema and change application with a sample producer.
Incorrect Answers
B:Mirroring focuses on synchronizing source changes; business enrichment and dimensional shaping require separate processing.
C:A query cannot display changes that have not reached OneLake; distinguish source replication delay from report refresh delay.
D:Replication health and source permissions determine whether changes continue to arrive; creating another shortcut won't repair a stalled mirror.
Question 206
A solution requires transformation of replicated operational rows before reporting. Where should complex transformations be added?
- Create downstream curated transformations over mirrored tables rather than treating source mirroring as a full ETL engine.
- Inspect the mirror's replication status and source-side change-capture prerequisites.
- Evaluate metadata mirroring with supported shortcuts rather than database data replication.
- Treat the operational source and the OneLake mirrored copy as separate systems with independent lifecycle rules.
Explanation
Correct Answer
A:Mirroring focuses on synchronizing source changes; business enrichment and dimensional shaping require separate processing. Compare the curated output with the unmodified mirror.
Incorrect Answers
B:Replication health and source permissions determine whether changes continue to arrive; creating another shortcut won't repair a stalled mirror.
C:Metadata mirroring synchronizes catalog structure while the underlying data remains in its source system.
D:Replication provides an analytical representation; stopping synchronization does not imply deleting source database records.
Question 207
A reviewer worries that stopping mirroring will automatically erase the original transactional database. What is the correct architectural distinction?
- Use open mirroring APIs and supported change format rather than a database-specific replication connector.
- Create downstream curated transformations over mirrored tables rather than treating source mirroring as a full ETL engine.
- Treat the operational source and the OneLake mirrored copy as separate systems with independent lifecycle rules.
- Inspect the mirror's replication status and source-side change-capture prerequisites.
Explanation
Correct Answer
C:Replication provides an analytical representation; stopping synchronization does not imply deleting source database records. Verify the source database is independently accessible.
Incorrect Answers
A:Open mirroring lets eligible producers supply table changes to mirrored data through an open interface.
B:Mirroring focuses on synchronizing source changes; business enrichment and dimensional shaping require separate processing.
D:Replication health and source permissions determine whether changes continue to arrive; creating another shortcut won't repair a stalled mirror.
Question 208
A mirrored table has unexpected lag during a high-volume source transaction burst. What metric should be investigated?
- Evaluate metadata mirroring with supported shortcuts rather than database data replication.
- Measure source-to-mirror replication latency and ingestion health before tuning downstream reports.
- Create downstream curated transformations over mirrored tables rather than treating source mirroring as a full ETL engine.
- Understand that Fabric SQL database mirroring is configured automatically for this source type.
Explanation
Correct Answer
B:A query cannot display changes that have not reached OneLake; distinguish source replication delay from report refresh delay. Compare event timestamps across source, mirror, and report.
Incorrect Answers
A:Metadata mirroring synchronizes catalog structure while the underlying data remains in its source system.
C:Mirroring focuses on synchronizing source changes; business enrichment and dimensional shaping require separate processing.
D:Fabric SQL database has a built-in mirroring path; setup differs from external source mirroring.
Question 209
A daily landing job copies files from an external storage folder to OneLake without altering their contents. Which pipeline activity fits?
- Refresh the connection credentials referenced by the relevant pipeline activity.
- Use a Copy Data activity with source and destination connections.
- Use supported source filtering or parameterized paths to select the intended incremental file set.
- Tune copy parallelism and source concurrency within the service's documented limits.
Explanation
Correct Answer
B:Copy activities move supported data between stores with mappings and transfer configuration, without requiring custom transformation code. Validate source and destination byte or record counts.
Incorrect Answers
A:Pipeline data movement uses saved connections; a changed password or secret invalidates activity authentication.
C:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch.
D:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput.
Question 210
A source and destination use different column names. Where should the copy mapping be corrected?
- Configure the Copy Data activity's explicit source-to-sink column mapping.
- Use supported source filtering or parameterized paths to select the intended incremental file set.
- Tune copy parallelism and source concurrency within the service's documented limits.
- Add a Dataflow activity dependent on successful Copy Data completion.
Explanation
Correct Answer
A:Column mapping aligns source fields to the target schema; changing the schedule does not repair a name mismatch. Run a test copy and inspect field-level values.
Incorrect Answers
B:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch.
C:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput.
D:The pipeline can coordinate ingestion and subsequent dataflow transformation as separate dependent steps.
