AdamMorton Flashcards
1
Q
what are the 6 type of files in file format?
A
csv, json, avro, orc, parquet, xml
2
Q
The output of a Snowflake directory table includes which 6 columns?
A
relative_path, size, last_modified, md5, etag, file_url
3
Q
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
A
Business critical
4
Q
A Snowflake user needs to import a JSON file larger than 16 MB.
What file format option could be used?
A
stripe_outer_array = true
5
Q
During periods of warehouse contention, which parameter controls the maximum length of time a warehouse will hold a query for processing?
A
statement_queued_timeout_in_seconds
