Question 200
An Azure SQL operations team investigates: An administrator tries to use an unsupported server-host SQL login management pattern for Azure SQL single database. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (An administrator tries to use an unsupported server-host SQL login management pattern for Azure SQL single database.) is: Approved users authenticate with expected policies while disabled credentials fail and access is logged. It directly tests whether the remediation (Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: An administrator tries to use an unsupported server-host SQL login management pattern for Azure SQL single database. The specific supported administrative response is: Maintain SQL login configuration and password policy appropriately on SQL Server installations that support SQL authentication and coordinate with directory alternatives. The technical risk is: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. Confirm the correction with: Approved users authenticate with expected policies while disabled credentials fail and access is logged.
Incorrect Answers
Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. This choice can be useful for that problem, but it does not establish the SQL authentication management on SQL server vms (2.1) control being assessed here.
Sensitive data classification and discovery (2.3) addresses another technical failure: Unclassified personal or payment data may be exposed through poorly scoped reporting or overlooked control decisions. The required paired action and test concerns SQL authentication management on SQL server vms (2.1); a passing result for this alternative could leave that requirement unresolved.
Transparent data encryption at rest (2.2) would demonstrate or implement: Encryption state and database availability checks confirm files are encrypted while ordinary authorized queries continue. The paired-answer requirement concerns SQL authentication management on SQL server vms (2.1); this alternative does not provide the matching intervention and separate acceptance evidence.