A company is migrating its on-premises Teradata data warehouse system to AWS. What AWS service offers columnar data store suitable for data warehousing?

Answer options:

A.Amazon Athena
B.Amazon Aurora
C.Amazon Lake Formation
D.Amazon Redshift

Answer: D
Option A is incorrect because Amazon Athena is a service that enables querying data stored in S3 using traditional SQL syntax.
Option B is incorrect because Amazon Aurora is a row-based relational database.
Option C is incorrect because Amazon Lake Formation is a service that assists in configuring and provisioning data lake components such as Redshift clusters, AWS Glue, Amazon EMR, Amazon Athena, etc. In some ways, it’s comparable to Elastic Beanstalk such that Beanstalk assists in provisioning infrastructure suitable for hosting web applications.
Option D is CORRECT because Amazon Redshift is a petabyte scale columnar datastore used for data reporting and data analytics use cases.
Reference:
https://docs.aws.amazon.com/redshift/latest/mgmt/welcome.html