70-450 · Question #138
The tempbd plays an even more important role than in previous versions of SQL Server. This includes DBCC operations, event notifications, large object variables and parameters. Its important to…
The correct answer is D. Auto growth enabled, Simple Recovery model selected. You also want to ensure that enough space has been preallocated to the tempdb to ensure that most operations are handled. You do this by setting the file size to an appropriate value. Autogrow should be enabled be default but autogrow operations are expensive and time consuming…
Question
The tempbd plays an even more important role than in previous versions of SQL Server. This includes DBCC operations, event notifications, large object variables and parameters. Its important to ensure that certain settings are enabled for the tempdb database. Which two are likely settings that you should configure?
Options
- AAuto growth disabled, Full Recovery model selected
- BAuto growth enabled, Compatibility level set to SQL 7
- CAuto growth enabled, Full Recovery model selected
- DAuto growth enabled, Simple Recovery model selected
How the community answered
(17 responses)- A12% (2)
- B6% (1)
- C6% (1)
- D76% (13)
Explanation
You also want to ensure that enough space has been preallocated to the tempdb to ensure that most operations are handled. You do this by setting the file size to an appropriate value. Autogrow should be enabled be default but autogrow operations are expensive and time consuming so its best to preallocate space
Topics
Community Discussion
No community discussion yet for this question.