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

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jesusita

2 days ago

SET? That's for updating columns, not joining tables. I think the exam writer needs to go back to SQL 101.

upvoted 0 times

...

Jenelle

5 days ago

KEY? Really? That's not even close. Maybe they're testing our database design knowledge instead of our SQL skills.

upvoted 0 times

...

Stephaine

14 days 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

Merilyn

2 days ago

A) JOIN

upvoted 0 times

...

Ettie

19 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

...

Josephine

19 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

...

Nan

23 days ago

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

upvoted 0 times

...

Samuel

25 days ago

I think the answer is A) JOIN.

upvoted 0 times

...