Implement and manage an analytics solution Questions
Practice questions for Implement and manage an analytics solution topic in Microsoft Certified: Fabric Data Engineer Associate. 64 questions covering this domain.
A PySpark notebook is committed to a Git-connected Fabric workspace. How is the notebook content stored in the repository?
A SQL analytics endpoint currently uses delegated identity mode with SQL roles and SQL-defined row-level security. The team switches it to user identi...
Two deployment pipelines are intended to autobind dependent items across workspaces. What must be true for autobinding across pipelines to succeed?
A data engineer creates a view over a shortcut table and shares only the current lakehouse with analysts. Analysts still can't query the view. Which a...
A user belongs to two OneLake security roles in user identity mode. One role grants full table access, and the other applies row-level security to res...
A user is already a pipeline admin and needs to deploy items from one stage to the next. What is the minimum documented workspace role requirement on ...
A team assigns a workspace to an empty deployment pipeline stage and completes the first deployment. Why must they refresh semantic models afterward b...
Which Git provider is officially supported by Microsoft Fabric Git integration?
A Fabric item is shared with an analyst by using item permissions only. What does the default Read permission allow?
A team needs read-only access to all items in a Fabric workspace but must not modify them. Which workspace role should you assign?
You deploy Fabric content from Development to Test. Which property is not copied during deployment?
After the initial deployment to a target stage, a semantic model refresh fails because the gateway isn't connected to the expected data source. What s...
A data engineer wants the SQL analytics endpoint to pass each signed-in user's identity to OneLake for authorization. Which access mode should be sele...
An architect wants OneLake row-level and column-level security to be enforced when users query a lakehouse through the SQL analytics endpoint in user ...
A notebook is deployed through a deployment pipeline, and a default lakehouse deployment rule is configured on the target stage. Which lakehouse bindi...
A lakehouse contains a shortcut to data stored in another lakehouse. A user can open the current lakehouse but receives an access error when querying ...
A team needs to secure a SQL analytics endpoint by using SQL GRANT statements, SQL-defined row-level security, and dynamic data masking. Which OneLake...
What is the default storage format for tabular data in Fabric lakehouses and warehouses?
Which Fabric construct stores a tenant's unified data lake underlying lakehouses, warehouses, and KQL databases?
Which Fabric workspace role is required to connect a workspace to a Git repository?
Sign in to see all 64 questions
Create a free account to browse all questions — completely free during our launch phase.