πŸ”

DEA-C01 β€” questions

Page 14 of 16 Β· 313 total questions.

Topic 1 Β· Question 261

A data engineer needs to deploy a complex pipeline. The stages of the pipeline must be able to run a script. The data engineer must use only fully managed and serverless services in the pipeline. Which solution will meet these requirements?

  • ADeploy AWS Glue jobs and workflows. Use AWS Glue to run the jobs and workflows on a schedule. (correct answer)
  • BUse Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to build and schedule the pipeline.
  • CDeploy the script to Amazon EC2 instances. Use Amazon EventBridge to run the script on a schedule.
  • DUse Aws Glue DataBrew to build the pipeline. Use Amazon EventBridge to run the pipeline on a schedule.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Deploy AWS Glue jobs and workflows. Use AWS Glue to run the jobs and workflows on a schedule.

Explanation

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

Topic 1 Β· Question 262

A company needs to optimize storage costs for an Amazon S3 bucket. The S3 bucket receives 10 million objects every day. The objects range in size from 2 KB to 5 MB. The objects need to be immediately accessible for the first 60 days. Users access objects infrequently from 61 to 180 days. The objects must be accessible within an hour from 181 to 365 days. The company can delete the objects after 365 days. Which solution will meet these requirements?

  • AUse S3 Intelligent-Tiering to automatically transition objects. Select the Archive Access tier for Intelligent-Tiering. Configure an S3 bucket policy to expire objects that are older than 365 days.
  • BCreate an S3 Lifecycle policy to move objects. Configure the policy to move objects from S3 Standard to S3 Standard-Infrequent Access (S3 Standard-IA) after 60 days. Move the objects to S3 Glacier Flexible Retrieval after 180 days. Expire objects after 365 days. (correct answer)
  • CEnable S3 Inventory. Use a daily inventory report to configure an S3 Batch Operations job that moves objects from S3 Standard to S3 Standard-Infrequent Access (S3 Standard-IA) after 60 days. Move objects to S3 Glacier Flexible Retrieval after 180 days. Expire objects after 365 days.
  • DEnable S3 Inventory. Run an AWS Lambda function each day to fetch an inventory report and move objects from S3 Standard to S3 Standard-Infrequent Access (S3 Standard-IA) after 60 days. Move objects to S3 Glacier Flexible Retrieval after 180 days. Expire objects after 365 days.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create an S3 Lifecycle policy to move objects. Configure the policy to move objects from S3 Standard to S3 Standard-Infrequent Access (S3 Standard-IA) after 60 days. Move the objects to S3 Glacier Flexible Retrieval a...

Explanation

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. S3 Lifecycle policies automatically transition or expire objects to control storage cost.

Topic 1 Β· Question 263

A company runs a multi-tenant Amazon EMR cluster on Amazon EC2 instances. Multiple teams perform interactive query analyses and data transformations on the data in the EMR cluster. The teams can access the cluster only through EMR Studio workspaces and EMR steps. The teams need to use EMR steps to run Apache Spark jobs to fetch data from an Amazon DynamoDB table. The DynamoDB table contains confidential data that must be accessible to only one specific team. The company needs to ensure that only the appropriate team can access the confidential data in the EMR cluster. Which solution will meet these requirements?

  • ASet up runtime roles for EMR steps. (correct answer)
  • BSet up AWS Lake Formation permissions.
  • CSet up IAM roles for EMR File System (EMRFS) requests.
  • DSet up a DynamoDB resource-based policy.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Set up runtime roles for EMR steps.

Explanation

Amazon EMR runs big-data frameworks like Spark and Hadoop on managed clusters.

Topic 1 Β· Question 264

A company stores Apache Parquet files in an Amazon S3 data lake. The data lake receives thousands of files from multiple sources every hour. The files range in size from 50 KB to 100 KB. The company is evaluating the implementation of Apache Iceberg tables for the data lake. The company is using AWS Glue Data Catalog as part of the evaluation. The company needs a solution to optimize query performance in Iceberg. The solution must ensure that Iceberg table performance does not degrade when more files are added over time. Which solution will meet these requirements?

  • AUse an AWS Glue job to compact the files into a standard size of 512 MB at the end of each day. Run an AWS Glue crawler to update the Data Catalog.
  • BConfigure the Data Catalog to automatically compact the files every minute.
  • CConfigure Iceberg table properties to enable automatic compaction based on thresholds for file size and the number of files. (correct answer)
  • DImplement a partition strategy in Amazon S3. Run an AWS Glue crawler to update the Data Catalog every 5 minutes.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Configure Iceberg table properties to enable automatic compaction based on thresholds for file size and the number of files.

Explanation

AWS Config tracks resource configuration changes and evaluates compliance.

Topic 1 Β· Question 265

A company needs a solution to store and query product data that has variable attributes. The solution must support unpredictable and high-volume queries with single-digit millisecond latency, even during sudden traffic spikes. The solution must retrieve items by a primary identifier named Product ID. The solution must allow flexible queries by secondary attributes named Category and Brand. Which solution will meet these requirements?

  • AUse an Amazon DynamoDB table with on-demand capacity to store product data. Store products by primary key. Use global secondary indexes (GSIs) to store secondary attributes. (correct answer)
  • BUse Amazon Aurora with a Multi-AZ deployment to store product data. Use read replicas. Create indexes for primary and secondary attributes.
  • CUse an Amazon OpenSearch Serverless cluster with dynamic scaling to store product data. Index product data by primary and secondary attributes.
  • DUse Amazon ElastiCache (Redis OSS) and Amazon S3 to store product data. Use Amazon Athena to run flexible secondary attribute queries.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use an Amazon DynamoDB table with on-demand capacity to store product data. Store products by primary key. Use global secondary indexes (GSIs) to store secondary attributes.

Explanation

Amazon DynamoDB is a fully managed, serverless NoSQL database with single-digit millisecond latency and automatic scaling. This option decouples the components so they scale independently and absorb load spikes.

Topic 1 Β· Question 266

A company needs to build a data pipeline to process a 1-TB file from an Amazon S3 bucket. The pipeline needs to create three DataFrames based on business logic. The pipeline must save all three DataFrames to a second S3 bucket in parallel. The company needs to set the pipeline to be the target of an Amazon EventBridge rule that matches file uploads to the source S3 bucket. Which solution will meet these requirements with the LEAST maintenance overhead?

  • AConfigure an Apache Spark Streaming application on Amazon EMR to process data from the S3 source bucket in batches, create DataFrames, and save the output to the destination S3 bucket.
  • BConfigure three AWS Lambda functions to process the business logic and to save the DataFrames to the destination S3 bucket in parallel.
  • CConfigure an AWS Glue workflow to run three AWS Glue jobs in parallel to process the file. (correct answer)
  • DConfigure an AWS Step Functions state machine to initiate an AWS Glue workflow to run three AWS Glue jobs in parallel to process the file.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Configure an AWS Glue workflow to run three AWS Glue jobs in parallel to process the file.

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. AWS Config tracks resource configuration changes and evaluates compliance.

Topic 1 Β· Question 267

An ecommerce company collects daily customer transaction logs in CSV format and stores the logs in Amazon S3. The company uses Amazon Athena to scan a subset of attributes from the logs on the same day the company receives each log. Query times are increasing because of increasing transaction volume. The company wants to improve query performance. Which solution will meet these requirements with the SHORTEST query times?

  • AConvert the CSV logs into multiple ORC files for better parallelism in Athena. Partition by date in Amazon S3. Use columnar pushdown filters. (correct answer)
  • BConvert the CSV logs to JSON. Partition by date in Amazon S3. Use Athena with dynamic filtering to reduce data scans.
  • CConvert the CSV logs to Avro. Partition by date in Amazon S3. Use Athena with projection-based partitioning.
  • DConvert the CSV logs to a single Apache Parquet file for each day Partition the data by date in Amazon S3. Use Athena with predicate pushdown filters.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Convert the CSV logs into multiple ORC files for better parallelism in Athena. Partition by date in Amazon S3. Use columnar pushdown filters.

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.

Topic 1 Β· Question 268

Two data engineering teams use separate AWS accounts. Both teams request access to the same datashare in an Amazon Redshift cluster that is in a third AWS account. The datashare is named salesshare. A data engineer must use the Amazon Redshift SQL interface to grant both data engineering teams' access to the datashare. Which command or commands will meet this requirement?

  • AGRANT USAGE ON DATASHARE salesshare TO ACCOUNTS β€˜β€™ AND β€˜β€™;
  • BGRANT USAGE ON DATASHARE salesshare TO NAMESPACES β€˜β€™ AND β€˜β€™;
  • CGRANT USAGE ON DATASHARE salesshare TO ACCOUNT β€˜β€™;GRANT USAGE ON DATASHARE salesshare TO ACCOUNT β€˜β€™; (correct answer)
  • DGRANT USAGE ON DATASHARE salesshare TO NAMESPACE β€˜β€™;GRANT USAGE ON DATASHARE salesshare TO NAMESPACE β€˜β€™;
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: GRANT USAGE ON DATASHARE salesshare TO ACCOUNT β€˜β€™;GRANT USAGE ON DATASHARE salesshare TO ACCOUNT β€˜β€™;.

Topic 1 Β· Question 269

A company must retain specific data for 1 year. A data engineer observes that one of the company’s Amazon S3 buckets contains millions of objects that are older than 3 years. Versioning is enabled on the bucket. To reduce costs, the data engineer implements an S3 Lifecycle rule to expire objects after 365 days. The new S3 Lifecycle rule causes the object count to double instead of decrease. Which additional step must the data engineer take to permanently delete the old objects?

  • ADisable versioning on the S3 bucket.
  • BUse an AWS Lambda function to run a Python job to identify and delete objects that are older than 365 days.
  • CSuspend versioning on the S3 bucket.
  • DAdd an additional S3 Lifecycle rule to delete the current and expired versions of objects that are older than 365 days. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Add an additional S3 Lifecycle rule to delete the current and expired versions of objects that are older than 365 days.

Explanation

S3 Lifecycle policies automatically transition or expire objects to control storage cost. Amazon S3 provides durable, scalable object storage that is fully managed. This option delivers the requirement at the lowest cost.

Topic 1 Β· Question 270

A manufacturing company uses AWS Glue jobs to process IoT sensor data to generate predictive maintenance models. A data engineer needs to implement automated data quality checks to identify temperature readings that are outside the expected range of -50Β°C to 150Β°C. The data quality checks must also identify records that are missing timestamp values. The data engineer needs a solution that requires minimal coding and can automatically flag the specified issues. Which solution will meet these requirements?

  • ACreate an AWS Glue DataBrew project to profile the sensor data Define completeness rules for timestamps. Set up numeric range validation for temperature values. (correct answer)
  • BUse AWS Glue’s Data Quality rules and machine learning (ML)-based anomaly detection to identify missing timestamps and to detect temperature anomalies.
  • CCreate an AWS Lambda function to scan the sensor data files to validate temperature ranges. Use AWS Glue Data Catalog tables to check timestamp completeness.
  • DCreate an AWS Glue DynamicFrame that uses a custom data quality operator to profile the sensor data. Use Amazon SageMaker Data Wrangler transforms to validate timestamps and temperature ranges.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Create an AWS Glue DataBrew project to profile the sensor data Define completeness rules for timestamps. Set up numeric range validation for temperature values.

Explanation

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

Topic 1 Β· Question 271

A company generates yearly financial statements for customers and stores the statements in an Amazon S3 bucket. Customers rarely access the documents after 1 week. The company must retain the statements for 7 years. The statements must remain readily accessible for customers. Which solution will meet these requirements in the MOST cost-effective way?

  • ACreate an S3 Lifecycle rule to transition objects to S3 Glacier Deep Archive after 7 days. Expire the objects after 7 years.
  • BSet the S3 bucket to use S3 Intelligent-Tiering when new objects are uploaded. Set objects to expire after 7 years.
  • CCreate an S3 Lifecycle rule to transition objects to S3 Glacier Instant Retrieval after 7 days. Expire the objects after 7 years. (correct answer)
  • DSet the S3 bucket to use S3 Glacier Instant Retrieval when new objects are uploaded. Create an AWS Lambda function that runs daily to delete any objects that are older than 7 years.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create an S3 Lifecycle rule to transition objects to S3 Glacier Instant Retrieval after 7 days. Expire the objects after 7 years.

Explanation

Amazon S3 Glacier offers low-cost archival storage for infrequently accessed data. S3 Lifecycle policies automatically transition or expire objects to control storage cost. Amazon S3 provides durable, scalable object storage that is fully managed. This option delivers the requirement at the lowest cost.

Topic 1 Β· Question 272

A company creates a new non-production application that runs on an Amazon EC2 instance. The application needs to communicate with an Amazon RDS database instance using Java Database Connectivity (JDBC). The EC2 instances and the RDS database instance are in the same subnet. Which solution will meet this requirement?

  • AModify the IAM role that is assigned to the database instance to allow connections from the EC2 instances.
  • BModify the ec2_authorized_hosts parameter in the RDS parameter group to include the EC2 instances. Restart the database instance.
  • CUpdate the database security group to allow connections from the EC2 instances. (correct answer)
  • DEnable the Amazon RDS Data API and specify the Amazon Resource Name (ARN) of the database instance in the JDBC connection string.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Update the database security group to allow connections from the EC2 instances.

Explanation

Amazon EC2 provides resizable virtual servers when you need full control of the operating system.

Topic 1 Β· Question 273

A retail company wants to implement real-time analytics for an ecommerce platform. The company needs to collect clickstream data from the company's website and mobile apps. The company needs to store the data for analytics. Which solution will meet these requirements with the LEAST ongoing maintenance?

  • AUse Amazon Data Firehose to ingest the streaming data. Deliver the processed data directly to a provisioned Amazon Redshift cluster.
  • BDeploy agents on Amazon EC2 instances to collect the streaming data. Use the AWS CLI to periodically batch upload the data to an Amazon S3 bucket.
  • CUse Amazon Kinesis Data Streams to collect the streaming data. Use Amazon Data Firehose to deliver the data to an Amazon S3 bucket. (correct answer)
  • DUse an Amazon Managed Streaming for Apache Kafka (Amazon MSK) broker to collect the data. Store the data in an Amazon RDS DB instance.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Amazon Kinesis Data Streams to collect the streaming data. Use Amazon Data Firehose to deliver the data to an Amazon S3 bucket.

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. This option meets the real-time / low-latency performance requirement.

Topic 1 Β· Question 274

A company uses AWS Glue ETL pipelines to process data. The company uses Amazon Athena to analyze data in an Amazon S3 bucket. To better understand shipping timelines, the company decides to collect and store shipping and delivery dates in addition to order data. The company adds a data quality check to ensure that shipping date is greater than order date and that delivery date is greater than shipping date. Orders that fail the quality check must be stored in a second S3 bucket. Which solution will meet these requirements MOST cost-effectively?

  • AUse the AWS Glue DataBrew DATEDIFF function to create two additional columns. Check the new columns.
  • BUse Athena to query all three date columns, and compare the columns.
  • CUse AWS Glue Data Quality to create a custom rule that uses the three date columns. (correct answer)
  • DUse an AWS Glue crawler to populate an AWS Glue Data Catalog. Use the three date columns to create a filter.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use AWS Glue Data Quality to create a custom rule that uses the three date columns.

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. This option delivers the requirement at the lowest cost.

Topic 1 Β· Question 275

A data engineer is designing a log table for an application that requires continuous ingestion. The application must provide dependable API-based access to specific records from other applications. The application must handle more than 4,000 concurrent write operations and 6,500 read operations every second. Which solution will meet these requirements?

  • ACreate an Amazon Redshift table with the KEY distribution style. Use the Amazon Redshift Data API to perform all read and write operations.
  • BStore the log files in an Amazon S3 Standard bucket. Register the schema in AWS Glue Data Catalog. Create an external Redshift table that points to the AWS Glue schema. Use the table to perform Amazon Redshift Spectrum read operations.
  • CCreate an Amazon Redshift table with the EVEN distribution style. Use the Amazon Redshift Java Database Connectivity (JDBC) connector to establish a database connection. Use the database connection to perform all read and write operations.
  • DCreate an Amazon DynamoDB table that has provisioned capacity to meet the application's capacity needs. Use the DynamoDB table to perform all read and write operations by using DynamoDB APIs. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Create an Amazon DynamoDB table that has provisioned capacity to meet the application's capacity needs. Use the DynamoDB table to perform all read and write operations by using DynamoDB APIs.

Explanation

Amazon DynamoDB is a fully managed, serverless NoSQL database with single-digit millisecond latency and automatic scaling.

Topic 1 Β· Question 276

A company needs to store and analyze a large amount of IoT sensor data. The company needs to retain the data indefinitely. The company analyzes the data in an Amazon Redshift cluster. Which solution will meet these requirements MOST cost-effectively?

  • AStore the data in an Amazon S3 bucket in JSON format. Configure auto-copy data ingestion from the S3 bucket to the Redshift cluster.
  • BStore the data in an Amazon S3 bucket in Apache Parquet format. Configure query access through Amazon Redshift Spectrum. (correct answer)
  • CStore the data in an Amazon S3 bucket in JSON format. Configure query access through Amazon Redshift Spectrum.
  • DStore the data in an Amazon S3 bucket in Apache Parquet format. Configure auto-copy data ingestion from the S3 bucket to the Redshift cluster.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Store the data in an Amazon S3 bucket in Apache Parquet format. Configure query access through Amazon Redshift Spectrum.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. 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.

Topic 1 Β· Question 277

A company has an Amazon S3 based data lake. The data lake contains datasets that belong to multiple departments. The data lake ingests millions of customer records each day. A data engineer needs to design an access and storage solution that allows departments to access only the subset of the company's dataset that each department requires. The solution must follow the principle of least privilege. Which solution will meet these requirements with the LEAST operational effort?

  • ADefine IAM policies and IAM roles for each department. Specify the S3 access paths from the data lake that each team can access.
  • BSet up Amazon Redshift and Amazon Redshift Spectrum as the primary entry points for the data lake. Define an IAM role that Amazon Redshift can assume. Configure the IAM role to grant access to the data that is in Amazon S3.
  • CSet up AWS Lake Formation. Assign LF-Tags to AWS Glue Data Catalog resources. Enable Lake Formation tag-based access control (LF-TBAC). (correct answer)
  • DDeploy an Amazon RDS for PostgreSQL database that has the aws_s3 extension installed. Configure AWS Step Functions events to invoke an AWS Lambda function to sync the data lake with the database.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Set up AWS Lake Formation. Assign LF-Tags to AWS Glue Data Catalog resources. Enable Lake Formation tag-based access control (LF-TBAC).

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. AWS Lake Formation builds and secures data lakes quickly.

Topic 1 Β· Question 278

A healthcare company stores patient records in an on-premises MySQL database. The company creates an application to access the MySQL database. The company must enforce security protocols to protect the patient records. The company currently rotates database credentials every 30 days to minimize the risk of unauthorized access. The company wants a solution that does require the company to modify the application code for each credential rotation. Which solution will meet this requirement with the LEAST operational overhead?

  • AAssign an IAM role access permissions to the database. Configure the application to obtain temporary credentials through the IAM role.
  • BUse AWS Key Management Service (AWS KMS) to generate encryption keys. Configure automatic key rotation. Store the encrypted credentials in an Amazon DynamoDB table.
  • CUse AWS Secrets Manager to automatically rotate credentials. Allow the application to retrieve the credentials by using API calls. (correct answer)
  • DStore credentials in an encrypted Amazon S3 bucket. Rotate the credentials every month by using an S3 Lifecycle policy. Use bucket policies to control access.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use AWS Secrets Manager to automatically rotate credentials. Allow the application to retrieve the credentials by using API calls.

Explanation

AWS Secrets Manager stores and automatically rotates secrets such as database credentials.

Topic 1 Β· Question 279

A retail company needs to implement a solution to capture data updates from multiple Amazon Aurora MySQL databases. The company needs to make the updates available for analytics in near real time. The solution must be serverless and require minimal maintenance. Which solution will meet these requirements with the LEAST operational overhead?

  • ASet up AWS Database Migration Service (AWS DMS) tasks that perform schema conversions for each database. Load the changes into Amazon Redshift Serverless.
  • BUse Amazon Managed Streaming for Apache Kafka (Amazon MSK) Connect with Debezium connectors to load data into Amazon Redshift Serverless.
  • CUse AWS Database Migration Service (AWS DMS) to set up binary log replication to Amazon Kinesis Data Streams. Load the data into Amazon Redshift Serverless after schema conversion.
  • DUse Aurora zero-ETL integrations with Amazon Redshift Serverless for each database to load Aurora MySQL changes in Amazon Redshift Serverless. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use Aurora zero-ETL integrations with Amazon Redshift Serverless for each database to load Aurora MySQL changes in Amazon Redshift Serverless.

Explanation

Amazon Aurora is a high-performance managed relational database with built-in replication and failover. Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries.

Topic 1 Β· Question 280

A data engineer is writing a query to join two tables in Amazon Athena. The data engineer needs to choose the correct join order for the tables to optimize query performance. Which solution will meet these requirements?

  • ASpecify the smaller table on the left side of the join and the larger table on the right side of the join.
  • BSpecify the larger table on the left side of the join and the smaller table on the right side of the join. (correct answer)
  • CUse AWS Glue to pre-process the tables before performing the join.
  • DUse table statistics to automatically determine the join order.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Specify the larger table on the left side of the join and the smaller table on the right side of the join.

Showing questions 261–280 of 313 Β· Page 14 of 16