What are important factors to consider when creating tables and views in Snowflake? (Choose threE.

The correct answer is A. Data security and access controls C. Optimization for query performance D. Documentation and metadata management. When creating tables and views in Snowflake, data security and access controls (A) matter because Snowflake's role-based access control (RBAC) determines who can read or modify data - misconfigured permissions lead to data breaches or broken pipelines. Query performance optimizat

Data Modeling and Transformation

Question

Options

AData security and access controls
BThe color of the tables and views
COptimization for query performance
DDocumentation and metadata management

How the community answered

(23 responses)

A
91% (21)
B
9% (2)

Explanation

When creating tables and views in Snowflake, data security and access controls (A) matter because Snowflake's role-based access control (RBAC) determines who can read or modify data - misconfigured permissions lead to data breaches or broken pipelines. Query performance optimization (C) is critical since choices like clustering keys, materialized views, and virtual warehouse sizing directly affect cost and speed. Documentation and metadata management (D) ensures long-term maintainability, enabling teams to understand lineage, column semantics, and data freshness through tools like the Information Schema and object comments.

Option B is a deliberate distractor - Snowflake is a cloud data platform with no concept of visual table/view styling; color has zero bearing on functionality or design decisions.

Memory tip: Think "ACD = Access, Cost, Documentation" - the three pillars of responsible data object design in any enterprise data warehouse.

Topics

#Table Design#View Design#Data Security#Performance Optimization

Community Discussion

No community discussion yet for this question.

Full DAA-C01 Practice