Dell-EMC
E20-007 · Question #27
E20-007 Question #27: Real Exam Question with Answer & Explanation
Sign in or unlock E20-007 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
Question
You have two tables of customers in your database. Customers in cust_table_1 were sent an e- mail promotion last year, and customers in cust_table_2 received a newsletter last year. Customers can only be entered in once per table. You want to create a table that includes all customers, and any of the communications they received last year. Which type of join would you use for this table?
Options
- ACross join
- BInner join
- CLeft outer join
- DFull outer join
Unlock E20-007 to see the answer
You've previewed enough free E20-007 questions. Unlock E20-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.