Microsoft
70-433 · Question #175
You administer a Microsoft SQL Server 2008 R2 database that has a table named Customer. The table has the following definition: The database also has a table named CustomerExclusionList. Data will…
The correct answer is C. Option C. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 R2 database that has a table named Customer. The table has the following definition:
The database also has a table named CustomerExclusionList. Data will be added to the CustomerExclusionList table regularly. The CustomerExclusionList table has the following definition:
You need to create a view that returns all records and columns of the Customer table that are not present in the CustomerExclusionList table. Which Transact-SQL statement should you use?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(26 responses)- A12% (3)
- B4% (1)
- C81% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.