Snowflake - SnowPro Associate Platform Practice Questions & Free Practice Exam

5 free Snowflake - SnowPro Associate Platform practice questions below, with instant explanations. The full simulator contains hundreds of exam-style questions across every topic.

Open the full Practice Zone Create a free account

Question 1

Among the following Snowflake surfaces, which one is NOT a browser-based UI and is delivered as a command-line client?

Question 2

Which built-in account role does the documented Snowflake convention recommend as the owner for databases, schemas, tables, and warehouses?

Question 3

Two custom roles, `analyst_us` and `analyst_eu`, are granted to a single user, each granting SELECT on a regional sales table. A join query referencing both regional tables fails when the active role is `analyst_us` because that role does not hold SELECT on the EU table. The user does not want to change the primary active role because object ownership on any new CREATE statement must still track `analyst_us`. The user runs a single statement that allows privilege checks for the join to consider every role the user has been granted, and the join succeeds. Which statement did the user run?

Question 4

The built-in PUBLIC pseudo-role has which relationship to users in a Snowflake account?

Question 5

The provider role grants privileges to a share that backs a Marketplace Listing. Which privilege CANNOT be granted to the share?

Ready for the full Snowflake - SnowPro Associate Platform exam simulator?

Unlock the complete question bank, weighted mock exams, saved-question flashcards, and the Shark AI tutor - all inside your MyCertStack account.

See pricing Browse other certifications