Free Amazon AWS-DEA-C01 Exam Questions

Question 1

A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file. Which Step Functions state should the data engineer use to meet these requirements?

A : Parallel state

B : Choice state

C : Map state

D : Wait state

Answer: C

Question 2

A company has three subsidiaries. Each subsidiary uses a different data warehousing solution. The firstsubsidiary hosts its data warehouse in Amazon Redshift. The second subsidiary uses Teradata Vantage onAWS. The third subsidiary uses Google BigQuery.The company wants to aggregate all the data into a central Amazon S3 data lake. The company wants to useApache Iceberg as the table format.A data engineer needs to build a new pipeline to connect to all the data sources, run transformations by usingeach source engine, join the data, and write the data to Iceberg.Which solution will meet these requirements with the LEAST operational effort?

A : Use native Amazon Redshift, Teradata, and BigQuery connectors to build the pipeline in AWS Glue. Use native AWS Glue transforms to join the data. Run a Merge operation on the data lake Iceberg table.

B : Use the Amazon Athena federated query connectors for Amazon Redshift, Teradata, and BigQuery to build the pipeline in Athena. Write a SQL query to read from all the data sources, join the data, and run a Merge operation on the data lake Iceberg table

C : Use the native Amazon Redshift connector, the Java Database Connectivity (JDBC) connector for Teradata, and the open source Apache Spark BigQuery connector to build the pipeline in Amazon EMR. Write code in PySpark to join the data. Run a Merge operation on the data lake Iceberg table.

D : Use the native Amazon Redshift, Teradata, and BigQuery connectors in Amazon Appflow to write data to Amazon S3 and AWS Glue Data Catalog. Use Amazon Athena to join the data. Run a Merge operation on the data lake Iceberg table.

Answer: B

Question 3

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

Question 4

A company receives test results from testing facilities that are located around the world. The company storesthe test results in millions of 1 KB JSON files in an Amazon S3 bucket. A data engineer needs to process thefiles, convert them into Apache Parquet format, and load them into Amazon Redshift tables. The dataengineer uses AWS Glue to process the files, AWS Step Functions to orchestrate the processes, and AmazonEventBridge to schedule jobs.The company recently added more testing facilities. The time required to process files is increasing. The dataengineer must reduce the data processing time.Which solution will MOST reduce the data processing time?

A : Use AWS Lambda to group the raw input files into larger files. Write the larger files back to Amazon S3. Use AWS Glue to process the files. Load the files into the Amazon Redshift tables.

B : Use the AWS Glue dynamic frame file-grouping option to ingest the raw input files. Process the files. Load the files into the Amazon Redshift tables.

C : Use the Amazon Redshift COPY command to move the raw input files from Amazon S3 directly into the Amazon Redshift tables. Process the files in Amazon Redshift.

D : Use Amazon EMR instead of AWS Glue to group the raw input files. Process the files in Amazon EMR. Load the files into the Amazon Redshift tables.

Answer: B

Question 5

A Cloud Data Engineer is tasked with setting up a secure and reliable connection from an AWS-based analytics service to an on-premises Microsoft SQL Server database. The goal is to perform regular data import operations.

Which approach would be most effective and secure for accomplishing this task?

A : Configure an AWS Lambda function within the VPC to use a JDBC connection with the database credentials hard-coded for simplicity and speed.

B : Implement an AWS Direct Connect link between the on-premises network and AWS, and use a JDBC connection with database credentials stored in Amazon RDS.

C : Use AWS DataSync with an ODBC connection to the SQL Server, ensuring the connection over the internet is encrypted with TLS.

D : Establish a VPN connection between the on-premises network and AWS VPC, and then use JDBC with SSL encryption to connect to the SQL Server.

Answer: D