A company is migrating its on-premises Teradata data warehouse system to AWS.
What AWS service offers columnar data store suitable for data warehousing?
Click on the arrows to vote for the correct answer
A. B. C. D.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.htmlThe AWS service that offers a columnar data store suitable for data warehousing is Amazon Redshift.
Amazon Redshift is a fast, scalable, and fully-managed data warehouse service that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools. Amazon Redshift stores data in a columnar format, which is optimized for querying and analyzing large volumes of data efficiently.
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. It is a serverless service that requires no infrastructure management and is ideal for ad hoc querying of data. However, it does not provide data warehousing capabilities like Amazon Redshift.
Amazon Aurora is a fully-managed, MySQL and PostgreSQL-compatible relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. While Aurora is a highly scalable relational database service, it does not provide the columnar data store capabilities required for data warehousing.
Amazon Lake Formation is a fully-managed service that makes it easy to build, secure, and manage data lakes. It provides features to centrally define and enforce security, governance, and auditing policies for data lakes. However, it does not provide data warehousing capabilities like Amazon Redshift.
In summary, Amazon Redshift is the best choice for a company that wants to migrate its on-premises Teradata data warehouse system to AWS and requires a columnar data store suitable for data warehousing.