Question 440
At fictional Olivebridge Logistics, a Snowflake data and AI engineering team is conducting a trusted self-service analytics redesign while preserving enterprise data boundaries and a reviewable audit trail. The separately composed technical incident is: A financial reporting agent has been equipped with a stored procedure that can modify approved ledger records, but it executes changes based on a natural-language instruction without independent human authorization. Assume only these documented facts and use safe, authorized production-change procedures; exact current Snowflake feature syntax and region or account availability require current review. Which repeatable assurance or control is most relevant to preventing this situation?
Explanation
Writer-proposed answer: D (UNVERIFIED)
Preliminary individual option explanations — NOT expert validated
Correct Answer
Keep mutation tools behind approval gates, test authorization bypass attempts and review access to all newly connected procedures. Tool-enabled AI must preserve human accountability and least privilege for irreversible or high-impact operations.
Incorrect Answers
This response concerns Cortex model access allowlist governance, which is different from the stated failure. A financial reporting agent has been equipped with a stored procedure that can modify approved ledger records, but it executes changes based on a natural-language instruction without independent human authorization.
Redaction quality on complex identifiers is insufficient to demonstrate this result: Unauthorized or ambiguous prompts cannot execute mutations, while approved tests produce reconciled change records with named signoff.
Overprivileged AI service account roles is not the cause of the reported failure: A financial reporting agent has been equipped with a stored procedure that can modify approved ledger records, but it executes changes based on a natural-language instruction without independent human authorization.