Question 680
An Azure SQL operations team investigates: A multi-tenant application needs target credentials scoped to approved maintenance procedures only. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A multi-tenant application needs target credentials scoped to approved maintenance procedures only. The specific supported administrative response is: Configure appropriate authentication and least-privilege target permissions for Azure SQL elastic job steps, then validate target connections. The technical risk is: A job agent with excessive access or invalid credentials can expose other tenants or fail across all targets. Confirm the correction with: A controlled job connects only to intended target databases, completes allowed statements and is denied unapproved objects.
The acceptance evidence for this incident (A multi-tenant application needs target credentials scoped to approved maintenance procedures only.) is: A controlled job connects only to intended target databases, completes allowed statements and is denied unapproved objects. It directly tests whether the remediation (Configure appropriate authentication and least-privilege target permissions for Azure SQL elastic job steps, then validate target connections.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Azure cli SQL resource provisioning (4.2) would demonstrate or implement: CLI output and an independent resource readback confirm the database was created with intended settings. The case states: A multi-tenant application needs target credentials scoped to approved maintenance procedures only. The most direct paired action and test is: Configure appropriate authentication and least-privilege target permissions for Azure SQL elastic job steps, then validate target connections.
Fabric SQL database pipelines and recurring tasks (4.3) addresses another technical failure: Moving automation from SQL Server to a Fabric-managed SQL database without adapting its scheduling mechanism can leave tasks unexecuted. This choice can be useful for that problem, but it does not establish the Elastic job credential and target security (4.3) control being assessed here.
Azure SQL resource deployment using bicep (4.2) addresses another technical failure: Manual production configuration can drift from tested resource sizing, networking and backup settings. The required paired action and test concerns Elastic job credential and target security (4.3); a passing result for this alternative could leave that requirement unresolved.