Snowpro Advanced Architect · Free Practice Question Medium
Question 36
You are designing a Snowflake pipeline for a healthcare client. They require strict governance over data ingestion with minimal privileges. How would you configure the roles?
- A Grant full access to the database for the ingestion user.
- B Create a dedicated role with 'OPERATE' and 'MONITOR' privileges for the pipe.
- C Enable 'VALIDATION_MODE' for all ingestion users.
- D Use the 'SECURITYADMIN' role to manage ingestion.
Reveal correct answer
Correct answer: B
Explanation
A dedicated role ensures least privilege for pipe operations.A. Full access violates the principle of least privilege.
B. These privileges allow restricted operations on the pipe.
C. VALIDATION_MODE' is not a privilege-related setting.
D. This role is not specific to the ingestion process.
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.
