EOD Fundamentals Quiz

What are the types of scaling?

• Across

• Up/Down

• Blocked/Through

• Back/Out

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

How can you connect to Snowflake?

• JDBC
• Snowsight
• Snowclient
• SnowSQL

How could you protect a table with sensitive columns from being accessed by certain roles, without consuming more storage?

• Create a secure materialized view on the sensitive table, grant access only to the secure materialized view
• Create a secure view on the sensitive table, grant access only to the secure view
• Create a materialized view on the sensitive table, grant access only to the materialized view
• Create a view on the sensitive table, grant access only to the view.

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

• MyTable
• mytable
• "MyTable"
• MYTABLE

While troubleshooting, you want a way to quickly locate all queries related to a specific workload. What feature would help with this?

• Query Tags
• Workload Labels
• Snowcategories
• Indexes

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.0
• 5.0
• 10.0

What caches do we have in Snowflake?

• Buffer Cache

• Data Cache

• Query Result Cache

• Metadata Cache

• Index Cache