Question 290
After the approved change, engineers revisit: A service account imports data via a storage integration but its cloud IAM policy allows access to an entire organization bucket. Which result establishes the intended state?
Explanation
Correct Answer
The approved source loads, while an unrelated prefix read is denied in the controlled test. This validates the relevant action: Reduce allowed cloud storage locations and integration permissions to the approved prefixes. The underlying Snowflake behavior is: Storage integration trust must be scoped to intended cloud resources rather than a whole storage estate.
Incorrect Answers
The pipeline loads representative events with measured latency and manageable operational overhead. This evidence tests a DIFFERENT situation: A data app needs to ingest events from Kafka but engineers build one file per message and a new warehouse COPY for each row. The correction required in this case is: Reduce allowed cloud storage locations and integration permissions to the approved prefixes.
The connector's role context and query results remain correct after default-role changes. This evidence tests a DIFFERENT situation: A partner uses an ODBC reporting connector with a role that changes silently after an administrator modifies user defaults. The correction required in this case is: Reduce allowed cloud storage locations and integration permissions to the approved prefixes.
Smaller supported files reach the table with predictable latency and tracked completeness. This evidence tests a DIFFERENT situation: A Snowpipe ingestion shows increasing time-to-availability after upstream sends huge compressed archives once daily. The correction required in this case is: Reduce allowed cloud storage locations and integration permissions to the approved prefixes.