DP-600 CERTIFICATION MICROSOFT FABRIC
What abilities (5) does the viewer role have in Microsoft lakehouses, warehouses and
related apps? - Answer -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? - Answer -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? - Answer -1) Add members, contributors, and viewers
2) Allow others to reshare items
What abilities (2), beyond viewer/contributor/member does the admin role have in
Microsoft lakehouses and related apps? - Answer -1) Update and delete the workspace
2) Add/remove admins, members, contributors, and viewers
How do you give access to your workspace (3 steps) - Answer -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 - Answer -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? - Answer -
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
What abilities (5) does the viewer role have in Microsoft lakehouses, warehouses and
related apps? - Answer -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? - Answer -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? - Answer -1) Add members, contributors, and viewers
2) Allow others to reshare items
What abilities (2), beyond viewer/contributor/member does the admin role have in
Microsoft lakehouses and related apps? - Answer -1) Update and delete the workspace
2) Add/remove admins, members, contributors, and viewers
How do you give access to your workspace (3 steps) - Answer -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 - Answer -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? - Answer -
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
