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

Lynelle

3 months ago

I'll just use the COMBINE clause. That's a real SQL keyword, right? *wink wink*

upvoted 0 times

Dylan

2 months ago

User 3: The COMBINE clause is not a real SQL keyword, you should use JOIN instead.

upvoted 0 times

...

Virgie

2 months ago

User 2: Yeah, JOIN is the correct clause for that.

upvoted 0 times

...

Dalene

2 months ago

User 1: You should use JOIN in a select statement to combine rows in one table with rows in another table.

upvoted 0 times

...

Jesusita

3 months 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

3 months 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

4 months 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

Kyoko

3 months ago

You're right, the JOIN clause is used to combine rows from different tables in a select statement.

upvoted 0 times

...

Merilyn

3 months ago

A) JOIN

upvoted 0 times

...

Ettie

4 months 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

4 months 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

4 months ago

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

upvoted 0 times

...

Samuel

4 months ago

I think the answer is A) JOIN.

upvoted 0 times

...