Knowledge Check 4 (Final)

What all options are available for data transformation while loading data into a table using the COPY command? (Select all that apply)

• Truncation of Text Strings

• Column omission

• Casts

• Join

• Column reordering

What is the expiration period of a File URL?

• Length of time specified in the expiration_time argument

• The URL expires when the persisted query result period ends

• It is Permanent

Which data does not fit into a predefined data model or schema?

• All of these

• Semi-Structured Data

• Structured-data

• Unstructured Data

How can we turn off the query result cache?

• Setting the parameter USE_CACHED_RESULT to FALSE

• Setting the parameter USE_CACHED_INFO to FALSE

• Setting the parameter USE_QUERY_CACHED to FALSE

• Query result cache can be turned off.

How long do results remain in the Query results cache?

• 16 hours

• 31 hours

• 1 hour

• 12 hours

• 24 hours

Micro-partitioning is the on-demand feature of Snowflake. It is required to be enabled explicitly by ACCOUNTADMIN. (True / False)

• True

• False

Which services are managed by Snowflake's cloud services layer? (Select all that apply)

• Infrastructure Management

• Access Control

• Metadata Management

• Authentication

• Query Parsing and Optimization

Which of these types of VIEW does Snowflake support? (Select 3)

• SECURE VIEW

• TEMPORARY VIEW

• STANDARD VIEW

• MATERIALIZED VIEW

• PERMANENT VIEW

Which of these Snowflake features does enable accessing historical data (i.e., data that has been changed or deleted) at any point within a defined period?

• Zero Copy Cloning

• Search Optimization Service

• Data Sharing

• Time Travel

Which object parameter can users with the ACCOUNTADMIN role use to set the default retention period for their account?

• DATA_RETENTION_TIME_IN_DAYS

• DATA_RETENTION_IN_TIME_TRAVEL

• DATA_RETENTION_TIME_MAX

• DATA_RETENTION_TIME_IN_HOURS