Microsoft Fabric Data Engineer Associate DP-700 Practice Question
A Fabric pipeline uses a Copy Data activity to load Parquet files from Azure Data Lake Storage Gen2 into a lakehouse. The source linked service authenticates by Azure AD service principal (client ID/secret). Yesterday the run succeeded; today every run fails in under two minutes with the error "Access token has expired or is invalid." Without changing activity settings, how do you restore successful scheduled runs?
Change the linked service to use workspace managed identity authentication and grant the managed identity the Storage Blob Data Contributor role.
Create a new client secret for the service principal, update the Azure Data Lake linked service with the new secret, and publish the pipeline.
Generate a new shared access signature (SAS) for the storage account and replace the data-source connection string in the Copy activity.
Increase the retry count and timeout properties of the Copy Data activity to allow the transfer to finish.
The Copy Data activity requests an Azure AD access token by submitting the service principal's client ID and secret that are stored in the linked service. Service-principal client secrets expire on their configured date; once expired, token acquisition fails and the activity returns an "access token has expired or is invalid" error before data movement starts. Creating a new client secret and updating the linked service immediately restores authentication without altering any activity properties. Generating a SAS, switching to managed identity, or merely increasing retries does not solve the underlying credential-expiration problem.
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 an Azure AD service principal and how does it authenticate?
Open an interactive chat with Bash
How does the Azure Data Lake linked service operate in a pipeline?
Open an interactive chat with Bash
What happens if credentials in a pipeline linked service expire?
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 .