Question 580
An incremental daily snapshot needs appending to a table that already exists. Which operation applies?
Explanation
Correct Answer
Correct: INSERT into existing target. INSERT INTO ... SELECT appends selected rows to an existing table.
Incorrect Answers
Not best here: CREATE TABLE AS SELECT creates a new table populated by a SELECT result; the case calls for INSERT into existing target.
Not best here: MERGE applies conditional source-to-target matching updates, inserts or deletes; the case calls for INSERT into existing target.
Not best here: CREATE VIEW AS SELECT creates a logical query definition rather than an independently stored result table; the case calls for INSERT into existing target.