5.3.1. Analytics Solution Questions

Question 1

Your organization uses Microsoft Fabric with deployment pipelines with stages: Development, Test, and Production. You need to configure the Production stage to connect to the production database. The solution must minimize administrative effort.

What should you do?

• A. Manually update database connections after each deployment
• B. Create a deployment rule for Production
• C. Create separate pipelines for each environment
• D. Use environment variables in the lakehouse

Answer: B. Create a deployment rule for Production

Explanation: Deployment rules automatically configure environment-specific settings (like database connections) during deployment. This eliminates manual intervention and reduces errors. Manual updates are error-prone; separate pipelines increase maintenance overhead.

Question 2

You have a Fabric domain named Domain1 that contains a subdomain named Subdomain1. You have a workspace named Workspace1 assigned to Domain1. You need to assign Workspace1 to Subdomain1 without changing its domain assignment.

What should you do from the Fabric admin portal?

• A. Edit the Domain settings
• B. Edit the Subdomain settings
• C. Edit the Workspace settings
• D. Create a new workspace in Subdomain1

Answer: C. Edit the Workspace settings

Explanation: Assigning a workspace to a subdomain is done from the workspace settings, not from domain or subdomain settings in the admin portal. This is a common configuration point that's easy to confuse.

Question 3

Your company uses Dynamic Data Masking (DDM) to protect sensitive customer information including the CreditCardNumber field. Non-privileged users should see masked versions showing only the last 4 digits.

Which masking function should you use?

• A. default()
• B. email()
• C. random(1000, 9999)
• D. partial(0, "XXXX-XXXX-XXXX-", 4)

Answer: D. partial(0, "XXXX-XXXX-XXXX-", 4)

Explanation: The partial function allows you to show specific portions of data. The syntax partial(0, "XXXX-XXXX-XXXX-", 4) shows 0 prefix characters, the padding string, and the last 4 characters. The default() function would hide all data, which doesn't meet the requirement of showing last 4 digits.