You are implementing a lakehouse in Fabric and need to ensure it supports multiple analytics engines (Spark, SQL, Power BI). What storage format should be used for maximum reuse within OneLake?
A- Proprietary binary format only readable by Spark.
B- Delta (Delta Parquet) or Iceberg table format on OneLake.
C- Plain CSV files in folders.
D- Excel files in OneDrive.
CORRECT ANSWER - B
Delta (Delta Parquet) or Iceberg table format on OneLake.
You want to register your Fabric tenant with Purview to enable metadata and lineage scanning. Which type of authentication is currently required for scanning lakehouses and other items (non-Power BI) in Fabric?
A- Managed Identity only.
B- Service Principal only (for lakehouse scanning).
C- Username/password.
D- No authentication needed.
CORRECT ANSWER - A
Managed Identity only.
A dataset in Fabric has high business value and is trusted for reuse across units. You want to flag it accordingly so analysts can find it easily. What feature supports this in OneLake catalog?
A- Marking dataset as “Archived.
B- Endorsement status (e.g., Certified, Promoted, Master) and tags/description metadata.
C- Hiding it from the catalog.
D- Copying it to each workspace.
CORRECT ANSWER - B
Endorsement status (e.g., Certified, Promoted, Master) and tags/description metadata.
Your organisation has historically maintained separate data lakes and warehouses per business unit. With Microsoft Fabric in place, you want to reduce duplication and enable analytics across units. Which approach best aligns with the OneLake architecture?
A - Maintain separate physical lakes for each business unit and replicate key tables manually.
B - Use OneLake as the single logical data lake, store data once and let different engines (Spark, SQL, Power BI) access the same tables.
C - Copy data from OneLake into each business unit’s workspace for performance.
D - Only use OneLake for archival data; keep hot analytics in separate silos.
CORRECT ANSWER - B
Use OneLake as the single logical data lake, store data once and let different engines (Spark, SQL, Power BI) access the same tables.
Team A has a lakehouse in Workspace 1, and Team B in Workspace 2 needs to access some of Team A’s data regularly. You want to enable access without creating full copies. What feature of Microsoft Fabric supports this scenario?
A- Export Team A’s data and import into Team B’s workspace.
B- Use OneLake shortcut from Team B’s workspace to reference Team A’s data in OneLake.
C- Create a brand-new data copy for Team B and schedule nightly sync.
D- Duplicate the lakehouse entirely and rename it
CORRECT ANSWER - B
Use OneLake shortcut from Team B’s workspace to reference Team A’s data in OneLake
You are the Fabric admin and need to review which items have missing descriptions or are rarely accessed across workspaces to improve data governance. Which tab in the OneLake catalog provides insights and recommended actions for this governance posture?-
A-Explore tab only
B-Govern tab
C-Secure tab
D-Usage tab
CORRECT ANSWER -B
Govern tab
Your organisation uses Fabric and needs to maintain lineage, classification and access controls across all workspaces and datasets. Which solution is integrated with Fabric to deliver enterprise-wide governance of the fabric data estate?
A- Only Fabric workspaces governance features.
B- Microsoft Purview (Unified Catalog, sensitivity labels, DLP).
C- Use Power BI service only.
D- Third-party catalogue independent of Fabric.
CORRECT ANSWER - B
Microsoft Purview (Unified Catalog, sensitivity labels, DLP).
You have a lakehouse table in Fabric/OneLake and want to periodically measure data quality (completeness, validity) and report on it. What is the correct approach in Fabric using Purview?
A- Import the data into Excel and run macros.
B- Use Purview data-quality scan on lakehouse tables after registering the data source.
C- Build a custom Spark job only.
D- Skip quality scanning and rely on manual checks.
CORRECT ANSWER -B
Use Purview data-quality scan on lakehouse tables after registering the data source.
As a security admin you need to review workspace roles, OneLake item permissions, and audit access in a single view inside Fabric. Which part of the OneLake catalog provides that unified security view?
A- Explore tab
B- Govern tab
C- Secure tab
D- Monitor tab
CORRECT ANSWER - C
Secure tab
You want to prevent sensitive data (e.g., PII) from being accessed or exported from lakehouse tables in Fabric. Which capability should you use?
A-Only Azure AD conditional access.
B-Purview DLP policies applied to Fabric/OneLake items.
C-Security through obscurity (hide folders).
D-Manual review of every dataset.
CORREECT ANSWER -B
Purview DLP policies applied to Fabric/OneLake items.
Your organisation defines “Customer” and “Product” as data domains. You want to assign ownership, metadata and endorsement status accordingly. Which feature supports this within the OneLake catalog govern view?
A-Only workspace admins.
B-Domain selector in Govern tab, endorsement types (Master, Certified, Promoted).
C-External spreadsheet only.
D-None — domains are not supported.
CORRECT ANSWER - B
Domain selector in Govern tab, endorsement types (Master, Certified, Promoted).
Your firm needs near-real-time ingestion of streaming data into the lakehouse in Fabric for downstream analytics and exposure to BI teams. Which overall architecture aligns with Fabric best practices?
A- Use batch ingestion daily only.
B- Use event-driven ingestion (e.g., streaming) into OneLake lakehouse, Spark or SQL engine, then make available to BI/AI.
C- Use CSV dumps and manual uploads.
D- Use separate data warehouse outside Fabric.
CORRECT ANSWER - B
Use event-driven ingestion (e.g., streaming) into OneLake lakehouse, Spark or SQL engine, then make available to BI/AI.
