Free Amazon Data-Engineer-Associate Exam Questions

Question 1

A company has as JSON file that contains personally identifiable information (PIT) data and non-PII data. The company needs to make the data available for querying and analysis. The non-PII data must be available to everyone in the company. The PII data must be available only to a limited group of employees. Which solution will meet these requirements with the LEAST operational overhead?

A : Store the JSON file in an Amazon S3 bucket. Configure AWS Glue to split the file into one file that contains the PII data and one file that contains the non-PII data. Store the output files in separate S3 buckets. Grant the required access to the buckets based on the type of user.

B : Store the JSON file in an Amazon S3 bucket. Use Amazon Macie to identify PII data and to grant access based on the type of user.

C : Store the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation. Use Lake Formation permissions to provide access to the required data based on the type of user.

D : Create two Amazon RDS PostgreSQL databases. Load the PII data and the non-PII data into the separate databases. Grant access to the databases based on the type of user.

Answer: C

Question 2

Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket. Which solution will meet these requirements?

A : Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.

B : Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.

C : Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.

D : Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.

Answer: D

Question 3

A company generates reports from 30 tables in an Amazon Redshift data warehouse. The data source is anoperational Amazon Aurora MySQL database that contains 100 tables. Currently, the company refreshes alldata from Aurora to Redshift every hour, which causes delays in report generation.Which combination of steps will meet these requirements with the LEAST operational overhead? (SelectTWO.)

A : Use AWS Database Migration Service (AWS DMS) to create a replication task. Select only the required tables.

B : Create a database in Amazon Redshift that uses the integration.

C : Create a zero-ETL integration in Amazon Aurora. Select only the required tables.

D : Use query editor v2 in Amazon Redshift to access the data in Aurora.

E : Create an AWS Glue job to transfer each required table. Run an AWS Glue workflow to initiate the jobs every 5 minutes.

Answer: A,C

Question 4

A healthcare company stores patient records in an on-premises MySQL database. The company creates anapplication to access the MySQL database. The company must enforce security protocols to protect thepatient records. The company currently rotates database credentials every 30 days to minimize the risk ofunauthorized access.The company wants a solution that does not require the company to modify the application code for eachcredential rotation.Which solution will meet this requirement with the least operational overhead?

A : Assign an IAM role access permissions to the database. Configure the application to obtain temporarycredentials through the IAM role.

B : Use AWS Key Management Service (AWS KMS) to generate encryption keys. Configure automatickey rotation. Store the encrypted credentials in an Amazon DynamoDB table.

C : Use AWS Secrets Manager to automatically rotate credentials. Allow the application to retrieve thecredentials by using API calls.

D : Store credentials in an encrypted Amazon S3 bucket. Rotate the credentials every month by using an S3Lifecycle policy. Use bucket policies to control access.

Answer: C

Question 5

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