Exam SOL-C01 Topic 1 Question 37 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 37
Topic #: 1
You have a Snowflake table named 'employees' with columns 'employee_id', 'name',
'department', and 'salary'. You need to load data from a fixed-width file located in an internal stage named 'employee_stage'. The file format is as follows: 'employee_id' (5 characters), name' (20 characters), 'department' (15 characters), and 'salary' (10 characters). Which of the following demonstrates the correct way to create the file format and then load the data into the 'employees' table, assuming all columns are of type STRING in the target table?

Suggested Answer: B Vote an answer

Option B is the most direct way. First creates the file format by specify that the file should not be delimited but treat each row as a single string of text, then loads the data into employees table.
Also, to consider that if any spacing available then TRIM_SPACE should be TRUE/FALSE.

by Edmund at Nov 10, 2025, 09:11 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10