Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).

The correct answer is A. Authorisation E. Query parsing and optimization. Snowflake's architecture has three layers: Storage, Query Processing (virtual warehouses), and Cloud Services. The Cloud Services layer handles metadata management, authentication and authorization (A), query compilation, query parsing and optimization (E), and transaction…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AAuthorisation
BAccess delegation
CData pruning
DData compression
EQuery parsing and optimization

How the community answered

(57 responses)

A
86% (49)
B
5% (3)
C
7% (4)
D
2% (1)

Explanation

Snowflake's architecture has three layers: Storage, Query Processing (virtual warehouses), and Cloud Services. The Cloud Services layer handles metadata management, authentication and authorization (A), query compilation, query parsing and optimization (E), and transaction management. Data compression (D) and data pruning/micro-partition pruning (C) are performed at the storage and query execution layers respectively, not the Cloud Services layer. Access delegation is an access-control concept rather than a distinct Cloud Services activity.

Topics

#Snowflake architecture#Cloud Services layer#Authorization#Query optimization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice