Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
