Font size
WorksheetsKnowledge Check 2
Total questions: 10
Worksheet time: 3mins
What type of tables should be used for important data with long-term retention?
Transcient tables
External tables
Temporary tables
Permanent tables
What should be considered when choosing table types in Snowflake?
User roles
Data retention needs, cost implications, and performance
Database schemas
Account organization
Which of the following is NOT a type of table in Snowflake?
Static
Temporary
Permanent
External
What is a key benefit of using external tables in Snowflake?
Increased data security
Direct access to data stored in cloud storage without loading
Automatic data compression
Faster query execution times
Which type of table in Snowflake is automatically dropped at the end of the session?
Permanent tables
Temporary tables
External tables
Transcient tables
What is one of the key features of Snowflake?
Manual Scaling
Static Data Loading
Single-Cluster Architecture
Data Encryption
Which Snowflake editions support HIPAA compliance?
Virtual Private Snowflake
Business Critical
Enterprise
Standard
What is the purpose of Snowpipe in Snowflake?
To create virtual warehouses
To perform data encryption
To enable continuous data loading
To manage user roles
Which of the following is a feature of Virtual Warehouses in Snowflake?
Single-User Access
Fixed Size
Auto-Resume
Manual Suspension
What is the cost structure for data transfer in Snowflake?
Free for all transfers
Charged for data ingress
Charged for both ingress and egress
Free for data ingress, charged for data egress
