Question 1
You need to grant a group of analysts read-only access to all Fabric items within a workspace.
Which workspace role should you assign?
A. Admin
B. Member
C. Contributor
D. Viewer
Answer: D
Explanation
The Viewer role provides read-only access to workspace content.
- Admin allows full management.
- Member allows content creation and modification.
- Contributor allows editing.
- Viewer is the least privileged role that satisfies the requirement.
Question 2
A company stores raw CSV files in a Bronze layer and cleansed Delta tables in a Silver layer.
What is the primary purpose of the Silver layer?
A. Long-term archival
B. Cleansed and validated data
C. Business reporting
D. Security auditing
Answer: B
Explanation
The Silver layer contains validated, transformed, and standardized data prepared for downstream analytics.
Question 3
Select TWO answers.
Which Fabric items can directly consume data from OneLake shortcuts?
A. Lakehouse
B. Warehouse
C. Eventstream
D. Dataflow Gen2
E. Activator
Answer: A, B
Explanation
OneLake shortcuts are commonly used by Lakehouses and Warehouses to access external data without duplication.
Question 4
Match each technology to its primary use case.
| Technology | Use Case |
|---|---|
| 1. Dataflow Gen2 | A. Streaming event processing |
| 2. Eventstream | B. Low-code data transformation |
| 3. Notebook | C. Advanced Spark development |
Answer
- 1 → B
- 2 → A
- 3 → C
Explanation
Each Fabric component addresses a specific processing requirement.
Question 5
Fill in the blank.
Delta tables use the __________ transaction log to provide ACID compliance.
Answer
Delta Log
Explanation
The Delta Log records transactional metadata and enables reliable operations.
Question 6
A Fabric pipeline must execute three data loads in a specific order because each load depends on the previous one.
What should you configure?
A. Sequential dependencies
B. Parallel execution
C. Eventhouse ingestion
D. Activator triggers
Answer: A
Explanation
Dependent tasks should execute sequentially using activity dependencies.
Question 7
A real-time analytics solution requires querying billions of telemetry events with low latency.
Which Fabric component is best suited for this workload?
A. Semantic Model
B. Warehouse
C. Eventhouse
D. Dataflow Gen2
Answer: C
Explanation
Eventhouse is optimized for high-volume, low-latency analytical workloads.
Question 8
Which KQL operator is primarily used to filter rows?
A. summarize
B. project
C. extend
D. where
Answer: D
Explanation
The where operator filters data based on specified conditions.
Question 9
A notebook execution fails due to an OutOfMemory error.
What should you investigate first?
A. Spark pool sizing
B. Workspace permissions
C. Semantic model refresh schedule
D. Pipeline trigger settings
Answer: A
Explanation
Memory-related failures typically indicate insufficient Spark resources.
Question 10
Select THREE answers.
Which factors commonly improve Lakehouse query performance?
A. V-Order optimization
B. Partition pruning
C. Delta optimization
D. Increasing file fragmentation
E. Removing statistics
Answer: A, B, C
Explanation
These optimizations reduce scanning and improve storage efficiency.
Question 11
You need to monitor Fabric capacity consumption over time.
Which tool should you use?
A. Eventstream diagnostics
B. Capacity Metrics App
C. Warehouse explorer
D. Semantic model lineage view
Answer: B
Explanation
The Capacity Metrics App provides detailed capacity usage and performance insights.
Question 12
A data engineering team wants to ingest data from Azure Event Hubs into Fabric in real time.
Which Fabric component should be configured first?
A. Warehouse
B. Notebook
C. Eventstream
D. Semantic Model
Answer: C
Explanation
Eventstreams are designed for real-time event ingestion.
Question 13
Match the optimization technique to the benefit.
| Technique | Benefit |
|---|---|
| 1. Broadcast Join | A. Reduce network shuffle |
| 2. Caching | B. Speed repeated access |
| 3. Partition Pruning | C. Reduce scanned data |
Answer
- 1 → A
- 2 → B
- 3 → C
Question 14
A Dataflow Gen2 refresh succeeds but loads fewer rows than expected.
What should you investigate first?
A. Applied transformation steps
B. Workspace branding
C. Capacity SKU name
D. Semantic model permissions
Answer: A
Explanation
Filtering or transformation logic may be unintentionally excluding records.
Question 15
Which Spark Structured Streaming feature helps handle late-arriving data?
A. Repartitioning
B. Watermarking
C. Broadcast joins
D. Delta optimization
Answer: B
Explanation
Watermarks define how long late events can be accepted.
Question 16
Select TWO answers.
Which destinations are commonly used with Eventstreams?
A. Eventhouse
B. Lakehouse
C. Semantic Model
D. Power BI Dashboard
Answer: A, B
Explanation
Eventstreams commonly route data into Eventhouse and Lakehouse destinations.
Question 17
Fill in the blank.
The KQL __________ operator is frequently used to aggregate data into groups.
Answer
summarize
Explanation
summarize performs aggregations such as count(), avg(), and max().
Question 18
A Fabric warehouse query experiences poor performance due to scanning an entire fact table.
Which optimization should be considered first?
A. More dashboards
B. Query filtering
C. Additional workspaces
D. Manual report refreshes
Answer: B
Explanation
Proper filtering significantly reduces data scanned.
Question 19
A team needs to access external Amazon S3 data without copying it into Fabric.
Which feature should they use?
A. Data Activator
B. Deployment Pipeline
C. OneLake Shortcut
D. Semantic Link
Answer: C
Explanation
OneLake shortcuts provide logical access to external storage.
Question 20
A streaming solution requires event aggregation every five minutes.
Which concept should be implemented?
A. Delta optimization
B. Windowing
C. Caching
D. Workspace roles
Answer: B
Explanation
Windowing groups events into time-based intervals.
Question 21
A notebook suddenly fails after a package upgrade.
What is the most likely cause?
A. Dependency incompatibility
B. Lakehouse corruption
C. Eventstream throttling
D. Capacity scaling
Answer: A
Explanation
Package upgrades frequently introduce compatibility issues.
Question 22
Select THREE answers.
Which metrics are useful when monitoring Eventhouse ingestion?
A. Ingestion latency
B. Throughput
C. Failed ingestions
D. Workspace color settings
E. Queue backlog
Answer: A, B, C
Explanation
These metrics directly measure ingestion health and performance.
Question 23
A Fabric administrator wants to identify which workloads consume the most capacity units.
Which tool should be used?
A. Dataflow Gen2
B. Activator
C. Capacity Metrics App
D. Eventstream canvas
Answer: C
Explanation
The Capacity Metrics App breaks down workload consumption.
Question 24
A pipeline includes several independent copy activities.
What is the best way to improve overall execution speed?
A. Disable monitoring
B. Execute sequentially
C. Reduce logging
D. Execute in parallel
Answer: D
Explanation
Parallel execution reduces total pipeline duration.
Question 25
Match each item to the most likely troubleshooting location.
| Issue | Tool |
|---|---|
| 1. Notebook error | A. Spark execution logs |
| 2. Pipeline failure | B. Pipeline run history |
| 3. Eventhouse ingestion issue | C. Ingestion diagnostics |
Answer
- 1 → A
- 2 → B
- 3 → C
Question 26
You need to improve performance of repeated Spark computations.
Which technique should you use?
A. Increase shuffle operations
B. Remove partitions
C. Cache intermediate DataFrames
D. Disable parallelism
Answer: C
Explanation
Caching avoids recomputation of frequently accessed datasets.
Question 27
A company wants automatic notifications when a streaming metric exceeds a threshold.
Which Fabric feature should be implemented?
A. Warehouse
B. Data Activator
C. Notebook
D. Shortcut
Answer: B
Explanation
Data Activator enables event-driven notifications and actions.
Question 28
Select TWO answers.
Which actions help optimize Eventhouse query performance?
A. Use filtering predicates
B. Reduce scanned data
C. Increase file fragmentation
D. Remove aggregation logic
Answer: A, B
Explanation
Filtering and reducing scanned data improve query efficiency.
Question 29
Fill in the blank.
A Fabric deployment pipeline is primarily used to promote content between development, test, and __________ environments.
Answer
production
Explanation
Deployment pipelines support lifecycle management across environments.
Question 30
A Fabric solution experiences intermittent performance degradation during peak business hours.
Which action should be performed first?
A. Delete semantic models
B. Disable monitoring
C. Review workload utilization and capacity metrics
D. Rebuild all Lakehouses
Answer: C
Explanation
Capacity metrics help identify bottlenecks, workload spikes, throttling, and resource contention before major architectural changes are made.
Go to the DP-700 Exam Prep Hub main page.
The Data Community 