A database specialist is designing an application to answer one-time queries.The application will query complex customer data and provide reports to end users.These reports can include many fields.The database specialist wants to give users the ability to query the database by using any of the provided fields.The database’s traffic volume will be high but variable during peak times.However, the database will not have much traffic at other times during the day.
Which solution will meet these requirements MOST cost-effectively?
Amazon DynamoDB with provisioned capacity mode and auto scaling
Amazon DynamoDB with on-demand capacity mode
Amazon Aurora with auto scaling enabled
Amazon Aurora in a serverless mode
I weigh that the answer is:
Amazon Aurora in a serverless mode