A DBA is planning a migration of on-premises enterprise Microsoft SQL Server to AWS. The current on-premises configuration utilizes SQL Server Reporting Services, and the DBA would like to continue using this feature in AWS. What solution would meet this requirement?

Answer options:

A.Create a Microsoft SQL Server on Amazon RDS database instance. Create a new Option Group and configure the SQLSERVER_SSRS option. Associate the option group with the RDS database instance.
B.Create a Microsoft SQL Server on Amazon RDS database instance. Create a new Parameter Group and configure the SQLSERVER_SSRS parameter. Associate the parameter group with the RDS database instance.
C.Install Microsoft SQL Server on EC2 instances.
D.Create a Microsoft SQL Server on Amazon RDS database instance. Configure Amazon RDS Performance Insights on the RDS database instance.

Answer: C
SQL Server Reporting Services is not available on Amazon RDS instances. If this service and feature are required in the AWS cloud, the only viable option is to install the Microsoft SQL Server database on EC2 instances. Therefore, option C is CORRECT, and all other options are incorrect.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html