Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CompTIA DS0-001 Exam - Topic 1 Question 53 Discussion

A database administrator is migrating the information in a legacy table to a newer table. Both tables contain the same columns, and some of the data may overlap.Which of the following SQL commands should the administrator use to ensure that records from the two tables are not duplicated?
A) UNION
B) JOIN
C) IINTERSECT
D) CROSS JOIN

CompTIA DS0-001 Exam - Topic 1 Question 53 Discussion

Actual exam question for CompTIA's DS0-001 exam
Question #: 53
Topic #: 1
[All DS0-001 Questions]

A database administrator is migrating the information in a legacy table to a newer table. Both tables contain the same columns, and some of the data may overlap.

Which of the following SQL commands should the administrator use to ensure that records from the two tables are not duplicated?

Show Suggested Answer Hide Answer
Suggested Answer: A

The SQL command that the administrator should use to ensure that records from the two tables are not duplicated is option A. This command uses theUNIONclause to combine the records from the legacy table and the newer table into a single result set. TheUNIONclause also eliminates any duplicate records that may exist in both tables, and sorts the result by default. The other options either do not produce the desired result or have syntax errors. For example, option B would join the records from the two tables based on a common column, but not remove any duplicates; option C would return only the records that are common to both tables, but not the ones that are unique to each table; option D would produce a Cartesian product of the records from the two tables, which would increase the number of duplicates.Reference:CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.2 Given a scenario, execute database tasks using scripting and programming languages.


by Ressie at Apr 06, 2026, 07:04 PM

Limited Time Offer

25%

Off

Get Premium DS0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Sena
10 hours ago
A) UNION is the way to go!
upvoted 0 times
...
Rodrigo
6 days ago
I thought INTERSECT would handle duplicates better.
upvoted 0 times
...
Alline
11 days ago
Wait, is UNION really the best choice?
upvoted 0 times
...
Erinn
16 days ago
Definitely A) UNION, no duplicates that way!
upvoted 0 times
...
Bernardine
2 months ago
I think JOIN might work too, but not for this.
upvoted 0 times
...
Iraida
2 months ago
A) UNION is the way to go!
upvoted 0 times
...
Oliva
3 months ago
CROSS JOIN definitely doesn't seem right for this scenario; I think it just combines all records without any filtering.
upvoted 0 times
...
Lawanda
3 months ago
I feel like INTERSECT could be relevant, but it seems more about finding common records rather than preventing duplicates.
upvoted 0 times
...
Whitley
3 months ago
I remember practicing with JOINs, but I don't think that's the right choice here since we want to avoid duplicates.
upvoted 0 times
...
Coleen
3 months ago
I think we might need to use UNION, but I'm not entirely sure if it handles duplicates the way we want.
upvoted 0 times
...

Save Cancel