Knowledge Check 2

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