Answer-first summary for fast verification
Answer: Migrate the database to Amazon DynamoDB using AWS Database Migration Service (AWS DMS) with the AWS Schema Conversion Tool (AWS SCT), and store the videos as objects in Amazon S3, with the S3 key stored in the corresponding DynamoDB item.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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?
A
Migrate the database to Amazon Aurora PostgreSQL using AWS Database Migration Service (AWS DMS) and store the videos as base64-encoded strings in a TEXT column within the database.
B
Migrate the database to Amazon DynamoDB using AWS Database Migration Service (AWS DMS) with the AWS Schema Conversion Tool (AWS SCT), and store the videos as objects in Amazon S3, with the S3 key stored in the corresponding DynamoDB item.
C
Migrate the database to Amazon Keyspaces (for Apache Cassandra) using AWS Database Migration Service (AWS DMS) with the AWS Schema Conversion Tool (AWS SCT), and store the videos as objects in Amazon S3, with the S3 object identifier stored in the corresponding Amazon Keyspaces entry.
D
Migrate the database to Amazon DynamoDB using AWS Database Migration Service (AWS DMS) with the AWS Schema Conversion Tool (AWS SCT), and store the videos as base64-encoded strings in the corresponding DynamoDB item.