Snowflake SnowPro Core (COF-C03)

1. A company is evaluating Snowflake for its cloud data platform. Which architectural layer is responsible for storing the actual table data in a compressed, columnar format?

2. An architect is designing a Snowflake architecture where multiple independent business units share the same Snowflake account but require completely separate compute resources so that one unit's heavy workload cannot impact another's query performance. Which approach should the architect implement?

3. A company is setting up Snowflake for the first time. The security team wants to understand which system-defined role should be used exclusively for managing account-level settings such as billing, resource monitors, and account parameters. Which role should they assign for these tasks?

4. A data platform team applies a tag-based masking policy by tagging columns with 'PII:email'. A new table is created with an EMAIL column, and the DBA tags it with 'PII:email'. However, the masking policy is not applied. What is the most likely cause?

5. A data engineering team is setting up a Snowflake virtual warehouse for the first time. They need to understand credit consumption. How many credits per hour does an X-Small (XS) virtual warehouse consume?