A Retail Company Wants to Combine Its Customer Orders with the Product

question 114

Multiple Choice

A retail company wants to combine its customer orders with the product description data from its product catalog. The structure and format of the records in each dataset is different. A data analyst tried to use a spreadsheet to combine the datasets, but the effort resulted in duplicate records and records that were not properly combined. The company needs a solution that it can use to combine similar records from the two datasets and remove any duplicates. Which solution will meet these requirements?

• A) Use an AWS Lambda function to process the data. Use two arrays to compare equal strings in the fields from the two datasets and remove any duplicates.
• B) Create AWS Glue crawlers for reading and populating the AWS Glue Data Catalog. Call the AWS Glue SearchTables API operation to perform a fuzzy-matching search on the two datasets, and cleanse the data accordingly.
• C) Create AWS Glue crawlers for reading and populating the AWS Glue Data Catalog. Use the FindMatches transform to cleanse the data.
• D) Create an AWS Lake Formation custom transform. Run a transformation for matching products from the Lake Formation console to cleanse the data automatically.

---

Definitions:

Transitional Expression

Words or phrases used to link sentences and paragraphs smoothly, guiding the reader through the text.

Social Class

A societal split determined by economic and social rankings.

Economic Class

A categorization based on the economic status of individuals or groups, often determined by income, wealth, and occupation.

Royal Woman

A female member of a royal family, often signifying someone of noble rank or birth within a monarchy.