Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake SOL-C01 Exam - Topic 4 Question 15 Discussion

What are the benefits of using the Snowsight data loading interface? (Select TWO).
B) It allows a user to insert the records of a supported file into a table. and C) It will try to detect data types.
A) It creates permanent file formats that can be used to load data in the future.
D) It allows a user to optimize data loading into a table.
E) It lets a user merge file rows into the table records.

Snowflake SOL-C01 Exam - Topic 4 Question 15 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 15
Topic #: 4
[All SOL-C01 Questions]

What are the benefits of using the Snowsight data loading interface? (Select TWO).

Show Suggested Answer Hide Answer
Suggested Answer: B, C

Snowsight's file-loading interface:

*Automatically detects data typesby inspecting column values.

*Loads (inserts) file contents directly into a table, either a new table or an existing one.

Snowsight does not automatically create permanent file formats, does not merge rows, and does not optimize warehouse-level performance.

==================


Contribute your Thoughts:

0/2000 characters
Gwenn
3 days ago
Not sure about the merging feature, sounds complicated.
upvoted 0 times
...
Lamonica
8 days ago
Definitely agree on the ability to insert records into tables.
upvoted 0 times
...
Edda
14 days ago
Wait, it creates permanent file formats? That’s new to me!
upvoted 0 times
...
Lina
19 days ago
I think it’s great for optimizing data loading too.
upvoted 0 times
...
Rodolfo
24 days ago
It can detect data types automatically!
upvoted 0 times
...
Stanton
29 days ago
I recall that Snowsight helps with optimizing data loading, so D seems solid, but I can't remember if A is correct about permanent file formats.
upvoted 0 times
...
Micheline
1 month ago
I practiced a similar question, and I feel like D is definitely a benefit, but I'm torn between A and E for the second choice.
upvoted 0 times
...
Henriette
1 month ago
I'm not entirely sure, but I remember something about data type detection being useful, so maybe C is one of the answers?
upvoted 0 times
...
Dominga
1 month ago
I think options B and D might be the right answers since they both relate to how data is loaded into tables.
upvoted 0 times
...

Save Cancel