HPE Edge-to-Cloud Solutions — Question 8

You are designing a highly-available SQL database solution, following HPE reference architectures for Microsoft SQL 2017 on Linux.
Which HA design factors should be considered? (Choose two.)

Answer options

• A. Real-Time Operational Analytics
• B. Transparent Data Encryption
• C. Always On Failover Cluster Instance (FCI)
• D. Read-Scale Availability Groups

Correct answer: C, D

Explanation

The correct answers, C and D, are critical components for achieving high availability in SQL Server. C. Always On Failover Cluster Instance (FCI) provides high availability by grouping multiple SQL Server instances, while D. Read-Scale Availability Groups enhances read performance and availability. Options A and B, although important for security and analytics, do not directly contribute to high availability design.