Microsoft Updated DP-600 Exam Questions and Answers by leena

Requirement

Fabric workspace: Workspace1

Contains: Warehouse1, Model1, Report1

Task: Allow User1 to access a single table in Warehouse1.

Must follow principle of least privilege → grant only the exact permissions required.

Step 1: Evaluate Options

A. Assign object level permissions to User1 for Warehouse1.

In Fabric warehouses, you can grant permissions at the object level (table, schema, or column).

If the requirement is access to only one table, the correct approach is to grant SELECT permissions on that specific table.

This satisfies least privilege.

Correct. ✅

B. Assign the db_datareader role to User1 for Warehouse1.

db_datareader provides read access to all tables in the database/warehouse.

This violates least privilege.

Not correct.

C. Share Warehouse1 with User1.

Sharing grants access to the whole warehouse.

Too broad, not least privilege.

Not correct.

D. Assign the Viewer role to User1 for Workspace1.

Viewer role allows seeing all items in the workspace (warehouse, model, reports).

This would expose more than the single table.

Not correct.

Step 2: Correct Action

Use object-level permissions:

GRANT SELECT ON dbo.TableName TO [User1];

This ensures User1 can only query that specific table, nothing else.

References

Manage object-level security in Microsoft Fabric warehouses

Principle of least privilege in Fabric

To identify the slowest DAX query and analyze the time it spends in the formula engine compared to the storage engine, you should perform the following actions in sequence:

From Performance analyzer, capture a recording.

View the Server Timings tab.

Enable Query Timings and Server Timings. Run the query.

View the Query Timings tab.

Sort the Duration (ms) column in descending order by DAX query time.

For a Type 1 SCD, you should include actions that update rows when non-key attributes have changed (A), and insert new records when the natural key is a new value in the table (D). A Type 1 SCD does not track historical data, so you always overwrite the old data with the new data for a given key. References = Details on Type 1 slowly changing dimension patterns can be found in data warehousing literature and Microsoft ' s official documentation.