Question 510
A database architect reviews two implementation risks. A deployment rotates an Azure SQL secret manually and leaves several applications unable to connect after the old password expires. A function app can obtain a token but receives database permission denied when it queries an approved stored procedure. Which response best addresses these needs?
Explanation
Correct Answer
First, centralized identity or rotation removes fragile manual credential propagation from application deployments. Second, successful token authentication does not by itself grant database object authorization.
Incorrect Answers
Replace the human identity with an approved workload identity and assign minimum operational roles; grant the managed identity the required database principal and narrowly scoped execution rights after verifying authentication: centralized identity or rotation removes fragile manual credential propagation from application deployments.
Adopt a supported passwordless or centrally rotated secret design and test renewal behavior before expiration; use an appropriate managed identity and Microsoft Entra authentication with scoped database permissions: successful token authentication does not by itself grant database object authorization.
Adopt a supported passwordless or centrally rotated secret design and test renewal behavior before expiration.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests