🔍

DEA-C01 — questions

Page 5 of 16 · 313 total questions.

DEA-C01 Question 81

Single page →
Topic 1 · Question 81

A data engineer creates an AWS Glue Data Catalog table by using an AWS Glue crawler that is named Orders. The data engineer wants to add the following new partitions: s3://transactions/orders/order_date=2023-01-01 s3://transactions/orders/order_date=2023-01-02 The data engineer must edit the metadata to include the new partitions in the table without scanning all the folders and files in the location of the table. Which data definition language (DDL) statement should the data engineer use in Amazon Athena?

  • AALTER TABLE Orders ADD PARTITION(order_date=’2023-01-01’) LOCATION ‘s3://transactions/orders/order_date=2023-01-01’; ALTER TABLE Orders ADD PARTITION(order_date=’2023-01-02’) LOCATION ‘s3://transactions/orders/order_date=2023-01-02’; (correct answer)
  • BMSCK REPAIR TABLE Orders;
  • CREPAIR TABLE Orders;
  • DALTER TABLE Orders MODIFY PARTITION(order_date=’2023-01-01’) LOCATION ‘s3://transactions/orders/2023-01-01’; ALTER TABLE Orders MODIFY PARTITION(order_date=’2023-01-02’) LOCATION ‘s3://transactions/orders/2023-01-02’;
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: ALTER TABLE Orders ADD PARTITION(order_date=’2023-01-01’) LOCATION ‘s3://transactions/orders/order_date=2023-01-01’; ALTER TABLE Orders ADD PARTITION(order_date=’2023-01-02’) LOCATION ‘s3://transactions/orders/order_d...

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed.

DEA-C01 Question 82

Single page →
Topic 1 · Question 82

A company stores 10 to 15 TB of uncompressed .csv files in Amazon S3. The company is evaluating Amazon Athena as a one-time query engine. The company wants to transform the data to optimize query runtime and storage costs. Which file format and compression solution will meet these requirements for Athena queries?

  • A.csv format compressed with zip
  • BJSON format compressed with bzip2
  • CApache Parquet format compressed with Snappy (correct answer)
  • DApache Avro format compressed with LZO
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Apache Parquet format compressed with Snappy.

DEA-C01 Question 83

Single page →
Topic 1 · Question 83

A company uses Apache Airflow to orchestrate the company's current on-premises data pipelines. The company runs SQL data quality check tasks as part of the pipelines. The company wants to migrate the pipelines to AWS and to use AWS managed services. Which solution will meet these requirements with the LEAST amount of refactoring?

  • ASetup AWS Outposts in the AWS Region that is nearest to the location where the company uses Airflow. Migrate the servers into Outposts hosted Amazon EC2 instances. Update the pipelines to interact with the Outposts hosted EC2 instances instead of the on-premises pipelines.
  • BCreate a custom Amazon Machine Image (AMI) that contains the Airflow application and the code that the company needs to migrate. Use the custom AMI to deploy Amazon EC2 instances. Update the network connections to interact with the newly deployed EC2 instances.
  • CMigrate the existing Airflow orchestration configuration into Amazon Managed Workflows for Apache Airflow (Amazon MWAA). Create the data quality checks during the ingestion to validate the data quality by using SQL tasks in Airflow. (correct answer)
  • DConvert the pipelines to AWS Step Functions workflows. Recreate the data quality checks in SQL as Python based AWS Lambda functions.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Migrate the existing Airflow orchestration configuration into Amazon Managed Workflows for Apache Airflow (Amazon MWAA). Create the data quality checks during the ingestion to validate the data quality by using SQL ta...

Explanation

AWS Config tracks resource configuration changes and evaluates compliance.

DEA-C01 Question 84

Single page →
Topic 1 · Question 84

A company uses Amazon EMR as an extract, transform, and load (ETL) pipeline to transform data that comes from multiple sources. A data engineer must orchestrate the pipeline to maximize performance. Which AWS service will meet this requirement MOST cost effectively?

  • AAmazon EventBridge
  • BAmazon Managed Workflows for Apache Airflow (Amazon MWAA)
  • CAWS Step Functions (correct answer)
  • DAWS Glue Workflows
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: AWS Step Functions

Explanation

AWS Step Functions coordinates multi-step workflows as a managed state machine. This option delivers the requirement at the lowest cost.

DEA-C01 Question 85

Single page →
Topic 1 · Question 85

An online retail company stores Application Load Balancer (ALB) access logs in an Amazon S3 bucket. The company wants to use Amazon Athena to query the logs to analyze traffic patterns. A data engineer creates an unpartitioned table in Athena. As the amount of the data gradually increases, the response time for queries also increases. The data engineer wants to improve the query performance in Athena. Which solution will meet these requirements with the LEAST operational effort?

  • ACreate an AWS Glue job that determines the schema of all ALB access logs and writes the partition metadata to AWS Glue Data Catalog.
  • BCreate an AWS Glue crawler that includes a classifier that determines the schema of all ALB access logs and writes the partition metadata to AWS Glue Data Catalog. (correct answer)
  • CCreate an AWS Lambda function to transform all ALB access logs. Save the results to Amazon S3 in Apache Parquet format. Partition the metadata. Use Athena to query the transformed data.
  • DUse Apache Hive to create bucketed tables. Use an AWS Lambda function to transform all ALB access logs.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create an AWS Glue crawler that includes a classifier that determines the schema of all ALB access logs and writes the partition metadata to AWS Glue Data Catalog.

Explanation

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

DEA-C01 Question 86

Single page →
Topic 1 · Question 86

A company has a business intelligence platform on AWS. The company uses an AWS Storage Gateway Amazon S3 File Gateway to transfer files from the company's on-premises environment to an Amazon S3 bucket. A data engineer needs to setup a process that will automatically launch an AWS Glue workflow to run a series of AWS Glue jobs when each file transfer finishes successfully. Which solution will meet these requirements with the LEAST operational overhead?

  • ADetermine when the file transfers usually finish based on previous successful file transfers. Set up an Amazon EventBridge scheduled event to initiate the AWS Glue jobs at that time of day.
  • BSet up an Amazon EventBridge event that initiates the AWS Glue workflow after every successful S3 File Gateway file transfer event. (correct answer)
  • CSet up an on-demand AWS Glue workflow so that the data engineer can start the AWS Glue workflow when each file transfer is complete.
  • DSet up an AWS Lambda function that will invoke the AWS Glue Workflow. Set up an event for the creation of an S3 object as a trigger for the Lambda function.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Set up an Amazon EventBridge event that initiates the AWS Glue workflow after every successful S3 File Gateway file transfer event.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. S3 File Gateway presents S3 as an NFS/SMB file share to on-premises applications. Amazon EventBridge routes events between services with rules, enabling event-driven, decoupled architectures.

DEA-C01 Question 87

Single page →
Topic 1 · Question 87

A retail company uses Amazon Aurora PostgreSQL to process and store live transactional data. The company uses an Amazon Redshift cluster for a data warehouse. An extract, transform, and load (ETL) job runs every morning to update the Redshift cluster with new data from the PostgreSQL database. The company has grown rapidly and needs to cost optimize the Redshift cluster. A data engineer needs to create a solution to archive historical data. The data engineer must be able to run analytics queries that effectively combine data from live transactional data in PostgreSQL, current data in Redshift, and archived historical data. The solution must keep only the most recent 15 months of data in Amazon Redshift to reduce costs. Which combination of steps will meet these requirements? (Choose two.)

  • AConfigure the Amazon Redshift Federated Query feature to query live transactional data that is in the PostgreSQL database. (correct answer)
  • BConfigure Amazon Redshift Spectrum to query live transactional data that is in the PostgreSQL database.
  • CSchedule a monthly job to copy data that is older than 15 months to Amazon S3 by using the UNLOAD command. Delete the old data from the Redshift cluster. Configure Amazon Redshift Spectrum to access historical data in Amazon S3.
  • DSchedule a monthly job to copy data that is older than 15 months to Amazon S3 Glacier Flexible Retrieval by using the UNLOAD command. Delete the old data from the Redshift cluster. Configure Redshift Spectrum to access historical data from S3 Glacier Flexible Retrieval.
  • ECreate a materialized view in Amazon Redshift that combines live, current, and historical data from different sources.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Configure the Amazon Redshift Federated Query feature to query live transactional data that is in the PostgreSQL database.

Explanation

Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. AWS Config tracks resource configuration changes and evaluates compliance. This option delivers the requirement at the lowest cost.

DEA-C01 Question 88

Single page →
Topic 1 · Question 88

A manufacturing company has many IoT devices in facilities around the world. The company uses Amazon Kinesis Data Streams to collect data from the devices. The data includes device ID, capture date, measurement type, measurement value, and facility ID. The company uses facility ID as the partition key. The company's operations team recently observed many WriteThroughputExceeded exceptions. The operations team found that some shards were heavily used but other shards were generally idle. How should the company resolve the issues that the operations team observed?

  • AChange the partition key from facility ID to a randomly generated key. (correct answer)
  • BIncrease the number of shards.
  • CArchive the data on the producer's side.
  • DChange the partition key from facility ID to capture date.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Change the partition key from facility ID to a randomly generated key.

DEA-C01 Question 89

Single page →
Topic 1 · Question 89

A data engineer wants to improve the performance of SQL queries in Amazon Athena that run against a sales data table. The data engineer wants to understand the execution plan of a specific SQL statement. The data engineer also wants to see the computational cost of each operation in a SQL query. Which statement does the data engineer need to run to meet these requirements?

  • AEXPLAIN SELECT * FROM sales;
  • BEXPLAIN ANALYZE FROM sales;
  • CEXPLAIN ANALYZE SELECT * FROM sales; (correct answer)
  • DEXPLAIN FROM sales;
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: EXPLAIN ANALYZE SELECT * FROM sales;.

DEA-C01 Question 90

Single page →
Topic 1 · Question 90

A company plans to provision a log delivery stream within a VPC. The company configured the VPC flow logs to publish to Amazon CloudWatch Logs. The company needs to send the flow logs to Splunk in near real time for further analysis. Which solution will meet these requirements with the LEAST operational overhead?

  • AConfigure an Amazon Kinesis Data Streams data stream to use Splunk as the destination. Create a CloudWatch Logs subscription filter to send log events to the data stream.
  • BCreate an Amazon Kinesis Data Firehose delivery stream to use Splunk as the destination. Create a CloudWatch Logs subscription filter to send log events to the delivery stream. (correct answer)
  • CCreate an Amazon Kinesis Data Firehose delivery stream to use Splunk as the destination. Create an AWS Lambda function to send the flow logs from CloudWatch Logs to the delivery stream.
  • DConfigure an Amazon Kinesis Data Streams data stream to use Splunk as the destination. Create an AWS Lambda function to send the flow logs from CloudWatch Logs to the data stream.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create an Amazon Kinesis Data Firehose delivery stream to use Splunk as the destination. Create a CloudWatch Logs subscription filter to send log events to the delivery stream.

Explanation

Kinesis Data Firehose delivers streaming data to destinations like S3/Redshift with no servers to manage. Amazon Kinesis ingests and processes real-time streaming data at scale. Amazon CloudWatch collects metrics, logs and alarms to monitor and react to operational health.

DEA-C01 Question 91

Single page →
Topic 1 · Question 91

A company has a data lake on AWS. The data lake ingests sources of data from business units. The company uses Amazon Athena for queries. The storage layer is Amazon S3 with an AWS Glue Data Catalog as a metadata repository. The company wants to make the data available to data scientists and business analysts. However, the company first needs to manage fine-grained, column-level data access for Athena based on the user roles and responsibilities. Which solution will meet these requirements?

  • ASet up AWS Lake Formation. Define security policy-based rules for the users and applications by IAM role in Lake Formation. (correct answer)
  • BDefine an IAM resource-based policy for AWS Glue tables. Attach the same policy to IAM user groups.
  • CDefine an IAM identity-based policy for AWS Glue tables. Attach the same policy to IAM roles. Associate the IAM roles with IAM groups that contain the users.
  • DCreate a resource share in AWS Resource Access Manager (AWS RAM) to grant access to IAM users.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Set up AWS Lake Formation. Define security policy-based rules for the users and applications by IAM role in Lake Formation.

Explanation

AWS Lake Formation builds and secures data lakes quickly. 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.

DEA-C01 Question 92

Single page →
Topic 1 · Question 92

A company has developed several AWS Glue extract, transform, and load (ETL) jobs to validate and transform data from Amazon S3. The ETL jobs load the data into Amazon RDS for MySQL in batches once every day. The ETL jobs use a DynamicFrame to read the S3 data. The ETL jobs currently process all the data that is in the S3 bucket. However, the company wants the jobs to process only the daily incremental data. Which solution will meet this requirement with the LEAST coding effort?

  • ACreate an ETL job that reads the S3 file status and logs the status in Amazon DynamoDB.
  • BEnable job bookmarks for the ETL jobs to update the state after a run to keep track of previously processed data. (correct answer)
  • CEnable job metrics for the ETL jobs to help keep track of processed objects in Amazon CloudWatch.
  • DConfigure the ETL jobs to delete processed objects from Amazon S3 after each run.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Enable job bookmarks for the ETL jobs to update the state after a run to keep track of previously processed data.

DEA-C01 Question 93

Single page →
Topic 1 · Question 93

An online retail company has an application that runs on Amazon EC2 instances that are in a VPC. The company wants to collect flow logs for the VPC and analyze network traffic. Which solution will meet these requirements MOST cost-effectively?

  • APublish flow logs to Amazon CloudWatch Logs. Use Amazon Athena for analytics.
  • BPublish flow logs to Amazon CloudWatch Logs. Use an Amazon OpenSearch Service cluster for analytics.
  • CPublish flow logs to Amazon S3 in text format. Use Amazon Athena for analytics.
  • DPublish flow logs to Amazon S3 in Apache Parquet format. Use Amazon Athena for analytics. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Publish flow logs to Amazon S3 in Apache Parquet format. Use Amazon Athena for analytics.

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. This option delivers the requirement at the lowest cost.

DEA-C01 Question 94

Single page →
Topic 1 · Question 94

A retail company stores transactions, store locations, and customer information tables in four reserved ra3.4xlarge Amazon Redshift cluster nodes. All three tables use even table distribution. The company updates the store location table only once or twice every few years. A data engineer notices that Redshift queues are slowing down because the whole store location table is constantly being broadcast to all four compute nodes for most queries. The data engineer wants to speed up the query performance by minimizing the broadcasting of the store location table. Which solution will meet these requirements in the MOST cost-effective way?

  • AChange the distribution style of the store location table from EVEN distribution to ALL distribution. (correct answer)
  • BChange the distribution style of the store location table to KEY distribution based on the column that has the highest dimension.
  • CAdd a join column named store_id into the sort key for all the tables.
  • DUpgrade the Redshift reserved node to a larger instance size in the same instance family.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Change the distribution style of the store location table from EVEN distribution to ALL distribution. This option delivers the requirement at the lowest cost.

DEA-C01 Question 95

Single page →
Topic 1 · Question 95

A company has a data warehouse that contains a table that is named Sales. The company stores the table in Amazon Redshift. The table includes a column that is named city_name. The company wants to query the table to find all rows that have a city_name that starts with "San" or "El". Which SQL query will meet this requirement?

  • ASelect * from Sales where city_name ~ ‘$(San|El)*’;
  • BSelect * from Sales where city_name ~ ‘^(San|El)*’; (correct answer)
  • CSelect * from Sales where city_name ~’$(San&El)*’;
  • DSelect * from Sales where city_name ~ ‘^(San&El)*’;
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Select * from Sales where city_name ~ ‘^(San|El)*’;.

DEA-C01 Question 96

Single page →
Topic 1 · Question 96

A company needs to send customer call data from its on-premises PostgreSQL database to AWS to generate near real-time insights. The solution must capture and load updates from operational data stores that run in the PostgreSQL database. The data changes continuously. A data engineer configures an AWS Database Migration Service (AWS DMS) ongoing replication task. The task reads changes in near real time from the PostgreSQL source database transaction logs for each table. The task then sends the data to an Amazon Redshift cluster for processing. The data engineer discovers latency issues during the change data capture (CDC) of the task. The data engineer thinks that the PostgreSQL source database is causing the high latency. Which solution will confirm that the PostgreSQL database is the source of the high latency?

  • AUse Amazon CloudWatch to monitor the DMS task. Examine the CDCIncomingChanges metric to identify delays in the CDC from the source database.
  • BVerify that logical replication of the source database is configured in the postgresql.conf configuration file.
  • CEnable Amazon CloudWatch Logs for the DMS endpoint of the source database. Check for error messages.
  • DUse Amazon CloudWatch to monitor the DMS task. Examine the CDCLatencySource metric to identify delays in the CDC from the source database. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use Amazon CloudWatch to monitor the DMS task. Examine the CDCLatencySource metric to identify delays in the CDC from the source database.

Explanation

Amazon CloudWatch collects metrics, logs and alarms to monitor and react to operational health. AWS Database Migration Service migrates databases with minimal downtime. This option meets the real-time / low-latency performance requirement.

DEA-C01 Question 97

Single page →
Topic 1 · Question 97

A lab uses IoT sensors to monitor humidity, temperature, and pressure for a project. The sensors send 100 KB of data every 10 seconds. A downstream process will read the data from an Amazon S3 bucket every 30 seconds. Which solution will deliver the data to the S3 bucket with the LEAST latency?

  • AUse Amazon Kinesis Data Streams and Amazon Kinesis Data Firehose to deliver the data to the S3 bucket. Use the default buffer interval for Kinesis Data Firehose.
  • BUse Amazon Kinesis Data Streams to deliver the data to the S3 bucket. Configure the stream to use 5 provisioned shards.
  • CUse Amazon Kinesis Data Streams and call the Kinesis Client Library to deliver the data to the S3 bucket. Use a 5 second buffer interval from an application. (correct answer)
  • DUse Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) and Amazon Kinesis Data Firehose to deliver the data to the S3 bucket. Use a 5 second buffer interval for Kinesis Data Firehose.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Amazon Kinesis Data Streams and call the Kinesis Client Library to deliver the data to the S3 bucket. Use a 5 second buffer interval from an application.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. Kinesis Data Streams ingests and processes high-volume real-time streaming data. Amazon Kinesis ingests and processes real-time streaming data at scale.

DEA-C01 Question 98

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

A company wants to use machine learning (ML) to perform analytics on data that is in an Amazon S3 data lake. The company has two data transformation requirements that will give consumers within the company the ability to create reports. The company must perform daily transformations on 300 GB of data that is in a variety format that must arrive in Amazon S3 at a scheduled time. The company must perform one-time transformations of terabytes of archived data that is in the S3 data lake. The company uses Amazon Managed Workflows for Apache Airflow (Amazon MWAA) Directed Acyclic Graphs (DAGs) to orchestrate processing. Which combination of tasks should the company schedule in the Amazon MWAA DAGs to meet these requirements MOST cost-effectively? (Choose two.)

  • AFor daily incoming data, use AWS Glue crawlers to scan and identify the schema. (correct answer)
  • BFor daily incoming data, use Amazon Athena to scan and identify the schema.
  • CFor daily incoming data, use Amazon Redshift to perform transformations.
  • DFor daily and archived data, use Amazon EMR to perform data transformations. (correct answer)
  • EFor archived data, use Amazon SageMaker to perform data transformations.
Reveal answer & explanation
Correct answer: A, D

The correct answer is A, D. Option A: For daily incoming data, use AWS Glue crawlers to scan and identify the schema. Option D: For daily and archived data, use Amazon EMR to perform data transformations.

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. Amazon EMR runs big-data frameworks like Spark and Hadoop on managed clusters. This option delivers the requirement at the lowest cost.

DEA-C01 Question 99

Single page →
Topic 1 · Question 99

A retail company uses AWS Glue for extract, transform, and load (ETL) operations on a dataset that contains information about customer orders. The company wants to implement specific validation rules to ensure data accuracy and consistency. Which solution will meet these requirements?

  • AUse AWS Glue job bookmarks to track the data for accuracy and consistency.
  • BCreate custom AWS Glue Data Quality rulesets to define specific data quality checks. (correct answer)
  • CUse the built-in AWS Glue Data Quality transforms for standard data quality validations.
  • DUse AWS Glue Data Catalog to maintain a centralized data schema and metadata repository.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create custom AWS Glue Data Quality rulesets to define specific data quality checks.

Explanation

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

DEA-C01 Question 100

Single page →
Topic 1 · Question 100

An insurance company stores transaction data that the company compressed with gzip. The company needs to query the transaction data for occasional audits. Which solution will meet this requirement in the MOST cost-effective way?

  • AStore the data in Amazon Glacier Flexible Retrieval. Use Amazon S3 Glacier Select to query the data.
  • BStore the data in Amazon S3. Use Amazon S3 Select to query the data. (correct answer)
  • CStore the data in Amazon S3. Use Amazon Athena to query the data.
  • DStore the data in Amazon Glacier Instant Retrieval. Use Amazon Athena to query the data.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Store the data in Amazon S3. Use Amazon S3 Select to query the data.

Explanation

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

Showing questions 81–100 of 313 · Page 5 of 16