DP-700 CERTIFICATION QUESTIONS WITH DETAILED
VERIFIED ANSWERS (100% CORRECT ANSWERS)
/ALREADY GRADED
Where is license management for Fabric handled? Ans✓✓✓Microsoft
365 admin center
What is the primary function of Activator in Microsoft Fabric?
Ans✓✓✓Activator is designed to automate actions triggered by specific
events in data streams.
What Does Activator monitor Ans✓✓✓It monitors data in Power BI
reports and eventstreams
What is the critical difference between the Member and Contributor
workspace roles? Ans✓✓✓The critical difference between the Member
and Contributor workspace roles is that Members can view, modify, and
share all content and data in the workspace, while Contributors can view
and modify all content and data but cannot share content. The sharing
capability is the key distinction between these two roles.
Which T-SQL commands are used to apply granular permissions in a
lakehouse? Ans✓✓✓Granular permissions in a lakehouse are applied
using T-SQL Data Control Language (DCL) commands such as
GRANT, DENY, and REVOKE.
,What feature allows access to data in the lakehouse to be restricted to
specific files or folders? Ans✓✓✓OneLake data access controls enable
the restriction of access to specific files or folders within the lakehouse.
What is the role of a domain in Microsoft Fabric? Ans✓✓✓A domain is
a logical grouping of workspaces used to organize items in a way that
makes sense for an organization, such as grouping by sales, marketing,
or finance.
In Fabric, what is the purpose of workspace roles? Ans✓✓✓Workspace
roles in Fabric are used to distribute ownership and access policies
within a workspace, enabling control over who can access and manage
resources.
What is the primary purpose of data lineage in Microsoft Fabric?
Ans✓✓✓Data lineage allows you to track the flow of data through
Fabric, including its origin, transformations, and destinations, providing
insights into how data is used.
Which of the following statements best describes continuous delivery?
Ans✓✓✓Continuous delivery follows continuous integration and
involves deploying code to a staging environment for additional
automated testing before production release.
What is the first step in securing data when managing sharing and
distribution of items? Ans✓✓✓The first step in securing data is to grant
, the least permissive rights, which helps to minimize access and protect
sensitive information.
What is OneLake in Microsoft Fabric? Ans✓✓✓OneLake serves as a
hierarchical storage system that simplifies data management across an
organization, built on Azure Data Lake Storage architecture.
What is the primary function of a workspace in Microsoft Fabric?
Ans✓✓✓A workspace in Fabric acts as a container for items such as
data warehouses, datasets, and reports, and provides controls for who
can access these items
What role should be assigned to a data engineer who needs to create
Fabric items and read data in a lakehouse? Ans✓✓✓The Contributor
role allows users to create Fabric items and modify content, which meets
the requirements for the data engineer.
What does the scanner API in Fabric allow admins to do? Ans✓✓✓The
scanner API is specifically designed to enable admins to scan various
Fabric items for sensitive data, enhancing data governance.
Which method is used to save a dataframe as a new table in Spark SQL?
Ans✓✓✓The method df.write.format('delta').saveAsTable is specifically
used to save a dataframe as a new table in Spark SQL.
VERIFIED ANSWERS (100% CORRECT ANSWERS)
/ALREADY GRADED
Where is license management for Fabric handled? Ans✓✓✓Microsoft
365 admin center
What is the primary function of Activator in Microsoft Fabric?
Ans✓✓✓Activator is designed to automate actions triggered by specific
events in data streams.
What Does Activator monitor Ans✓✓✓It monitors data in Power BI
reports and eventstreams
What is the critical difference between the Member and Contributor
workspace roles? Ans✓✓✓The critical difference between the Member
and Contributor workspace roles is that Members can view, modify, and
share all content and data in the workspace, while Contributors can view
and modify all content and data but cannot share content. The sharing
capability is the key distinction between these two roles.
Which T-SQL commands are used to apply granular permissions in a
lakehouse? Ans✓✓✓Granular permissions in a lakehouse are applied
using T-SQL Data Control Language (DCL) commands such as
GRANT, DENY, and REVOKE.
,What feature allows access to data in the lakehouse to be restricted to
specific files or folders? Ans✓✓✓OneLake data access controls enable
the restriction of access to specific files or folders within the lakehouse.
What is the role of a domain in Microsoft Fabric? Ans✓✓✓A domain is
a logical grouping of workspaces used to organize items in a way that
makes sense for an organization, such as grouping by sales, marketing,
or finance.
In Fabric, what is the purpose of workspace roles? Ans✓✓✓Workspace
roles in Fabric are used to distribute ownership and access policies
within a workspace, enabling control over who can access and manage
resources.
What is the primary purpose of data lineage in Microsoft Fabric?
Ans✓✓✓Data lineage allows you to track the flow of data through
Fabric, including its origin, transformations, and destinations, providing
insights into how data is used.
Which of the following statements best describes continuous delivery?
Ans✓✓✓Continuous delivery follows continuous integration and
involves deploying code to a staging environment for additional
automated testing before production release.
What is the first step in securing data when managing sharing and
distribution of items? Ans✓✓✓The first step in securing data is to grant
, the least permissive rights, which helps to minimize access and protect
sensitive information.
What is OneLake in Microsoft Fabric? Ans✓✓✓OneLake serves as a
hierarchical storage system that simplifies data management across an
organization, built on Azure Data Lake Storage architecture.
What is the primary function of a workspace in Microsoft Fabric?
Ans✓✓✓A workspace in Fabric acts as a container for items such as
data warehouses, datasets, and reports, and provides controls for who
can access these items
What role should be assigned to a data engineer who needs to create
Fabric items and read data in a lakehouse? Ans✓✓✓The Contributor
role allows users to create Fabric items and modify content, which meets
the requirements for the data engineer.
What does the scanner API in Fabric allow admins to do? Ans✓✓✓The
scanner API is specifically designed to enable admins to scan various
Fabric items for sensitive data, enhancing data governance.
Which method is used to save a dataframe as a new table in Spark SQL?
Ans✓✓✓The method df.write.format('delta').saveAsTable is specifically
used to save a dataframe as a new table in Spark SQL.
