Question 460
At fictional Hillside Cooperative Bank, a Snowflake data and AI engineering team is conducting a source-system modernization and AI search review under documented decision rights and minimum-privilege security requirements. The separately composed technical incident is: A document indexing job fails intermittently because its stage role lacks narrow read access, and a suggested workaround would grant broad ownership over all uploaded confidential files. 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
Automate stage grant inventories and file-scope tests before each document pipeline release. Stage-based document processing follows object-level access controls; operational fixes should not expand permissions unnecessarily.
Incorrect Answers
This response concerns Structured field extraction and validation, which is different from the stated failure. A document indexing job fails intermittently because its stage role lacks narrow read access, and a suggested workaround would grant broad ownership over all uploaded confidential files.
Idempotent document reindexing pipeline is insufficient to demonstrate this result: Authorized documents are indexed reliably and negative tests show the ingestion role cannot enumerate or read unrelated private stages.
Document OCR versus layout parsing choice is not the cause of the reported failure: A document indexing job fails intermittently because its stage role lacks narrow read access, and a suggested workaround would grant broad ownership over all uploaded confidential files.