Developing SQL Databases — Question 143

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?

Answer options

Correct answer: B

Explanation

Changing the transaction log file size to expand dynamically does not directly address the issue of report timeouts, which are often caused by long-running queries or insufficient resources. Instead, optimizing queries, indexing strategies, or increasing server resources would be more effective solutions. Therefore, the correct answer is B, as the proposed solution does not meet the goal.