Free Amazon AWS-DEA-C01 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

A financial services company is storing time-series data in a relational database hosted on Amazon RDS. The company wants to improve query performance for reports that are run on a monthly basis, which involve large scans over historical data. The solution should optimize costs and maintain current data integrity constraints.

Which approach should the company take?

A : Migrate the database to Amazon Redshift and utilize Redshift's materialized views to optimize the query performance for repetitive and predictable analysis patterns.

B : Use Amazon RDS for MySQL and implement read replicas to distribute the read load during the execution of large scan operations.

C : Convert the database to use Amazon Aurora with MySQL compatibility and implement Aurora's parallel query feature for faster data scans.

D : Migrate the database to Amazon DynamoDB and use DynamoDB Accelerator (DAX) to cache frequent read requests and improve response times.

Answer: A

Question 3

A company plans to move 10 TB of multimedia content from their local servers to AWS, with a portion of the data being updated weekly. These updates must be reflected in the Amazon S3 bucket where the data will be stored. The multimedia content consists of large image and video files.

To automate and schedule these data transfers effectively, which AWS service should the company employ?

A : Use AWS Transfer for SFTP to secure and automate data transfer to S3.

B : Use AWS DataSync to automate and schedule the ongoing transfer of files to Amazon S3.

C : Set up an AWS Snowball job for periodic data transfer to Amazon S3.

D : Deploy an AWS Storage Gateway to synchronize and manage data transfers to S3.

Answer: B

Question 4

A sales company uses AWS Glue ETL to collect, process, and ingest data into an Amazon S3 bucket. The AWS Glue pipeline creates a new file in the S3 bucket every hour. File sizes vary from 200 KB to 300 KB. The company wants to build a sales prediction model by using data from the previous 5 years. The historic data includes 44,000 files. The company builds a second AWS Glue ETL pipeline by using the smallest worker type. The second pipeline retrieves the historic files from the S3 bucket and processes the files for downstream analysis. The company notices significant performance issues with the second ETL pipeline. The company needs to improve the performance of the second pipeline. Which solution will meet this requirement MOST cost-effectively?

A : Use a larger worker type.

B : Increase the number of workers in the AWS Glue ETL jobs.

C : Use the AWS Glue DynamicFrame grouping option.

D : Enable AWS Glue auto scaling.

Answer: D

Question 5

A company wants to migrate an application and an on-premises Apache Kafka server to AWS. Theapplication processes incremental updates that an on-premises Oracle database sends to the Kafka server. Thecompany wants to use the replatform migration strategy instead of the refactor strategy.Which solution will meet these requirements with the LEAST management overhead?

A : Amazon Kinesis Data Streams

B : Amazon Managed Streaming for Apache Kafka (Amazon MSK) provisioned cluster

C : Amazon Data Firehose

D : Amazon Managed Streaming for Apache Kafka (Amazon MSK) Serverless

Answer: D