🔍

DEA-C01 — questions

Page 10 of 16 · 313 total questions.

DEA-C01 Question 181

Single page →
Topic 1 · Question 181

A data engineer is launching an Amazon EMR cluster. The data that the data engineer needs to load into the new cluster is currently in an Amazon S3 bucket. The data engineer needs to ensure that data is encrypted both at rest and in transit. The data that is in the S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. The data engineer has an Amazon S3 path that has a Privacy Enhanced Mail (PEM) file. Which solution will meet these requirements?

  • ACreate an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-rest encryption for the S3 bucket. Create a second security configuration. Specify the Amazon S3 path of the PEM file for in-transit encryption. Create the EMR cluster, and attach both security configurations to the cluster.
  • BCreate an Amazon EMR security configuration. Specify the appropriate AWS KMS key for local disk encryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Use the security configuration during EMR cluster creation.
  • CCreate an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-rest encryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Use the security configuration during EMR cluster creation. (correct answer)
  • DCreate an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-rest encryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Create the EMR cluster, and attach the security configuration to the cluster.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create an Amazon EMR security configuration. Specify the appropriate AWS KMS key for at-rest encryption for the S3 bucket. Specify the Amazon S3 path of the PEM file for in-transit encryption. Use the security configu...

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. Amazon EMR runs big-data frameworks like Spark and Hadoop on managed clusters. AWS KMS manages encryption keys and integrates with most AWS services for encryption at rest.

DEA-C01 Question 182

Single page →
Topic 1 · Question 182 · Select all that apply

A retail company is using an Amazon Redshift cluster to support real-time inventory management. The company has deployed an ML model on a real-time endpoint in Amazon SageMaker. The company wants to make real-time inventory recommendations. The company also wants to make predictions about future inventory needs. Which solutions will meet these requirements? (Choose two.)

  • AUse Amazon Redshift ML to generate inventory recommendations. (correct answer)
  • BUse SQL to invoke a remote SageMaker endpoint for prediction. (correct answer)
  • CUse Amazon Redshift ML to schedule regular data exports for offline model training.
  • DUse SageMaker Autopilot to create inventory management dashboards in Amazon Redshift.
  • EUse Amazon Redshift as a file storage system to archive old inventory management reports.
Reveal answer & explanation
Correct answer: A, B

The correct answer is A, B. Option A: Use Amazon Redshift ML to generate inventory recommendations. Option B: Use SQL to invoke a remote SageMaker endpoint for prediction.

Explanation

Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. Amazon SageMaker builds, trains and deploys machine learning models in a fully managed service. This option meets the real-time / low-latency performance requirement.

DEA-C01 Question 183

Single page →
Topic 1 · Question 183

A company stores CSV files in an Amazon S3 bucket. A data engineer needs to process the data in the CSV files and store the processed data in a new S3 bucket. The process needs to rename a column, remove specific columns, ignore the second row of each file, create a new column based on the values of the first row of the data, and filter the results by a numeric value of a column. Which solution will meet these requirements with the LEAST development effort?

  • AUse AWS Glue Python jobs to read and transform the CSV files.
  • BUse an AWS Glue custom crawler to read and transform the CSV files.
  • CUse an AWS Glue workflow to build a set of jobs to crawl and transform the CSV files.
  • DUse AWS Glue DataBrew recipes to read and transform the CSV files. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use AWS Glue DataBrew recipes to read and transform the CSV files.

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. This option needs the least custom development effort.

DEA-C01 Question 184

Single page →
Topic 1 · Question 184

A company uses Amazon Redshift as its data warehouse. Data encoding is applied to the existing tables of the data warehouse. A data engineer discovers that the compression encoding applied to some of the tables is not the best fit for the data. The data engineer needs to improve the data encoding for the tables that have sub-optimal encoding. Which solution will meet this requirement?

  • ARun the ANALYZE command against the identified tables. Manually update the compression encoding of columns based on the output of the command.
  • BRun the ANALYZE COMPRESSION command against the identified tables. Manually update the compression encoding of columns based on the output of the command. (correct answer)
  • CRun the VACUUM REINDEX command against the identified tables.
  • DRun the VACUUM RECLUSTER command against the identified tables.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Run the ANALYZE COMPRESSION command against the identified tables. Manually update the compression encoding of columns based on the output of the command.

DEA-C01 Question 185

Single page →
Topic 1 · Question 185

The company stores a large volume of customer records in Amazon S3. To comply with regulations, the company must be able to access new customer records immediately for the first 30 days after the records are created. The company accesses records that are older than 30 days infrequently. The company needs to cost-optimize its Amazon S3 storage. Which solution will meet these requirements MOST cost-effectively?

  • AApply a lifecycle policy to transition records to S3 Standard Infrequent-Access (S3 Standard-IA) storage after 30 days. (correct answer)
  • BUse S3 Intelligent-Tiering storage.
  • CTransition records to S3 Glacier Deep Archive storage after 30 days.
  • DUse S3 Standard-Infrequent Access (S3 Standard-IA) storage for all customer records.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Apply a lifecycle policy to transition records to S3 Standard Infrequent-Access (S3 Standard-IA) storage after 30 days.

Explanation

S3 Standard-IA reduces cost for infrequently accessed data that still needs high availability. Amazon S3 provides durable, scalable object storage that is fully managed. Amazon RDS is a managed relational database that handles patching, backups and failover. This option delivers the requirement at the lowest cost.

DEA-C01 Question 186

Single page →
Topic 1 · Question 186

A data engineer is using Amazon QuickSight to build a dashboard to report a company’s revenue in multiple AWS Regions. The data engineer wants the dashboard to display the total revenue for a Region, regardless of the drill-down levels shown in the visual. Which solution will meet these requirements?

  • ACreate a table calculation.
  • BCreate a simple calculated field.
  • CCreate a level-aware calculation - aggregate (LAC-A) function. (correct answer)
  • DCreate a level-aware calculation - window (LAC-W) function.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a level-aware calculation - aggregate (LAC-A) function.

DEA-C01 Question 187

Single page →
Topic 1 · Question 187

A retail company stores customer data in an Amazon S3 bucket. Some of the customer data contains personally identifiable information (PII) about customers. The company must not share PII data with business partners. A data engineer must determine whether a dataset contains PII before making objects in the dataset available to business partners. Which solution will meet this requirement with the LEAST manual intervention?

  • AConfigure the S3 bucket and S3 objects to allow access to Amazon Macie. Use automated sensitive data discovery in Macie. (correct answer)
  • BConfigure AWS CloudTrail to monitor S3 PUT operations. Inspect the CloudTrail trails to identify operations that save PII.
  • CCreate an AWS Lambda function to identify PII in S3 objects. Schedule the function to run periodically.
  • DCreate a table in AWS Glue Data Catalog. Write custom SQL queries to identify PII in the table. Use Amazon Athena to run the queries.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Configure the S3 bucket and S3 objects to allow access to Amazon Macie. Use automated sensitive data discovery in Macie.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Macie discovers and protects sensitive data such as PII in S3. AWS Config tracks resource configuration changes and evaluates compliance.

DEA-C01 Question 188

Single page →
Topic 1 · Question 188

A data engineer needs to create an empty copy of an existing table in Amazon Athena to perform data processing tasks. The existing table in Athena contains 1,000 rows. Which query will meet this requirement?

  • ACREATE TABLE new_table - LIKE old_table;
  • BCREATE TABLE new_table - AS SELECT * FROM old_table - WITH NO DATA; (correct answer)
  • CCREATE TABLE new_table - AS SELECT * FROM old_table;
  • DCREATE TABLE new_table - as SELECT * FROM old_cable - WHERE 1=1;
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: CREATE TABLE new_table - AS SELECT * FROM old_table - WITH NO DATA;.

DEA-C01 Question 189

Single page →
Topic 1 · Question 189 · Select all that apply

A company has a data lake in Amazon S3. The company collects AWS CloudTrail logs for multiple applications. The company stores the logs in the data lake, catalogs the logs in AWS Glue, and partitions the logs based on the year. The company uses Amazon Athena to analyze the logs. Recently, customers reported that a query on one of the Athena tables did not return any data. A data engineer must resolve the issue. Which combination of troubleshooting steps should the data engineer take? (Choose two.)

  • AConfirm that Athena is pointing to the correct Amazon S3 location. (correct answer)
  • BIncrease the query timeout duration.
  • CUse the MSCK REPAIR TABLE command. (correct answer)
  • DRestart Athena.
  • EDelete and recreate the problematic Athena table.
Reveal answer & explanation
Correct answer: A, C

The correct answer is A, C. Option A: Confirm that Athena is pointing to the correct Amazon S3 location. Option C: Use the MSCK REPAIR TABLE command.

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.

DEA-C01 Question 190

Single page →
Topic 1 · Question 190

A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. The ETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, and load data into Amazon Redshift. The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python to orchestrate the jobs. Which service will meet these requirements?

  • AAmazon Managed Workflows for Apache Airflow (Amazon MWAA) (correct answer)
  • BAWS Step Functions
  • CAWS Glue
  • DAmazon EventBridge
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Amazon Managed Workflows for Apache Airflow (Amazon MWAA).

DEA-C01 Question 191

Single page →
Topic 1 · Question 191

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?

  • AStore the custom Python scripts in a shared Amazon S3 bucket. Store a pointer to the custom scripts in the execution context object.
  • BPackage the custom Python scripts into Lambda layers. Apply the Lambda layers to the Lambda functions. (correct answer)
  • CStore the custom Python scripts in a shared Amazon S3 bucket. Store a pointer to the customer scripts in environment variables.
  • DAssign the same alias to each Lambda function. Call each Lambda function by specifying the function's alias.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Package the custom Python scripts into Lambda layers. Apply the Lambda layers to the Lambda functions.

Explanation

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

DEA-C01 Question 192

Single page →
Topic 1 · Question 192

A company stores customer data in an Amazon S3 bucket. Multiple teams in the company want to use the customer data for downstream analysis. The company needs to ensure that the teams do not have access to personally identifiable information (PII) about the customers. Which solution will meet this requirement with LEAST operational overhead?

  • AUse Amazon Macie to create and run a sensitive data discovery job to detect and remove PII.
  • BUse S3 Object Lambda to access the data, and use Amazon Comprehend to detect and remove PII. (correct answer)
  • CUse Amazon Data Firehose and Amazon Comprehend to detect and remove PII.
  • DUse an AWS Glue DataBrew job to store the PII data in a second S3 bucket. Perform analysis on the data that remains in the original S3 bucket.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use S3 Object Lambda to access the data, and use Amazon Comprehend to detect and remove PII.

Explanation

AWS Lambda runs code without provisioning servers and scales automatically, which minimizes operational overhead. Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Comprehend extracts insights and entities from text using NLP.

DEA-C01 Question 193

Single page →
Topic 1 · Question 193

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

  • AUse AWS Config rules to detect violations of the data access policy. Set up compliance alarms.
  • BUse Amazon CloudWatch metrics to gather object-level metrics. Set up CloudWatch alarms.
  • CUse AWS CloudTrail to track object-level events for the S3 bucket. Forward events to Amazon CloudWatch to set up CloudWatch alarms. (correct answer)
  • DUse Amazon S3 server access logs to monitor access to the bucket. Forward the access logs to an Amazon CloudWatch log group. Use metric filters on the log group to set up CloudWatch alarms.
Reveal answer & explanation
Correct answer: C

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

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. Amazon CloudWatch collects metrics, logs and alarms to monitor and react to operational health. AWS CloudTrail records API activity for auditing and governance.

DEA-C01 Question 194

Single page →
Topic 1 · Question 194

A company needs to load customer data that comes from a third party into an Amazon Redshift data warehouse. The company stores order data and product data in the same data warehouse. The company wants to use the combined dataset to identify potential new customers. A data engineer notices that one of the fields in the source data includes values that are in JSON format. How should the data engineer load the JSON data into the data warehouse with the LEAST effort?

  • AUse the SUPER data type to store the data in the Amazon Redshift table. (correct answer)
  • BUse AWS Glue to flatten the JSON data and ingest it into the Amazon Redshift table.
  • CUse Amazon S3 to store the JSON data. Use Amazon Athena to query the data.
  • DUse an AWS Lambda function to flatten the JSON data. Store the data in Amazon S3.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use the SUPER data type to store the data in the Amazon Redshift table.

Explanation

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

DEA-C01 Question 195

Single page →
Topic 1 · Question 195

A company wants to analyze sales records that the company stores in a MySQL database. The company wants to correlate the records with sales opportunities identified by Salesforce. The company receives 2 GB of sales records every day. The company has 100 GB of identified sales opportunities. A data engineer needs to develop a process that will analyze and correlate sales records and sales opportunities. The process must run once each night. Which solution will meet these requirements with the LEAST operational overhead?

  • AUse Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to fetch both datasets. Use AWS Lambda functions to correlate the datasets. Use AWS Step Functions to orchestrate the process.
  • BUse Amazon AppFlow to fetch sales opportunities from Salesforce. Use AWS Glue to fetch sales records from the MySQL database. Correlate the sales records with the sales opportunities. Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate the process.
  • CUse Amazon AppFlow to fetch sales opportunities from Salesforce. Use AWS Glue to fetch sales records from the MySQL database. Correlate the sales records with sales opportunities. Use AWS Step Functions to orchestrate the process. (correct answer)
  • DUse Amazon AppFlow to fetch sales opportunities from Salesforce. Use Amazon Kinesis Data Streams to fetch sales records from the MySQL database. Use Amazon Managed Service for Apache Flink to correlate the datasets. Use AWS Step Functions to orchestrate the process.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Amazon AppFlow to fetch sales opportunities from Salesforce. Use AWS Glue to fetch sales records from the MySQL database. Correlate the sales records with sales opportunities. Use AWS Step Functions to orchestrate...

Explanation

Amazon RDS is a managed relational database that handles patching, backups and failover. AWS Step Functions coordinates multi-step workflows as a managed state machine. Amazon AppFlow securely transfers data between SaaS apps and AWS without code.

DEA-C01 Question 196

Single page →
Topic 1 · Question 196

A company stores server logs in an Amazon S3 bucket. The company needs to keep the logs for 1 year. The logs are not required after 1 year. A data engineer needs a solution to automatically delete logs that are older than 1 year. Which solution will meet these requirements with the LEAST operational overhead?

  • ADefine an S3 Lifecycle configuration to delete the logs after 1 year. (correct answer)
  • BCreate an AWS Lambda function to delete the logs after 1 year.
  • CSchedule a cron job on an Amazon EC2 instance to delete the logs after 1 year.
  • DConfigure an AWS Step Functions state machine to delete the logs after 1 year.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Define an S3 Lifecycle configuration to delete the logs after 1 year.

Explanation

S3 Lifecycle policies automatically transition or expire objects to control storage cost. Amazon S3 provides durable, scalable object storage that is fully managed. AWS Config tracks resource configuration changes and evaluates compliance.

DEA-C01 Question 197

Single page →
Topic 1 · Question 197

A company is designing a serverless data processing workflow in AWS Step Functions that involves multiple steps. The processing workflow ingests data from an external API, transforms the data by using multiple AWS Lambda functions, and loads the transformed data into Amazon DynamoDB. The company needs the workflow to perform specific steps based on the content of the incoming data. Which Step Functions state type should the company use to meet this requirement?

  • AParallel
  • BChoice (correct answer)
  • CTask
  • DMap
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Choice.

DEA-C01 Question 198

Single page →
Topic 1 · Question 198

A data engineer created a table named cloudtrail_logs in Amazon Athena to query AWS CloudTrail logs and prepare data for audits. The data engineer needs to write a query to display errors with error codes that have occurred since the beginning of 2024. The query must return the 10 most recent errors. Which query will meet these requirements?

  • Aselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logswhere errorcode is not nulland eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessageorder by TotalEvents desclimit 10; (correct answer)
  • Bselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logs where eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessage order by TotalEvents desc limit 10;
  • Cselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logswhere eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessageorder by eventname asc limit 10;
  • Dselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logs where errorcode is not nulland eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessagelimit 10;
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: select count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logswhere errorcode is not nulland eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessageorder by TotalEvent...

Explanation

AWS CloudTrail records API activity for auditing and governance.

DEA-C01 Question 199

Single page →
Topic 1 · Question 199

An online retailer uses multiple delivery partners to deliver products to customers. The delivery partners send order summaries to the retailer. The retailer stores the order summaries in Amazon S3. Some of the order summaries contain personally identifiable information (PII) about customers. A data engineer needs to detect PII in the order summaries so the company can redact the PII. Which solution will meet these requirements with the LEAST operational overhead?

  • AAmazon Textract
  • BAmazon S3 Storage Lens
  • CAmazon Macie (correct answer)
  • DAmazon SageMaker Data Wrangler
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Amazon Macie

Explanation

Amazon Macie discovers and protects sensitive data such as PII in S3.

DEA-C01 Question 200

Single page →
Topic 1 · Question 200

A company has an Amazon Redshift data warehouse that users access by using a variety of IAM roles. More than 100 users access the data warehouse every day. The company wants to control user access to the objects based on each user's job role, permissions, and how sensitive the data is. Which solution will meet these requirements?

  • AUse the role-based access control (RBAC) feature of Amazon Redshift. (correct answer)
  • BUse the row-level security (RLS) feature of Amazon Redshift.
  • CUse the column-level security (CLS) feature of Amazon Redshift.
  • DUse dynamic data masking policies in Amazon Redshift.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use the role-based access control (RBAC) feature of Amazon Redshift.

Explanation

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

Showing questions 181–200 of 313 · Page 10 of 16