Microsoft
70-432 · Question #192
You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives according to the following table: You discover that the Windows application log is being filled with entries…
The correct answer is D. Run the following Transact-SQL statement. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives according to the following table:
You discover that the Windows application log is being filled with entries from a SQL Server Audit process named DatabaseAudit. The volume of these events is causing older events to be removed from the log. You need to ensure that the following requirements are met:
- SQL Server Audit information is stored in the D:\AuditLogs folder.
- No data is currently lost in the Windows application log.
What should you do?
Options
- AOpen the Windows Server Manager.
- BCreate a folder named AuditLogs on driveD.
- CCreate a folder named AuditLogs on drive
- DRun the following Transact-SQL statement:
How the community answered
(20 responses)- A5% (1)
- B15% (3)
- C5% (1)
- D75% (15)
Community Discussion
No community discussion yet for this question.