Snowflake COF-C03: Snowflake AI Data Cloud architecture Practice Questions

CORRECT — MIN_CLUSTER_COUNT = 1 ensures only one cluster runs during normal periods (minimizing cost), MAX_CLUSTER_COUNT = 4 allows scale-out during peak demand, and SCALING_POLICY = 'ECONOMY' waits until a cluster is fully loaded before spinning up a new one AND shuts down extra clusters as soon as their queue clears, prioritizing cost savings over speed. OPTION B is wrong because STANDARD policy scales up more aggressively (before queuing becomes severe) and is slower to scale down, leading to higher costs during the transition periods — it does not minimize cost as effectively as ECONOMY. OPTION C is wrong because MIN_CLUSTER_COUNT = 2 guarantees two clusters run at all times, incurring unnecessary cost during normal (non-peak) periods. OPTION D is wrong because MAX_CLUSTER_COUNT = 1 disables scale-out entirely; this is effectively just a single-cluster warehouse and will not reduce queue times during peak load regardless of the scaling policy.

Business Critical is correct because it is the minimum edition that provides HIPAA support, Tri-Secret Secure (customer-managed encryption keys via Snowflake + customer KMS), and enhanced security including dedicated infrastructure options. Standard lacks all three features. Enterprise adds multi-cluster warehouses and column-level security but does NOT include HIPAA compliance, Tri-Secret Secure, or dedicated VPC isolation. Virtual Private Snowflake (VPS) offers the highest isolation but is not a standard purchasable edition tier in the same way and is above what is minimally required—Business Critical satisfies all stated requirements.

The MONITORING role is a system-defined role specifically intended for users who need to view account-level operational data (query history, login history, warehouse usage) without the full administrative power of ACCOUNTADMIN. SYSADMIN manages database objects but does not have account-wide monitoring privileges. SECURITYADMIN manages users and roles but is not focused on operational monitoring. ACCOUNTADMIN has all privileges and would satisfy the requirement but violates the principle of least privilege — the question asks for the LEAST additional privilege.

Business Critical is correct because periodic data rekeying (Tri-Secret Secure / customer-managed keys) is a Business Critical feature. Column-level security and multi-cluster virtual warehouses are available in Enterprise, but rekeying pushes the minimum to Business Critical. Standard lacks multi-cluster warehouses and column-level security. Enterprise adds those features but does NOT include periodic rekeying or enhanced encryption for compliance (Tri-Secret Secure). VPS would also satisfy requirements but is not the MINIMUM — Business Critical is the lowest edition that covers all three.

The Cloud Services layer is responsible for authentication/access control/query optimization (option F) and for maintaining global metadata including micro-partition statistics that enable partition pruning (option E). Option B is wrong—columnar data is stored in the Storage layer (cloud object storage). Option C is wrong—Cloud Services is a shared, centralized layer, not provisioned per warehouse. Option A is wrong—Cloud Services usage is generally free up to 10% of daily warehouse compute credits; it is not billed at the same per-credit rate. Option D partially describes the result cache (a function of Cloud Services), but the 24-hour result cache behavior is an attribute of the result cache specifically, and the statement incorrectly implies Cloud Services itself 'caches' in that manner as a defining characteristic—moreover, query results are served from the result cache only when the underlying data has not changed, which the option omits.