DEA-C01 Question 280
Select 2You are designing a data lake architecture to store and analyze data from multiple sources. The data includes relational database tables, JSON files, and raw video footage. How should you model the data to ensure efficient querying and processing while leveraging AWS services?
- A
Store relational database tables in Amazon RDS, JSON files in Amazon S3 with an appropriate prefix structure, and raw video footage in Amazon S3 with S3 Glacier for archival.
- B
Convert all data into a single format, such as Parquet, and store it in Amazon S3 for consistency.
- C
Store relational database tables in Amazon Redshift, JSON files in Amazon DynamoDB, and raw video footage in Amazon S3.
- D
Store relational database tables in Amazon RDS, use AWS Glue to catalog JSON files stored in Amazon S3, and store raw video footage in Amazon S3 with lifecycle policies for cost management.
Show answer and explanation
Correct answers: A, D
Explanation
When modeling diverse data types such as structured, semi-structured, and unstructured data, it's important to choose services that align with the nature of the data and its access patterns. Amazon RDS is well-suited for structured relational data, JSON files are semi-structured and can be efficiently stored and cataloged in S3 using AWS Glue, and raw video footage, being unstructured and often large, is best stored in S3 with lifecycle policies to optimize cost and performance.
- A. Correct.
Correct: By storing relational tables in Amazon RDS and JSON files in Amazon S3 with meaningful prefixes, you can enable efficient querying and processing. Using S3 Glacier for video archival ensures cost-effective storage of rarely accessed unstructured data.
- B. Incorrect.
Incorrect: Converting all data into a single format, such as Parquet, is not suitable in this scenario because relational data and raw video footage have different requirements and use cases. A one-format-fits-all approach would lead to inefficiencies.
- C. Incorrect.
Incorrect: While Amazon Redshift is a good choice for analytics, storing JSON files in DynamoDB is not optimal for large-scale processing or querying. This option does not leverage AWS services effectively for the unstructured video data.
- D. Correct.
Correct: This approach optimally uses AWS services by placing relational database tables in Amazon RDS, leveraging AWS Glue to catalog and process JSON files, and storing video footage in S3 with lifecycle policies to manage costs.