nerdexam
Snowflake

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.

Data Loading and Unloading

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

SOL-C01 question #177 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.

Topics

#Fixed-width format#COPY INTO#CREATE FILE FORMAT#Internal Stage
Full SOL-C01 Practice