Free Amazon AWS-DEA-C01 Exam Questions

A mobile app tracks user activity data, which is continuously streamed to Amazon Kinesis Data Streams. The app requires a solution to process this data in real-time and update user profiles stored in Amazon DynamoDB based on the activity data.

What combination of AWS services should be used for real-time processing of the stream and updating the user profiles in DynamoDB?

A Data Engineering Consultant is working on a data processing project that involves AWS services, and the project's code is stored in a Git repository hosted on AWS CodeCommit. The project has a well-established branching strategy, and the consultant needs to update their local copy with the latest changes from the remote repository's main branch, to include recent updates related to AWS configurations and scripts.

Which Git command should be used to update the local repository with these latest changes from AWS CodeCommit?

A company needs to load customer data that comes from a third party into an Amazon Redshift datawarehouse. The company stores order data and product data in the same data warehouse. The company wantsto use the combined dataset to identify potential new customers.A data engineer notices that one of the fields in the source data includes values that are in JSON format.How should the data engineer load the JSON data into the data warehouse with the LEAST effort?

A Data Engineering Team is setting up a new job in AWS Glue ETL. They have configured their data sources and targets, defined the necessary transformations, but when they attempt to run the job, it fails with an authorization error. The team needs to ensure that the AWS Glue job has the necessary permissions to access the required AWS resources for execution.

What should the team do to resolve this issue and successfully run the Glue ETL job?

A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. TheETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, andload data into Amazon Redshift.The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python toorchestrate the jobs.Which service will meet these requirements?