試験DEA-C01 トピック1 問題64 スレッド

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

B. 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.

C. 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.

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

E. 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.