Font size
WorksheetsKnowledge Check 3
Total questions: 5
Worksheet time: 4mins
Which copyOptions can help load a file with expired metadata (if the LAST_MODIFIED date is older than 64 days and the initial set of data was loaded into the table more than 64 days earlier (and if the file was loaded into the table, that also occurred more than 64 days earlier))? (Select 2)
LOAD_UNCERTAIN_FILES = TRUE
LOAD_CERTAIN_FILES = TRUE
FORCE = FALSE
LOAD_FILES = TRUE
FORCE = TRUE
Which of the following file format is not supported by Snowflake?
JSON
AVRO
CSV
ORC
EDI
What all locations do Snowflake support for staging the data? (Select all that apply)
Amazon S3
Oracle Cloud Storage
Snowflake Internal Stage
Microsoft Azure Blob Storage
Google Cloud Storage
Loading into Snowflake from a local file system is a straightforward affair. Which command is used to grab files from the local system, compress them and encrypt them, and then it copies them to Snowflake?
MOVE command
GET command
PUT command
COPY INTO <table>
Which options for selecting staged data files are supported by COPY command in Snowflake? (Select that all apply)
By path (internal stages) / prefix (Amazon S3 bucket)
Using pattern matching to identify specific files by pattern
Specifying a list of specific files to load
