nerdexam
Snowflake

COF-C02 · Question #131

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

The correct answer is A. Management of metadata E. Parsing and optimizing queries. The Cloud Services layer coordinates all activity across Snowflake. It handles Management of metadata (A) - storing statistics, schema definitions, and micro-partition details - and Parsing and optimizing queries (E) - compiling SQL, building execution plans, and leveraging…

Snowflake Cloud Data Platform Features and Architecture

Question

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options

  • AManagement of metadata
  • BComputing the data
  • CMaintaining Availability Zones
  • DInfrastructure security
  • EParsing and optimizing queries

How the community answered

(23 responses)
  • A
    91% (21)
  • B
    4% (1)
  • D
    4% (1)

Explanation

The Cloud Services layer coordinates all activity across Snowflake. It handles Management of metadata (A) - storing statistics, schema definitions, and micro-partition details - and Parsing and optimizing queries (E) - compiling SQL, building execution plans, and leveraging metadata for pruning. Computing the data (B) is performed by Virtual Warehouses (compute layer). Maintaining Availability Zones (C) is the responsibility of the underlying cloud provider (AWS, Azure, GCP). Infrastructure security (D) is a shared responsibility split between Snowflake and the cloud provider, not a primary Cloud Services function listed in Snowflake documentation.

Topics

#Snowflake architecture#Cloud Services layer#Metadata management#Query optimization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice