COF-C02: SnowPro Core Certification - Free download from Exam Files

What Snowflake role must be granted for a user to create and manage accounts?

ACCOUNTADMIN
ORGADMIN
SECURITYADMIN
SYSADMIN

Correct answer: A

Explanation:

The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake.This role has the highest level of privileges and is responsible for managing all aspects of the Snowflake account, including the ability to create and manage other user accounts1.https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake.This role has the highest level of privileges and is responsible for managing all aspects of the Snowflake account, including the ability to create and manage other user accounts1.

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

When unloading to a stage, which of the following is a recommended practice or approach?

Set SINGLE: = true for larger files
Use OBJECT_CONSTRUCT ( * ) when using Parquet
Avoid the use of the CAST function
Define an individual file format

Correct answer: D

Explanation:

When unloading data to a stage, it is recommended to define an individual file format.This ensures that the data is unloaded in a consistent and expected format, which can be crucial for downstream processing and analysis2

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

10-50 MB
100-250 MB
300-500 MB
1000-1500 MB

Correct answer: B

Explanation:

For loading data into Snowflake via Snowpipe, the recommended compressed file size is between 100-250 MB.This size range is optimal for balancing the performance of parallel processing and minimizing the overhead associated with handling many small files2.

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

External Tokenization
External Tables
Materialized Views
User-Defined Table Functions (UDTF)

Correct answer: A

Explanation:

The feature in Snowflake that allows a user to substitute a randomly generated identifier for sensitive data before loading it into Snowflake is known as External Tokenization.This process helps to secure sensitive data by ensuring that it is not exposed in its original form, thus preventing unauthorized access3.

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

VIEWS_HISTORY
OBJECT_HISTORY
ACCESS_HISTORY
LOGIN_HISTORY

Correct answer: C

Explanation:

TheACCESS_HISTORYview in theSNOWFLAKE.ACCOUNT_USAGEschema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1.

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

1 second
60 seconds
5 minutes
60 minutes

Correct answer: B

Explanation:

When a running virtual warehouse in Snowflake is suspended and then restarted, the minimum amount of time it will incur charges for is 60 seconds2.

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Authentication
Resource management
Virtual warehouse caching
Query parsing and optimization
Query execution
Physical storage of micro-partitions

Correct answer: ABD

Explanation:

The responsibilities of Snowflake's Cloud Service layer include authentication (A), which ensures secure access to the platform; resource management (B), which involves allocating and managing compute resources; and query parsing and optimization (D), which improves the efficiency and performance of SQL query execution3.

How long is the Fail-safe period for temporary and transient tables?

There is no Fail-safe period for these tables.
1 day
7 days
31 days
90 days

Correct answer: A

Explanation:

Temporary and transient tables in Snowflake do not have a Fail-safe period.Once the session ends or the tables are dropped, the data is purged and not recoverable1.

When is the result set cache no longer available? (Select TWO)

When another warehouse is used to execute the query
When another user executes the query
When the underlying data has changed
When the warehouse used to execute the query is suspended
When it has been 24 hours since the last query

Correct answer: CE

Explanation:

The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return the most current data.Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1.

Which of the following describes external functions in Snowflake?

They are a type of User-defined Function (UDF).
They contain their own SQL code.
They call code that is stored inside of Snowflake.
They can return multiple rows for each row received

Correct answer: A

Explanation:

External functions in Snowflake are a special type of User-Defined Function (UDF) that call code executed outside of Snowflake, typically through a remote service.Unlike traditional UDFs, external functions do not contain SQL code within Snowflake; instead, they interact with external services to process data2.https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.

External functions in Snowflake are a special type of User-Defined Function (UDF) that call code executed outside of Snowflake, typically through a remote service.Unlike traditional UDFs, external functions do not contain SQL code within Snowflake; instead, they interact with external services to process data2.

https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.