MLS-C01 Question #220: Real Exam Question with Answer & Explanation

Question

A data engineer needs to provide a team of data scientists with the appropriate dataset to run machine learning training jobs. The data will be stored in Amazon S3. The data engineer is obtaining the data from an Amazon Redshift database and is using join queries to extract a single tabular dataset. A portion of the schema is as follows: - TransactionTimestamp (Timestamp) - CardName (Varchar) - CardNo (Varchar) The data engineer must provide the data so that any row with a CardNo value of NULL is removed. Also, the TransactionTimestamp column must be separated into a TransactionDate column and a TransactionTime column. Finally, the CardName column must be renamed to NameOnCard. The data will be extracted on a monthly basis and will be loaded into an S3 bucket. The solution must minimize the effort that is needed to set up infrastructure for the ingestion and transformation. The solution also must be automated and must minimize the load on the Amazon Redshift cluster. Which solution meets these requirements?

Options

• ASet up an Amazon EMR cluster. Create an Apache Spark job to read the data from the Amazon
• BSet up an Amazon EC2 instance with a SQL client tool, such as SQL Workbench/J, to query the
• CSet up an AWS Glue job that has the Amazon Redshift cluster as the source and the S3 bucket
• DUse Amazon Redshift Spectrum to run a query that writes the data directly to the S3 bucket.