data-engineer video for a company is using AWS Glue DataBrew to clean and structure data from an Amazon S3 bucket before loading it into an Amazon Redshift data
A company is using AWS Glue DataBrew to clean and structure data from an Amazon S3 bucket before loading it into an Amazon Redshift data warehouse for analysis. The data contains combined fields such as city and zip code in a single column. The company also wants to automate this process on a daily schedule. Which steps should the data engineer take to meet these requirements? (Choose TWO.)