Data Loading Flashcards

1
Q

Snowpipe supports loading from what stages

A
  • Named internal or external stages
  • Table stages
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Need to look into copy options

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Where can you define the file format settings

A
  • While creating named file formats
  • In the table definition
  • In the named stage definition
  • Directly in the COPY INTO TABLE statement when loading data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A
  • CONTINUE
  • SKIP_FILE
  • ABORT_STATEMENT
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

STRIP_NULL_VALUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

A non-deterministic list of 10 grades

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the REST apis provided by SnowPipe

A

insertFiles
insertReport
loadHistoryScan

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

RECORD_CONTENT
RECORD_METADATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

T/F SNOWPIPE_AUTO_INGEST is supported for external stages only

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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?

A

PURGE=TRUE into the COPY INTO command

How well did you know this?
1
Not at all
2
3
4
5
Perfectly