SnowPro Core Recertification — Free Practice Questions
10 free sample questions from a bank of 52, with the correct answers and explanations. No signup required — start practising right now.
1By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
0 days
1 day
7 days
14 days
Answer: B
2At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Account
Database
Schema
Table
Answer: A
3What type of function returns one value for each invocation?
Aggregate
Scalar
Table
Window
Answer: B
4What persistent data structures are used by the search optimization service to improve the performance of point lookups?
Micro-partitions
Clustering keys
Equality searches
Search access paths
Answer: D
5Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?
Answer:
6Which of the following SQL statements will list the version of the drivers currently being used?
Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
Execute SELECT CURRENT_CLIENT(); from an application
Execute SELECT CURRENT-VERSION(); from the Python Connector
Answer: C
7What action can be performed using the GET command in Snowflake?
Automatically rename downloaded files.
Automatically decrypt downloaded data on a client machine.
Download data files from Snowflake internal stages to a local directory/folder.
Download data files from Snowflake external stages to a local directory/folder.
Answer: C
8What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
The type of SQL statements executed
The number of tables or databases queried
The amount of data stored in the warehouse
The length of time the compute resources in each cluster run
Answer: C
9What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?
Faster query performance and increased storage consumption
Slower query performance and increased storage consumption
Faster query performance and decreased storage consumption
Slower query performance and decreased storage consumption
Answer: B
10A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
What will Snowflake do if the user's IP address does not match the user-level network policy rules?
Log the user out.
Deactivate the network policy.
Prevent the user from executing additional queries.
Allow the user to continue until the session or login token expires.