Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 135

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Correct Answer: A, C, D

Best practices for loading data into Snowflake include aiming to produce data files that are between 100 MB and 250 MB in size, compressed, to optimize the number of parallel operations. Enclosing fields that contain delimiter characters in single or double quotes ensures the data is correctly interpreted. Finally, splitting large files into a greater number of smaller files helps distribute the load among the compute resources in an active warehouse, thereby enhancing performance and efficiency.

Discussion

Tapasgup007Options: ACD

The answer is wrong it shorud be ACD ,Nobody can pass using these dumps They all have wrong Answers

Manish5031994

Bhai dil ki baat bol di..saare ke saare answers galat hai..admin bhai please revisit kar lo ek baar.

ManocsOptions: ACD

A, C, D https://docs.snowflake.com/en/user-guide/data-load-considerations.html A. To optimize the number of parallel operations for a load, we recommend aiming to produce data files roughly 100-250 MB (or larger) in size compressed. C. Fields that contain delimiter characters should be enclosed in quotes (single or double). If the data contains single or double quotes, then those quotes must be escaped. D. Split larger files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

jveagOptions: ACD

these tests are confusing me more than learning. the correct answers would be a, c and d.

Madhavan71Options: ACD

ACD is correct

baig123Options: ACD

correct answer ACD .

pranaligOptions: ACD

correct answer:ACD

PrashantGupta1616Options: ACD

A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed. C. Enclose fields that contain delimiter characters in single or double quotes. D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

AnireddySaikiranReddyOptions: ACD

Correct Answer: ACD

_yyuktaOptions: ACE

ACD are correct

SoftwareEngineerGoneDataOptions: ACD

Definitely ACD

RajuNaikOptions: ACD

ACD right answer

vini15Options: ACD

ACD right answer

nishantgshahOptions: ACD

Correct Answer ACD

EmiBOptions: ACD

ACD is correct

William_20Options: ACD

b: more latency and cost, e:more cost f: less efficient