- (Topic 6)
What persistent data structures are used by the search optimization service to improve the performance of point lookups?

1. A. Micro-partitions
2. B. Clustering keys
3. C. Equality searches
4. D. Search access paths

Correct Answer: D
The search optimization service in Snowflake uses persistent data structures known as search access paths to improve the performance of point lookups. These structures enable efficient retrieval of data by reducing the amount of data scanned during queries.
✑ Search Access Paths:
✑ Point Lookups:
✑ Performance Improvement:
References:
✑ Snowflake Documentation: Search Optimization Service
✑ Snowflake Documentation: Understanding Search Access Paths

- (Topic 5)
A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

1. A. ARRAY
2. B. OBJECT
3. C. TEXT
4. D. VARIANT

Correct Answer: D
When dealing with semi-structured data in Snowflake, and the specific types of operations to be performed on the data are not yet determined, Snowflake recommends using the VARIANT data type. The VARIANT type is highly flexible and capable of storing data in multiple formats, including JSON, AVRO, BSON, and more, within a single column. This flexibility allows users to perform various operations on the data, including querying and manipulation of nested data structures without predefined schemas.
References:
✑ Snowflake Documentation: Semi-structured Data Types

- (Topic 3)
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

1. A. READ
2. B. OWNERSHIP
3. C. USAGK
4. D. WRTTF

Correct Answer: A
The minimum privilege required on an external stage for any role to access unstructured data files using a file URL in the GET REST API is READ. This allows the role to retrieve or download data files from the stage.

- (Topic 6)
What is the MINIMUM Snowftake edition that supports database replication?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake (VPS)

Correct Answer: B
The minimum Snowflake edition that supports database replication is the Enterprise edition. Database replication allows data to be replicated between different Snowflake accounts or regions, providing high availability and disaster recovery capabilities. References:
✑ Snowflake Documentation: Database Replication

- (Topic 1)
In which use cases does Snowflake apply egress charges?

1. A. Data sharing within a specific region
2. B. Query result retrieval
3. C. Database replication
4. D. Loading data into Snowflake

Correct Answer: C
Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region to another region or cloud provider. This is because the data transfer incurs costs associated with moving data across different networks. Egress charges are not applied for data sharing within the same region, query result retrieval, or loading data into Snowflake, as these actions do not involve data transfer across regions.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Data Replication and Egress Charges1