COF-C02 Free Practice Test

- (Topic 3)
Which stream type can be used for tracking the records in external tables?

1. A. Append-only
2. B. External
3. C. Insert-only
4. D. Standard

Correct Answer: B
The stream type that can be used for tracking the records in external tables is ??External??. This type of stream is specifically designed to track changes in external tables

- (Topic 4)
What is a characteristic of materialized views in Snowflake?

1. A. Materialized views do not allow joins.
2. B. Clones of materialized views can be created directly by the user.
3. C. Multiple tables can be joined in the underlying query of a materialized view.
4. D. Aggregate functions can be used as window functions in materialized views.

Correct Answer: C
One of the characteristics of materialized views in Snowflake is that they allow multiple tables to be joined in the underlying query. This enables the pre-computation of complex queries involving joins, which can significantly improve the performance of subsequent queries that access the materialized view4. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 4)
How can a Snowflake user validate data that is unloaded using the COPY INTO command?

1. A. Load the data into a CSV file.
2. B. Load the data into a relational table.
3. C. Use the VALlDATlON_MODE - SQL statement.
4. D. Use the validation mode = return rows statement.

Correct Answer: C
To validate data unloaded using the COPY INTO <location> command, a Snowflake user can use the VALIDATION_MODE parameter within the SQL statement to test the files for errors without loading them3.

- (Topic 2)
What is the default file size when unloading data from Snowflake using the COPY command?

1. A. 5 MB
2. B. 8 GB
3. C. 16 MB
4. D. 32 MB

Correct Answer: C
The default file size when unloading data from Snowflake using the COPY command is not explicitly stated in the provided resources. However, Snowflake documentation suggests that the file size can be specified using the MAX_FILE_SIZE option in the COPY INTO <location> command2.

- (Topic 6)
Which type of role can be granted to a share?

1. A. Account role
2. B. Custom role
3. C. Database role
4. D. Secondary role

Correct Answer: B
In Snowflake, shares are used to share data between Snowflake accounts. When creating a share, it is possible to grant access to the share to roles within the Snowflake account that is creating the share. The type of role that can be granted to a share is a Custom role. Custom roles are user-defined roles that account administrators can create to manage access control in a more granular way. Unlike predefined roles such as ACCOUNTADMIN or SYSADMIN, custom roles can be tailored with specific privileges to meet the security and access requirements of different groups within an organization.
Granting a custom role access to a share enables users associated with that role to access the shared data if the share is received by another Snowflake account. It is important to carefully manage the privileges granted to custom roles to ensure that data sharing aligns with organizational policies and data governance standards.
References:
✑ Snowflake Documentation on Shares: Shares
✑ Snowflake Documentation on Roles: Access Control