Exam AWS Certified Data Analytics - Specialty topic 1 question 78 discussion

Exam question from Amazon's AWS Certified Data Analytics - Specialty

Question #: 78
Topic #: 1

[All AWS Certified Data Analytics - Specialty Questions]

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?

A. Store the contents of the mapping file in an Amazon DynamoDB table. Preprocess the records as they arrive in the Kinesis Data Analytics application with an AWS Lambda function that fetches the mapping and supplements each record to include the territory code, if one exists. Change the SQL query in the application to include the new field in the SELECT statement.
B. Store the mapping file in an Amazon S3 bucket and configure the reference data column headers for the .csv file in the Kinesis Data Analytics application. Change the SQL query in the application to include a join to the file's S3 Amazon Resource Name (ARN), and add the territory code field to the SELECT columns.
C. Store the mapping file in an Amazon S3 bucket and configure it as a reference data source for the Kinesis Data Analytics application. Change the SQL query in the application to include a join to the reference table and add the territory code field to the SELECT columns.
D. Store the contents of the mapping file in an Amazon DynamoDB table. Change the Kinesis Data Analytics application to send its output to an AWS Lambda function that fetches the mapping and supplements each record to include the territory code, if one exists. Forward the record from the Lambda function to the original application destination.

Show Suggested Answer

Suggested Answer: C 🗳️

by VikG12 at May 3, 2021, 5:35 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Heer

Highly Voted 3 years, 7 months ago

ANSWER:C EXPLANATION:Since ,Kinesis data analytics only consume the data from KDS and KDF ,so S3 Data reference can be attached to it as a datasource .

upvoted 23 times

...

DerekKey

Highly Voted 3 years, 8 months ago

C - https://docs.aws.amazon.com/kinesisanalytics/latest/dev/app-add-reference-data.html

upvoted 7 times

...

pk349

Most Recent 2 years, 1 month ago

C: I passed the test

upvoted 1 times

...

cloudlearnerhere

2 years, 7 months ago

Selected Answer: C

Correct answer is C as Kinesis Data Analytics allows adding S3 source for reference data which can be referred by Kinesis Data Analytics for data enrichment. Kinesis Data Analytics stores it as an in-application reference table. Options A & D are wrong as they are not cost-effective. Option B is wrong as Kinesis Data Analytics stores the reference data as an in-application reference table.

upvoted 6 times

...

rocky48

2 years, 10 months ago

Selected Answer: C

ANSWER:C

upvoted 1 times

...

tobsam

3 years, 6 months ago

I think B is more concise than C. https://docs.aws.amazon.com/kinesisanalytics/latest/dev/sch-mapping.html Since the mapping file is a .csv file, I think we need the columns headers to avoid schema discovery for kda joins. https://docs.aws.amazon.com/kinesisanalytics/latest/dev/app-add-reference-data.html Also IAM role ARN is needed to Add the Reference Data Source to the Application Configuration

upvoted 1 times