What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
MultipleChoice
Which type of loop requires a BREAK statement to stop executing?
OptionsMultipleChoice
What is the recommended file sizing for data loading using Snowpipe?
OptionsMultipleChoice
What is the MINIMUM permission needed to access a file URL from an external stage?
OptionsMultipleChoice
What is one of the characteristics of data shares?
OptionsMultipleChoice
A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?
OptionsMultipleChoice
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
OptionsMultipleChoice
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
OptionsMultipleChoice
When does Snowflake automatically encrypt data that is loaded into Snowflake? (Select TWO}.
OptionsMultipleChoice
If a JOIN operation is based on two columns which both contain NULL values, what SQL function will return results?
Options