Microsoft Discussions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Go to Exam

Exam 70-761 topic 1 question 90 discussion

Actual exam question from Microsoft's 70-761

Question #: 90
Topic #: 1

[All 70-761 Questions]

You have a database that includes the following tables.

HumanResources.Employee -

Sales.SalesPerson -

The HumanResources.Employee table has 2,500 rows, and the Sales.SalesPerson table has 2,000 rows.
You review the following Transact-SQL statement:

You need to determine the performance impact of the query.
How many times will a lookup occur on the primary key index on the Sales.SalesPerson table?

A. 200
B. 2,000
C. 2,500
D. 5,500

Show Suggested Answer

Suggested Answer: C 🗳️

by Hjkasdjfoiasdfh at Aug. 2, 2020, 12:25 p.m.

Comments

Submit Cancel

Hjkasdjfoiasdfh

Highly Voted 5 years ago

Correct

upvoted 5 times

...

d_m

Most Recent 4 years, 10 months ago

why is the correct answer 2500?

upvoted 1 times

HA2020

4 years, 8 months ago

because it is a correlated query that the constant is compared to, the server will have to do the comparison for each record.

upvoted 1 times

...

...

Oooo

4 years, 10 months ago

Answer is correct but the inner query is wrong. In the inner query it should be sp.BusinessentityID=e.BusyinessentityID.

upvoted 1 times

BabyBee

4 years, 8 months ago

The order of the factors do not affect the product. It's the same as: WHERE e.BusinessentityID=sp.BusyinessentityID

upvoted 1 times

...

...