DAS-C01 Question #88: Real Exam Question with Answer & Explanation

Question

An online gaming company is using an Amazon Kinesis Data Analytics SQL application with a Kinesis data stream as its source. The source sends three non-null fields to the application: player_id, score, and us_5_digit_zip_code. A data analyst has a .csv mapping file that maps a small number of us_5_digit_zip_code values to a territory code. The data analyst needs to include the territory code, if one exists, as an additional output of the Kinesis Data Analytics application. How should the data analyst meet this requirement while minimizing costs?

Options

• AStore the contents of the mapping file in an Amazon DynamoDB table.
• BStore the mapping file in an Amazon S3 bucket and configure the reference data column headers
• CStore the mapping file in an Amazon S3 bucket and configure it as a reference data source for the
• DStore the contents of the mapping file in an Amazon DynamoDB table.

Explanation

{"question_number": 1, "question_summary": "Kinesis Data Analytics: enriching streaming data with a small CSV zip-to-territory mapping", "correct_answer": "C", "explanation": "Amazon Kinesis Data Analytics natively supports S3 reference data sources. You upload the small CSV mapping file to S3, configure it as a reference data source on the application, and then join it with the live stream using SQL - no additional infrastructure needed. This is the lowest-cost option because it avoids provisioning or paying for DynamoDB when the dataset is small and static. Options A and D propose DynamoDB, which adds unnecessary cost and complexity. Option B is close but incomplete because simply configuring column headers without registering the file as a reference data source does not enable SQL JOIN access from within the analytics application.", "generated_by": "claude-sonnet", "llm_judge_score": 4}

No community discussion yet for this question.