100% Free Amazon AWS-DEA-C01 Practice Test Questions

Question 1

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

Question 2

An analyst is using Amazon Athena and needs to create a new table in the Parquet format with SNAPPY compression from an existing table named old_table. The task requires the correct syntax for a Create Table As Select (CTAS) statement in Athena. Which of the following SQL statements correctly achieves this objective?

A : CREATE NEW TABLE new_tableFROM old_tableWITH FORMAT AS 'Parquet' AND COMPRESSION AS 'SNAPPY';

B : CREATE TABLE new_tableSET FORMAT = 'Parquet', COMPRESSION = 'SNAPPY'AS SELECT *FROM old_table;

C : CREATE TABLE new_table ASSELECT *FROM old_tableUSING ('format' = 'Parquet', 'compression' = 'SNAPPY');

D : CREATE TABLE new_tableWITH ( format = 'Parquet', write_compression = 'SNAPPY')AS SELECT *FROM old_table;

Answer: D

Question 3

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 4

A company stores its processed data in an S3 bucket. The company has a strict data access policy. Thecompany uses IAM roles to grant teams within the company different levels of access to the S3 bucket.The company wants to receive notifications when a user violates the data access policy. Each notificationmust include the username of the user who violated the policy.Which solution will meet these requirements?

A : Use AWS Config rules to detect violations of the data access policy. Set up compliance alarms.

B : Use Amazon CloudWatch metrics to gather object-level metrics. Set up CloudWatch alarms.

C : Use AWS CloudTrail to track object-level events for the S3 bucket. Forward events to Amazon CloudWatch to set up CloudWatch alarms.

D : Use Amazon S3 server access logs to monitor access to the bucket. Forward the access logs to an Amazon CloudWatch log group. Use metric filters on the log group to set up CloudWatch alarms.

Answer: C

Question 5

A Data Engineering Team is tasked with enhancing the CI/CD workflow of their complex ETL pipeline on AWS. The pipeline involves frequent but varying updates—from minor feature additions to major architectural overhauls. The team uses GitHub for version control and manages a diverse array of AWS resources in their projects.

They require a CI/CD solution that not only automates build and test processes upon each commit but also allows for customizable, condition-based deployment strategies (e.g., deploying only specific branches or tags, or based on commit messages).

Given these requirements, which AWS service or combination of services would be the most effective?

A : AWS Lambda and AWS CodePipeline, where a Lambda function is triggered by GitHub webhooks to determine if the deployment should proceed, followed by CodePipeline managing the build, test, and deployment phases.

B : AWS CodeCommit and AWS CodePipeline, with CodeCommit to replace GitHub for enhanced integration within the AWS ecosystem, and CodePipeline to orchestrate the entire process including condition-based deployments.

C : AWS CodePipeline, integrating both GitHub and AWS CodeBuild. CodePipeline to manage the overall workflow and CodeBuild for the build and testing phases, leveraging pipeline actions for deployment conditions.

D : AWS CodeBuild and AWS CodeDeploy, with CodeBuild handling the build and test processes and CodeDeploy managing advanced deployment strategies based on GitHub webhook events.

Answer: C

Free Practice Amazon AWS-DEA-C01 Exam Questions 2025