SnowPro Core RecertificationFree trialFree trial

By snowflake
Aug, 2025

Verified

25Q per page

Question 1

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

  • A: 0 days
  • B: 1 day
  • C: 7 days
  • D: 14 days
—

Question 2

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

  • A: Account
  • B: Database
  • C: Schema
  • D: Table
—

Question 3

What type of function returns one value for each invocation?

  • A: Aggregate
  • B: Scalar
  • C: Table
  • D: Window
—

Question 4

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

  • A: Micro-partitions
  • B: Clustering keys
  • C: Equality searches
  • D: Search access paths
—

Question 5

Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?

  • A:
  • B:
  • C:
  • D:
—

Question 6

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

  • A: Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
  • B: Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
  • C: Execute SELECT CURRENT_CLIENT(); from an application
  • D: Execute SELECT CURRENT-VERSION(); from the Python Connector
—

Question 7

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

  • A: Automatically rename downloaded files.
  • B: Automatically decrypt downloaded data on a client machine.
  • C: Download data files from Snowflake internal stages to a local directory/folder.
  • D: Download data files from Snowflake external stages to a local directory/folder.
—

Question 8

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

  • A: The type of SQL statements executed
  • B: The number of tables or databases queried
  • C: The amount of data stored in the warehouse
  • D: The length of time the compute resources in each cluster run
—

Question 9

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

  • A: Faster query performance and increased storage consumption
  • B: Slower query performance and increased storage consumption
  • C: Faster query performance and decreased storage consumption
  • D: Slower query performance and decreased storage consumption
—

Question 10

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?

  • A: Log the user out.
  • B: Deactivate the network policy.
  • C: Prevent the user from executing additional queries.
  • D: Allow the user to continue until the session or login token expires.
—

Question 11

In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

  • A: READ
  • B: REFERENCES
  • C: REFERENCE_USAGE
  • D: USAGE
—

That’s the end of your free questions

You’ve reached the preview limit for SnowPro Core Recertification

Consider upgrading to gain full access!

Page 1 of 3 • Questions 1-25 of 52
123
→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!