exam questions

Exam 70-339 All Questions

View all questions & answers for the 70-339 exam

Exam 70-339 topic 1 question 87 discussion

Actual exam question from Microsoft's 70-339
Question #: 87
Topic #: 1
[All 70-339 Questions]

HOTSPOT -
You manage a SharePoint environment for a company. The file size for the tempdb database is set to 500 megabytes (MB).
You observe an increase in the consumption of system disk space by the tempdb database. You need to minimize the space requirements and optimize the performance of the tempdb database.
You need to optimize the performance for the tempdb database.
How should you configure the database? To answer, select the appropriate option from each list in the answer area.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Simple -

TempDB Optimization -
First, the TempDB recovery model should be set to simple. Indeed, this model automatically reclaims log space to keep space requirements small.
Box 2: 20 Megabytes (MB)
With 20 MB increments the TempDB will remain smaller.
References:
https://blog.dbi-services.com/how-improve-sharepoint-performance-with-sql-server-settings/

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
Suprotim
4 years, 5 months ago
This question came on 29th Jan 2021.
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
Loading ...