Microsoft
70-433 · Question #188
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 PreferredCustomerList. Data will…
The correct answer is B. Option B. 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 PreferredCustomerList. Data will be added to the PreferredCustomerList table regularly. The PreferredCustomerList table has the following definition:
You need to create a view that returns all records and columns of the Customer table that are also present in the PreferredCustomerList table. Which Transact-SQL statement should you use?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(35 responses)- A3% (1)
- B83% (29)
- C9% (3)
- D6% (2)
Community Discussion
No community discussion yet for this question.