SnowPro Advanced: Architect — Question 9

A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe.
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?

Answer options

• A. OWNERSHIP on the named pipe, USAGE on the named stage, target database, and schema, and INSERT and SELECT on the target table
• B. OWNERSHIP on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table
• C. CREATE on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table
• D. USAGE on the named pipe, named stage, target database, and schema, and INSERT and SELECT on the target table

Correct answer: A

Explanation

The correct answer is A because it specifies the necessary privileges for Snowpipe to function properly, including OWNERSHIP on the pipe and USAGE on the stage, database, and schema, along with INSERT and SELECT on the target table. The other options either include unnecessary privileges or incorrect privileges that do not align with the minimum requirements for Snowpipe execution.