- (Topic 3)
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

Correct Answer:A
In Snowflake, a User-Defined Table Function (UDTF) can be accessed in the FROM clause of a query. UDTFs return a set of rows with one or more columns, which can be queried like a regular table

- (Topic 6)
When does a materialized view get suspended in Snowflake?

Correct Answer:B
A materialized view in Snowflake gets suspended when structural changes that could impact the view's integrity are made to the base table, such asB. When a column is dropped from the base table. Dropping a column from the base table on which amaterialized view is defined can invalidate the view's data, as the view might rely on the column that is being removed. To maintain data consistency and prevent the materialized view from serving stale or incorrect data, Snowflake automatically suspends the materialized view.
Upon suspension, the materialized view does not reflect changes to the base table until it is refreshed or re-created. This ensures that only accurate and current data is presented to users querying the materialized view.
References:
✑ Snowflake Documentation on Materialized Views: Materialized Views

- (Topic 3)
Which objects together comprise a namespace in Snowflake? (Select TWO).

Correct Answer:BC
In Snowflake, a namespace is comprised of a database and a schema. The combination of a database and schema uniquely identifies database objects within an account

- (Topic 4)
How can a Snowflake user traverse semi-structured data?

Correct Answer:A
To traverse semi-structured data in Snowflake, a user can insert a colon (:) between the VARIANT column name and any first-level element. This path syntax is used to retrieve elements in a VARIANT column4.

- (Topic 2)
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Correct Answer:D
The COPY command is used in Snowflake to load data from files located in an external stage into a table. This command allows for efficient and parallelized data loading from various file formats1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 6)
How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

Correct Answer:D
In Snowflake, configuring a virtual warehouse to be in a "Maximized" mode implies maximizing the resources allocated to the warehouse for its duration. This is done to ensure that the warehouse has a consistent amount of compute resources available, enhancing performance for workloads that require a high level of parallel processing or for handling high query volumes.
To configure a virtual warehouse in maximized mode, you should set the same value for bothMIN_CLUSTER_COUNTandMAX_CLUSTER_COUNT. This configuration ensures that the warehouse operates with a fixed number of clusters, thereby providing a stable and maximized level of compute resources.
Reference to Snowflake documentation on warehouse sizing and scaling:
✑ Warehouse Sizing and Scaling
✑ Understanding Warehouses