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:

Inventory Collection

The process of organizing and managing products or stock that a company holds for sale to customers.

Inventory Payment

The financial transactions related to the purchasing of inventory, either on a cash or credit basis.

Cash Conversion Cycle

A measurement that gauges the duration required for a business to transform its investments in stock and other assets into cash flows from customer purchases.

Receivables Collection

The process of a business collecting payments owed by its customers for goods or services provided.