MICROSOFT FABRIC DP-600
CERTIFICATION EXAM QUESTIONS
AND ANSWERS GRADED A+ 2026
What abilities (5) does the viewer role have in Microsoft lakehouses, warehouses and related
apps? - ANS 1) View/read content of data pipelines and notebooks
2) Execute/cancel execution of data pipelines (not notebooks)
3) View execution output of data pipelines and notebooks
4) Connect to and read data/shortcuts through lakehouse/warehouse SQL analytics endpoint
5) Reshare items in a workspace, if you have Reshare permissions
What abilities (6), beyond the included viewer ones, does the contributor roles have in
Microsoft lakehouses and related apps? - ANS 1) Read lakehouse/wwarehouse
data/shortcuts through OneLake APIs and Spark
2) Read lakehouse data through Lakehouse Explorer
3) Write/delete data pipelines and notebooks
4) Execute/cancel execution of notebooks
5) Schedule data-refresh via the on-premises gateway
6) Modify gateway connection settings.
What abilities (2) (beyond viewer/contributor) does the member role have in Microsoft
lakehouses and related apps? - ANS 1) Add members, contributors, and viewers
2) Allow others to reshare items
@COPYRIGHT 2026/2027 ALLRIGHTS RESERVED 1
, What abilities (2), beyond viewer/contributor/member does the admin role have in Microsoft
lakehouses and related apps? - ANS 1) Update and delete the workspace
2) Add/remove admins, members, contributors, and viewers
How do you give access to your workspace (3 steps) - ANS 1) In the workspace, click on
manage access (it may be in the ... section)
2) Click "+Add people or groups"
3) Enter name/email and role, and click "Add"
Capacity Unit - ANS A pool of compute power, needed to run queries, jobs, or tasks in Fabric
What are the requirements and actions of the 1st normal form? - ANS Requirements:
The values in each column must be atomic (indivisible - e.g. column cant have a first and last
name)
Each value contains only a single value
Actions
Elimate repeating groups in individual tables
Create a separate table for each set of related data
Identify each set of related data with a primary key
What are the requirements and actions of the 2nd normal form? - ANS Requirements
Is in the 1st normal form
Reduce repeating info
Actions
Create separate tables for values that apply to multiple records
@COPYRIGHT 2026/2027 ALLRIGHTS RESERVED 2
CERTIFICATION EXAM QUESTIONS
AND ANSWERS GRADED A+ 2026
What abilities (5) does the viewer role have in Microsoft lakehouses, warehouses and related
apps? - ANS 1) View/read content of data pipelines and notebooks
2) Execute/cancel execution of data pipelines (not notebooks)
3) View execution output of data pipelines and notebooks
4) Connect to and read data/shortcuts through lakehouse/warehouse SQL analytics endpoint
5) Reshare items in a workspace, if you have Reshare permissions
What abilities (6), beyond the included viewer ones, does the contributor roles have in
Microsoft lakehouses and related apps? - ANS 1) Read lakehouse/wwarehouse
data/shortcuts through OneLake APIs and Spark
2) Read lakehouse data through Lakehouse Explorer
3) Write/delete data pipelines and notebooks
4) Execute/cancel execution of notebooks
5) Schedule data-refresh via the on-premises gateway
6) Modify gateway connection settings.
What abilities (2) (beyond viewer/contributor) does the member role have in Microsoft
lakehouses and related apps? - ANS 1) Add members, contributors, and viewers
2) Allow others to reshare items
@COPYRIGHT 2026/2027 ALLRIGHTS RESERVED 1
, What abilities (2), beyond viewer/contributor/member does the admin role have in Microsoft
lakehouses and related apps? - ANS 1) Update and delete the workspace
2) Add/remove admins, members, contributors, and viewers
How do you give access to your workspace (3 steps) - ANS 1) In the workspace, click on
manage access (it may be in the ... section)
2) Click "+Add people or groups"
3) Enter name/email and role, and click "Add"
Capacity Unit - ANS A pool of compute power, needed to run queries, jobs, or tasks in Fabric
What are the requirements and actions of the 1st normal form? - ANS Requirements:
The values in each column must be atomic (indivisible - e.g. column cant have a first and last
name)
Each value contains only a single value
Actions
Elimate repeating groups in individual tables
Create a separate table for each set of related data
Identify each set of related data with a primary key
What are the requirements and actions of the 2nd normal form? - ANS Requirements
Is in the 1st normal form
Reduce repeating info
Actions
Create separate tables for values that apply to multiple records
@COPYRIGHT 2026/2027 ALLRIGHTS RESERVED 2
