Exam 70-762 topic 1 question 87 discussion

Actual exam question from Microsoft's 70-762

Question #: 87
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a database that is 130 GB and contains 500 million rows of data.
Granular transactions and mass batch data imports change the database frequently throughout the day. Microsoft SQL Server Reporting Services (SSRS) uses the database to generate various reports by using several filters.
You discover that some reports time out before they complete.
You need to reduce the likelihood that the reports will time out.
Solution: You change the transaction log file size to expand dynamically in increments of 200 MB.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by kiri2020 at Nov. 13, 2020, 11:29 p.m.

Comments

Submit Cancel

TheDUdeu

4 years, 5 months ago

The answer is no this won't help.

upvoted 2 times

...

kiri2020

4 years, 7 months ago

It doesn't say the size of Transaction log was an issue, default value for autogrow is 64 MB for SQL Server 16

upvoted 1 times

NhiN

4 years, 5 months ago

"Granular transactions and mass batch data imports change the database frequently throughout the day" would increase log rapidly. Setting the initial size of the SQL Server Transaction Log file to 20-30% of the database data file size and the auto-growth to a large amount, above 1024MB, will avoid the problem of the frequent and the small increments in the SQL Transaction Log file size, that may lead to queries slowness, due to pausing all log writing processes until the log file size increase process is completed, and generates a large number of Virtual Log Files

upvoted 1 times

NhiN

4 years, 5 months ago

I think it is YES

upvoted 1 times

NhiN

4 years, 5 months ago

Link: https://www.sqlshack.com/sql-server-transaction-log-administration-best-practices/

upvoted 1 times

...

BabyBee

4 years, 5 months ago

Ok, then 200 MB seems too little, so NO.

upvoted 1 times

...