SnowPro Advanced: Architect — Question 159

An Architect needs to ensure that users are able to upload data from Snowsight into an existing table.

What privileges need to be granted to the users to accomplish this? (Choose three.)

Answer options

• A. Database: USAGE
• B. Database: OWNERSHIP
• C. Schema: CREATE TABLE
• D. Schema: USAGE
• E. Table: SELECT
• F. Table: OWNERSHIP

Correct answer: A, D, E

Explanation

The correct answer includes Database: USAGE, Schema: USAGE, and Table: SELECT, which are essential for users to access the database, schema, and read data from the table. Database: OWNERSHIP and Schema: CREATE TABLE are not required since the table already exists and ownership is not necessary for data upload.