Google Cloud Professional Cloud Developer PCD — Topic 1 Question 8

Question

You have two tables in an ANSI-SQL compliant database with identical columns that you need to quickly combine into a single table, removing duplicate rows from the result set. What should you do?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use the UNION operator in SQL to combine the tables.

Google Cloud Professional Cloud Developer PCD — Question 8