wants to run many SQL queries on this data. However, DynamoDB does not support complex SQL query function, what you can do in this case?
A. You will copy these data in Oracle RDS instance table.
B. You will copy these data in MySQL RDS instance table.
C. You will copy these data in a Redshift table.
D. While copying data from DynamoDB table if values are Empty, we need to treat them properly either as NULL or Empty.
E. We need to Copy Indexes as well from the DynamoDB table.
F. We need to make sure data types matches while data copying.
1. A,B,C
2. C,D,E
3. C,D,F
4. A,B,E
5. A,C,F
Correct Answer : 3 Exp : In this case we know that data volume is quite high and Analytics team wanted to apply various analytical function on that data. Then best solution is Data Warehouse solution. And in the given
option only Redshift Cluster is a data warehouse solution. Hence, option-C is correct.
Now Redshift is an SQL engine but DynamoDB is not an SQL engine. Hence while copying data we need to take care of few things as below.
. DynamoDB table names can contain up to 255 characters, including . (dot) and - (dash) characters, and are case-sensitive. Amazon Redshift table names are limited to 127 characters, cannot contain dots or
dashes and are not case-sensitive. In addition, table names cannot conflict with any Amazon Redshift reserved words.
. DynamoDB does not support the SQL concept of NULL. You need to specify how Amazon Redshift interprets empty or blank attribute values in DynamoDB, treating them either as NULLs or as empty fields.
. DynamoDB data types do not correspond directly with those of Amazon Redshift. You need to ensure that each column in the Amazon Redshift table is of the correct data type and size to accommodate the data from
DynamoDB.
Based on this we can say that option-D and option-F are correct.
3
