Microsoft
70-433 · Question #129
70-433 Question #129: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #129. The question stem and answer options stay visible for context.
Question
You have two tables named dbo.CurrentProducts and dbo.ArchiveProducts. You have the following query: SELECT ProductID, Name FROM dbo.CurrentProducts UNION ALL SELECT ProductID, Name FROM dbo.ArchiveProducts; You need to predict the list of products that the query will produce. Which list of products should the query return?
Options
- AProducts that appear in dbo.CurrentProducts or dbo.ArchiveProducts but not in both.
- BProducts that have a matching ProductID and Name in dbo.CurrentProducts or
- CProducts that appear in dbo.CurrentProducts or dbo.ArchiveProducts.
- DProducts that appear in dbo.CurrentProducts or dbo.ArchiveProducts.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 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.