ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Which Snowflake technique can be used to improve the performance of a query?
What is a key feature of Snowflake architecture?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Will data cached in a warehouse be lost when the warehouse is resized?

Question 116 - SnowPro Core discussion

Report
Export

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

A.
Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
Answers
A.
Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
B.
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.
Answers
B.
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.
C.
Enclose fields that contain delimiter characters in single or double quotes.
Answers
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.
Answers
D.
Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
E.
When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
Answers
E.
When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
F.
Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
Answers
F.
Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
Suggested answer: A, C, D

Explanation:

Best practices for loading data into Snowflake include aiming for data file sizes between 100 MB and 250 MB when compressed, as this size is optimal for parallel processing and minimizes overhead. Enclosing fields with delimiter characters in quotes ensures proper field recognition during the load process. Splitting large files into smaller ones allows for better distribution of the load across compute resources, enhancing performance and efficiency.

Show Answer
asked 23/09/2024
Hayat Hassan
44 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms