Free Amazon AWS-DEA-C01 Exam Questions

Question 1

As a Cloud Data Engineering Consultant, you are assisting a client in setting up a data warehouse using Amazon Redshift. The client's data warehouse stores sensitive financial information and is used by various departments within the organization, each requiring different levels of access. The client emphasizes the need for secure data sharing practices that would allow specific teams to access only the data relevant to their work. They seek your advice on implementing a solution within Amazon Redshift to grant permissions effectively and securely for sharing data across different teams.

To meet the client's need for secure, role-specific data access in their Amazon Redshift data warehouse, which of the following approaches would you recommend?

A : Utilize Redshift Spectrum to create external schemas and tables, granting access to these external tables to specific IAM roles assigned to different teams.

B : Configure Amazon Redshift Security Groups to control which teams can access the data warehouse, assigning specific IP address ranges for each team.

C : Leverage Amazon Redshift's Row-Level Security (RLS) feature to control access to rows of data based on user attributes such as team or role, enabling fine-grained access control within shared tables.

D : Implement Redshift Data Sharing to share live data across different Redshift clusters, using Redshift's ALTER DATASHARE command to add and manage consumer clusters' access to the data.

Answer: C

Question 2

A company uses Amazon S3 as a data lake. The company sets up a data warehouse by using a multi-nodeAmazon Redshift cluster. The company organizes the data files in the data lake based on the data source ofeach data file.The company loads all the data files into one table in the Redshift cluster by using a separate COPY commandfor each data file location. This approach takes a long time to load all the data files into the table. Thecompany must increase the speed of the data ingestion. The company does not want to increase the cost of theprocess.Which solution will meet these requirements?

A : Use a provisioned Amazon EMR cluster to copy all the data files into one folder. Use a COPY command to load the data into Amazon Redshift.

B : Load all the data files in parallel into Amazon Aurora. Run an AWS Glue job to load the data into Amazon Redshift.

C : Use an AWS Glue job to copy all the data files into one folder. Use a COPY command to load the data into Amazon Redshift.

D : Create a manifest file that contains the data file locations. Use a COPY command to load the data into Amazon Redshift.

Answer: D

Question 3

A Data Engineering Consultant is tasked with establishing a CI/CD pipeline for a data engineering project in AWS. The project involves a multi-stage data processing application, requiring reliable build, test, and deployment phases, and should leverage infrastructure as code for consistency and speed. The team desires a highly automated pipeline, well integrated into the AWS ecosystem, with minimal manual interventions and quick turnaround times for deploying updates.

Which of the following setups would best meet these requirements?

A : Store the code in a GitHub repository, use Travis CI for continuous integration and deployment, Ansible for infrastructure provisioning, and deploy to AWS Elastic Beanstalk for managing application deployment.

B : Implement source control with GitLab, use AWS CodeBuild for build and test, AWS CloudFormation for infrastructure management, and manually deploy using AWS Elastic Container Service (ECS) tasks and services.

C : Utilize AWS CodeCommit for source control, AWS CodeBuild for building the application, AWS CodePipeline for orchestrating the CI/CD process, AWS CloudFormation for infrastructure as code, and AWS CodeDeploy for deploying the application across environments.

D : Adopt AWS CodeCommit for version control, integrate CircleCI for building and testing, use Terraform for infrastructure as code, and script deployment processes using AWS CLI within CircleCI jobs.

Answer: C

Question 4

A retail company's Data Engineering Team is tasked with refining their Amazon Redshift cluster to facilitate analysis in a separate testing environment, utilizing the primary cluster's data. The new testing process will engage the secondary cluster for a duration of 3 hours biweekly. The team is evaluating the most cost-effective solution to meet this requirement.

Which method would be the most economical for the company to implement?

A : Export data biweekly from the primary Redshift cluster to Amazon S3. Access this data from the Redshift test cluster via Amazon Redshift Spectrum.

B : Establish a data share between the primary Redshift cluster and the test Redshift cluster, utilizing Amazon Redshift Serverless for the latter.

C : Generate a manual snapshot of the primary Redshift cluster every two weeks and restore this to the test cluster, which should mirror the main cluster's node configuration.

D : Program an operation to transfer data from the primary Redshift cluster to Amazon S3 every two weeks, followed by configuring an AWS Glue job to import the data into the Redshift test cluster.

Answer: B

Question 5

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 : git push origin main

B : git fetch origin mai

C : git commit -m "Update with latest main"

D : git pull origin main

Answer: D