Microsoft Exam DP-900 Topic 2 Question 92 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 92
Topic #: 2

[All DP-900 Questions]

Which clause should you use in a select statement to combine rows in one table with rows in another table?

AJOIN

BVALUES

Cset

DKEY

Show Suggested Answer

Suggested Answer: A

by Evette at Sep 13, 2024, 04:03 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

15 hours ago

I thought the VALUES clause was for inserting new rows, not combining them. Guess I need to brush up on my SQL basics.

upvoted 0 times

...

6 days ago

The JOIN clause is definitely the correct answer here. It's the bread and butter of combining data from multiple tables.

upvoted 0 times

...

6 days ago

I'm not sure, but I think it's C) set because it sounds like it could be used for combining rows.

upvoted 0 times

...

10 days ago

I agree with Samuel, JOIN is used to combine rows from different tables.

upvoted 0 times

...

12 days ago

I think the answer is A) JOIN.

upvoted 0 times

...