Microsoft Fabric Data Engineer Associate DP-700 Practice Question
During a Microsoft Fabric pipeline run, a Copy data activity that uses an Azure Key Vault-backed linked service fails with the error "UserErrorFailedToConnectToAzureStorage: Unable to retrieve storage account credentials." The service principal already has Storage Blob Data Reader on the storage account, and the referenced secret name is correct. What should you do to ensure the next run succeeds?
Reconfigure the Copy data activity to use managed identity authentication instead of the Key Vault-backed linked service.
Add a retry policy to the Copy data activity and increase fault-tolerance settings.
Grant the service principal the Key Vault Secrets User role on the Azure Key Vault that stores the connection string secret.
Disable Secure Output on the Copy data activity so the secret can be passed to the runtime unencrypted.
The failure occurs because the pipeline runtime cannot read the connection-string secret from Azure Key Vault. Granting the service principal (or its managed identity) the Key Vault Secrets User role, or another role that includes secret-get permission, allows the linked service to retrieve the secret and authenticate to the storage account. Changing secure-output settings, adding retries, or switching authentication methods without addressing the missing Key Vault permission will not resolve the underlying issue.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the Azure Key Vault Secrets User role?
Open an interactive chat with Bash
How does a service principal interact with Azure Key Vault?
Open an interactive chat with Bash
What is a Key Vault-backed linked service in Microsoft Fabric?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .