πŸ”

DEA-C01 β€” questions

Page 2 of 16 Β· 313 total questions.

Topic 1 Β· Question 21

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?

  • AUse an Amazon Kinesis Data Firehose delivery stream to process the dataset. Create an AWS Lambda transform function to identify the PII. Use an AWS SDK to obfuscate the PII. Set the S3 data lake as the target for the delivery stream.
  • BUse the Detect PII transform in AWS Glue Studio to identify the PII. Obfuscate the PII. Use an AWS Step Functions state machine to orchestrate a data pipeline to ingest the data into the S3 data lake. (correct answer)
  • CUse the Detect PII transform in AWS Glue Studio to identify the PII. Create a rule in AWS Glue Data Quality to obfuscate the PII. Use an AWS Step Functions state machine to orchestrate a data pipeline to ingest the data into the S3 data lake.
  • DIngest the dataset into Amazon DynamoDB. Create an AWS Lambda function to identify and obfuscate the PII in the DynamoDB table and to transform the data. Use the same Lambda function to ingest the data into the S3 data lake.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use the Detect PII transform in AWS Glue Studio to identify the PII. Obfuscate the PII. Use an AWS Step Functions state machine to orchestrate a data pipeline to ingest the data into the S3 data lake.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. AWS Step Functions coordinates multi-step workflows as a managed state machine. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

Topic 1 Β· Question 22

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?

  • AAWS Glue workflows
  • BAWS Step Functions tasks (correct answer)
  • CAWS Lambda functions
  • DAmazon Managed Workflows for Apache Airflow (Amazon MWAA) workflows
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: AWS Step Functions tasks

Explanation

AWS Step Functions coordinates multi-step workflows as a managed state machine.

Topic 1 Β· Question 23

A company currently stores all of its data in Amazon S3 by using the S3 Standard storage class. A data engineer examined data access patterns to identify trends. During the first 6 months, most data files are accessed several times each day. Between 6 months and 2 years, most data files are accessed once or twice each month. After 2 years, data files are accessed only once or twice each year. The data engineer needs to use an S3 Lifecycle policy to develop new data storage rules. The new storage solution must continue to provide high availability. Which solution will meet these requirements in the MOST cost-effective way?

  • ATransition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months. Transfer objects to S3 Glacier Flexible Retrieval after 2 years.
  • BTransition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months. Transfer objects to S3 Glacier Flexible Retrieval after 2 years.
  • CTransition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months. Transfer objects to S3 Glacier Deep Archive after 2 years. (correct answer)
  • DTransition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months. Transfer objects to S3 Glacier Deep Archive after 2 years.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months. Transfer objects to S3 Glacier Deep Archive after 2 years.

Explanation

S3 Glacier Deep Archive is the lowest-cost storage for long-term archival with retrieval in hours. Amazon S3 Glacier offers low-cost archival storage for infrequently accessed data. S3 Standard-IA reduces cost for infrequently accessed data that still needs high availability. This option delivers the requirement at the lowest cost.

Topic 1 Β· Question 24

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?

  • ASet up the sales team BI cluster as a consumer of the ETL cluster by using Redshift data sharing. (correct answer)
  • BCreate materialized views based on the sales team's requirements. Grant the sales team direct access to the ETL cluster.
  • CCreate database views based on the sales team's requirements. Grant the sales team direct access to the ETL cluster.
  • DUnload a copy of the data from the ETL cluster to an Amazon S3 bucket every week. Create an Amazon Redshift Spectrum table based on the content of the ETL cluster.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Set up the sales team BI cluster as a consumer of the ETL cluster by using Redshift data sharing.

Explanation

Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries.

Topic 1 Β· Question 25

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?

  • AUse an Amazon EMR provisioned cluster to read from all sources. Use Apache Spark to join the data and perform the analysis.
  • BCopy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3. Run Amazon Athena queries directly on the S3 files.
  • CUse Amazon Athena Federated Query to join the data from all data sources. (correct answer)
  • DUse Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Amazon Athena Federated Query to join the data from all data sources.

Explanation

Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. This option delivers the requirement at the lowest cost.

Topic 1 Β· Question 26 Β· Select all that apply

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.)

  • AUse Hadoop Distributed File System (HDFS) as a persistent data store.
  • BUse Amazon S3 as a persistent data store. (correct answer)
  • CUse x86-based instances for core nodes and task nodes.
  • DUse Graviton instances for core nodes and task nodes. (correct answer)
  • EUse Spot Instances for all primary nodes.
Reveal answer & explanation
Correct answer: B, D

The correct answer is B, D. Option B: Use Amazon S3 as a persistent data store. Option D: Use Graviton instances for core nodes and task nodes.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. This option delivers the requirement at the lowest cost.

Topic 1 Β· 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?

  • AUse Kinesis Data Streams to stage data in Amazon S3. Use the COPY command to load data from Amazon S3 directly into Amazon Redshift to make the data immediately available for real-time analysis.
  • BAccess the data from Kinesis Data Streams by using SQL queries. Create materialized views directly on top of the stream. Refresh the materialized views regularly to query the most recent stream data.
  • CCreate an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object. Create a materialized view to read data from the stream. Set the materialized view to auto refresh. (correct answer)
  • DConnect Kinesis Data Streams to Amazon Kinesis Data Firehose. Use Kinesis Data Firehose to stage the data in Amazon S3. Use the COPY command to load the data from Amazon S3 to a table in Amazon Redshift.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object. Create a materialized view to read data from the stream. Set the materialized view to auto refresh.

Explanation

Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. Kinesis Data Streams ingests and processes high-volume real-time streaming data. Amazon Kinesis ingests and processes real-time streaming data at scale.

Topic 1 Β· Question 28 Β· Select all that apply

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.)

  • APartition the data that is in the S3 bucket. Organize the data by year, month, and day. (correct answer)
  • BIncrease the AWS Glue instance size by scaling up the worker type. (correct answer)
  • CConvert the AWS Glue schema to the DynamicFrame schema class.
  • DAdjust AWS Glue job scheduling frequency so the jobs run half as many times each day.
  • EModify the IAM role that grants access to AWS glue to grant access to all S3 features.
Reveal answer & explanation
Correct answer: A, B

The correct answer is A, B. Option A: Partition the data that is in the S3 bucket. Organize the data by year, month, and day. Option B: Increase the AWS Glue instance size by scaling up the worker type.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

Topic 1 Β· Question 29

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?

  • AParallel state
  • BChoice state
  • CMap state (correct answer)
  • DWait state
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Map state.

Topic 1 Β· Question 30

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?

  • AWrite a custom extract, transform, and load (ETL) job in Python. Use the DataFrame.drop_duplicates() function by importing the Pandas library to perform data deduplication.
  • BWrite an AWS Glue extract, transform, and load (ETL) job. Use the FindMatches machine learning (ML) transform to transform the data to perform data deduplication. (correct answer)
  • CWrite a custom extract, transform, and load (ETL) job in Python. Import the Python dedupe library. Use the dedupe library to perform data deduplication.
  • DWrite an AWS Glue extract, transform, and load (ETL) job. Import the Python dedupe library. Use the dedupe library to perform data deduplication.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Write an AWS Glue extract, transform, and load (ETL) job. Use the FindMatches machine learning (ML) transform to transform the data to perform data deduplication.

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

Topic 1 Β· Question 31 Β· Select all that apply

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.)

  • AUse gzip compression to compress individual files to sizes that are between 1 GB and 5 GB.
  • BUse a columnar storage file format. (correct answer)
  • CPartition the data based on the most common query predicates. (correct answer)
  • DSplit the data into files that are less than 10 KB.
  • EUse file formats that are not splittable.
Reveal answer & explanation
Correct answer: B, C

The correct answer is B, C. Option B: Use a columnar storage file format. Option C: Partition the data based on the most common query predicates.

Topic 1 Β· Question 32 Β· Select all that apply

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.)

  • ATurn on the public access setting for the DB instance.
  • BUpdate the security group of the DB instance to allow only Lambda function invocations on the database port.
  • CConfigure the Lambda function to run in the same subnet that the DB instance uses. (correct answer)
  • DAttach the same security group to the Lambda function and the DB instance. Include a self-referencing rule that allows access through the database port. (correct answer)
  • EUpdate the network ACL of the private subnet to include a self-referencing rule that allows access through the database port.
Reveal answer & explanation
Correct answer: C, D

The correct answer is C, D. Option C: Configure the Lambda function to run in the same subnet that the DB instance uses. Option D: Attach the same security group to the Lambda function and the DB instance. Include a self-referencing rule that allows access through the database port.

Explanation

AWS Lambda runs code without provisioning servers and scales automatically, which minimizes operational overhead. AWS Config tracks resource configuration changes and evaluates compliance.

Topic 1 Β· Question 33

A company has a frontend ReactJS website that uses Amazon API Gateway to invoke REST APIs. The APIs perform the functionality of the website. A data engineer needs to write a Python script that can be occasionally invoked through API Gateway. The code must return results to API Gateway. Which solution will meet these requirements with the LEAST operational overhead?

  • ADeploy a custom Python script on an Amazon Elastic Container Service (Amazon ECS) cluster.
  • BCreate an AWS Lambda Python function with provisioned concurrency. (correct answer)
  • CDeploy a custom Python script that can integrate with API Gateway on Amazon Elastic Kubernetes Service (Amazon EKS).
  • DCreate an AWS Lambda function. Ensure that the function is warm by scheduling an Amazon EventBridge rule to invoke the Lambda function every 5 minutes by using mock events.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create an AWS Lambda Python function with provisioned concurrency.

Explanation

AWS Lambda runs code without provisioning servers and scales automatically, which minimizes operational overhead.

Topic 1 Β· Question 34

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?

  • ACreate 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.
  • BCreate 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.
  • CCreate 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.
  • DCreate 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. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option 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 A...

Explanation

An IAM role grants temporary, least-privilege permissions to AWS resources without long-term credentials. AWS IAM controls authenticated and authorized access to AWS resources with fine-grained policies. Amazon CloudWatch collects metrics, logs and alarms to monitor and react to operational health.

Topic 1 Β· Question 35

A company uses Amazon S3 to store semi-structured data in a transactional data lake. Some of the data files are small, but other data files are tens of terabytes. A data engineer must perform a change data capture (CDC) operation to identify changed data from the data source. The data source sends a full snapshot as a JSON file every day and ingests the changed data into the data lake. Which solution will capture the changed data MOST cost-effectively?

  • ACreate an AWS Lambda function to identify the changes between the previous data and the current data. Configure the Lambda function to ingest the changes into the data lake.
  • BIngest the data into Amazon RDS for MySQL. Use AWS Database Migration Service (AWS DMS) to write the changed data to the data lake.
  • CUse an open source data lake format to merge the data source with the S3 data lake to insert the new data and update the existing data. (correct answer)
  • DIngest the data into an Amazon Aurora MySQL DB instance that runs Aurora Serverless. Use AWS Database Migration Service (AWS DMS) to write the changed data to the data lake.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use an open source data lake format to merge the data source with the S3 data lake to insert the new data and update the existing data.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. This option delivers the requirement at the lowest cost.

Topic 1 Β· Question 36 Β· Select all that apply

A data engineer runs Amazon Athena queries on data that is in an Amazon S3 bucket. The Athena queries use AWS Glue Data Catalog as a metadata table. The data engineer notices that the Athena query plans are experiencing a performance bottleneck. The data engineer determines that the cause of the performance bottleneck is the large number of partitions that are in the S3 bucket. The data engineer must resolve the performance bottleneck and reduce Athena query planning time. Which solutions will meet these requirements? (Choose two.)

  • ACreate an AWS Glue partition index. Enable partition filtering. (correct answer)
  • BBucket the data based on a column that the data have in common in a WHERE clause of the user query.
  • CUse Athena partition projection based on the S3 bucket prefix. (correct answer)
  • DTransform the data that is in the S3 bucket to Apache Parquet format.
  • EUse the Amazon EMR S3DistCP utility to combine smaller objects in the S3 bucket into larger objects.
Reveal answer & explanation
Correct answer: A, C

The correct answer is A, C. Option A: Create an AWS Glue partition index. Enable partition filtering. Option C: Use Athena partition projection based on the S3 bucket prefix.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

Topic 1 Β· Question 37

A data engineer must manage the ingestion of real-time streaming data into AWS. The data engineer wants to perform real-time analytics on the incoming streaming data by using time-based aggregations over a window of up to 30 minutes. The data engineer needs a solution that is highly fault tolerant. Which solution will meet these requirements with the LEAST operational overhead?

  • AUse an AWS Lambda function that includes both the business and the analytics logic to perform time-based aggregations over a window of up to 30 minutes for the data in Amazon Kinesis Data Streams.
  • BUse Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to analyze the data that might occasionally contain duplicates by using multiple types of aggregations.
  • CUse an AWS Lambda function that includes both the business and the analytics logic to perform aggregations for a tumbling window of up to 30 minutes, based on the event timestamp.
  • DUse Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to analyze the data by using multiple types of aggregations to perform time-based analytics over a window of up to 30 minutes. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to analyze the data by using multiple types of aggregations to perform time-based analytics over a window of up to 30 min...

Explanation

Amazon Kinesis ingests and processes real-time streaming data at scale.

Topic 1 Β· Question 38

A company is planning to upgrade its Amazon Elastic Block Store (Amazon EBS) General Purpose SSD storage from gp2 to gp3. The company wants to prevent any interruptions in its Amazon EC2 instances that will cause data loss during the migration to the upgraded storage. Which solution will meet these requirements with the LEAST operational overhead?

  • ACreate snapshots of the gp2 volumes. Create new gp3 volumes from the snapshots. Attach the new gp3 volumes to the EC2 instances.
  • BCreate new gp3 volumes. Gradually transfer the data to the new gp3 volumes. When the transfer is complete, mount the new gp3 volumes to the EC2 instances to replace the gp2 volumes.
  • CChange the volume type of the existing gp2 volumes to gp3. Enter new values for volume size, IOPS, and throughput. (correct answer)
  • DUse AWS DataSync to create new gp3 volumes. Transfer the data from the original gp2 volumes to the new gp3 volumes.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Change the volume type of the existing gp2 volumes to gp3. Enter new values for volume size, IOPS, and throughput.

Topic 1 Β· Question 39

A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joins across multiple tables. The data must be in Apache Parquet format. The analytics team must store the data in Amazon S3. Which solution will meet these requirements in the MOST operationally efficient way?

  • ACreate a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create an AWS Glue job that selects the data directly from the view and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day. (correct answer)
  • BSchedule SQL Server Agent to run a daily SQL query that selects the desired data elements from the EC2 instance-based SQL Server databases. Configure the query to direct the output .csv objects to an S3 bucket. Create an S3 event that invokes an AWS Lambda function to transform the output format from .csv to Parquet.
  • CUse a SQL query to create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create and run an AWS Glue crawler to read the view. Create an AWS Glue job that retrieves the data and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day.
  • DCreate an AWS Lambda function that queries the EC2 instance-based databases by using Java Database Connectivity (JDBC). Configure the Lambda function to retrieve the required data, transform the data into Parquet format, and transfer the data into an S3 bucket. Use Amazon EventBridge to schedule the Lambda function to run every day.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create an AWS Glue job that selects the data directly from the view and transfers the data in Parquet format to an...

Explanation

Amazon EC2 provides resizable virtual servers when you need full control of the operating system. Amazon S3 provides durable, scalable object storage that is fully managed. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

Topic 1 Β· Question 40

A data engineering team is using an Amazon Redshift data warehouse for operational reporting. The team wants to prevent performance issues that might result from long- running queries. A data engineer must choose a system table in Amazon Redshift to record anomalies when a query optimizer identifies conditions that might indicate performance issues. Which table views should the data engineer use to meet this requirement?

  • ASTL_USAGE_CONTROL
  • BSTL_ALERT_EVENT_LOG (correct answer)
  • CSTL_QUERY_METRICS
  • DSTL_PLAN_INFO
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: STL_ALERT_EVENT_LOG.

Showing questions 21–40 of 313 Β· Page 2 of 16