ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 807 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 807
Topic #: 1
[All SnowPro Core Questions]

A Snowflake user needs to import a JSON file larger than 16 MB.

What file format option could be used?

  • A. trim_space = true
  • B. compression = auto
  • C. strip_outer_array = true
  • D. strip_outer_array = false
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Heetec at Oct. 10, 2023, 8:25 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Isio05
7 months, 1 week ago
Selected Answer: C
C is correct
upvoted 2 times
...
BobFar
7 months, 2 weeks ago
The correct answer is C. strip_outer_array = true will remove the outer array structure and copy the file into multiple table rows instead of row. (the limitation for table rows is max 16MB) with this solution it will be fine. https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare#semi-structured-data-size-limitations
upvoted 3 times
...
Heetec
8 months, 1 week ago
Selected Answer: C
C correct - https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel