COF-C02 Free Practice Test

- (Topic 6)
Which statements reflect valid commands when using secondary roles? (Select TWO).

1. A. Use SECONDARY ROLES RESUME
2. B. USE SECONDARY ROLES SUSPEND
3. C. USE SECONDARY RLES ALL
4. D. USE SECONDARY ROLES ADD
5. E. Use SECONDARY ROLES NONE

Correct Answer: CE
✑ Incorrect Commands:The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in the context of secondary roles.
References:
✑ Snowflake Documentation (USE SECONDARY
ROLES): https://docs.snowflake.com/en/sql-reference/sql/use-secondary- roles.html

- (Topic 2)
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

1. A. Local disk caching
2. B. Authentication and access control
3. C. Metadata management
4. D. Query processing
5. E. Database storage

Correct Answer: BC
The Snowflake cloud services layer is responsible for tasks such as authentication and access control, ensuring secure access to the platform, and metadata management, which involves organizing and maintaining information about the data stored in Snowflake56.

- (Topic 2)
What type of query benefits the MOST from search optimization?

1. A. A query that uses only disjunction (i.e., OR) predicates
2. B. A query that includes analytical expressions
3. C. A query that uses equality predicates or predicates that use IN
4. D. A query that filters on semi-structured data types

Correct Answer: C
Search optimization in Snowflake is designed to improve the performance of queries that are selective and involve point lookup operations using equality and IN predicates. It is particularly beneficial for queries that access columns with a high number of distinct values1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 2)
Which of the following significantly improves the performance of selective point lookup queries on a table?

1. A. Clustering
2. B. Materialized Views
3. C. Zero-copy Cloning
4. D. Search Optimization Service

Correct Answer: D
The Search Optimization Service significantly improves the performance of selective point lookup queries on tables by creating and maintaining a persistent data structure called a search access path, which allows some micro-partitions to be skipped when scanning the table

- (Topic 2)
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?

1. A. External Tokenization
2. B. External Tables
3. C. Materialized Views
4. D. User-Defined Table Functions (UDTF)

Correct Answer: A
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.