- (Topic 1)
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

1. A. Yes, because a table owner has full control and can unset masking policies.
2. B. Yes, because masking policies only apply to cloned tables.
3. C. No, because masking policies must always reference specific access roles.
4. D. No, because ownership of a table does not include the ability to change masking policies

Correct Answer: D
Even if a developer is granted ownership of a table with a masking policy, they will not be able to modify the table to read the masked data if their role does not have the necessary permissions. Ownership of a table does not automatically confer the ability
to alter masking policies, which are designed to protect sensitive data. Masking policies are applied at the schema level and require specific privileges to modify12.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Masking Policies

- (Topic 2)
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

1. A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
2. B. The listing is replicated into all selected regions automatically, the data is not.
3. C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
4. D. Shares attached to listings in remote regions can be viewed from any account in an organization.
5. E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Correct Answer: BC
When publishing a Snowflake Data Marketplace listing into a remote region, it??s important to note that while the listing is replicated into all selected regions automatically, the data itself is not.Therefore, the data must be replicated separately. Additionally, the user must have the ORGADMIN role in at least one account to manage the replication of accounts1.

- (Topic 2)
When cloning a database, what is cloned with the database? (Choose two.)

1. A. Privileges on the database
2. B. Existing child objects within the database
3. C. Future child objects within the database
4. D. Privileges on the schemas within the database
5. E. Only schemas and tables within the database

Correct Answer: AB
When cloning a database in Snowflake, the clone includes all privileges on the database as well as existing child objects within the database, such as schemas, tables, views, etc. However, it does not include future child objects or privileges on schemas within the database2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 1)
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

1. A. Compute Credits = 50 Credits Cloud Services = 10
2. B. Compute Credits = 80 Credits Cloud Services = 5
3. C. Compute Credits = 10 Credits Cloud Services = 9
4. D. Compute Credits = 120 Credits Cloud Services = 10
5. E. Compute Credits = 200 Credits Cloud Services = 26

Correct Answer: AE
In Snowflake, Cloud Services costs are incurred when the Cloud Services usage exceeds 10% of the compute usage (measured in credits). Therefore, scenarios A and E would result in Cloud Services charges because the Cloud Services usage is more than 10% of the compute credits used.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake??s official documentation on billing and usage1

- (Topic 5)
Which command can be used to list all the file formats for which a user has access privileges?

1. A. LIST
2. B. ALTER FILE FORMAT
3. C. DESCRIBE FILE FORMAT
4. D. SHOW FILE FORMATS

Correct Answer: D
The command to list all the file formats for which a user has access privileges in Snowflake isSHOW FILE FORMATS. This command provides a list of all file formats defined in the user's current session or specified database/schema, along with details such as the name, type, and creation time of each file format. It is a valuable tool for users to understand and manage the file formats available for data loading and unloading operations.
References:
✑ Snowflake Documentation: SHOW FILE FORMATS