snow5

When does a materialized view get suspended in Snowflake?

• When a column is added to the base table

• When a column is dropped from the base table

• When a DML operation is run on the base table

• When the base table is reclustered

What happens when a Snowflake user changes the data retention period at the schema level?

• All child objects will retain data for the new retention period.

• All child objects that do not have an explicit retention period will automatically inherit the new retention period.

• All child objects with an explicit retention period will be overridden with the new retention period.

• All explicit child object retention periods will remain unchanged.

How can a Snowflake user sample 10 rows from a table named SNOWPRO? (Choose two.)

• SELECT * FROM SNOWPRO SAMPLE SYSTEM (10)

• SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS)

• SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10)

• SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10 ROWS)

• SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS)

What data type is used to ingest semi-structured data into a Snowflake table?

• BOOLEAN

• NUMBER

• VARBINARY

• VARIANT

Which security feature is used to connect or log in to a Snowflake account?

• Network policy

• SCIM

• Role-Based Access Control (RBAC)

• Key pair authentication

Given the statement template below, which database objects can be added to a share? (Choose two.) GRANT ON TO SHARE ;

• Secure functions

• Stored procedures

• Streams

• Tables

• Tasks

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

• Persisted query results

• QUERY_HISTORY view

• Query acceleration service

• Query Profile

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

• Fail-safe

• Time Travel

• Cloning

• Account replication

What is the purpose of collecting statistics on data in Snowflake?

• To identify data storage order correlations

• To enable efficient pruning based on query filters

• To reduce the total number of micro-partitions in a table

• To optimize query performance by reading all data in a table

Which file formats support unloading semi-structured data? (Choose two.)

• Avro

• JSON

• ORC

• Parquet

• XML