Snowpro Advanced Architect · Free Practice Question Medium
Question 47
A financial client wants to use Snowpipe for loading sensitive transaction data and requires encryption at all stages. What steps would you take?
- A Enable server-side encryption for all files in the internal stage.
- B Use an external stage with a storage integration enforcing encryption.
- C Use a 'VALIDATION_MODE' to confirm file integrity during staging.
- D Set the pipe's 'AUTO_INGEST' parameter to 'TRUE'.
Reveal correct answer
Correct answer: B
Explanation
An external stage with encryption enforced ensures compliance and security.A. Internal stage encryption may not meet external compliance standards.
B. Storage integrations ensure encryption policies are applied.
C. Validation checks file integrity but not encryption.
D. AUTO_INGEST' automates loads but does not enforce encryption.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
