APICS Certified Supply Chain Professional (CSCP) — Question 347

A data engineer has been given a new record of data:

id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4

Which of the following SQL commands can be used to append the new record to an existing Delta table my_table?

Answer options

• A. INSERT INTO my_table VALUES ('a1', 6, 9.4)
• B. my_table UNION VALUES ('a1', 6, 9.4)
• C. INSERT VALUES ( 'a1' , 6, 9.4) INTO my_table
• D. UPDATE my_table VALUES ('a1', 6, 9.4)
• E. UPDATE VALUES ('a1', 6, 9.4) my_table

Correct answer: A

Explanation

The correct answer is A, which properly uses the INSERT INTO statement to add the new record to the Delta table. Options B, C, D, and E are incorrect because they either use incorrect SQL syntax or commands meant for different operations, such as UNION or UPDATE, which do not append new records.