Question 510
For a telecommunications provider, the original problem was: A data lake S3 bucket is accessed using embedded access keys in a COPY script shared with contractors. What observation confirms success?
Explanation
Correct Answer
A least-privilege role can read the approved object prefix without SQL containing long-lived cloud secrets. This validates the relevant action: Use a supported external stage and storage integration with properly scoped cloud permissions. The underlying Snowflake behavior is: Storage integrations provide controlled cloud access delegation for external stages.
Incorrect Answers
A representative record maps its fields and header correctly without column shifts. This evidence tests a DIFFERENT situation: A bulk load of customer CSV records splits addresses into wrong columns because the delimiter differs from the source contract. The correction required in this case is: Use a supported external stage and storage integration with properly scoped cloud permissions.
A dry-run or test load includes only source files for the approved business feed. This evidence tests a DIFFERENT situation: A staged directory contains many unrelated feeds and COPY loads data intended for another department. The correction required in this case is: Use a supported external stage and storage integration with properly scoped cloud permissions.
The updated client establishes an authorized session and runs the same controlled query. This evidence tests a DIFFERENT situation: A BI tool connects using an outdated driver and sees unsupported authentication failures after a platform security update. The correction required in this case is: Use a supported external stage and storage integration with properly scoped cloud permissions.