DP-700 Practice Test

Answer choices

1. A. Modify the connection string directly within the deployed semantic model in the production workspace after deployment
2. B. Configure a parameter in the semantic model and map it to a deployment pipeline variable that holds the production Azure Data Lake Storage Gen2 connection string
3. C. Create a custom action in the deployment pipeline that updates the connection string in the deployed semantic model’s configuration file
4. D. Define a workspace parameter in the production workspace and configure the deployment pipeline to automatically populate it with the connection string

Wrong-answer review

• A. Modify the connection string directly within the deployed semantic model in the production workspace after deployment: Editing the deployed production model manually undermines repeatable deployment behavior.
• C. Create a custom action in the deployment pipeline that updates the connection string in the deployed semantic model’s configuration file: A custom action against configuration files is unnecessary and outside the native deployment rule pattern.
• D. Define a workspace parameter in the production workspace and configure the deployment pipeline to automatically populate it with the connection string: A workspace parameter alone does not replace the semantic model connection value through the pipeline rule.

Answer choices

1. A. Share the 'SalesLake' item and grant only the 'Read' permission
2. B. Assign the third-party service principal to the workspace 'Contributor' role
3. C. Configure a OneLake data access role with 'ReadWrite' permissions at the folder level
4. D. Share the 'SalesLake' item and grant the 'Read all OneLake data (ReadAll)' permission

Answer choices

1. A. Configure all critical datasets for 'Promoted' endorsement, as this provides a simple way for users to identify important data assets
2. B. Configure critical datasets for 'Certified' endorsement, while less critical datasets receive 'Promoted' endorsement. This allows for a tiered level of validation and trust
3. C. Configure all datasets for 'Promoted' endorsement and manually create custom data quality rules to achieve the desired level of validation
4. D. Configure critical datasets for 'Certified' endorsement, and use workspace roles to control who can endorse items, ensuring only authorized personnel can validate data

Answer choices

1. A. Provide an AWS access key pair directly in the shortcut connection settings
2. B. Create the Amazon S3 shortcut and configure Service Principal authentication with the Microsoft Entra service principal details and the AWS RoleARN
3. C. Create the Amazon S3 shortcut and configure only a Fabric workspace data access role for the bucket
4. D. Store AWS user secrets as a workspace artifact and reference them from the shortcut

Answer choices

1. A. Assign a larger F SKU immediately without reviewing workload utilization
2. B. Use the Microsoft Fabric Capacity Metrics app to review utilization, throttling, and workload patterns before resizing the capacity
3. C. Increase the number of concurrent users so the capacity is used more efficiently
4. D. Configure Spark pool autoscaling only, because all Fabric capacity pressure comes from Spark jobs

Answer choices

1. A. Force-push the resolved branch to the remote repository, overriding the existing state
2. B. Initiate a workspace reset to the last known good commit from the Git repository, discarding any uncommitted local changes
3. C. Use the 'Resolve Conflicts' option within the Fabric workspace Git integration panel to review and merge the conflicting changes, ensuring both versions are incorporated
4. D. Manually delete the affected dataflow definition file from the workspace and re-upload the resolved version from the Git repository

Answer choices

1. A. Assign workspace-scoped roles to all involved users
2. B. Create a custom table role for engineers and assign the analyst access at the workspace scope
3. C. Grant direct access on the lakehouse item: Edit for the engineers, and Read plus Read All with SQL analytics endpoint for the analyst
4. D. Place engineers in a group and assign that group a workspace-level Contributor role

Answer choices

1. A. Configure the default Spark pool with a large number of compute nodes (e.g., 20) to ensure consistent performance regardless of workload
2. B. Configure the default Spark pool with a small number of compute nodes and auto-scaling enabled, setting the minimum nodes to 1 and the maximum to 5
3. C. Configure the default Spark pool with a medium number of compute nodes (e.g., 8) and disable auto-scaling to maintain predictable resource allocation
4. D. Configure the default Spark pool with a small number of compute nodes (e.g., 2) and disable auto-scaling to minimize costs during periods of low activity

Answer choices

1. A. Configure the Customer Sales lakehouse as Certified, with certification performed by a user allowed by the Fabric administrator
2. B. Configure the Customer Sales lakehouse as Promoted and require all Workspace Admins to approve the endorsement
3. C. Configure the Customer Sales lakehouse as Promoted so item creators can signal that it is ready for reuse
4. D. Configure the Customer Sales lakehouse as Certified by any workspace Contributor without administrator-approved certification permissions

Answer choices

1. A. Grant all workspace members 'Contributor' access and utilize Git branching strategies to isolate development efforts, then manually merge branches into Production after UAT
2. B. Create separate Microsoft Fabric workspaces for Development, Staging, and Production, and manually copy items between them using the Fabric UI
3. C. Configure a deployment pipeline with three stages (Development, Staging, Production), assign different user groups to each stage with varying permission levels (e.g., 'Contributor' for Development, 'Reader' for Production), and utilize pipeline rules to manage parameter overrides
4. D. Enable workspace-level data policies to restrict access to sensitive data in the Production environment, while granting all users 'Contributor' access to all stages