DP-700 Implement and Manage an Analytics Solution Practice Question
You are managing a Microsoft Fabric Lakehouse. You need to ensure that data in the Bronze layer is accessible to the Silver layer while enforcing strict row-level security for downstream users. What is the most efficient way to implement this architecture while maintaining performance?
⚠ Common exam trap
Candidates often suggest creating physical copies of data for different security roles. This ignores the efficiency of Fabric semantic models, which apply security logic without duplicating the underlying storage.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a Fabric semantic model over the Silver layer and implement row-level security within the model settings.
Implementing Medallion architecture using shortcuts and Fabric security roles provides a decoupled, performant approach. By utilizing OneLake shortcuts, you avoid unnecessary data movement between layers, reducing latency. Applying row-level security through Fabric's semantic model permissions ensures that end-users only access data relevant to their authorization level without requiring redundant copies of the underlying Parquet files, thus optimizing compute and storage utilization across the analytics lifecycle.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Export Bronze data to a separate Azure SQL database to apply row-level security via T-SQL stored procedures.
Why it's wrong here
Exporting data to Azure SQL introduces unnecessary latency and maintenance overhead. Fabric Lakehouses natively support security configurations that do not require external database engines. This approach breaks the unified data platform model, increasing costs and complicating the synchronization process between the storage layer and the reporting engine.
- ✗
Use Microsoft Purview to enforce row-level security directly on the Parquet files stored in OneLake.
Why it's wrong here
Microsoft Purview provides data governance and discovery, not transactional security enforcement on raw Parquet files. While it can label sensitive data, it does not act as a security gateway for data access at the row level. Row-level security must be implemented through the Fabric semantic model or SQL endpoint.
- ✓
Create a Fabric semantic model over the Silver layer and implement row-level security within the model settings.
Why this is correct
Fabric semantic models allow you to define granular security roles that filter data dynamically for users. This is the standard, high-performance method for controlling access in Fabric, ensuring that the lakehouse remains the single source of truth while providing secure, compliant access for Power BI reporting and analysis.
- ✗
Create separate physical copies of the Silver layer tables for every user group requiring restricted access.
Why it's wrong here
Creating physical copies results in data sprawl, increased storage costs, and significant synchronization challenges. This approach negates the benefits of the Lakehouse architecture, which emphasizes a single, performant storage layer. Security should be managed through logical permissions rather than physical duplication, ensuring data integrity and reducing management overhead.
About these practice questions
Courseiva writes every DP-700 question from scratch — 152 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-700 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-700 exam.