Free AWS DEA-C01 Practice Questions & Answers 2026 Part4

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. reate a destination data stream in the production AWS account

B. reate a destination data stream in the security AWS account

C. reate a destination data stream in the production AWS account

D. reate a destination data stream in the security AWS account

View answer

Correct Answer: D

Question #2

A data engineer must orchestrate a series of Amazon Athena queries that will run every day. Each query can run for more than 15 minutes.Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)

A. Use an AWS Lambda function and the Athena Boto3 client start_query_execution API call to invoke the Athena queries programmatically

B. Create an AWS Step Functions workflow and add two states

C. Use an AWS Glue Python shell job and the Athena Boto3 client start_query_execution API call to invoke the Athena queries programmatically

D. Use an AWS Glue Python shell script to run a sleep timer that checks every 5 minutes to determine whether the current Athena query has finished running successfully

E. Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate the Athena queries in AWS Batch

View answer

Correct Answer: AB

Question #3

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #4

A data engineer needs to schedule a workflow that runs a set of AWS Glue jobs every day. The data engineer does not require the Glue jobs to run or finish at a specific time.Which solution will run the Glue jobs in the MOST cost-effective way?

A. hoose the FLEX execution class in the Glue job properties

B. se the Spot Instance type in Glue job properties

C. hoose the STANDARD execution class in the Glue job properties

D. hoose the latest version in the GlueVersion field in the Glue job properties

View answer

Correct Answer: A

Question #5

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #6

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #7

A company maintains an Amazon Redshift provisioned cluster that the company uses for extract, transform, and load (ETL) operations to support critical analysis tasks. A sales team within the company maintains a Redshift cluster that the sales team uses for business intelligence (BI) tasks.The sales team recently requested access to the data that is in the ETL Redshift cluster so the team can perform weekly summary analysis tasks. The sales team needs to join data from the ETL cluster with data that is in the sales team's BI cluster.The company needs a solution that will share the ETL cluster data with the sales team without interrupting the critical analysis tasks. The solution must minimize usage of the computing resources of the ETL cluster.Which solution will meet these requirements?

A. Set up the sales team BI cluster as a consumer of the ETL cluster by using Redshift data sharing

B. Create materialized views based on the sales team's requirements

C. Create database views based on the sales team's requirements

D. Unload a copy of the data from the ETL cluster to an Amazon S3 bucket every week

View answer

Correct Answer: A

Question #8

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #9

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

View answer

Correct Answer: C

Question #10

A data engineer needs to schedule a workflow that runs a set of AWS Glue jobs every day. The data engineer does not require the Glue jobs to run or finish at a specific time.Which solution will run the Glue jobs in the MOST cost-effective way?

A. Choose the FLEX execution class in the Glue job properties

B. Use the Spot Instance type in Glue job properties

C. Choose the STANDARD execution class in the Glue job properties

D. Choose the latest version in the GlueVersion field in the Glue job properties

View answer

Correct Answer: A

Question #11

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #12

A company maintains multiple extract, transform, and load (ETL) workflows that ingest data from the company's operational databases into an Amazon S3 based data lake. The ETL workflows use AWS Glue and Amazon EMR to process data.The company wants to improve the existing architecture to provide automated orchestration and to require minimal manual effort.Which solution will meet these requirements with the LEAST operational overhead?

A. AWS Glue workflows

B. AWS Step Functions tasks

C. AWS Lambda functions

D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA) workflows

View answer

Correct Answer: B

Question #13

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

View answer

Correct Answer: C

Question #14

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #15

A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.Which solution will meet these requirements with the LEAST operational overhead?

A. Establish WebSocket connections to Amazon Redshift

B. Use the Amazon Redshift Data API

C. Set up Java Database Connectivity (JDBC) connections to Amazon Redshift

D. Store frequently accessed data in Amazon S3

View answer

Correct Answer: B

Question #16

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #17

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #18

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

View answer

Correct Answer: C

Question #19

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #20

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #21

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company's existing analytics platform.The company wants to minimize the effort and time required to incorporate third-party datasets.Which solution will meet these requirements with the LEAST operational overhead?

A. Use API calls to access and integrate third-party datasets from AWS Data Exchange

B. Use API calls to access and integrate third-party datasets from AWS DataSync

C. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories

D. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR)

View answer

Correct Answer: A

Question #22

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #23

A financial company recently added more features to its mobile app. The new features required the company to create a new topic in an existing Amazon Managed Streaming for Apache Kafka (Amazon MSK) cluster.A few days after the company added the new topic, Amazon CloudWatch raised an alarm on the RootDiskUsed metric for the MSK cluster.How should the company address the CloudWatch alarm?

A. Expand the storage of the MSK broker

B. Expand the storage of the Apache ZooKeeper nodes

C. Update the MSK broker instance to a larger instance type

D. Specify the Target-Volume-in-GiB parameter for the existing topic

View answer

Correct Answer: A

Question #24

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #25

A retail company has a customer data hub in an Amazon S3 bucket. Employees from many countries use the data hub to support company-wide analytics. A governance team must ensure that the company's data analysts can access data only for customers who are within the same country as the analysts.Which solution will meet these requirements with the LEAST operational effort?

A. reate a separate table for each country's customer data

B. egister the S3 bucket as a data lake location in AWS Lake Formation

C. ove the data to AWS Regions that are close to the countries where the customers are

D. oad the data into Amazon Redshift

View answer

Correct Answer: B

Question #26

A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options.The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS.Which extract, transform, and load (ETL) service will meet these requirements?

A. AWS Glue

B. Amazon EMR

C. AWS Lambda

D. Amazon Redshift

View answer

Correct Answer: B

Question #27

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #28

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

View answer

Correct Answer: C

Question #29

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #30

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #31

Tasks may optionally use table streams to provide a convenient way to continuously process new or changed dat a. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table and either consume the change data or skip the current run if no change data exists. Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?

A. SYSTEM$STREAM_HAS_CHANGE_DATA

B. SYSTEM$STREAM_CDC_DATA

C. SYSTEM$STREAM_HAS_DATA

D. SYSTEM$STREAM_DELTA_DATA

View answer

Correct Answer: C

Question #32

What is a common risk when large analytical datasets are stored without lifecycle management?

A. Storage cost and data clutter may grow unnecessarily

B. All queries automatically become faster

C. Data access control becomes unnecessary

D. Processing jobs no longer need input data

View answer

Correct Answer: a

Question #33

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #34

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #35

A data engineer needs to create an AWS Lambda function that converts the format of data from .csv to Apache Parquet. The Lambda function must run only if a user uploads a .csv file to an Amazon S3 bucket.Which solution will meet these requirements with the LEAST operational overhead?

A. reate an S3 event notification that has an event type of s3:ObjectCreated:*

B. reate an S3 event notification that has an event type of s3:ObjectTagging:* for objects that have a tag set to

C. reate an S3 event notification that has an event type of s3:*

D. reate an S3 event notification that has an event type of s3:ObjectCreated:*

View answer

Correct Answer: A

Question #36

A company regularly loads data into an Amazon DynamoDB table. The company must retain the data in DynamoDB for 1 year. After 1 year, the company must archive the data for 5 years. After5 years, the company must delete the data. Which solution will meet these requirements in the MOST operationally efficient way?

A. nclude a timestamp with the data that is loaded into DynamoDB

B. nable Amazon DynamoDB Streams

C. nable Amazon DynamoDB Streams

D. nclude a timestamp with the data that is loaded into DynamoDB

View answer

Correct Answer: C

Question #37

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #38

A data engineer must use AWS services to ingest a dataset into an Amazon S3 data lake. The data engineer profiles the dataset and discovers that the dataset contains personally identifiable information (PII). The data engineer must implement a solution to profile the dataset and obfuscate the PII.Which solution will meet this requirement with the LEAST operational effort?

A. Use an Amazon Kinesis Data Firehose delivery stream to process the dataset

B. Use the Detect PII transform in AWS Glue Studio to identify the PII

C. Use the Detect PII transform in AWS Glue Studio to identify the PII

D. Ingest the dataset into Amazon DynamoDB

View answer

Correct Answer: B

Question #39

A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real- time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.Which solution will meet these requirements with the LEAST operational overhead?

A. tore frequently accessed data in Amazon S3

B. stablish WebSocket connections to Amazon Redshift

C. se the Amazon Redshift Data API

D. et up Java Database Connectivity (JDBC) connections to Amazon Redshift

View answer

Correct Answer: C

Question #40

Which characteristic of big data refers to the increasing speed at which data is generated, collected, and analyzed?

A. Velocity

B. Variety

C. Veracity

D. Volume

View answer

Correct Answer: a

Question #41

Which methods can be used to create a DataFrame object in Snowpark? (Select THREE)

A. ession

B. ession

C. ession,table()

D. ataFraas

E. ession

F. ession

View answer

Correct Answer: BCF

Question #42

A company loads transaction data for each day into Amazon Redshift tables at the end of each day. The company wants to have the ability to track which tables have been loaded and which tables still need to be loaded.A data engineer wants to store the load statuses of Redshift tables in an Amazon DynamoDB table. The data engineer creates an AWS Lambda function to publish the details of the load statuses to DynamoDB.How should the data engineer invoke the Lambda function to write load statuses to the DynamoDB table?

A. Use a second Lambda function to invoke the first Lambda function based on Amazon CloudWatch events

B. Use the Amazon Redshift Data API to publish an event to Amazon EventBridge

C. Use the Amazon Redshift Data API to publish a message to an Amazon Simple Queue Service (Amazon SQS) queue

D. Use a second Lambda function to invoke the first Lambda function based on AWS CloudTrail events

View answer

Correct Answer: B

Question #43

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

View answer

Correct Answer: C

Question #44

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #45

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #46

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #47

A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.Which solution will meet these requirements?

A. Create an S3 bucket for each use case

B. Create an Athena workgroup for each use case

C. Create an IAM role for each use case

D. Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case

View answer

Correct Answer: B

Question #48

A company is using an AWS Transfer Family server to migrate data from an on-premises environment to AWS. Company policy mandates the use of TLS 1.2 or above to encrypt the data in transit.Which solution will meet these requirements?

A. Generate new SSH keys for the Transfer Family server

B. Update the security group rules for the on-premises network to allow only connections that use TLS 1

C. Update the security policy of the Transfer Family server to specify a minimum protocol version of TLS 1

D. Install an SSL certificate on the Transfer Family server to encrypt data transfers by using TLS 1

View answer

Correct Answer: C

Question #49

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #50

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

View answer

Correct Answer: C

Question #51

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

View answer

Correct Answer: C

Question #52

A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer must crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and load the output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.Which AWS service or feature will meet these requirements MOST cost-effectively?

A. AWS Step Functions

B. AWS Glue workflows

C. AWS Glue Studio

D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

View answer

Correct Answer: B

Question #53

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #54

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

View answer

Correct Answer: C

Question #55

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #56

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #57

A company uses Amazon Athena to run SQL queries for extract, transform, and load (ETL) tasks by using Create Table As Select (CTAS). The company must use Apache Spark instead of SQL to generate analytics.Which solution will give the company the ability to use Spark to access Athena?

A. thena query settings

B. thena workgroup

C. thena data source

D. thena query editor

View answer

Correct Answer: B

Question #58

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

View answer

Correct Answer: C

Question #59

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company's existing analytics platform.The company wants to minimize the effort and time required to incorporate third-party datasets.Which solution will meet these requirements with the LEAST operational overhead?

A. se API calls to access and integrate third-party datasets from AWS Data Exchange

B. se API calls to access and integrate third-party datasets from AWS DataSync

C. se Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories

D. se Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR)

View answer

Correct Answer: A

Question #60

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #61

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #62

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #63

A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?

A. Write a custom extract, transform, and load (ETL) job in Python

B. Write an AWS Glue extract, transform, and load (ETL) job

C. Write a custom extract, transform, and load (ETL) job in Python

D. Write an AWS Glue extract, transform, and load (ETL) job

View answer

Correct Answer: B

Question #64

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #65

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #66

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #67

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #68

A data engineer is building a data pipeline on AWS by using AWS Glue extract, transform, and load (ETL) jobs. The data engineer needs to process data from Amazon RDS and MongoDB, perform transformations, and load the transformed data into Amazon Redshift for analytics. The data updates must occur every hour.Which combination of tasks will meet these requirements with the LEAST operational overhead? (Choose two.)

A. Configure AWS Glue triggers to run the ETL jobs every hour

B. Use AWS Glue DataBrew to clean and prepare the data for analytics

C. Use AWS Lambda functions to schedule and run the ETL jobs every hour

D. Use AWS Glue connections to establish connectivity between the data sources and Amazon Redshift

E. Use the Redshift Data API to load transformed data into Amazon Redshift

View answer

Correct Answer: AD

Question #69

A batch workflow recalculates the same business metric using different logic in multiple jobs. What is the main risk?

A. Processing will automatically become real time

B. Reports may show inconsistent metric definitions

C. Data storage requirements will become zero

D. All source systems will be synchronized instantly

View answer

Correct Answer: b

Question #70

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)

A. Partition the data that is in the S3 bucket

B. Increase the AWS Glue instance size by scaling up the worker type

C. Convert the AWS Glue schema to the DynamicFrame schema class

D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day

E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features

View answer

Correct Answer: AB

Question #71

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #72

A data engineer maintains custom Python scripts that perform a data formatting process that many AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data engineer must manually update all the Lambda functions.The data engineer requires a less manual way to update the Lambda functions.Which solution will meet this requirement?

A. Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket

B. Package the custom Python scripts into Lambda layers

C. Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket

D. Assign the same alias to each Lambda function

View answer

Correct Answer: B

Question #73

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. reate a destination data stream in the production AWS account

B. reate a destination data stream in the security AWS account

C. reate a destination data stream in the production AWS account

D. reate a destination data stream in the security AWS account

View answer

Correct Answer: D

Question #74

A company uses AWS Glue Data Catalog to index data that is uploaded to an Amazon S3 bucket every day. The company uses a daily batch processes in an extract, transform, and load (ETL) pipeline to upload data from external sources into the S3 bucket.The company runs a daily report on the S3 data. Some days, the company runs the report before all the daily data has been uploaded to the S3 bucket. A data engineer must be able to send a message that identifies any incomplete data to an existing Amazon Simple Notification Service (Amazon SNS) topic.Which solution will meet this requirement with the LEAST operational overhead?

A. Create data quality checks for the source datasets that the daily reports use

B. Create data quality checks on the source datasets that the daily reports use

C. Create data quality checks on the source datasets that the daily reports use

D. Create AWS Lambda functions that run data quality queries on the columns data type and the presence of null values

View answer

Correct Answer: C

Question #75

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #76

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

A. Turn on the public access setting for the DB instance

B. Update the security group of the DB instance to allow only Lambda function invocations on the database port

C. Configure the Lambda function to run in the same subnet that the DB instance uses

D. Attach the same security group to the Lambda function and the DB instance

E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port

View answer

Correct Answer: CD

Question #77

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #78

A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options.The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS.Which extract, transform, and load (ETL) service will meet these requirements?

A. AWS Glue

B. Amazon EMR

C. AWS Lambda

D. Amazon Redshift

View answer

Correct Answer: B

Question #79

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

View answer

Correct Answer: C

Question #80

A company is developing an application that runs on Amazon EC2 instances. Currently, the data that the application generates is temporary. However, the company needs to persist the data, even if the EC2 instances are terminated.A data engineer must launch new EC2 instances from an Amazon Machine Image (AMI) and configure the instances to preserve the data.Which solution will meet this requirement?

A. aunch new EC2 instances by using an AMI that is backed by an EC2 instance store volume that contains the application data

B. aunch new EC2 instances by using an AMI that is backed by a root Amazon Elastic Block Store (Amazon EBS) volume that contains the application data

C. aunch new EC2 instances by using an AMI that is backed by an EC2 instance store volume

D. aunch new EC2 instances by using an AMI that is backed by an Amazon Elastic Block Store (Amazon EBS) volume

View answer

Correct Answer: C

Question #81

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)

A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB

B. Use a columnar storage file format

C. Partition the data based on the most common query predicates

D. Split the data into files that are less than 10 KB

E. Use file formats that are not splittable

View answer

Correct Answer: BC

Question #82

A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?

A. Use an Amazon EMR provisioned cluster to read from all sources

B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3

C. Use Amazon Athena Federated Query to join the data from all data sources

D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift

View answer

Correct Answer: C

Question #83

A company uses an on-premises Microsoft SQL Server database to store financial transaction data. The company migrates the transaction data from the on-premises database to AWS at the end of each month. The company has noticed that the cost to migrate data from the on-premises database to an Amazon RDS for SQL Server database has increased recently.The company requires a cost-effective solution to migrate the data to AWS. The solution must cause minimal downtown for the applications that access the database.Which AWS service should the company use to meet these requirements?

A. AWS Lambda

B. AWS Database Migration Service (AWS DMS)

C. AWS Direct Connect

D. AWS DataSync

View answer

Correct Answer: B

Question #84

A manufacturing company collects sensor data from its factory floor to monitor and enhance operational efficiency. The company uses Amazon Kinesis Data Streams to publish the data that the sensors collect to a data stream. Then Amazon Kinesis Data Firehose writes the data to an Amazon S3 bucket.The company needs to display a real-time view of operational efficiency on a large screen in the manufacturing facility.Which solution will meet these requirements with the LOWEST latency?

A. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to process the sensor data

B. Configure the S3 bucket to send a notification to an AWS Lambda function when any new object is created

C. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to process the sensor data

D. Use AWS Glue bookmarks to read sensor data from the S3 bucket in real time

View answer

Correct Answer: A

Question #85

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company's existing analytics platform.The company wants to minimize the effort and time required to incorporate third-party datasets.Which solution will meet these requirements with the LEAST operational overhead?

A. Use API calls to access and integrate third-party datasets from AWS Data Exchange

B. Use API calls to access and integrate third-party datasets from AWS DataSync

C. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories

D. Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR)

View answer

Correct Answer: A

Question #86

A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.Which solution will meet these requirements?

A. Create an S3 bucket for each use case

B. Create an Athena workgroup for each use case

C. Create an IAM role for each use case

D. Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case

View answer

Correct Answer: B

Question #87

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

View answer

Correct Answer: C

Question #88

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #89

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)

A. Use Hadoop Distributed File System (HDFS) as a persistent data store

B. Use Amazon S3 as a persistent data store

C. Use x86-based instances for core nodes and task nodes

D. Use Graviton instances for core nodes and task nodes

E. Use Spot Instances for all primary nodes

View answer

Correct Answer: BD

Question #90

A company stores daily records of the financial performance of investment portfolios in .csv format in an Amazon S3 bucket. A data engineer uses AWS Glue crawlers to crawl the S3 data.The data engineer must make the S3 data accessible daily in the AWS Glue Data Catalog.Which solution will meet these requirements?

A. Create an IAM role that includes the AmazonS3FullAccess policy

B. Create an IAM role that includes the AWSGlueServiceRole policy

C. Create an IAM role that includes the AmazonS3FullAccess policy

D. Create an IAM role that includes the AWSGlueServiceRole policy

View answer

Correct Answer: B

Question #91

A retail company has a customer data hub in an Amazon S3 bucket. Employees from many countries use the data hub to support company-wide analytics. A governance team must ensure that the company's data analysts can access data only for customers who are within the same country as the analysts.Which solution will meet these requirements with the LEAST operational effort?

A. Create a separate table for each country's customer data

B. Register the S3 bucket as a data lake location in AWS Lake Formation

C. Move the data to AWS Regions that are close to the countries where the customers are

D. Load the data into Amazon Redshift

View answer

Correct Answer: B

Question #92

A data engineer is building a data pipeline on AWS by using AWS Glue extract, transform, and load (ETL) jobs. The data engineer needs to process data from Amazon RDS and MongoDB, perform transformations, and load the transformed data into Amazon Redshift for analytics. The data updates must occur every hour.Which combination of tasks will meet these requirements with the LEAST operational overhead? (Choose two.)

A. Configure AWS Glue triggers to run the ETL jobs every hour

B. Use AWS Glue DataBrew to clean and prepare the data for analytics

C. Use AWS Lambda functions to schedule and run the ETL jobs every hour

D. Use AWS Glue connections to establish connectivity between the data sources and Amazon Redshift

E. Use the Redshift Data API to load transformed data into Amazon Redshift

View answer

Correct Answer: AD

Question #93

A Data Engineer is investigating a query that is taking a long time to return The Query Profile showsthe following:What step should the Engineer take to increase the query performance?

A. dd additional virtual warehouses

B. ncrease the size of the virtual warehouse

C. ewrite the query using Common Table Expressions (CTEs)

D. hange the order of the joins and start with smaller tables first

View answer

Correct Answer: B

Question #94

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

View answer

Correct Answer: C

Question #95

A data engineer is building a data pipeline on AWS by using AWS Glue extract, transform, and load (ETL) jobs. The data engineer needs to process data from Amazon RDS and MongoDB, perform transformations, and load the transformed data into Amazon Redshift for analytics. The data updates must occur every hour.Which combination of tasks will meet these requirements with the LEAST operational overhead? (Choose two.)

A. Configure AWS Glue triggers to run the ETL jobs every hour

B. Use AWS Glue DataBrew to clean and prepare the data for analytics

C. Use AWS Lambda functions to schedule and run the ETL jobs every hour

D. Use AWS Glue connections to establish connectivity between the data sources and Amazon Redshift

E. Use the Redshift Data API to load transformed data into Amazon Redshift

View answer

Correct Answer: AD

Question #96

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

A. Standard tables, including shared tables

B. Views, including secure views

C. Directory tables

D. Query Log Tables

E. External tables

View answer

Correct Answer: D

Question #97

A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?

A. Use Kinesis Data Streams to stage data in Amazon S3

B. Access the data from Kinesis Data Streams by using SQL queries

C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object

D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose

View answer

Correct Answer: C

Question #98

A Data Engineer is writing a Python script using the Snowflake Connector for Python. The Engineerwill use the snowflake. Connector.connect function to connect to Snowflake The requirements are:* Raise an exception if the specified database schema or warehouse does not exist* improve download performanceWhich parameters of the connect function should be used? (Select TWO).

A. uthenticator

B. rrow_nunber_to_decimal

C. lient_prefetch_threads

D. lient_session_keep_alivs

E. alidate_default_parameters

View answer

Correct Answer: CE

Question #99

A data engineer must ingest a source of structured data that is in .csv format into an Amazon S3 data lake. The .csv files contain 15 columns. Data analysts need to run Amazon Athena queries on one or two columns of the dataset. The data analysts rarely query the entire file.Which solution will meet these requirements MOST cost-effectively?

A. se an AWS Glue PySpark job to ingest the source data into the data lake in

B. reate an AWS Glue extract, transform, and load (ETL) job to read from the

C. se an AWS Glue PySpark job to ingest the source data into the data lake in Apache Avro format

D. reate an AWS Glue extract, transform, and load (ETL) job to read from the

View answer

Correct Answer: D

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now

Free AWS DEA-C01 Practice Questions & Answers 2026 Part4

View The Updated AWS Exam Questions

View Answers after Submission

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE Get Now

Free AWS DEA-C01 Practice Questions & Answers 2026 Part4

View The Updated AWS Exam Questions

View Answers after Submission

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now