Microsoft
70-433 · Question #126
You have two tables named SalesPerson and SalesTerritory. You need to create sample data by using a Cartesian product that contains the data from the SalesPerson and SalesTerritory tables. Which…
The correct answer is D. SELECT p.SalesPersonId, t. See the full explanation below for the reasoning.
Question
You have two tables named SalesPerson and SalesTerritory. You need to create sample data by using a Cartesian product that contains the data from the SalesPerson and SalesTerritory tables. Which code segment should you use?
Options
- ASELECT p.SalesPersonId, t.
- BSELECT p.SalesPersonId,
- CSELECT p.SalesPersonId, t.
- DSELECT p.SalesPersonId, t.
How the community answered
(37 responses)- A5% (2)
- B14% (5)
- C3% (1)
- D78% (29)
Community Discussion
No community discussion yet for this question.