Question 5 : 70-450 MCITP Microsoft SQL 2008 | Free practice exams

Question 5

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?

Auto growth disabled, Full Recovery model selected

Auto growth enabled, Simple Recovery model selected

Auto growth enabled, Compatibility level set to SQL 7

Auto growth enabled, Full 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 so its best to preallocate space

This is a sample question. You can start the practice exam by clicking the 'Start Practice Exam' link on the exam page.

Back to practice exam

Home
Microsoft Exams

Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD