DEA-C01 Question 314
Select 3You are working on a big data project where data needs to be processed, transformed, and analyzed. You want to use AWS services that allow you to write custom scripts in Python or SQL for these tasks. Which of the following services allow scripting capabilities?
- A
Amazon EMR
- B
Amazon Redshift
- C
AWS Glue
- D
Amazon S3
- E
Amazon RDS
Show answer and explanation
Correct answers: A, B, C
Explanation
Amazon EMR, Amazon Redshift, and AWS Glue all support scripting capabilities, making them suitable for use cases where custom Python or SQL scripts are required. Amazon EMR provides scripting through frameworks like Spark, AWS Glue supports Python-based ETL scripts, and Amazon Redshift allows SQL scripting for data analysis and transformations. Amazon S3 and Amazon RDS, on the other hand, either do not support scripting or are not designed for this purpose.
- A. Correct.
Amazon EMR allows scripting through frameworks like Apache Spark and Hadoop. You can write custom scripts in Python (e.g., PySpark) and other languages.
- B. Correct.
Amazon Redshift supports scripting for data analysis and transformation using SQL, and it offers user-defined functions (UDFs) for custom logic.
- C. Correct.
AWS Glue allows scripting in Python for ETL processes using Glue's custom Python or PySpark environments.
- D. Incorrect.
Amazon S3 is a storage service and does not support scripting capabilities directly. It is often used alongside other services for scripting tasks.
- E. Incorrect.
Amazon RDS supports basic SQL queries but is not typically used for scripting or extensive data transformations like the other services mentioned.