Free Snowflake DEA-C01 Exam Questions

Become Snowflake Certified with updated DEA-C01 exam questions and correct answers

Page: 1 / 48

Total 240 Questions | Updated On: Feb 18, 2025

Add To Cart

Question 1

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

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

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.

Answer: A

Question 2

To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards?

A : He can choose to remove stage files during data loading (using the COPY INTO command).

B : Files no longer needed, can be removed using the PURGE=TRUE command.

C : Files no longer needed, can be removed using the REMOVE command.

D : Script can be used during data loading & post data loading with DELETE command.

Answer: A,B

Question 3

Data Engineer is looking out to delete staged files automatically/periodically when the data is suc-cessfully loaded into tables by the Snowpipe. For achieving the same, which options/command is best suited: [Select 2]

A : PURGE option can be set as True in the COPY INTO Command embedded in PIPE objects definition.

B : To remove staged files that no longer needed, periodically REMOVE command can be executed to delete the files.

C : To remove staged files that no longer needed, periodically DELETE command can be executed to delete the files.

D : REMOVE_STAGE_FILES option can be set as True in the COPY INTO Command embedded in PIPE objects definition.

Answer: A,B

Question 4

Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?

A : SYSTEM$TASK_DEPENDENTS

B : SYSTEM$TASK_DEPENDENTS_ENABLE

C : SYSTEM$TASK_DEPENDENTS_RESUME

D : SYSTEM$TASK_RECURSIVE_ENABLE

Answer: B

Question 5

What can you infer from the below query profile?

A : Less number of bytes of data are read from the cloud storage

B : More bytes are read from the cloud storage

C : The query did a good partition pruning

Answer: A

Page: 1 / 48

Total 240 Questions | Updated On: Feb 18, 2025

Add To Cart