Data Loading

Question 1

Snowpipe supports loading from what stages

Answer 1

• Named internal or external stages
• Table stages

Question 2

Need to look into copy options

Question 3

Where can you define the file format settings

Answer 3

• While creating named file formats
• In the table definition
• In the named stage definition
• Directly in the COPY INTO TABLE statement when loading data

Question 4

When loading data using the COPY INTO cmd, what options can you specify for the ON_ERROR clause

Answer 4

• CONTINUE
• SKIP_FILE
• ABORT_STATEMENT

Question 5

T/F The kafka connector creates one pipe for each partition in a Kafka Topic

Answer 5

True

Question 6

To convert JSON null value to SQL null value, you will use

Answer 6

STRIP_NULL_VALUE

Question 7

What does the following query return:
SELECT TOP 10 GRADES FROM STUDENT;

Answer 7

A non-deterministic list of 10 grades

Question 8

T/F a column with very high cardinality (e.g. a column containing UUID or nanosecond timestamp values) is also typically not a good candidate to use as a clustering key directly.

Answer 8

TRUE

Question 9

What are the REST apis provided by SnowPipe

Answer 9

insertFiles
insertReport
loadHistoryScan

Question 10

Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. What are those?

Answer 10

RECORD_CONTENT
RECORD_METADATA

Question 11

T/F SNOWPIPE_AUTO_INGEST is supported for external stages only

Answer 11

TRUE

Question 12

You want to automatically delete the files from stage after a successful load using the COPY INTO command. What would be the recommended approach for deletion?

Answer 12

PURGE=TRUE into the COPY INTO command