- (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)
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

1. A. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
2. B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
3. C. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
4. D. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Correct Answer: D
In Snowflake, to create a materialized view, the user must have the necessary privileges on the schema where the view will be created. These privileges are granted through roles, not directly to individual users. Therefore, the correct process is to grant the role to the user and then grant the privilege to create the materialized view to the role itself.
The statement GRANT ROLE MYROLE TO USER USER1; grants the specified role to the user, allowing them to assume that role and exercise its privileges. The subsequent statement CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO
MYROLE; grants the privilege to create a materialized view within the specified schema to the role MYROLE. Any user who has been granted MYROLE can then create materialized views in MYDB.MYSCHEMA.
References:
✑ Snowflake Documentation on Roles
✑ Snowflake Documentation on Materialized Views

- (Topic 2)
Which of the following describes the Snowflake Cloud Services layer?

1. A. Coordinates activities in the Snowflake account
2. B. Executes queries submitted by the Snowflake account users
3. C. Manages quotas on the Snowflake account storage
4. D. Manages the virtual warehouse cache to speed up queries

Correct Answer: A
The Snowflake Cloud Services layer is a collection of services that coordinate activities across Snowflake, tying together all the different components to process user requests, from login to query dispatch1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1

- (Topic 4)
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)

1. A. ARRAY
2. B. BLOB
3. C. CLOB
4. D. JSON
5. E. VARIANT

Correct Answer: AE
Snowflake supports the storage of semi-structured data using the ARRAY and VARIANT data types. The ARRAY data type can directly contain VARIANT, and thus indirectly contain any other data type, including itself. The VARIANT data type can store a value of any other type, including OBJECT and ARRAY, and is often used to represent semi-structured data formats like JSON, Avro, ORC, Parquet, or XML34.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
Which type of charts are supported by Snowsight? {Select TWO)

1. A. Flowcharts
2. B. Gantt charts
3. C. Line charts
4. D. Pie charts
5. E. Scatterplots

Correct Answer: DE