DP-700 — Most Debated Topics

Community-voted ranking of 38 topics, sorted by disagreement level. Higher dispute = more test-takers disagree on the answer.

#1
A 500-million-row fact table exceeds the F32 Direct Lake guardrail, so increase the capacity to F64
S-Grade Dispute: 58% 19 comments
#2
Shortcut caching supports only S3/GCS shortcuts and excludes files larger than 1 GB
S-Grade Dispute: 54% 14 comments
#3
Updating warehouse tables requires at least the Contributor workspace role because Write is not shareable to a Viewer
S-Grade Dispute: 52% 13 comments
#4
Run T-SQL in a KQL database only by prefixing the query with a -- comment line
S-Grade Dispute: 48% 8 comments
#5
Store semi-structured data readable by T-SQL, KQL, and Spark in an eventhouse
S-Grade Dispute: 43% 20 comments
#6
Use a semantic link in a notebook to dynamically execute and monitor a semantic model refresh
S-Grade Dispute: 43% 7 comments
#7
Use a service principal to authenticate Azure DevOps to Fabric deployment pipelines
S-Grade Dispute: 40% 8 comments
#8
Disable high concurrency so bronze and silver notebook runs get isolated Spark sessions
A-Grade Dispute: 40% 3 comments
#9
A blob storage action plus a data pipeline processes book cover images on arrival
A-Grade Dispute: 33% 3 comments
#10
KQL sort defaults to descending, so ascending order requires an explicit asc modifier
S-Grade Dispute: 32% 9 comments
#11
ForEach over the MAR1 endpoints with Copy data loads the bronze layer
A-Grade Dispute: 30% 3 comments
#12
OneLake availability for an eventhouse copies only newly ingested data by default
S-Grade Dispute: 25% 12 comments
#13
Only a Fabric admin can create top-level domains; domain admin handles subdomains
S-Grade Dispute: 21% 10 comments
#14
An eventstream filters the event hub feed to Chelsea and lands it in a lakehouse
A-Grade Dispute: 21% 4 comments
#15
Deploying a restructured workspace creates Folder1, relocates Pipeline1, and deploys Lakehouse1
A-Grade Dispute: 20% 4 comments
#16
The run series view shows a notebook's nine jobs as a timeline chart
A-Grade Dispute: 20% 4 comments
#17
An S3 shortcut with workspace caching enabled minimizes egress without persisting raw data
S-Grade Dispute: 18% 7 comments
#18
Deployment pipelines validate invalid warehouse references as part of deployment
A-Grade Dispute: 15% 3 comments
#19
A data pipeline with a storage event trigger gives event-driven, high-throughput file ingestion
S-Grade Dispute: 12% 5 comments
#20
Add an eventhouse to the Dev/Test/Prod deployment through the deployment pipeline
A-Grade Dispute: 12% 3 comments
#21
Cache serves Products and Stores but Trips expired after 48 hours without access
A-Grade Dispute: 10% 4 comments
#22
An explicit asc modifier makes the KQL sort by solution meet the ascending goal
A-Grade Dispute: 9% 4 comments
#23
Running a deployment pipeline overwrites already-paired items with minimal effort
S-Grade Dispute: 8% 6 comments
#24
The Group by operator provides the Standard deviation aggregation in Eventstream
S-Grade Dispute: 7% 5 comments
#25
Grant analysts gold-layer access by sharing the lakehouse with Read all SQL Endpoint data
A-Grade Dispute: 0% 4 comments
#26
A security predicate function is the warehouse object behind row-level security
A-Grade Dispute: 0% 4 comments
#27
Share Lakehouse1 directly with Read all SQL endpoint data to scope User1 access
A-Grade Dispute: 0% 3 comments
#28
OPTIMIZE consolidates the small Parquet files of a Delta table
A-Grade Dispute: 0% 6 comments
#29
A data pipeline copies on-premises SQL Server data through the gateway into a warehouse
A-Grade Dispute: 0% 6 comments
#30
Fabric Monitor's notebook run details show the runtime's Delta version
A-Grade Dispute: 0% 3 comments
#31
KQL solution fails the goal because sort by defaults to descending order
A-Grade Dispute: 0% 5 comments
#32
Data pipelines are the gateway-compatible item to load a warehouse from on-prem SQL Server
A-Grade Dispute: 0% 4 comments
#33
An S3 shortcut makes the book reviews available without copying the data
A-Grade Dispute: 0% 3 comments
#34
A data pipeline with a storage event trigger delivers the highest-throughput file ingestion
A-Grade Dispute: 0% 3 comments
#35
One scheduled pipeline invoking the others sequences the medallion layers
A-Grade Dispute: 0% 5 comments
#36
OPTIMIZE plus VACUUM minimizes query time on a table of 2,000 one-MB files
A-Grade Dispute: 0% 3 comments
#37
sys.dm_exec_sessions identifies the users actively running warehouse queries
A-Grade Dispute: 0% 4 comments
#38
VACUUM removes lakehouse files older than seven days that are no longer in use
A-Grade Dispute: 0% 3 comments

← Back to DP-700 Implementing Data Engineering Solutions Study Guide