For the most efficient and cost-effective Data load experience, Data Engineer needs to inconsider-ate which of the following considerations?

Question

I Haq · Accepted Answer

Split larger files into a greater number of smaller files, maximize the processing over-head for each file.(Correct)

I Haq · Answer

Enabling the STRIP_OUTER_ARRAY file format option for the COPY INTO <ta-ble> command to remove the outer array structure and load the records into separate table rows.

I Haq · Answer

Amazon Kinesis Firehose can be convenient way to aggregate and batch data files which also allows defining both the desired file size, called the buffer size, and the wait interval after which a new file is sent, called the buffer interval.

I Haq · Answer

When preparing your delimited text (CSV) files for loading, the number of columns in each row should be consistent.

I Haq · Answer

if the "null" values in your files indicate missing values and have no other special mean-ing, Snowflake recommend setting the file format option STRIP_NULL_VALUES to TRUE when loading the semi-structured data file.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 71 - DEA-C01 discussion

Suggested answer: A

0 comments