⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

2 days, 4 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

A data analyst needs to combine two large fact tables named invoice_2024 and invoice_2025, each holding the same 15 columns and more than three million rows. Because invoice numbers are sequentially generated and never reused, the business has confirmed there will be no duplicate records across the two tables. The merged result will feed year-over-year revenue dashboards, so the SQL written for the merge step must minimize extra processing such as sorting or de-duplication. Which SQL construct should the analyst use to build the consolidated data set with the least overhead?

  • Use a UNION ALL operator to append invoice_2025 to invoice_2024.

  • Merge the tables with a FULL OUTER JOIN on invoice_number.

  • Create an INNER JOIN between the tables on invoice_number.

  • Use a UNION operator so that only distinct rows are returned.

CompTIA Data+ DA0-002 (V2)
Data Acquisition and Preparation
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot