A company wants to use machine learning (ML) to perform analytics on data that is in an Amazon S3 data lake. The company has two data transformation requirements that will give consumers within the company the ability to create reports.
The company must perform daily transformations on 300 GB of data that is in a variety format that must arrive in Amazon S3 at a scheduled time. The company must perform one-time transformations of terabytes of archived data that is in the S3 data lake. The company uses Amazon Managed Workflows for Apache Airflow (Amazon MWAA) Directed Acyclic Graphs (DAGs) to orchestrate processing.
Which combination of tasks should the company schedule in the Amazon MWAA DAGs to meet these requirements MOST cost-effectively? (Choose two.)

• A. For daily incoming data, use AWS Glue crawlers to scan and identify the schema.
• B. For archived data, use Amazon SageMaker to perform data transformations.
• C. For daily and archived data, use Amazon EMR to perform data transformations.
• D. For daily incoming data, use Amazon Redshift to perform transformations.
• E. For daily incoming data, use Amazon Athena to scan and identify the schema.

In a data engineering pipeline, a company is using multiple applications and teams to access a shared Amazon S3 bucket. To streamline access and simplify permissions management for these different entities, which S3 feature should the company utilize?

• A. Use S3 Access Points to create unique endpoints with tailored permissions for each application or team.
• B. Activate S3 Transfer Acceleration for the bucket to ensure fast and differentiated access for each application or team.
• C. Enable multiple IAM roles, each corresponding to an application or team, granting access to the S3 bucket.
• D. Implement S3 Lifecycle policies for each application or team to manage their specific data access and retention.

A company uses Amazon Redshift for its data warehouse. A data engineer must query a table named orders.complete_orders_history, which contains 100 columns. The query must return all columns except columns named companyId and unique_system_id. Which Amazon Redshift SQL statement will meet this requirement?

• A.
  
• B.
  
• C.
  
• D.
  

A company wants to analyze sales records that the company stores in a MySQL database. The company wants to correlate the records with sales opportunities identified by Salesforce.
The company receives 2 GB of sales records every day. The company has 100 GB of identified sales opportunities. A data engineer needs to develop a process that will analyze and correlate sales records and sales opportunities. The process must run once each night.
Which solution will meet these requirements with the LEAST operational overhead?

• A. Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to fetch both datasets.
  Use AWS Lambda functions to correlate the datasets. Use AWS Step Functions to orchestrate the process.
• B. Use Amazon AppFlow to fetch sales opportunities from Salesforce. Use AWS Glue to fetch sales records from the MySQL database. Correlate the sales records with the sales opportunities. Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate the process.
• C. Use Amazon AppFlow to fetch sales opportunities from Salesforce. Use AWS Glue to fetch sales records from the MySQL database. Correlate the sales records with sales opportunities. Use AWS Step Functions to orchestrate the process.
• D. Use Amazon AppFlow to fetch sales opportunities from Salesforce. Use Amazon Kinesis Data Streams to fetch sales records from the MySQL database. Use Amazon Managed Service for Apache Flink to correlate the datasets. Use AWS Step Functions to orchestrate the process.

A marketing company uses Amazon S3 to store marketing data. The company uses versioning in some buckets. The company runs several jobs to read and load data into the buckets.
To help cost-optimize its storage, the company wants to gather information about incomplete multipart uploads and outdated versions that are present in the S3 buckets.
Which solution will meet these requirements with the LEAST operational effort?

• A. Use Amazon S3 Inventory configurations reports to gather the information.
• B. Use the Amazon S3 Storage Lens dashboard to gather the information.
• C. Use AWS CLI to gather the information.
• D. Use AWS usage reports for Amazon S3 to gather the information.