SAP-C02 · Question #56
A financial services company receives a regular data feed from its credit card servicing partner. Approximately 5,000 records are sent every 15 minutes in plaintext delivered over httpS directly into
The correct answer is C. Create an AWS Glue crawler and custom classifier based on the data feed formats and build a. You can use a Glue crawler to populate the AWS Glue Data Catalog with tables. The Lambda function can be triggered using S3 event notifications when object create events occur. The Lambda function will then trigger the Glue ETL job to transform the records masking the sensitive d
Question
A financial services company receives a regular data feed from its credit card servicing partner. Approximately 5,000 records are sent every 15 minutes in plaintext delivered over httpS directly into an Amazon S3 bucket with server-side encryption. This feed contains sensitive credit card primary account number (PAN) data. The company needs to automatically mask the PAN before sending the data to another S3 bucket for additional internal processing. The company also needs to remove and merge specific fields and then transform the record into JSON format Additionally extra feeds are likely to be added in the future so any design needs to be easily expandable. Which solutions will meet these requirements?
Options
- ATrigger an AWS Lambda function on file delivery that extracts each record and writes it to an
- BTrigger an AWS Lambda function on file delivery that extracts each record and writes it to an
- CCreate an AWS Glue crawler and custom classifier based on the data feed formats and build a
- DCreate an AWS Glue crawler and custom classifier based upon the data feed formats and build a
How the community answered
(52 responses)- A21% (11)
- B4% (2)
- C67% (35)
- D8% (4)
Explanation
You can use a Glue crawler to populate the AWS Glue Data Catalog with tables. The Lambda function can be triggered using S3 event notifications when object create events occur. The Lambda function will then trigger the Glue ETL job to transform the records masking the sensitive data and modifying the output format to JSON. This solution meets all requirements. Create an AWS Glue crawler and custom classifier based on the data feed formats and build a table definition to match. Trigger an AWS Lambda function on file delivery to start an AWS Glue ETL job to transform the entire record according to the processing and transformation requirements. Define the output format as JSON. Once complete, have the ETL job send the results to another S3 bucket for internal processing. https://docs.aws.amazon.com/glue/latest/dg/trigger-job.html https://d1.awsstatic.com/Products/product-name/diagrams/product-page-diagram_Glue_Event- driven-ETL-Pipelines.e24d59bb79a9e24cdba7f43ffd234ec0482a60e2.png
Community Discussion
No community discussion yet for this question.