Question 180
A schema migration adds a stored procedure but the production app service role cannot execute it. The team proposes this approach: Test the deployed service workflow under least-privilege app identity in staging. Which technical principle supports this approach?
Explanation
Correct Answer
CI/CD integration testing should use representative application identities and permissions. Test credentials must not be copied from production secrets.
Incorrect Answers
Application permissions differ from deployment-operator permissions; tests must use a representative low-privilege identity.
Module execution rights and ownership/role context require explicit verification for the deployed procedure.
A sound test validates both allowed and denied operations using scoped test credentials, never unrestricted access.