SOL-C01 · Question #177
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_
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #177. The question stem and answer options stay visible for context.
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?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
