SnowPro Core Recertification practice test

1. Question 1 · 1

   By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

   Choose one answer.

   • 0 days
   • 1 day
   • 7 days
   • 14 days

2. Question 2 · 1

   At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

   Choose one answer.

   • Account
   • Database
   • Schema
   • Table

3. Question 3 · 1

   What type of function returns one value for each invocation?

   Choose one answer.

   • Aggregate
   • Scalar
   • Table
   • Window

4. Question 4 · 1

   What persistent data structures are used by the search optimization service to improve the performance of point lookups?

   Choose one answer.

   • Micro-partitions
   • Clustering keys
   • Equality searches
   • Search access paths

5. Question 5 · 1

   Which of the following SQL statements will list the version of the drivers currently being used?

   Choose one answer.

   • 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

6. Question 6 · 1

   What action can be performed using the GET command in Snowflake?

   Choose one answer.

   • 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.

7. Question 7 · 1

   What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?

   Choose one answer.

   • 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

8. Question 8 · 1

   A 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?

   Choose one answer.

   • 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.

9. Question 9 · 1

   What happens to the privileges granted to Snowflake system-defined roles?

   Choose one answer.

   • The privileges cannot be revoked.
   • The privileges can be revoked by an ACCOUNTADMIN.
   • The privileges can be revoked by an ORGADMIN.
   • The privileges can be revoked by any user-defined role with appropriate privileges.

10. Question 10 · 1

    How long does Snowflake retain information in the ACCESS_HISTORY view?

    Choose one answer.

    • 7 days
    • 14 days
    • 28 days
    • 365 days

11. Question 11 · 1

    Which Snowflake data governance feature can support auditing when a user query reads column data?

    Choose one answer.

    • Access History
    • Data classification
    • Column-level security
    • Object dependencies

12. Question 12 · 1

    Which command can be used to list all network policies available in an account?

    Choose one answer.

    • DESCRIBE SESSION POLICY
    • DESCRIBE NETWORK POLICY
    • SHOW SESSION POLICIES
    • SHOW NETWORK POLICIES

13. Question 13 · 1

    Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

    Choose one answer.

    • Data classification
    • Query acceleration service
    • Search optimization service
    • Tagging

14. Question 14 · 1

    What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

    Choose one answer.

    • Standard Edition
    • Enterprise Edition
    • Business Critical Edition
    • Virtual Private Snowflake Edition

15. Question 15 · 1

    What are the primary authentication methods that Snowflake supports for securing REST API interactions? (Choose two.)

    Choose all answers that apply.

    • OAuth
    • Key pair authentication
    • Federated authentication
    • Multi-Factor Authentication (MFA)
    • Username and password authentication

Paid access to all 32 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.