Free Amazon Data-Engineer-Associate Exam Questions

Question 1

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 2

A financial services company is in need of an enhanced storage solution for their transactional relational database system. The solution must ensure high durability, strong consistency, and enhanced read performance for real-time analytics. Additionally, the company needs to maintain high availability and disaster recovery capabilities. Cost management is also a priority, but not at the expense of these performance characteristics. The company's current infrastructure does not require multiple geographical regions.

Which combination of AWS storage services and features should the consultant recommend to meet these requirements? (Select TWO)

A : Use Amazon DynamoDB with provisioned capacity to manage cost while offering built-in high availability and durability.

B : Implement Amazon EFS with lifecycle management policies to transition older transaction data to EFS Infrequent Access.

C : Utilize Amazon ElastiCache to improve read performance and reduce the load on the primary transaction database.

D : Deploy Amazon Aurora Global Database for high performance, availability, and cross-region disaster recovery.

E : Enable Amazon RDS Multi-AZ deployments for high availability and durability with synchronous data replication.

Answer: C,E

Question 3

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?

A : Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

B : AWS Step Functions

C : AWS Glue

D : Amazon EventBridge

Answer: A

Question 4

A data engineer has a one-time task to read data from objects that are in Apache Parquet format in an Amazon S3 bucket. The data engineer needs to query only one column of the data. Which solution will meet these requirements with the LEAST operational overhead?

A : Confiqure an AWS Lambda function to load data from the S3 bucket into a pandas dataframe- Write a SQL SELECT statement on the dataframe to query the required column.

B : Use S3 Select to write a SQL SELECT statement to retrieve the required column from the S3 objects.

C : Prepare an AWS Glue DataBrew project to consume the S3 objects and to query the required column.

D : Run an AWS Glue crawler on the S3 objects. Use a SQL SELECT statement in Amazon Athena to query the required column.

Answer: B,D

Question 5

While reviewing the data security policies of their company, a Cloud Data Engineering Consultant identifies a need to enhance the protection of sensitive data stored in various AWS services such as Amazon S3, RDS, and DynamoDB.

Which method would be most effective in securing the data across these services to prevent unauthorized access?

A : Encrypt the data at rest using AWS KMS-managed keys and ensure that encryption in transit is enabled for all communications.

B : Rely solely on AWS IAM policies to govern access, granting necessary permissions to each service based on the role of the user or service accessing the data.

C : Implement network access control lists (NACLs) and security groups to restrict access to the resources based on IP addresses.

D : Place all data in a private VPC and disable internet access, requiring all access to occur through a VPN or Direct Connect.

Answer: A