AWS Certified Solutions Architect – Professional — Question 931

Is it possible to load data from Amazon DynamoDB into Amazon Redshift?

Answer options

• A. No, you cannot load all the data from DynamoDB table to a Redshift table as it limited by size constraints.
• B. No
• C. No, DynamoDB data types do not correspond directly with those of Amazon Redshift.
• D. Yes

Correct answer: D

Explanation

Amazon Redshift supports loading data directly from Amazon DynamoDB tables using the COPY command. During this process, Amazon Redshift automatically maps DynamoDB attributes to the corresponding columns of the Redshift table. This allows users to perform complex analytical queries on their NoSQL data within the data warehouse.