Which AWS service is used for data warehousing and analytics?
a) Amazon Redshift
b) Amazon S3
c) AWS Lambda
d) Amazon RDS
Answer:
a) Amazon Redshift
Explanation:
Amazon Redshift is a fully managed data warehousing service designed for fast querying and analysis of large datasets. It allows users to run complex queries against structured and semi-structured data, making it ideal for business intelligence (BI) and analytics workloads.
Redshift uses columnar storage and data compression to optimize performance and reduce storage costs. It can handle petabytes of data, making it suitable for large-scale data warehousing and reporting.
With Redshift, users can integrate data from various sources, such as S3, RDS, or on-premises databases, and analyze it using SQL-based querying tools.