ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-765 All Questions

View all questions & answers for the 70-765 exam
Go to Exam

Exam 70-765 topic 4 question 31 discussion

Actual exam question from Microsoft's 70-765
Question #: 31
Topic #: 4
[All 70-765 Questions]

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You discover that queries take longer than expected to execute. You also find that the top wait type for the SQL Server instance is ASYNC_NETWORK_IO.
You need to resolve the performance issue.
What should you do?

  • A. Increase the number of processor cores for the virtual machine
  • B. Create any missing indexes
  • C. Modify the application code to remove row-by-row processing
  • D. Allocate more memory to the SQL Server instance
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
References:
https://www.sqlservercentral.com/articles/speeding-up-data-access-part-1-missing-indexes-1
by cmps at May 20, 2020, 7:40 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
cmps
Highly Voted 5 years ago
Correct is C. The most common reason for excessive SQL Server ASYNC_NETWORK_IO wait types is that the application cannot process the data that arrives from SQL Server fast enough Row by Agonizing Row (RBAR) processing is often the cause of such behavior and high ASYNC_NETWORK_IO wait type values
upvoted 12 times
jolsca
4 years, 9 months ago
Is correct https://www.sqlshack.com/reducing-sql-server-async_network_io-wait-type/
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel