70-450 · Question #63
70-450 Question #63: Real Exam Question with Answer & Explanation
The correct answer is C. To finish the task, multiple data files should be create for the database.. If your database is very large and very busy, multiple tiles can be used to increase performance. Here is one example of how you might use multiple files. Let's say you have a single table with 10 million rows that is heavily queried. It the table is in a single file, such as a s
Question
Options
- ATo finish the task, database and log files should be placed on the same volume.
- BTo finish the task, the affinity mask option should be configured properly.
- CTo finish the task, multiple data files should be create for the database.
- DTo finish the task, the affinity I/O mask option should be configured properly.
Explanation
If your database is very large and very busy, multiple tiles can be used to increase performance. Here is one example of how you might use multiple files. Let's say you have a single table with 10 million rows that is heavily queried. It the table is in a single file, such as a single database file, then SQL Server would only use one thread to perform a read of the rows in the table. But if the table were divided into three physical files, then SOL Server would use three threads (one per physical file} to read the table, which potentially could be faster. In addition, if each tile were on its own separate physical disk or disk array, the performance gain would even be greater. Essentially, the more files that a large table is divided into, the greater the potential performance. Of course there is a point where the additional threads aren't of much use when you max out the server's UO. But up until you do max out the IXO, additional threads (and files) should increase
Community Discussion
No community discussion yet for this question.