Your network contains a Network Policy Server (NPS) server named Server1. The network contains a server
named SQL1 that has Microsoft SQL Server 2008 R2 installed. All servers run Windows Server 2012 R2.
You configure NPS on Server1 to log accounting data to a database on SQL1.
You need to ensure that the accounting data is captured if SQL1 fails. The solution must minimize cost.
What should you do?
A.
Implement Failover Clustering.
B.
Implement database mirroring.
C.
Run the Accounting Configuration Wizard.
D.
Modify the SQL Server Logging properties.
Explanation:
In Windows Server 2008 R2, an accounting configuration wizard is added to the Accounting node in the NPS
console. By using the Accounting Configuration wizard, you can configure the following four accounting
settings:
SQL logging only. By using this setting, you can configure a data link to a SQL Server that allows NPS to
connect to and send accounting data to the SQL server. In addition, the wizard can configure the database
on the SQL Server to ensure that the database is compatible with NPS SQL server logging.
Text logging only. By using this setting, you can configure NPS to log accounting data to a text file.
Parallel logging. By using this setting, you can configure the SQL Server data link and database. You can
also configure text file logging so that NPS logs simultaneously to the text file and the SQL Server database.
SQL logging with backup. By using this setting, you can configure the SQL Server data link and database. In
addition, you can configure text file logging that NPS uses if SQL Server logging fails.