Snowpro Advanced Architect · Free Practice Question Medium
Question 23
A Snowflake stage is configured for encrypted data uploads. How can you verify that encryption policies are being enforced?
- A Manually download and inspect uploaded files for encryption attributes
- B Query the stage definition for ENCRYPTION settings using the SHOW STAGES command
- C Validate encryption during data uploads using COPY INTO VALIDATION_MODE
- D Review encryption settings in the ACCOUNT_USAGE schema for the stage
Reveal correct answer
Correct answer: B
Explanation
SHOW STAGES confirms encryption configurations for data uploads.A. Manual inspection is not efficient or reliable for policy enforcement.
B. SHOW STAGES reveals the encryption configuration for stages.
C. VALIDATION_MODE checks data integrity but not encryption settings.
D. ACCOUNT_USAGE does not store encryption configurations.
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.
