- (Topic 4)
How can performance be optimized for a query that returns a small amount of data from a very large base table?

Correct Answer:C
The search optimization service in Snowflake is designed to improve the performance of selective point lookup queries on large tables, which is ideal for scenarios where a query returns a small amount of data from a very large base table1. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 2)
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Correct Answer:BD
The LATERAL FLATTEN command in Snowflake produces a result set that includes several columns, among which PATH and INDEX are includedPATH indicates the path to the element within a data structure that needs to be flattened, and INDEX represents the index of the element if it is an array2.

- (Topic 1)
Which data types does Snowflake support when querying semi-structured data? (Select TWO)

Correct Answer:AB
Snowflake supports querying semi-structured data using specific data types that are capable of handling the flexibility and structure of such data. The data types supported for this purpose are:
✑ A. VARIANT: This is a universal data type that can store values of any other type,
including structured and semi-structured types. It is particularly useful for handling JSON, Avro, ORC, Parquet, and XML data formats1.
✑ B. ARRAY: An array is a list of elements that can be of any data type, including
VARIANT, and is used to handle semi-structured data that is naturally represented as a list1.
These data types are part of Snowflake??s built-in support for semi-structured data, allowing for the storage, querying, and analysis of data that does not fit into the traditional row- column format.
References:
✑ Snowflake Documentation on Semi-Structured Data
✑ [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 4)
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Correct Answer:C
To determine which user has accessed a database object containing sensitive information, a Snowflake administrator can query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema, which provides information about access to database objects3.

- (Topic 1)
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Correct Answer:D
When a query in Snowflake is too large to fit into the available memory, it will start spilling to remote storage. This is an indication that the memory allocated for the query is insufficient for its execution, and as a result, Snowflake uses remote disk storage to handle the overflow. This spill to remote storage can lead to slower query performance due to the additional I/O operations required.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Query Profile1
✑ Snowpro Core Certification Exam Flashcards2

- (Topic 4)
Which function unloads data from a relational table to JSON?

Correct Answer:B
The TO_JSON function is used to convert a VARIANT value into a string containing the JSON representation of the value. This function is suitable for unloading data from a relational table to JSON format. References: [COF-C02] SnowPro Core Certification Exam Study Guide