Brett-Eric-1

What are the types of scaling?

• Across
• Up/Down
• Blocked/Through
• In/Out

Snowflake Metadata is managed in which layer?

• Compute Layer
• Data Storage Layer
• Cloud Services Layer
• Cloud Vendor (Azure, AWS, GCP)

How does Snowflake eliminate irrelevant data from scans?

• Defragmentation
• Pruning
• Indexes
• Gaussian elimination

What are the four components of your session context?

• Schema
• Database
• Role
• Group
• Warehouse

You clone a 100GB table and immediately add 50GB of new data to that clone. Approximately much storage is being consumed in total?

• 50GB
• 100GB
• 150GB
• 200GB
• 250GB

You wish to store data in a table that can be read by multiple users, but this data can be recreated if lost. What table type would meet these requirements and keep costs contained?

• Transient Table
• Temporary Table
• Permanent Table
• External Table

You execute "create table MyTable (column1 varchar(50));". What is the name of the table created?

• MyTable
• mytable
• "MyTable"
• MYTABLE

You execute the following statements: ALTER ACCOUNT SET DATA_RETENTION_TIME_IN_DAYS = 5; ALTER TABLE mytable SET DATA_RETENTION_TIME_IN_DAYS = 10; How many days of retention will be effective on mytable?

• 0
• 1
• 5
• 10

What caches do we have in Snowflake?

• Buffer Cache
• Data Cache
• Result Cache
• Metadata Cache
• Index Cache

Which cache can be bypassed?

• Buffer Cache
• Data Cache
• Result Cache
• Metadata Cache
• Index Cache