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.