Which service is designed for petabyte-scale data warehousing and integrates with business intelligence tools?

• A. AWS X-Ray
• B. Amazon Redshift
• C. Amazon Timestream
• D. AWS CodeArtifact

Answer: (B)

Petabyte-scale data warehousing with BI tool integration is what this is about. Amazon Redshift is AWS’s managed data warehouse designed for exactly that: storing and analyzing massive datasets efficiently. It uses columnar storage and massively parallel processing to run complex analytics quickly and can scale to petabyte-scale clusters. It integrates with business intelligence tools through standard SQL, JDBC, and ODBC connections, and works well with BI platforms like Amazon QuickSight as well as third-party tools such as Tableau and Power BI. Redshift also supports querying data in Amazon S3 via Redshift Spectrum, enabling analysis that combines data from both the data warehouse and the data lake in a single query. This combination of scale, performance, and BI compatibility makes it the natural fit for petabyte-scale data warehousing.

AWS X-Ray focuses on tracing and debugging distributed applications, not warehousing. Amazon Timestream is a time-series database optimized for IoT and real-time analytics, not general-purpose petabyte-scale warehousing. AWS CodeArtifact is a software package artifact repository, unrelated to data warehousing.