snow6

Which file functions are non-deterministic? (Choose two.)

• BUILD_SCOPED_FILE_URL

• BUILD_STAGE_FILE_URL

• GET_ABSOLUTE_PATH

• GET_PRESIGNED_URL

• GET_RELATIVE_PATH

How can a Snowflake user optimize query performance in Snowflake? (Choose two.)

• Create a view.

• Cluster a table.

• Enable the search optimization service.

• Enable Time Travel.

• Index a table.

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

• ACCOUNTADMIN

• SECURITYADMIN

• SYSADMIN

• ORGADMIN

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

• ARRAY

• OBJECT

• TEXT

• VARIANT

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

• Resource monitor

• Account_usage.query_history

• Information_schema.warehouse_load_history

• Information_schema.warehouse_metering_history

Which Snowflake object can be created to be temporary?

• Role

• Stage

• User

• Storage integration

Which stream type can be used for tracking the records in external tables?

• Append-only

• External

• Insert-only

• Standard

Which command is used to unload files from an internal or external stage to a local file system?

• COPY INTO

• GET

• PUT

• TRANSFER

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

• list @bronzestage;

• select * from directory(@bronzestage);

• select metadata$filename from @bronzestage;

• select * from table(information_schema.stage_directory_file_registration_history( stage_name=>'bronzestage'));

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

• Cloud Services

• Database Storage

• Query Processing

• Metadata Management