Which command will load data successfully to the table named finance_dept_location?

Question

Options

• Acopy into finance_dept_location(city, zip, sale_date, price)
• Bcopy into finance_dept_location(city, zip, sale_date, price)
• Ccopy into finance_dept_location(city, zip, sale_date, price)
• Dcopy into finance_dept_location(city, zip, sale_date, price)

• A
  87% (58)
• B
  1% (1)
• C
  9% (6)
• D
  3% (2)

Explanation

The options as provided appear identical in text - the distinguishing details (file stage path, format options, or source specification) were likely lost in formatting. That said, here's what you need to know to answer this type of question confidently:

Why A is correct: A valid COPY INTO command must reference a properly defined stage (e.g., FROM @my_stage), match column names to the target table's schema, and include any required file format options. Option A presumably satisfies all these requirements - correct stage path, matching column list, and valid format specification.

Why the distractors are wrong: Typical wrong answers in COPY INTO questions fail because they reference a non-existent stage, omit the FROM clause, specify columns in the wrong order without an explicit column mapping, use an incompatible file format option, or include a PURGE or FORCE flag that causes a conflict.

Memory tip: Think "Stage → Columns → Format" - a valid COPY INTO needs a source (the stage), a target (column list matching the table), and a format (CSV, JSON, Parquet, etc.) that agrees with the actual file. If any of these three are mismatched or missing, the load will fail.

Note: The four choices in your question appear textually identical - double-check your source material to ensure the full options (including stage paths and format clauses) are visible, as the key differences are almost certainly in those omitted parts.

No community discussion yet for this question.