Question

How do you use a reference table in Kinesis Analytics?

A) By defining it in SQL queries
B) By uploading a CSV file
C) By using a NoSQL database
D) By creating a custom API

Answer 1

In Kinesis Analytics, you can use a reference table by uploading a CSV file to an S3 bucket and then referencing it in SQL queries.

Step-by-step explanation:

To use a reference table in Kinesis Analytics, you can perform the following step: B) By uploading a CSV file. When you create a reference data source in Amazon Kinesis Analytics, you upload a CSV file to an S3 bucket. Then, you provide the S3 bucket URI to Kinesis Analytics. After the reference data source is added, you can then join this static reference data with your incoming streaming data within your SQL queries in Kinesis Analytics applications.