Citrix Virtual Apps and Desktops 7 Advanced Administration — Question 3

Scenario: A Citrix Engineer recently implemented a Provisioning Services pilot environment, which still has all the default configurations and uses a standalone
SQL Server Express machine to host the Farm database. Management would like the engineer to expand the environmental so that it can be used to support several critical use cases within the organization. The farm database must meet these requirements:
-The solution must ensure that production users are NOT impacted in the event of a database outage.
-The solution must NOT require manual administrator intervention.
-No additional funding is available to accomplish this objective.
Which configuration will meet all the requirements of this scenario?

Answer options

Correct answer: A

Explanation

The SQL AlwaysOn Availability Group is the best option because it allows for high availability and disaster recovery without impacting users during outages and does not necessitate manual intervention. Offline database support does not provide the necessary availability, while SQL Mirroring and SQL Clustering might require additional funding or manual management, which contradicts the scenario's constraints.