DP-700 · Practice set 1 of 9
What Is Microsoft Fabric?: 10 practice questions
10 free DP-700 practice questions on What Is Microsoft Fabric?, with an explanation for every answer. Untimed. The full mock exam and the timed version are in the app.
-
Question 1 of 10
Which description best defines Microsoft Fabric?
- AA desktop-only tool that creates reports from local spreadsheets
- BA single-purpose Spark service without storage or reporting capabilities
- CA SaaS analytics platform that supports end-to-end data workflows
- DA physical data lake appliance installed in each business unit
Show the answer
Fabric unifies ingestion, transformation, real-time processing, analytics, and reporting on a shared SaaS foundation.
Next → 1 / 10 -
Question 2 of 10
What is OneLake's platform-level role in Fabric?
- AIt replaces every specialized workload with one universal query engine
- BIt provides a centralized logical data lake shared by Fabric workloads
- CIt stores only Power BI reports and excludes engineering data items
- DIt provides a separate storage account that each notebook must provision
Show the answer
OneLake is the shared storage foundation through which Fabric workloads store and access organizational data.
Next → 2 / 10 -
Question 3 of 10
Which Fabric workload is centered on Apache Spark, notebooks, and transformation jobs?
- AData Engineering
- BPower BI
- CFabric Data Warehouse
- DReal-Time Intelligence
Show the answer
Data Engineering provides Spark processing, notebooks, and tools for writing and scheduling transformation jobs.
Next → 3 / 10 -
Question 4 of 10
Which platform problem does Fabric primarily reduce?
- AThe inability to operate any workload through cloud software
- BThe absence of local spreadsheet formatting in business reports
- CThe need to replace structured data with unstructured files
- DFragmentation across disconnected data and analytics services
Show the answer
Fabric puts lifecycle stages on shared foundations to reduce silos, manual integration, and duplicated platform work.
Next → 4 / 10 -
Question 5 of 10
How do Fabric workloads relate to one another?
- AThey run as isolated products and require exported files for every handoff
- BThey share a brand name but cannot use artifacts created by another workload
- CThey remain task-specific but share a common Fabric environment and data foundation
- DThey all expose identical tools and remove the need to select an experience
Show the answer
Fabric keeps workload-specific tools while allowing them to share data and artifacts through the same platform foundation.
Next → 5 / 10 -
Keep the ones you got wrong
In the app, every question you miss comes back exactly when you’re about to forget it.
-
Question 6 of 10
Which sequence illustrates an end-to-end Fabric solution?
- AStore in Copilot, transform with the catalog, and visualize with a capacity unit
- BVisualize with OneLake, store with Power BI, and ingest with Microsoft Purview
- CProcess with Power BI, govern with a notebook, and report through a Spark pool
- DIngest with Data Factory, process with Data Engineering, and visualize with Power BI
Show the answer
The workloads specialize by stage: Data Factory ingests, Data Engineering processes, and Power BI visualizes, with OneLake beneath them.
Next → 6 / 10 -
Question 7 of 10
Why can OneLake reduce duplicate copies between analytics tools?
- AFabric disables specialized storage patterns whenever more than one workload is used
- BOneLake requires each workload to maintain a private copy under a separate tenant
- COneLake converts every workload into the same compute engine before data is read
- DFabric workloads can access shared data through the same logical storage layer
Show the answer
Shared access through OneLake lets several experiences work with the same organizational data instead of creating a copy per service.
Next → 7 / 10 -
Question 8 of 10
A team needs scheduled ingestion, Spark transformations, and interactive business reports. It wants shared data and minimal manual integration between services. Which approach fits best?
- AUse OneLake as the transformation engine and remove every task-specific workload
- BDeploy three isolated services and export a full data copy after every processing step
- CUse Power BI alone and replace ingestion and Spark processing with report visuals
- DUse Data Factory, Data Engineering, and Power BI together over OneLake
Show the answer
Fabric combines the three specialized workloads over OneLake, meeting all stages while reducing manual integration and duplication.
Next → 8 / 10 -
Question 9 of 10
An organization has duplicated datasets across engineering, warehouse, and BI platforms. It wants specialized tools but a common governed storage foundation. What should it adopt?
- AMicrosoft Fabric workloads operating over OneLake
- BIndependent platforms with separate storage and manual file transfers
- CA collection of local notebooks without tenant-wide storage or governance
- DOne universal reporting workload replacing engineering and warehouse processing
Show the answer
Fabric preserves specialized workloads while OneLake supplies the shared logical data layer and the platform centralizes governance.
Next → 9 / 10 -
Question 10 of 10
A new engineer sees a notebook inside a workspace and assumes it is the whole Fabric platform. Which correction is accurate and useful for navigating the product?
- AThe notebook is OneLake, because code cells provide the platform's shared storage layer
- BThe notebook is the tenant, and every other workload must be created inside that document
- CThe notebook is an item in Data Engineering, which is one workload in the wider Fabric platform
- DThe notebook is a capacity unit, so it defines how much compute every workspace receives
Show the answer
Fabric is the platform, Data Engineering is a specialized workload, and the notebook is one item used within that workload.
Next → 10 / 10 -
You’ve finished this set
That’s 10 questions on What Is Microsoft Fabric?. In the app the ones you miss come back exactly when you’re about to forget them.
The whole course, on your phone
Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.