Which three components will be available during a SQL Server outage? (Choose three.)

During a SQL Server database outage, the Local Host Cache (LHC) feature on each Delivery Controller takes over connection brokering. LHC maintains a local copy of the site's main configuration, allowing it to continue brokering user sessions to available resources. This ensures that users can still launch new sessions and connect to their published applications and desktops, including Hosted Windows and Browser Applications, Personal (static/assigned) Desktops, and Hosted Shared Desktops, provided the VDAs are registered and powered on when the outage begins.

D. Remote PC Desktop (for Automatic enrollment): While existing Remote PC Access desktops are available, the automatic enrollment and assignment process requires write access to the central Site database and is therefore unavailable during an outage.
E. Citrix Studio: Citrix Studio is the primary management console for the site. It requires a live connection to the central Site database to read and modify the site configuration. It cannot function during a database outage.

1. Citrix Virtual Apps and Desktops 7.15 LTSR Product Documentation, "Local Host Cache":

Section: "What is available during an outage": This section explicitly states that users can connect to published applications and desktops. This supports options A, B, and C. It states, "Users can start new sessions to applications and desktops."

Section: "What is unavailable during an outage": This section confirms the incorrect options. It states, "You cannot use Studio or run PowerShell cmdlets." This makes option E incorrect. It also states, "Automatic enrollment for Remote PC Access is not available." This makes option D incorrect.

2. Citrix Virtual Apps and Desktops 7.15 LTSR Product Documentation, "Databases":

Section: "High availability": This section describes the purpose of LHC: "Local Host Cache (LHC) allows connection brokering operations in your deployment to continue when the connection between a Delivery Controller and the site database fails." This confirms the fundamental principle that brokering for user resources (A, B, C) continues.