Knowledge Check 3

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