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

Question 3

A Data Engineering team is planning to migrate a complex legacy Microsoft SQL Server database to Amazon Aurora MySQL. The existing SQL Server database contains several stored procedures, triggers, and complex joins. The team is concerned about potential compatibility issues and the effort needed to rewrite substantial amounts of SQL code manually. They aim to use AWS services to facilitate an efficient and accurate schema conversion, ensuring minimal downtime and data consistency during the migration process.

What sequence of steps should the team follow using AWS services to achieve this migration?

A : Use AWS Database Migration Service (AWS DMS) for an initial assessment of the schema conversion, apply the AWS Schema Conversion Tool (AWS SCT) for the actual schema conversion, then use AWS DMS again to migrate the data to Amazon Aurora MySQL.

B : First, apply the AWS Schema Conversion Tool (AWS SCT) to assess and convert the SQL Server schema and SQL code to a format compatible with Aurora MySQL. Following this, use AWS DMS to migrate the data from SQL Server to Aurora MySQL.

C : Directly utilize AWS DMS to migrate the SQL Server database to Amazon Aurora MySQL, relying on the DMS’s built-in schema conversion feature to handle any compatibility issues during the migration.

D : Start with the AWS Schema Conversion Tool (AWS SCT) for converting the SQL Server schema and code to Aurora MySQL, utilize Amazon RDS to temporarily host the converted schema, and then use AWS DMS for the final migration to Aurora MySQL.

Answer: B

Question 4

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 5

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