Free SnowPro Core Recertification Sample Questions — SnowPro Core Recertification (COF-R02)

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

Which function returns the URL of a stage using the stage name as the input?

• A. BUILD_STAGE_FILE_URL
• B. BUILD_SCOPED_FILE_URL
• C. GET_PRESIGNED_URL
• D. GET_STAGE_LOCATION

Which Query Profile category displays the time spent setting up the query processing?

• A. Initialization
• B. Processing
• C. Synchronization
• D. Local Disk IO

What type of function returns one value for each invocation?

• A. Aggregate
• B. Scalar
• C. Table
• D. Window

Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?

• A. BUILD_SCOPED_FILE_URL
• B. BUILD_STAGE_FILE_URL
• C. GET_ABSOLUTE_PATH
• D. GET_PRESIGNED_URL

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

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

• A. Area chart
• B. Box plot
• C. Heat grid
• D. Pie chart

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

How can the Query Profile be used to identify the costliest operator of a query?

• A. Select any node in the operator tree and look at the number of micro-partitions scanned
• B. Find the operator node with the highest fraction of time or percentage of total time
• C. Select the TableScan operator node and look at the percentage scanned from cache
• D. Look at the number of rows between operator nodes across the operator tree

In which hierarchy is tag inheritance possible?

• A. Organization >> Account >> Role
• B. Account >> User >> Schema
• C. Database >> View >> Column
• D. Schema >> Table >> Column

What does the LATERAL modifier for the FLATTEN function do?

• A. Casts the values of the flattened data
• B. Extracts the path of the flattened data
• C. Joins information outside the object with the flattened data
• D. Retrieves a single instance of a repeating element in the flattened data

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database. Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

• A. CREATE TABLE <table_name> LIKE TABLE_A;
• B. CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
• C. CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
• D. CREATE MATERIALIZED VIEW <view_name> AS SELECT * FROM TABLE_A;

What does a Notify & Suspend action for a resource monitor do?

• A. Send an alert notification to all account users who have notifications enabled
• B. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met
• C. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed
• D. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses

The property MINS_TO_BYPASS_NETWORK_POLICY is set at which level?

• A. User
• B. Role
• C. Account
• D. Organization

Which operation can be performed on Snowflake external tables?

• A. INSERT
• B. JOIN
• C. RENAME
• D. ALTER