CLF-C02 practice question: AI, machine learning and analytics (3 of 3)
Cloud Technology and Services A free question from our original CLF-C02 practice exam. Try it, then open the answer to see why each option is right or wrong.
A retail chain has 40 TB of sales data from five systems.
Analysts need to run complex SQL queries across all of it and connect their existing business intelligence tools, with AWS managing the infrastructure.
Which service should it choose?
Choose one answer.
AA. Amazon DynamoDB, a key-value and document database for fast lookups by key
BB. Amazon Redshift, a managed data warehouse for SQL analytics
CC. Amazon ElastiCache, an in-memory cache for fast repeated reads
DD. Amazon Kinesis Data Streams, which carries streams of records in real time
Show the answer and explanation
Answer: B
A. Wrong: DynamoDB is built for fast lookups by key. It is not designed for complex SQL analysis across many terabytes of data from several systems.
B. Right: Redshift is a fully managed cloud data warehouse for SQL analytics on large volumes of data. It works with BI tools such as Amazon QuickSight and Tableau. Learn more: Amazon Redshift (opens in a new tab)
C. Wrong: ElastiCache speeds up reads of data stored elsewhere. It does not hold the full sales data set or run analysis queries on it.
D. Wrong: Kinesis Data Streams moves streams of records as they arrive. It does not store the data for analysts to query with SQL.
Explanation
Redshift is AWS's managed data warehouse for SQL analytics across large data sets, and it supports BI tools. DynamoDB and ElastiCache serve fast lookups or cached reads, and Kinesis Data Streams moves records in real time rather than storing them for analysis.
Want more on AI, machine learning and analytics? The 5 full-length practice sets have 12 more AI, machine learning and analytics questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets →