DP-600
Free Microsoft Certified: Fabric Analytics Engineer Associate Practice Test
12 exam-style questions with full explanations — no sign-up. Score yourself, then close your gaps with the full course.
Exam fee ~$1653 exam domainsLevel Intermediate2 timed practice tests in the course
✅ Free practice — no sign-up📝 Real exam-style questions💡 Detailed explanations💸 30-day money-back via Udemy
A Fabric workspace admin wants to add a new team member who will build and publish reports, create lakehouses, and modify semantic models, but who must NOT be able to add other users to the workspace or change workspace-level settings. Which workspace role should be assigned?
Contributor can create, edit, and publish content (reports, lakehouses, semantic models) within the workspace but cannot manage workspace access or update workspace settings.
A data engineering team must transform 500 GB of raw JSON files daily using complex custom Python logic, including machine learning feature engineering, before landing the results as Delta tables in a lakehouse. Which Fabric tool should they use for this transformation?
Spark notebooks support full custom Python code, distributed processing at scale, and libraries for ML feature engineering — Dataflow Gen2's Power Query M engine cannot handle this level of custom logic or volume efficiently.
A company runs a Direct Lake semantic model on an F64 Fabric capacity. One of the underlying lakehouse tables grows beyond the row-count guardrail defined for F64. By default, what happens when a report visual queries that specific table?
When a Direct Lake table exceeds the capacity's row-count or size guardrails, Fabric automatically falls back to DirectQuery for queries against that table (fallback behavior is on by default and can be disabled).
A lakehouse contains a Files section with subfolders for Finance, HR, and Sales data. You need to grant an external audit team read-only access to only the Finance subfolder, without exposing any other folder or the SQL analytics endpoint's other tables. Which Fabric feature should you configure?
OneLake data access roles let you define folder-level permissions inside a lakehouse (via one or more folder paths) and assign specific users or groups read access to only that scope, independent of workspace roles.
A team creates a OneLake shortcut in a lakehouse that points to an existing ADLS Gen2 container containing Parquet files. What happens to the data as a result of creating this shortcut?
Shortcuts create a virtual reference to data in its original location (ADLS Gen2, S3, or another Fabric item) so it can be accessed as if it were in OneLake, without any physical data movement or duplication.
A financial services company continuously loads high-volume transaction data into a Fabric warehouse throughout the day. Analysts need Power BI reports that reflect changes within seconds, without scheduled refreshes and without duplicating the underlying data into the semantic model. Which storage mode should you choose?
Direct Lake reads Delta Parquet files directly from OneLake with near in-memory (Vertipaq-like) query performance and no scheduled refresh or data duplication, making it the optimal choice for near-real-time reporting on lakehouse/warehouse data.
You are configuring row-level security (RLS) on a Fabric semantic model. Each sales representative should see only rows in the Sales table where the SalesRepEmail column matches the email address of the signed-in Power BI Service user. Which DAX table filter expression should you use in the RLS role definition?
USERPRINCIPALNAME() returns the UPN (typically the email address) of the signed-in user in the Power BI Service, making it the correct function to match against an email-formatted column for RLS.
A team requires full T-SQL INSERT, UPDATE, and DELETE support with multi-statement transactional guarantees on their structured tables in Fabric. Which item should they create to meet this requirement?
A Fabric Warehouse provides a full T-SQL engine with complete DML support (INSERT/UPDATE/DELETE) and multi-table transactions, matching traditional data warehouse semantics.
You need dynamic row-level security so that each salesperson viewing a report sees only rows where Sales[SalesRegion] matches their assigned region, stored in a Regions table with a UserPrincipalName column. Which DAX filter expression should you use in the RLS role defined on the Sales table?
LOOKUPVALUE correctly retrieves the region assigned to the currently signed-in user (via USERPRINCIPALNAME) from the Regions table and compares it against SalesRegion, implementing proper dynamic RLS.
A Fabric Warehouse table stores customer email addresses in a column named Email. You need to ensure that users without unmask permission see a masked version of the email (e.g., aXX@XXXX.com) when querying the table, while the underlying data remains unchanged. Which T-SQL statement should you run?
Dynamic Data Masking in Fabric Warehouse (T-SQL) is applied with ALTER TABLE ... ALTER COLUMN ... ADD MASKED WITH (FUNCTION = 'email()'), which obfuscates the email format for users lacking UNMASK permission while leaving stored data intact.
For a star-schema semantic model optimized for DAX performance in Fabric, which approach to handling dates is recommended?
Best practice is one shared, marked date dimension with a single-direction active relationship to each fact table's date key, enabling consistent time intelligence and efficient DAX evaluation across the model.
What are calculation groups primarily used for in a Power BI semantic model?
Calculation groups let you define calculation items (e.g., YTD, PY, currency conversion) once and apply them to any measure at query time, dramatically reducing measure duplication and DAX maintenance overhead.
Ready for the real thing?
The full course: two full-length practice tests, video lessons for every exam domain, hands-on labs and detailed explanations.
$109.99 $34.99 with code FREETEST33 — valid through September 16.
Get my $34.99 deal →DP-600 exam — quick answers
How much does the DP-600 exam cost?
The exam fee is approximately $165 and varies by region — confirm current pricing with the certification vendor before you book.
What topics are on the exam?
It covers 3 domains: Maintain a data analytics solution (25-30%), Prepare data (45-50%), Implement and manage semantic models (25-30%). The full course has a dedicated chapter, lab and practice-test coverage for each.
Is this practice test really free?
Yes — all questions on this page are free with explanations and no sign-up. The paid Udemy course adds two full-length timed exams, video lessons and hands-on labs.
How do I get the discount?
Use code FREETEST33 at checkout for $34.99 (list $109.99) through September 16 — the enroll button applies it automatically.
Will this prepare me for the real exam?
The questions mirror the real exam's style and are mapped to the official domains. This is exam-focused preparation — combine the free test with the full course's timed simulations to gauge your readiness.