{"id":13521,"date":"2026-09-16T09:29:04","date_gmt":"2026-09-16T09:29:04","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=13521"},"modified":"2026-09-16T09:29:04","modified_gmt":"2026-09-16T09:29:04","slug":"amazon-aws-certified-data-engineer-associate-dea-c01-practice-test-questions-and-exam-dumps-part-4-q61-80","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/amazon-aws-certified-data-engineer-associate-dea-c01-practice-test-questions-and-exam-dumps-part-4-q61-80\/","title":{"rendered":"Amazon AWS Certified Data Engineer &#8211; Associate DEA-C01 Practice Test Questions and Exam Dumps Part 4 Q61-80"},"content":{"rendered":"<h1><\/h1>\n<h2><b>View Full <\/b><a href=\"https:\/\/www.examlabs.com\/aws-certified-data-engineer-associate-dea-c01-exam-dumps\"><b>Amazon AWS Certified Data Engineer &#8211; Associate DEA-C01 Exam Dumps<\/b><\/a><b> and Practice Test Dumps.<\/b><\/h2>\n<p>&nbsp;<\/p>\n<h3><b>Question 61<\/b><\/h3>\n<p><b>A company needs to process a large number of records continuously as they arrive and wants to retain the records for later consumption by multiple applications. Which AWS service is most appropriate?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Athena<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon RDS<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Kinesis Data Streams<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Redshift<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Amazon Kinesis Data Streams is designed to collect and retain real-time streaming data for consumption by multiple applications or services. Producers can continuously send records to a stream, while different consumers can independently process those records. This makes Kinesis Data Streams useful for real-time analytics, application monitoring, log processing, and event-driven workloads. Amazon Athena is primarily used to query data, RDS provides relational database capabilities, and Redshift is a data warehouse designed for analytical workloads. Therefore, Kinesis Data Streams is the best choice when an organization needs to continuously ingest records and make them available for multiple downstream consumers.<\/span><\/p>\n<h3><b>Question 62<\/b><\/h3>\n<p><b>A data engineer wants to prevent an AWS Glue ETL job from accessing resources that are not required for its processing. Which security principle should be followed?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Least privilege<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Maximum availability<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Horizontal scaling<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data duplication<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The principle of least privilege requires granting users, applications, and services only the permissions they need to perform their specific tasks. For an AWS Glue ETL job, the associated IAM role should provide access only to the required S3 buckets, databases, tables, or other resources. This limits the potential impact if credentials or the workload are compromised. Maximum availability focuses on system uptime, horizontal scaling concerns resource capacity, and data duplication involves creating additional copies of information. Therefore, least privilege is the correct security principle for restricting an ETL job&#8217;s access to only the resources necessary for its operation.<\/span><\/p>\n<h3><b>Question 63<\/b><\/h3>\n<p><b>A company needs to create a table definition for data stored in Amazon S3 so that Amazon Athena can query the data. Which component provides the required metadata?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon CloudWatch<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Glue Data Catalog<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon SQS<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS KMS<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The AWS Glue Data Catalog stores metadata such as table names, column definitions, data types, partitions, and S3 locations. Amazon Athena can use this catalog metadata to understand the structure of datasets stored in Amazon S3 and execute SQL queries against them. CloudWatch is used for monitoring, SQS provides message queuing, and AWS KMS manages encryption keys. Therefore, the AWS Glue Data Catalog provides the metadata required by Athena to query S3-based datasets. Data engineers can populate the catalog manually or use AWS Glue Crawlers to automatically discover schemas from supported data sources.<\/span><\/p>\n<h3><b>Question 64<\/b><\/h3>\n<p><b>A data engineer needs to transform raw JSON data into Parquet format before storing the processed data in Amazon S3. Which service can perform this transformation as part of an ETL pipeline?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Route 53<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon CloudFront<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Glue<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon SQS<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">AWS Glue provides managed ETL capabilities that can read data from sources such as Amazon S3, apply transformations, and write the resulting data in another format or location. A Glue ETL job can transform raw JSON data into Parquet and store the processed output back in Amazon S3. Using Parquet can improve analytical query efficiency because it is a columnar format. Route 53 provides DNS services, CloudFront provides content delivery, and SQS provides asynchronous messaging. Therefore, AWS Glue is the most appropriate service for transforming JSON data into Parquet as part of a managed ETL pipeline.<\/span><\/p>\n<h3><b>Question 65<\/b><\/h3>\n<p><b>A company wants to keep frequently queried data in memory to reduce query latency for an application. Which AWS service is designed for this purpose?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon ElastiCache<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon S3 Glacier<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Glue<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Athena<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Amazon ElastiCache provides managed in-memory caching using technologies such as Redis and Memcached. Keeping frequently accessed data in memory can significantly reduce latency compared with retrieving the same information from a persistent database or storage system. This makes ElastiCache useful for applications that require fast access to frequently requested data. S3 Glacier is designed for archival storage, AWS Glue provides data integration and ETL capabilities, and Athena is used for SQL queries against data sources such as Amazon S3. Therefore, Amazon ElastiCache is the appropriate service when an application needs low-latency access to frequently queried data stored in memory.<\/span><\/p>\n<h3><b>Question 66<\/b><\/h3>\n<p><b>A data engineer wants to ensure that a pipeline can identify when a processing job has failed and investigate the cause later. Which capability is most important?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Disabling logs<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Logging and monitoring<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Removing error handling<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Increasing storage replication only<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Logging and monitoring are essential for identifying pipeline failures and understanding their causes. Logs can provide detailed information about processing steps, errors, warnings, and application behavior, while monitoring systems can track metrics and trigger alerts when predefined conditions occur. AWS services such as Amazon CloudWatch can collect logs and metrics from many workloads and provide alarms for operational conditions. Disabling logs makes troubleshooting more difficult, removing error handling reduces reliability, and storage replication alone does not provide pipeline observability. Therefore, implementing appropriate logging and monitoring is critical for detecting failures, investigating issues, and maintaining reliable data processing workflows.<\/span><\/p>\n<h3><b>Question 67<\/b><\/h3>\n<p><b>A company has data stored in Amazon S3 that is accessed unpredictably. The company wants to automatically optimize storage costs based on changing access patterns. Which storage class should be considered?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Glacier Deep Archive<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Standard<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Intelligent-Tiering<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 One Zone-IA<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">S3 Intelligent-Tiering is designed for data with changing or unknown access patterns. It automatically moves objects between appropriate access tiers based on their access behavior, helping reduce storage costs without requiring the data engineer to manually determine when objects should transition. S3 Standard is suitable for frequently accessed data, Glacier Deep Archive is intended for long-term archival workloads, and One Zone-IA is intended for infrequently accessed data that can tolerate storage in a single Availability Zone. Therefore, S3 Intelligent-Tiering is the most appropriate choice when access patterns are unpredictable and automatic cost optimization is desired.<\/span><\/p>\n<h3><b>Question 68<\/b><\/h3>\n<p><b>A data engineer needs to execute a function automatically whenever a new file is uploaded to an Amazon S3 bucket. Which AWS service can provide the serverless compute capability?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Redshift<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Lambda<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon RDS<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon EBS<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">AWS Lambda provides serverless compute that can execute code in response to events. Amazon S3 can generate object-created events when new files are uploaded, and those events can trigger a Lambda function automatically. This allows data engineers to build event-driven processing pipelines without managing servers. The Lambda function could validate the file, transform metadata, initiate an ETL process, or perform another required action. Amazon Redshift and RDS are database services, while EBS provides block storage. Therefore, AWS Lambda is the appropriate service when custom code needs to execute automatically in response to new objects arriving in an S3 bucket.<\/span><\/p>\n<h3><b>Question 69<\/b><\/h3>\n<p><b>A company wants to analyze historical data while ensuring that only the necessary columns are read from a large analytical dataset. Which file format is best suited for this workload?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">CSV<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">XML<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">JSON<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Apache Parquet<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Apache Parquet is a columnar file format designed for efficient analytical workloads. Because data is stored by column, query engines can read only the columns needed by a query rather than scanning the complete dataset. This can reduce data scanned, improve query performance, and lower costs when using services such as Amazon Athena. CSV, JSON, and XML are not generally optimized for column-level analytical access in the same way. Therefore, Apache Parquet is the best choice when a data engineer needs to analyze large datasets while minimizing the amount of unnecessary data read during analytical queries.<\/span><\/p>\n<h3><b>Question 70<\/b><\/h3>\n<p><b>A data engineer needs to orchestrate a workflow that includes AWS Lambda, AWS Glue, and Amazon EMR tasks with retries and conditional branching. Which AWS service should be used?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Step Functions<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon S3<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Athena<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon CloudFront<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">AWS Step Functions is a serverless workflow orchestration service that can coordinate multiple AWS services and application components. It supports sequential and parallel execution, conditional branching, retries, error handling, and state management. This makes it suitable for complex data workflows involving services such as Lambda, AWS Glue, and Amazon EMR. Amazon S3 provides object storage, Athena provides serverless SQL querying, and CloudFront provides content delivery. Therefore, AWS Step Functions is the most appropriate service for orchestrating multiple data processing tasks while providing workflow control, retries, and conditional execution.<\/span><\/p>\n<h3><b>Question 71<\/b><\/h3>\n<p><b>A company wants to reduce the amount of data scanned by Amazon Athena by storing data in smaller logical groups based on a frequently filtered column. Which technique should be used?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Replication<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Partitioning<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Encryption<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tokenization<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Partitioning divides a dataset into separate logical portions based on one or more columns, such as date, region, or department. When queries filter on the partition key, Amazon Athena can use partition pruning to avoid scanning unrelated partitions. This can reduce the amount of data scanned and improve query performance while lowering query costs. Replication creates additional copies of data, encryption protects information, and tokenization replaces sensitive values with tokens. Therefore, partitioning is the appropriate technique when a data engineer wants to organize large S3 datasets into logical groups and allow Athena to efficiently process only the relevant data.<\/span><\/p>\n<h3><b>Question 72<\/b><\/h3>\n<p><b>A data engineer wants to make a data pipeline resilient to temporary network or service failures. Which approach is recommended?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use retry mechanisms with appropriate backoff<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Disable all monitoring<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Remove error handling<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Store credentials in source code<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Retry mechanisms with appropriate backoff can make data pipelines more resilient to temporary failures. Services can occasionally experience transient errors, throttling, or temporary network problems. Instead of immediately failing the entire pipeline, a workflow can retry an operation after waiting for a defined period. Exponential backoff can help avoid repeatedly overwhelming a service during an incident. Disabling monitoring reduces visibility, removing error handling decreases reliability, and storing credentials in source code creates security risks. Therefore, controlled retries with suitable backoff are an important reliability technique for handling temporary failures in data processing pipelines.<\/span><\/p>\n<h3><b>Question 73<\/b><\/h3>\n<p><b>A company wants to continuously replicate changes from a source database to a target database after an initial full data migration. Which AWS DMS capability should be used?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Static snapshots<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Change data capture<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Manual exports<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 lifecycle policies<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">AWS Database Migration Service supports Change Data Capture, commonly known as CDC, which allows ongoing changes made to a source database to be captured and replicated to a target. This is useful after an initial full load because new inserts, updates, and deletes can continue to be transferred while the source system remains operational. Static snapshots do not continuously replicate changes, manual exports require repeated intervention, and S3 lifecycle policies manage object transitions rather than database replication. Therefore, Change Data Capture is the appropriate capability when a data engineer needs to keep the target database synchronized with changes occurring in the source.<\/span><\/p>\n<h3><b>Question 74<\/b><\/h3>\n<p><b>A data engineer needs to query a large dataset stored in Amazon S3 and wants to avoid managing any servers or database infrastructure. Which service is most appropriate?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon EC2<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon RDS<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Athena<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Neptune<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Amazon Athena is a serverless query service that allows users to analyze data stored directly in Amazon S3 using SQL. It does not require users to provision, configure, or maintain database servers or clusters. This makes Athena particularly useful for ad hoc analysis, data lake queries, and exploratory workloads. Amazon EC2 requires management of virtual compute instances, RDS provides managed relational databases, and Neptune is designed for graph databases. Therefore, Amazon Athena is the most appropriate service when a data engineer needs to query S3-based datasets using SQL without managing underlying server infrastructure.<\/span><\/p>\n<h3><b>Question 75<\/b><\/h3>\n<p><b>A company wants to identify unusual activity and potential threats in its AWS environment. Which AWS service is designed for threat detection?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon GuardDuty<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Athena<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Glue<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon QuickSight<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Amazon GuardDuty is a managed threat detection service that continuously monitors supported AWS data sources and identifies suspicious or potentially malicious activity. It can help detect issues such as unusual API activity, compromised credentials, and certain network-based threats. Athena is used for querying data, Glue provides data integration and ETL capabilities, and QuickSight provides business intelligence and visualization. Therefore, Amazon GuardDuty is the appropriate service when an organization needs continuous monitoring for potential security threats within its AWS environment. GuardDuty findings can also be integrated with other security and response services for further investigation and automated remediation.<\/span><\/p>\n<h3><b>Question 76<\/b><\/h3>\n<p><b>A data engineer needs to store metadata about a dataset, including its schema and S3 location, and make that metadata available to Athena. Which AWS service should be used?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon CloudWatch<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Glue Data Catalog<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Kinesis Data Streams<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS CloudTrail<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">AWS Glue Data Catalog stores metadata about datasets, including table definitions, column names, data types, partition information, and the physical location of data such as an Amazon S3 path. Amazon Athena can use this catalog metadata to interpret the underlying dataset and execute SQL queries. CloudWatch provides monitoring and logging, Kinesis Data Streams handles real-time streaming data, and CloudTrail records AWS API activity. Therefore, AWS Glue Data Catalog is the correct service for storing and sharing dataset metadata with Athena and other AWS analytics services.<\/span><\/p>\n<h3><b>Question 77<\/b><\/h3>\n<p><b>A company wants to automatically delete temporary files from an Amazon S3 bucket after a specific number of days. Which feature should be configured?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Object Lock<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Lifecycle rule<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Transfer Acceleration<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Access Point<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Amazon S3 Lifecycle rules can automatically transition or expire objects based on conditions such as object age. A lifecycle rule can be configured to delete temporary files after a specified number of days, helping organizations control storage usage and costs without manually deleting objects. S3 Object Lock is designed to prevent protected objects from being deleted or modified during retention periods. Transfer Acceleration improves data transfer speeds, while Access Points provide specialized access controls for S3 data. Therefore, an S3 Lifecycle rule is the appropriate feature when temporary objects need to be automatically deleted after a defined period.<\/span><\/p>\n<h3><b>Question 78<\/b><\/h3>\n<p><b>A data engineer needs to store data in Amazon S3 with high durability and frequent access for analytical processing. Which storage class is generally appropriate?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Glacier Deep Archive<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Standard<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 One Zone-IA<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S3 Glacier Flexible Retrieval<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">S3 Standard is designed for frequently accessed data and provides high durability and availability. It is generally appropriate for datasets that are actively used by analytics applications, data processing pipelines, and other workloads requiring regular access. Glacier storage classes are optimized for archival data with less frequent retrieval, while S3 One Zone-IA is designed for infrequently accessed data stored in a single Availability Zone. Since the requirement specifies frequent access for analytical processing, S3 Standard is the most appropriate storage class. Storage class selection should always consider access frequency, retrieval requirements, durability, availability, and overall storage cost.<\/span><\/p>\n<h3><b>Question 79<\/b><\/h3>\n<p><b>A company wants to provide analysts with controlled access to specific tables and columns in a data lake. Which AWS service provides centralized fine-grained data lake permissions?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon CloudFront<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon SQS<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS Lake Formation<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon ElastiCache<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">AWS Lake Formation provides centralized governance and access management capabilities for data lakes. It can help organizations define fine-grained permissions for data lake resources, including databases, tables, and columns. This allows organizations to provide analysts with access to only the data they are authorized to use while maintaining centralized control. CloudFront is a content delivery service, SQS provides message queuing, and ElastiCache provides in-memory caching. Therefore, AWS Lake Formation is the most appropriate service when a company needs centralized, fine-grained access control for data lake resources and wants to manage analyst permissions effectively.<\/span><\/p>\n<h3><b>Question 80<\/b><\/h3>\n<p><b>A data engineer wants to monitor the number of records processed by a data pipeline and trigger an alert when the value falls below an expected threshold. Which AWS service is appropriate?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS CloudTrail<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AWS KMS<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon CloudWatch<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Amazon Route 53<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Amazon CloudWatch can collect metrics and logs from AWS resources and applications and can create alarms based on defined thresholds. A data pipeline can publish or expose a metric representing the number of processed records, and a CloudWatch alarm can trigger when the value falls below an expected level. CloudTrail records API activity, KMS manages encryption keys, and Route 53 provides DNS services. Therefore, CloudWatch is the appropriate service for monitoring pipeline metrics and triggering alerts when processing activity falls below a predefined threshold. This type of monitoring can help data engineers detect incomplete processing and investigate pipeline problems quickly.<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>View Full Amazon AWS Certified Data Engineer &#8211; Associate DEA-C01 Exam Dumps and Practice Test Dumps. &nbsp; Question 61 A company needs to process a large number of records continuously as they arrive and wants to retain the records for later consumption by multiple applications. Which AWS service is most appropriate? Amazon Athena Amazon RDS [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13521"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=13521"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13521\/revisions"}],"predecessor-version":[{"id":13554,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13521\/revisions\/13554"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=13521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=13521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=13521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}