Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A company has a production AWS account that runs company workloads. The company's security team

created a security AWS account to store and analyze security logs from the production AWS account. The

security logs in the production AWS account are stored in Amazon CloudWatch Logs.

The company needs to use Amazon Kinesis Data Streams to deliver the security logs to the security AWS

account.

Which solution will meet these requirements?

A : Create a destination data stream in the production AWS account. In the security AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the production AWS account.

B : Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the security AWS account.

C : Create a destination data stream in the production AWS account. In the production AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the security AWS account

D : Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the production AWS account.

Answer: D

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 company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?

A : Use AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema. Use AWS DMS to migrate the data.

B : Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data.

C : Use AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema conversion.

D : Manually export the schema definition from Teradata. Apply the schema to the Amazon Redshift database. Use AWS Database Migration Service (AWS DMS) to migrate the data.

Answer: B

Question 4

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 5

A data engineer needs to build an enterprise data catalog based on the company's Amazon S3 buckets andAmazon RDS databases. The data catalog must include storage format metadata for the data in the catalog.Which solution will meet these requirements with the LEAST effort?

A : Use an AWS Glue crawler to scan the S3 buckets and RDS databases and build a data catalog. Use data stewards to inspect the data and update the data catalog with the data format.

B : Use an AWS Glue crawler to build a data catalog. Use AWS Glue crawler classifiers to recognize the format of data and store the format in the catalog.

C : Use Amazon Macie to build a data catalog and to identify sensitive data elements. Collect the data format information from Macie.

D : Use scripts to scan data elements and to assign data classifications based on the format of the data.

Answer: B