Allianz Financial Services (AFS) is a banking group offering end-to-end banking and financial solutions in South East Asia through its consumer banking, business banking, Islamic banking, investment finance and stock broking businesses as well as unit trust and asset administration, having served the financial community over the past five decades. AFS uses Redshift on AWS to fulfill the data warehousing needs and uses S3 as the staging area to host files.
AFS uses other services like DynamoDB, Aurora, and Amazon RDS on remote hosts to fulfill other needs.
The team uses load the data from different data sources using COPY command.
What data sources does not support loading of data using COPY command? Select 1 option.
Click on the arrows to vote for the correct answer
A. B. C. D.Answer : C.
Option C is correct: COPY command can load data from text files in an Amazon S3 bucket, in an Amazon EMR cluster, or on a remote host that your cluster can access using an SSH connection.
You can also load data directly from a DynamoDB table.
https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-source.htmlThe COPY command is a feature in Amazon Redshift that enables the loading of large amounts of data from various data sources such as Amazon S3, Amazon EMR, Amazon DynamoDB, and remote hosts using the AWS Data Pipeline or other ETL (Extract, Transform, Load) tools.
In this scenario, Allianz Financial Services (AFS) uses Redshift on AWS for its data warehousing needs and S3 as the staging area to host files. The team loads data from different data sources using the COPY command.
Out of the options provided, only one data source does not support loading of data using COPY command. Amazon DynamoDB is the only data source in this list that cannot be loaded using the COPY command.
Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. The data in DynamoDB is stored as key-value pairs, and the data model is different from the relational model used in Redshift.
While it is possible to move data from DynamoDB to Redshift, it cannot be done using the COPY command. Instead, the data has to be exported from DynamoDB to S3 using tools like AWS Data Pipeline or AWS Glue, and then loaded into Redshift using the COPY command.
Therefore, the answer to the question is D. Amazon DynamoDB.