Question 110
Issue 1: A GitHub Actions deployment workflow embeds the production SQL administrator password directly in its YAML file. Issue 2: An artifact downloaded for SQL deployment has an unexpected hash but the pipeline proceeds because its filename matches the prior release. Issue 3: A CI job prints full connection strings in console output whenever a database migration fails. Which complete response addresses the three issues in order?
Explanation
Correct Answer
For issue 1, secrets committed in pipeline source can leak through history and logs and should not be hardcoded. For issue 2, an artifact name is not proof that the bytes match the reviewed and approved build. For issue 3, build logs can become a credential leakage path even when repository secret storage is configured correctly.
Incorrect Answers
Configure an approved deployment service principal or workload identity with restricted environment permissions; Fail the deployment and verify artifact provenance and integrity before executing the package; and Mask sensitive variables and replace secret-bearing diagnostic output with sanitized structured error logging: secrets committed in pipeline source can leak through history and logs and should not be hardcoded.
Remove and rotate the exposed password and use an approved workload identity or protected secret for deployment; configure an approved deployment service principal or workload identity with restricted environment permissions; and Mask sensitive variables and replace secret-bearing diagnostic output with sanitized structured error logging: an artifact name is not proof that the bytes match the reviewed and approved build.
Remove and rotate the exposed password and use an approved workload identity or protected secret for deployment; Fail the deployment and verify artifact provenance and integrity before executing the package; and configure an approved deployment service principal or workload identity with restricted environment permissions: build logs can become a credential leakage path even when repository secret storage is configured correctly.



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