Knowledge Check 3

Knowledge Check 3

Professional Development

5 Qs

quiz-placeholder

Similar activities

Knowledge Check - 2

Knowledge Check - 2

Professional Development

10 Qs

LINKS Cyber Youth Challenge - Round 3

LINKS Cyber Youth Challenge - Round 3

Professional Development

10 Qs

Understanding SPO Library and List

Understanding SPO Library and List

Professional Development

6 Qs

Quiz - Webinar #24

Quiz - Webinar #24

Professional Development

10 Qs

Uji Pemahaman Microsoft Word

Uji Pemahaman Microsoft Word

Professional Development

10 Qs

Quiz Konsep Dasar Teknologi Website dan Desain Website

Quiz Konsep Dasar Teknologi Website dan Desain Website

Professional Development

10 Qs

Quiz Dasar-dasar CSS

Quiz Dasar-dasar CSS

Professional Development

10 Qs

How Cyber Safe Are You? Part 4

How Cyber Safe Are You? Part 4

Professional Development

10 Qs

Knowledge Check 3

Knowledge Check 3

Assessment

Quiz

Information Technology (IT)

Professional Development

Practice Problem

Hard

Created by

Blue Azul

Used 5+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

5 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following file format is not supported by Snowflake?

JSON

AVRO

CSV

ORC

EDI

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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>

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?