Snowpro Associate Platform · Free Practice Question Medium
Question 17
- A Your user account is locked due to inactivity.
- B The SELECT privilege was revoked after it was granted.
- C You lack the USAGE privilege on the database or schema containing the table.
- D The table is encrypted with a key you don't have access to.
Reveal correct answer
Correct answer: C
Explanation
✅ You lack the USAGE privilege on the database or schema containing the table.
Explanation:
In Snowflake, having SELECT privilege on a table is not sufficient by itself. You also need:
USAGE privilege on the database that contains the schema
USAGE privilege on the schema that contains the table
Without these, Snowflake will block access—even if SELECT is granted—because it cannot resolve the object path.
❌ The table is encrypted with a key you don't have access to – Snowflake handles encryption transparently for users
❌ The SELECT privilege was revoked after it was granted – Possible, but you'd receive a permission error, not silent failure
❌ Your user account is locked due to inactivity – You wouldn’t be able to log in or run any queries at all
More details in Snowflake’s access control documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
