SOL-C01 · Question #177
SOL-C01 Question #177: Real Exam Question with Answer & Explanation
The correct answer is B: Option B. 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/
Question
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?
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.