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.