Answer-first summary for fast verification
Answer: Use Amazon Redshift with SQL pivot functions for large datasets.
Amazon Redshift supports SQL pivot functions that are efficient for transforming rows into columns, especially for large datasets. This approach requires careful consideration of the data schema and the pivot logic to ensure the transformation is performed correctly and efficiently.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Consider a scenario where you need to pivot a large dataset to transform rows into columns for better analysis. Which AWS service would you use to perform this operation efficiently, and what considerations would you need to take into account?
A
Use Amazon Redshift with SQL pivot functions for large datasets.
B
Use AWS Glue to transform data into a suitable format before pivoting.
C
Use Amazon QuickSight for direct pivoting without preprocessing.
D
Use Amazon Athena for querying and pivoting data directly from S3.