A Company Has a Business Unit Uploading

question 28

Multiple Choice

A company has a business unit uploading .csv files to an Amazon S3 bucket. The company's data platform team has set up an AWS Glue crawler to do discovery, and create tables and schemas. An AWS Glue job writes processed data from the created tables to an Amazon Redshift database. The AWS Glue job handles column mapping and creating the Amazon Redshift table appropriately. When the AWS Glue job is rerun for any reason in a day, duplicate records are introduced into the Amazon Redshift table. Which solution will update the Redshift table without duplicates when jobs are rerun?

• A) Modify the AWS Glue job to copy the rows into a staging table. Add SQL commands to replace the existing rows in the main table as postactions in the DynamicFrameWriter class.
• B) Load the previously inserted data into a MySQL database in the AWS Glue job. Perform an upsert operation in MySQL, and copy the results to the Amazon Redshift table.
• C) Use Apache Spark's DataFrame dropDuplicates() API to eliminate duplicates and then write the data to Amazon Redshift.
• D) Use the AWS Glue ResolveChoice built-in transform to select the most recent value of the column.

---

Definitions:

Inability To Speak

A condition where an individual is unable to articulate words or produce speech sounds, also known as aphasia.

Pulse Over 100

A heart rate exceeding 100 beats per minute in an adult, often considered tachycardia, indicating a possible underlying condition or physical state.

Acute Streptococcal Pharyngitis

A bacterial infection that causes inflammation and soreness in the throat, commonly caused by group A streptococcus bacteria.

Antibiotics

Medications used to treat bacterial infections by killing the bacteria or inhibiting their growth.