Exams / CLF-C02 / AI, machine learning and analytics / Question 3
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 company wants a fully managed data warehouse where analysts can run complex SQL queries across many terabytes of structured sales data collected from several systems, using their existing business intelligence tools. Which service should it choose?
Choose one answer.
- AA. Amazon Redshift
- BB. Amazon DynamoDB
- CC. Amazon ElastiCache
- DD. Amazon Kinesis Data Streams
Show the answer and explanation
Answer: A
- A. Right: Correct. Redshift is a fully managed, petabyte-scale data warehouse that analyses large datasets with standard SQL and BI tools.
- B. Wrong: DynamoDB is a NoSQL database for fast key-value access in applications. It is not designed for complex analytical SQL queries.
- C. Wrong: ElastiCache is an in-memory cache for speeding up applications, not a data warehouse.
- D. Wrong: Kinesis Data Streams captures streaming data in real time. It does not store and query years of data as a warehouse.
Explanation
Amazon Redshift is AWS's data warehouse service. It is built for analytics: running complex SQL queries over very large amounts of structured data from many sources. A serverless option provisions and scales capacity automatically. Transactional databases such as DynamoDB and RDS are designed for application workloads instead.
Study
Keep practising
Answer questions with a score at the end, or practise just this topic with the explanation after each one. No sign-up needed.