Disagreement ranking

DP-700 — most debated topics

Community-voted ranking of 62 topics, sorted by disagreement level. A higher dispute score means more test-takers disagree on the answer.

Full ranking

62 topics · highest disagreement first

  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. Resolving Direct Lake Row Limits in Fabric F32 Capacity

    A-grade Dispute: 50% 17 comments

  5. Run T-SQL in a KQL database only by prefixing the query with a -- comment line

    S-grade Dispute: 48% 8 comments

  6. Store semi-structured data readable by T-SQL, KQL, and Spark in an eventhouse

    S-grade Dispute: 43% 20 comments

  7. Use a semantic link in a notebook to dynamically execute and monitor a semantic model refresh

    S-grade Dispute: 43% 7 comments

  8. Use a service principal to authenticate Azure DevOps to Fabric deployment pipelines

    S-grade Dispute: 40% 8 comments

  9. Disable high concurrency so bronze and silver notebook runs get isolated Spark sessions

    A-grade Dispute: 40% 3 comments

  10. Optimizing Fabric Warehouse Query Performance with V-Order

    A-grade Dispute: 40% 11 comments

  11. A blob storage action plus a data pipeline processes book cover images on arrival

    A-grade Dispute: 33% 3 comments

  12. KQL sort defaults to descending, so ascending order requires an explicit asc modifier

    S-grade Dispute: 32% 9 comments

  13. ForEach over the MAR1 endpoints with Copy data loads the bronze layer

    A-grade Dispute: 30% 3 comments

  14. OneLake availability for an eventhouse copies only newly ingested data by default

    S-grade Dispute: 25% 12 comments

  15. Only a Fabric admin can create top-level domains; domain admin handles subdomains

    S-grade Dispute: 21% 10 comments

  16. An eventstream filters the event hub feed to Chelsea and lands it in a lakehouse

    A-grade Dispute: 21% 4 comments

  17. Deploying a restructured workspace creates Folder1, relocates Pipeline1, and deploys Lakehouse1

    A-grade Dispute: 20% 4 comments

  18. The run series view shows a notebook's nine jobs as a timeline chart

    A-grade Dispute: 20% 4 comments

  19. An S3 shortcut with workspace caching enabled minimizes egress without persisting raw data

    S-grade Dispute: 18% 7 comments

  20. Deployment pipelines validate invalid warehouse references as part of deployment

    A-grade Dispute: 15% 3 comments

  21. A data pipeline with a storage event trigger gives event-driven, high-throughput file ingestion

    S-grade Dispute: 12% 5 comments

  22. Add an eventhouse to the Dev/Test/Prod deployment through the deployment pipeline

    A-grade Dispute: 12% 3 comments

  23. Cache serves Products and Stores but Trips expired after 48 hours without access

    A-grade Dispute: 10% 4 comments

  24. An explicit asc modifier makes the KQL sort by solution meet the ascending goal

    A-grade Dispute: 9% 4 comments

  25. Running a deployment pipeline overwrites already-paired items with minimal effort

    S-grade Dispute: 8% 6 comments

  26. The Group by operator provides the Standard deviation aggregation in Eventstream

    S-grade Dispute: 7% 5 comments

  27. Grant analysts gold-layer access by sharing the lakehouse with Read all SQL Endpoint data

    A-grade Dispute: 0% 4 comments

  28. A security predicate function is the warehouse object behind row-level security

    A-grade Dispute: 0% 4 comments

  29. Share Lakehouse1 directly with Read all SQL endpoint data to scope User1 access

    A-grade Dispute: 0% 3 comments

  30. OPTIMIZE consolidates the small Parquet files of a Delta table

    A-grade Dispute: 0% 6 comments

  31. A data pipeline copies on-premises SQL Server data through the gateway into a warehouse

    A-grade Dispute: 0% 6 comments

  32. Fabric Monitor's notebook run details show the runtime's Delta version

    A-grade Dispute: 0% 3 comments

  33. KQL solution fails the goal because sort by defaults to descending order

    A-grade Dispute: 0% 5 comments

  34. Data pipelines are the gateway-compatible item to load a warehouse from on-prem SQL Server

    A-grade Dispute: 0% 4 comments

  35. An S3 shortcut makes the book reviews available without copying the data

    A-grade Dispute: 0% 3 comments

  36. A data pipeline with a storage event trigger delivers the highest-throughput file ingestion

    A-grade Dispute: 0% 3 comments

  37. One scheduled pipeline invoking the others sequences the medallion layers

    A-grade Dispute: 0% 5 comments

  38. OPTIMIZE plus VACUUM minimizes query time on a table of 2,000 one-MB files

    A-grade Dispute: 0% 3 comments

  39. sys.dm_exec_sessions identifies the users actively running warehouse queries

    A-grade Dispute: 0% 4 comments

  40. VACUUM removes lakehouse files older than seven days that are no longer in use

    A-grade Dispute: 0% 3 comments

  41. Which Fabric store supports T-SQL, KQL, and Spark reads with Spark writes?

    A-grade Dispute: 0% 89 comments

  42. Which Fabric item copies on-premises SQL Server data to Warehouse1?

    A-grade Dispute: 0% 18 comments

  43. What Data Does Eventhouse OneLake Availability Copy?

    A-grade Dispute: 0% 54 comments

  44. Which authentication should Azure DevOps use for Fabric deployment pipeline API?

    A-grade Dispute: 0% 17 comments

  45. Which workspace role meets least privilege for viewing items and updating DW1?

    A-grade Dispute: 0% 56 comments

  46. How Do Fabric Default Domains Affect Workspace3 Access?

    A-grade Dispute: 0% 23 comments

  47. Does KQL Order By Return Ascending No_Bikes Results?

    A-grade Dispute: 0% 16 comments

  48. How Should Contoso Access Amazon S3 Email Data in Fabric?

    A-grade Dispute: 0% 31 comments

  49. Streaming IoT Data into Fabric Lakehouse for NRT Dashboards

    A-grade Dispute: 0% 2 comments

  50. Why Do Direct Lake Reports Fail on F32 Capacity?

    A-grade Dispute: 0% 98 comments

  51. Which Columns Belong in DimProduct?

    A-grade Dispute: 0% 18 comments

  52. Isolating PII Tables in a Fabric Lakehouse

    A-grade Dispute: 0% 26 comments

  53. Which Warehouse Object Implements Row-Level Security in Fabric?

    A-grade Dispute: 0% 9 comments

  54. What Actually Deploys from Workspace1_DEV to Workspace1_TEST in a Fabric Deployment Pipeline?

    A-grade Dispute: 0% 30 comments

  55. Validating Invalid References in a Fabric Warehouse

    A-grade Dispute: 0% 20 comments

  56. OneLake Shortcut Cache Retention and Data Retrieval

    A-grade Dispute: 0% 44 comments

  57. Which Fabric Shortcuts Use the OneLake Cache?

    A-grade Dispute: 0% 61 comments

  58. Which Role Creates a New Fabric Domain and Subdomains

    A-grade Dispute: 0% 38 comments

  59. Deployment Pipeline: Overwriting Paired Items in the Target Workspace

    A-grade Dispute: 0% 12 comments

  60. How to Mask Phone in Fabric Warehouse for Group1 Only?

    A-grade Dispute: 0% 1 comments

  61. Which two Fabric warehouse tables should you refresh first?

    A-grade Dispute: 0% 1 comments

  62. Choosing Starter Pool vs Custom Spark Pool per Notebook

    A-grade Dispute: 0% 6 comments

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