SnowPro Core Certification Mock Test 1 - COF-C02

Question 25: Which of the following statements about Snowflake's data compression are true? (Select all that apply)

Compression is automatic and transparent

Users can choose compression algorithms

Compression ratios vary by data type

Compressed data reduces storage costs

Question 26: What SQL statement would you use to create a table that automatically clusters data?

CREATE TABLE table_name (...) CLUSTER BY (column_name)

CREATE TABLE table_name (...) AUTO_CLUSTER = TRUE

CREATE CLUSTERED TABLE table_name (...)

CREATE TABLE table_name (...) WITH CLUSTERING

Question 27: Which function is used to extract values from JSON data in Snowflake?

JSON_EXTRACT

GET_PATH

PARSE_JSON with path notation

Both B and C

Question 28: What happens when you execute UNDROP TABLE command in Snowflake?

Restores the table from the most recent backup

Restores the table using Time Travel within the retention period

Creates a new empty table with the same structure

Only works if Fail-safe is enabled

Question 29: Which of the following are valid Snowflake account identifiers? (Select all that apply)

Account URL

Organization name and account name

Legacy account locator

Account UUID

Question 30: What is the default warehouse size when creating a new virtual warehouse?

X-Small

Small

Medium

Large

Question 31: Which command would you use to view the query history for your session?

SHOW QUERY HISTORY

SELECT * FROM INFORMATION_SCHEMA.QUERY_HISTORY

SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY())

DESCRIBE QUERIES

Question 32: What are the key benefits of using stored procedures in Snowflake? (Select all that apply)

Encapsulation of business logic

Reduced network traffic

Support for JavaScript and SQL

Automatic performance optimization

Question 33: Which privilege is required to create a database in Snowflake?

CREATE DATABASE on the account

SYSADMIN role

USAGE privilege on the account

ACCOUNTADMIN role only

Question 34: What is the correct way to load data from a named internal stage?

COPY INTO table_name FROM @stage_name

LOAD DATA FROM @stage_name INTO table_name

INSERT INTO table_name FROM @stage_name

IMPORT table_name FROM @stage_name

Question 35: Which of the following are characteristics of Snowflake's Streams feature? (Select all that apply)

Tracks DML changes to tables

Provides change data capture (CDC)

Consumes additional storage

Automatically expires after 14 days

Question 36: What is the purpose of the VALIDATE function in Snowflake?

To check data quality before loading

To validate file format and schema without loading data

To verify user permissions

To check table constraints

Question 37: Which statement about Snowflake's Tasks feature is correct?

Tasks can only execute SQL statements

Tasks can call stored procedures and execute SQL

Tasks require a running warehouse at all times

Tasks cannot be chained together

Question 38: What command is used to see the definition of a view in Snowflake?

DESCRIBE VIEW view_name

SHOW CREATE VIEW view_name

GET DDL view_name

Both A and B

Question 39: Which of the following are valid data unloading file formats in Snowflake? (Select all that apply)

CSV

JSON

Parquet

XML

Question 40: What is the primary difference between Standard and Enterprise editions of Snowflake?

Enterprise supports multi-cluster warehouses

Enterprise has longer Time Travel retention (up to 90 days)

Enterprise includes advanced security features

All of the above

Question 41: Which SQL function returns the current warehouse name in Snowflake?

CURRENT_WAREHOUSE()

GET_WAREHOUSE()

WAREHOUSE_NAME()

SHOW_WAREHOUSE()

Question 42: What is the maximum file size that can be loaded using a single COPY INTO command?

250 MB

1 GB

5 GB

No limit

Question 43: Which of the following are supported by Snowflake's Data Marketplace? (Select all that apply)

Free data sets

Commercial data products

Live data feeds

Data applications

Question 44: What happens to compute credits when a warehouse is in a suspended state?

Credits continue to be consumed at a reduced rate

No credits are consumed

Credits are consumed only for metadata operations

Credits are consumed based on cache usage

Question 45: Which command is used to alter the retention period for Time Travel on a table?

ALTER TABLE table_name SET DATA_RETENTION_TIME_IN_DAYS = 7

ALTER TABLE table_name TIME_TRAVEL = 7

SET TIME_TRAVEL_DAYS = 7 FOR table_name

UPDATE TABLE table_name SET RETENTION = 7

Question 46: What is the purpose of Snowflake's Query Acceleration Service?

To automatically optimize all queries

To improve performance of eligible queries by offloading parts to shared compute resources

To cache query results permanently

To prevent query timeout errors

Question 47: Which of these are valid ways to secure data in Snowflake? (Select all that apply)

End-to-end encryption

Role-based access control (RBAC)

Network policies

Multi-factor authentication (MFA)

Question 48: What is the maximum number of characters allowed in a Snowflake identifier (table name, column name, etc.)?

128

255

256

512

Question 49: Which query would you use to find tables that have clustering keys defined?

SHOW TABLES WITH CLUSTERING

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE CLUSTERING_KEY IS NOT NULL

SHOW TABLES LIKE '%CLUSTERED%'

SELECT * FROM SYSTEM$CLUSTERING_INFORMATION

Question 50: What is the correct syntax to create a file format for JSON data?

CREATE FILE FORMAT json_format TYPE = JSON

CREATE FORMAT json_format AS JSON

CREATE FILE_FORMAT json_format TYPE = 'JSON'

NEW FILE FORMAT json_format TYPE = JSON

Question 51: Which of the following can trigger a Snowpipe to load data? (Select all that apply)

Cloud storage event notifications

REST API calls

Scheduled intervals

SQL triggers

Question 52: What is the default collation for string comparisons in Snowflake?

utf8

utf8mb4

utf8_general_ci

No default collation

Question 53: Which privilege allows a user to create warehouses in Snowflake?

CREATE WAREHOUSE on the account

SYSADMIN role

USAGE on the account

ACCOUNTADMIN role only

Question 54: What is the purpose of the FLATTEN function in Snowflake?

To compress table data

To convert nested or repeated data into relational rows

To merge multiple tables

To normalize database tables

Question 55: Which of the following are characteristics of Snowflake's Zero-copy cloning? (Select all that apply)

Creates independent metadata

Shares underlying data storage initially

Instantaneous cloning process

Requires additional storage immediately

Question 56: What command would you use to see all active queries currently running in your account?

SHOW QUERIES

SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY()) WHERE EXECUTION_STATUS = 'RUNNING'

SHOW PROCESSES

LIST ACTIVE QUERIES

Question 57: Which statement about Snowflake's AUTO_SUSPEND feature is correct?

It only works for single-cluster warehouses

It suspends warehouses after a period of inactivity

It requires manual configuration for each warehouse

It cannot be disabled once enabled

Question 58: What are the main components of Snowflake's Data Cloud? (Select all that apply)

Data Engineering

Data Lake

Data Science

Data Applications

Question 59: Which SQL statement correctly creates a materialized view in Snowflake?

CREATE MATERIALIZED VIEW mv_name AS SELECT...

CREATE CACHED VIEW mv_name AS SELECT...

CREATE PERSISTENT VIEW mv_name AS SELECT...

CREATE PHYSICAL VIEW mv_name AS SELECT...

Question 60: What is the minimum warehouse size required for Snowpipe operations?

X-Small

Small

Medium

No warehouse required

Question 61: Which of the following are valid methods to monitor Snowflake usage? (Select all that apply)

ACCOUNT_USAGE schema

INFORMATION_SCHEMA

Web interface Usage tab

Third-party monitoring tools

Question 62: What is the purpose of the COPY INTO command's FORCE parameter?

To ignore file format errors

To reload files that have already been loaded

To compress data during loading

To override schema validation

Question 63: Which system function provides information about clustering for a table?

SYSTEM$CLUSTERING_INFORMATION

SYSTEM$CLUSTER_STATUS

SYSTEM$TABLE_CLUSTERING

SYSTEM$GET_CLUSTERING_INFO

Question 64: What are the key benefits of using User-Defined Functions (UDFs) in Snowflake? (Select all that apply)

Code reusability

Support for SQL and JavaScript

Performance optimization

Custom business logic implementation

Question 65: Which command is used to see the schema of a table without querying the data?

DESCRIBE TABLE table_name

SHOW SCHEMA table_name

SELECT SCHEMA(table_name)

Both A and B

Question 66: What is the maximum number of concurrent queries that can run on a single-cluster warehouse?

8

16

32

No specific limit

Question 67: Which of the following are valid Snowflake connection methods? (Select all that apply)

Web interface (Snowsight)

JDBC/ODBC drivers

SnowSQL CLI

Python Connector

Question 68: What is the correct syntax to create a sequence in Snowflake?

CREATE SEQUENCE seq_name START 1 INCREMENT 1

CREATE SEQUENCE seq_name START WITH 1 INCREMENT BY 1

NEW SEQUENCE seq_name BEGIN 1 STEP 1

CREATE SEQUENCE seq_name FROM 1 TO MAX INCREMENT 1

Question 69: Which feature allows you to automatically scale compute resources based on query load?

Auto-scaling

Multi-cluster warehouses

Auto-suspend

Query acceleration

Question 70: What happens when you query a table that doesn't exist in Snowflake?

Returns empty result set

Throws an error: Object does not exist

Creates the table automatically

Returns NULL values

Question 71: Which of the following are best practices for query optimization in Snowflake? (Select all that apply)

Use appropriate warehouse sizes

Avoid SELECT * queries

Use clustering keys for large tables

Always use the largest warehouse available

Question 72: What is the purpose of Snowflake's Data Exchange?

To facilitate private data sharing between specific organizations

To backup data across regions

To compress data for storage

To convert data formats

Question 73: Which SQL function would you use to get the current timestamp in Snowflake?

NOW()

CURRENT_TIMESTAMP()

GETDATE()

All of the above

Question 74: What is the default behavior for handling duplicate rows during data loading?

Duplicates are automatically removed

Duplicates are loaded as separate rows

Loading fails if duplicates are found

Only the first occurrence is loaded

Question 75: Which command would you use to see all databases in your Snowflake account?

LIST DATABASES

SHOW DATABASES

SELECT * FROM DATABASES

DESCRIBE DATABASES

Question 76: Which of the following statements about Snowflake's data sharing are correct? (Select all that apply)

Data providers control access and permissions

Data consumers pay for compute only

Shared data can be joined with local data

Data is physically copied to consumer accounts

Question 77: What is the correct way to handle errors during data loading using COPY INTO?

Use ON_ERROR = 'CONTINUE' to skip error records

Use TRY_CATCH blocks

Use IGNORE_ERRORS = TRUE

Use ERROR_HANDLING = 'SKIP'

Question 78: Which system function returns information about warehouse credit consumption?

SYSTEM$WAREHOUSE_CREDITS()

WAREHOUSE_METERING_HISTORY view

SYSTEM$CREDIT_USAGE()

SHOW WAREHOUSE USAGE

Question 79: What is the purpose of the MERGE statement in Snowflake?

To combine multiple tables into one

To perform INSERT, UPDATE, and DELETE operations in a single statement

To join tables with different schemas

To compress table data

Question 80: Which of the following are valid Snowflake stage types? (Select all that apply)

Internal named stage

External stage

User stage

Table stage

Question 81: What SQL statement would you use to check if a file has been loaded before using COPY INTO?

SELECT * FROM LOAD_HISTORY WHERE filename = 'file.csv'

COPY INTO table_name FROM @stage/file.csv VALIDATION_MODE = RETURN_ERRORS

SELECT * FROM TABLE(VALIDATE(table_name, JOB_ID=>'query_id'))

LIST @stage to check file status

Question 82: Which feature provides automatic maintenance of clustering for tables?

Automatic Clustering

Auto-maintenance

Smart Clustering

Adaptive Clustering

Question 83: What is the maximum length of a VARCHAR column in Snowflake?

4,000 characters

8,000 characters

16,777,216 characters

No limit

Question 84: Which of the following are components of Snowflake's security model? (Select all that apply)

Column-level security

Row-level security

Dynamic data masking

Object-level security

Question 85: What command is used to cancel a running query in Snowflake?

CANCEL QUERY 'query_id'

SELECT SYSTEM$CANCEL_QUERY('query_id')

STOP QUERY 'query_id'

KILL QUERY 'query_id'

Question 86: Which of the following are valid Snowflake object types that can be cloned? (Select all that apply)

Databases

Schemas

Tables

Warehouses

Question 87: What is the purpose of the RESULT_SCAN function in Snowflake?

To scan for errors in query results

To retrieve results from a previous query using its query ID

To analyze query performance

To format query output

Question 88: Which statement about Snowflake's Virtual Private Snowflake (VPS) is correct?

It's available in all Snowflake editions

It provides a dedicated virtual network for enhanced security

It only affects data storage, not compute

It's automatically enabled for Enterprise accounts

Question 89: What SQL command would you use to see the current session parameters?

SHOW PARAMETERS

SHOW SESSION PARAMETERS

SELECT * FROM SESSION_PARAMETERS

Both A and B

Question 90: Which of the following are benefits of using Snowflake's Query Tags? (Select all that apply)

Query categorization and tracking

Cost allocation and chargeback

Performance monitoring by application

Automatic query optimization

Question 91: What is the correct syntax to create a transient table in Snowflake?

CREATE TRANSIENT TABLE table_name (...)

CREATE TABLE table_name (...) TRANSIENT = TRUE

CREATE TEMP TABLE table_name (...)

CREATE TABLE table_name (...) WITH TRANSIENT

Question 92: Which function is used to parse XML data in Snowflake?

PARSE_XML

XMLGET

XML_EXTRACT

Both A and B

Question 93: What is the primary purpose of Snowflake's Search Optimization Service?

To optimize warehouse performance

To improve performance of point lookup queries and substring searches

To index all table columns automatically

To compress search results

Question 94: Which of the following statements about Snowflake's pricing model are true? (Select all that apply)

Pay only for what you use

Separate pricing for compute and storage

No upfront costs or termination fees

Fixed monthly subscription model

Question 95: What command would you use to see the data types of columns in a table?

SHOW COLUMNS FROM table_name

DESCRIBE TABLE table_name

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'table_name'

All of the above

Question 96: Which statement about Snowflake's data retention and Fail-safe is correct?

Fail-safe provides 7 days of additional data protection after Time Travel expires

Fail-safe data can be accessed by users directly

Fail-safe is only available for Enterprise accounts

Fail-safe can be configured by users

Question 97: What is the correct way to load data with transformations during the COPY INTO process?

COPY INTO table_name (col1, UPPER(col2)) FROM @stage

COPY INTO table_name FROM (SELECT col1, UPPER($2) FROM @stage)

COPY INTO table_name FROM @stage TRANSFORM (col1, UPPER(col2))

COPY INTO table_name FROM @stage WITH TRANSFORM

Question 98: Which of the following are characteristics of Snowflake's Secure Data Sharing? (Select all that apply)

No data movement or copying

Real-time access to shared data

Granular access control

Cross-cloud sharing capabilities

Question 99: Complex Scenario: You have a table with 500 million rows that requires frequent filtering on date ranges. The table grows by 10 million rows daily. What combination of Snowflake features would provide the best query performance?

Clustering key on date column + Search Optimization Service

Materialized views + Result caching

Partitioning by date + Indexing

Multi-cluster warehouse + Query acceleration

Question 100: Query-based Scenario: You execute the following SQL: SELECT * FROM my_table AT(OFFSET => -3600). What does this query return?

Data from 3600 minutes ago

Data from 1 hour ago (3600 seconds)

Data from 3600 rows back

An error - invalid syntax

Snowflake SnowPro Core Certification

Mock Test 1

Exam Code
COF-C02

Questions
100 Questions

Duration
115 Minutes

Passing Score
75%

Question 1: Which of the following are key components of Snowflake's architecture? (Select all that apply)

Database Storage Layer

Query Processing Layer

Cloud Services Layer

Application Layer

Question 2: What is the default file format for data loading in Snowflake?

JSON

CSV

Parquet

Avro

Question 3: Which statement about Snowflake's Time Travel feature is correct?

It's available for 90 days by default

It allows querying historical data up to 90 days for Enterprise accounts

It's only available for tables, not databases

It requires additional storage costs

Question 4: What are the main benefits of Snowflake's micro-partitioning? (Select all that apply)

Automatic data clustering

Improved query performance

Reduced data scanning

Manual partition maintenance required

Question 5: Which virtual warehouse size would be most appropriate for loading large amounts of data?

X-Small

Small

Large or X-Large

Medium

Question 6: What is the purpose of Snowflake's Fail-safe feature?

To provide disaster recovery capabilities

To automatically scale compute resources

To enable data sharing between accounts

To compress data automatically

Question 7: Which of the following are valid Snowflake data types? (Select all that apply)

VARIANT

GEOGRAPHY

TIMESTAMP_NTZ

BLOB

Question 8: What happens when a virtual warehouse is suspended?

All running queries are canceled

Compute resources are released and no credits are consumed

Data in the warehouse cache is lost

Both A and B

Question 9: Which command is used to create a new database in Snowflake?

CREATE DB database_name

CREATE DATABASE database_name

NEW DATABASE database_name

ADD DATABASE database_name

Question 10: What is the maximum retention period for Time Travel in Snowflake Enterprise edition?

1 day

7 days

90 days

365 days

Question 11: Which of the following are benefits of Snowflake's Data Sharing feature? (Select all that apply)

Real-time data access without data movement

Secure sharing across different Snowflake accounts

Automatic data encryption

No additional storage costs for shared data

Question 12: What is the primary purpose of clustering keys in Snowflake?

To enforce data uniqueness

To improve query performance on large tables

To enable data replication

To create table relationships

Question 13: Which statement about Snowflake's zero-copy cloning is correct?

It creates a full physical copy of the data

It creates a logical copy that shares the same physical data

It only works for small tables

It requires additional storage immediately

Question 14: What are the main components that affect Snowflake pricing? (Select all that apply)

Compute usage (credits)

Data storage

Data transfer

Number of users

Question 15: Which role has the highest level of privileges in Snowflake by default?

SYSADMIN

SECURITYADMIN

ACCOUNTADMIN

USERADMIN

Question 16: What is the purpose of Snowflake's Result Cache?

To store frequently accessed data permanently

To cache query results and improve performance for identical queries

To backup data automatically

To compress data during storage

Question 17: Which of the following are valid methods to load data into Snowflake? (Select all that apply)

COPY INTO command

INSERT statements

Snowpipe

Third-party ETL tools

Question 18: What is the default auto-suspend time for a virtual warehouse?

1 minute

5 minutes

10 minutes

60 minutes

Question 19: Which feature allows Snowflake to automatically optimize table performance?

Auto-clustering

Auto-scaling

Auto-suspend

Auto-resume

Question 20: What is the primary difference between temporary and transient tables in Snowflake?

Temporary tables have no Time Travel, transient tables have limited Time Travel

Temporary tables are session-specific, transient tables persist beyond sessions

There is no difference

Both A and B

Question 21: Which of the following are valid Snowflake warehouse scaling policies? (Select all that apply)

Standard

Economy

Premium

Conservative

Question 22: What is the purpose of Snowflake's Information Schema?

To store user data

To provide metadata about database objects

To manage user permissions

To configure system settings

Question 23: Which command is used to grant privileges to a role in Snowflake?

ASSIGN privilege TO role

GRANT privilege TO ROLE role_name

GIVE privilege TO role_name

SET privilege ON role_name

Question 24: What is the maximum number of clusters a multi-cluster warehouse can have?

5

10

15

20

Question 25: Which of the following statements about Snowflake's data compression are true? (Select all that apply)

Compression is automatic and transparent

Users can choose compression algorithms

Compression ratios vary by data type

Compressed data reduces storage costs

1 of 100

Exam Results