AdamMorton

Question 1

what are the 6 type of files in file format?

Answer 1

csv, json, avro, orc, parquet, xml

Question 2

The output of a Snowflake directory table includes which 6 columns?

Answer 2

relative_path, size, last_modified, md5, etag, file_url

Question 3

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Answer 3

Business critical

Question 4

A Snowflake user needs to import a JSON file larger than 16 MB.
What file format option could be used?

Answer 4

stripe_outer_array = true

Question 5

During periods of warehouse contention, which parameter controls the maximum length of time a warehouse will hold a query for processing?

Answer 5

statement_queued_timeout_in_seconds