Ultimate access to all questions.
A company is modernizing an application and intends to migrate it to AWS. Currently, the application stores user profile data as text in a single table within an on-premises MySQL database. Post-modernization, the application will enable users to upload video files up to 4 GB in size, and other users will need to download these videos. The company requires a video storage solution that can scale rapidly without compromising application performance. Which AWS solution meets these requirements?
Explanation:
Option B is the correct answer. Storing large video files in a database like Amazon Aurora or DynamoDB (as suggested in options A and D) as base64-encoded strings is not optimal due to the significant increase in storage and retrieval times, which would affect application performance. Amazon S3 is specifically designed to handle large objects like video files and provides rapid scaling. By using Amazon DynamoDB for metadata and Amazon S3 for actual video storage (as described in option B), the solution can scale efficiently without compromising the application's performance. The combination of AWS Database Migration Service (AWS DMS) and AWS Schema Conversion Tool (AWS SCT) will facilitate the migration process from MySQL to DynamoDB seamlessly. Option C also stores the videos in S3 but unnecessarily introduces Amazon Keyspaces, which is not needed for this use case, making option B the best choice.