SOL-C01 · Question #7
SOL-C01 Question #7: Real Exam Question with Answer & Explanation
The correct answer is E: USAGE privilege on the FIJBLIC' schema and SELECT privilege on the 'CUSTOMERS table.. To query a table, a user needs 'SELECT privilege on the table and 'USAGE privilege on the schema containing the table. Having ` USAGE' on the database is not enough; 'USAGE' is also needed on the schema. READ is not a valid privilege on tables.
Question
A Snowflake user is attempting to query a table named 'CUSTOMERS within the `SALES DB.PUBLIC' schema. However, they are receiving an error indicating insufficient privileges. Assuming the user has been granted the `USAGE privilege on the database 'SALES , which additional privilege(s) is/are required for the user to successfully query the 'CUSTOMERS table?
Options
- ASELECT privilege on the 'CUSTOMERS' table.
- BUSAGE privilege on the `PUBLIC' schema.
- CREAD privilege on the 'CUSTOMERS' table.
- DUSAGE privilege on the 'SALES DB' database and SELECT privilege on the 'CUSTOMERS table.
- EUSAGE privilege on the FIJBLIC' schema and SELECT privilege on the 'CUSTOMERS table.
Explanation
To query a table, a user needs 'SELECT privilege on the table and 'USAGE privilege on the schema containing the table. Having ` USAGE' on the database is not enough; 'USAGE' is also needed on the schema. READ is not a valid privilege on tables.
Topics
Community Discussion
No community discussion yet for this question.