Dell-EMC

E20-324 · Question #187

When designing storage for SQL Server 2012 transaction log files, how should you allocate storage space?

The correct answer is A. Create a large log file LUN to improve recovery performance. See the full explanation below for the reasoning.

Question

When designing storage for SQL Server 2012 transaction log files, how should you allocate storage space?

Options

ACreate a large log file LUN to improve recovery performance.
BCreate a large log file LUN to improve write performance.
CCreate a small log file LUN to improve recovery performance.
DCreate a small log file LUN to improve write performance.

How the community answered

(57 responses)

A
72% (41)
B
16% (9)
C
9% (5)
D
4% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full E20-324 Practice