πŸ”

DEA-C01 β€” questions

Page 9 of 16 Β· 313 total questions.

Topic 1 Β· Question 161

A company uses Amazon Redshift as its data warehouse service. A data engineer needs to design a physical data model. The data engineer encounters a de-normalized table that is growing in size. The table does not have a suitable column to use as the distribution key. Which distribution style should the data engineer use to meet these requirements with the LEAST maintenance overhead?

  • AALL distribution
  • BEVEN distribution
  • CAUTO distribution (correct answer)
  • DKEY distribution
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: AUTO distribution.

Topic 1 Β· Question 162

A retail company is expanding its operations globally. The company needs to use Amazon QuickSight to accurately calculate currency exchange rates for financial reports. The company has an existing dashboard that includes a visual that is based on an analysis of a dataset that contains global currency values and exchange rates. A data engineer needs to ensure that exchange rates are calculated with a precision of four decimal places. The calculations must be precomputed. The data engineer must materialize results in QuickSight super-fast, parallel, in-memory calculation engine (SPICE). Which solution will meet these requirements?

  • ADefine and create the calculated field in the dataset. (correct answer)
  • BDefine and create the calculated field in the analysis.
  • CDefine and create the calculated field in the visual.
  • DDefine and create the calculated field in the dashboard.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Define and create the calculated field in the dataset.

Topic 1 Β· Question 163

A company has three subsidiaries. Each subsidiary uses a different data warehousing solution. The first subsidiary hosts its data warehouse in Amazon Redshift. The second subsidiary uses Teradata Vantage on AWS. The third subsidiary uses Google BigQuery. The company wants to aggregate all the data into a central Amazon S3 data lake. The company wants to use Apache Iceberg as the table format. A data engineer needs to build a new pipeline to connect to all the data sources, run transformations by using each source engine, join the data, and write the data to Iceberg. Which solution will meet these requirements with the LEAST operational effort?

  • AUse native Amazon Redshift, Teradata, and BigQuery connectors to build the pipeline in AWS Glue. Use native AWS Glue transforms to join the data. Run a Merge operation on the data lake Iceberg table.
  • BUse the Amazon Athena federated query connectors for Amazon Redshift, Teradata, and BigQuery to build the pipeline in Athena. Write a SQL query to read from all the data sources, join the data, and run a Merge operation on the data lake Iceberg table. (correct answer)
  • CUse the native Amazon Redshift connector, the Java Database Connectivity (JDBC) connector for Teradata, and the open source Apache Spark BigQuery connector to build the pipeline in Amazon EMR. Write code in PySpark to join the data. Run a Merge operation on the data lake Iceberg table.
  • DUse the native Amazon Redshift, Teradata, and BigQuery connectors in Amazon Appflow to write data to Amazon S3 and AWS Glue Data Catalog. Use Amazon Athena to join the data. Run a Merge operation on the data lake Iceberg table.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use the Amazon Athena federated query connectors for Amazon Redshift, Teradata, and BigQuery to build the pipeline in Athena. Write a SQL query to read from all the data sources, join the data, and run a Merge operati...

Explanation

Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage.

Topic 1 Β· Question 164

A company is building a data stream processing application. The application runs in an Amazon Elastic Kubernetes Service (Amazon EKS) cluster. The application stores processed data in an Amazon DynamoDB table. The company needs the application containers in the EKS cluster to have secure access to the DynamoDB table. The company does not want to embed AWS credentials in the containers. Which solution will meet these requirements?

  • AStore the AWS credentials in an Amazon S3 bucket. Grant the EKS containers access to the S3 bucket to retrieve the credentials.
  • BAttach an IAM role to the EKS worker nodes, Grant the IAM role access to DynamoDUse the IAM role to set up IAM roles service accounts (IRSA) functionality. (correct answer)
  • CCreate an IAM user that has an access key to access the DynamoDB table. Use environment variables in the EKS containers to store the IAM user access key data.
  • DCreate an IAM user that has an access key to access the DynamoDB table. Use Kubernetes secrets that are mounted in a volume of the EKS duster nodes to store the user access key data.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Attach an IAM role to the EKS worker nodes, Grant the IAM role access to DynamoDUse the IAM role to set up IAM roles service accounts (IRSA) functionality.

Explanation

Amazon EKS runs managed Kubernetes when you need the Kubernetes ecosystem. 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.

Topic 1 Β· Question 165

A data engineer needs to onboard a new data producer into AWS. The data producer needs to migrate data products to AWS. The data producer maintains many data pipelines that support a business application. Each pipeline must have service accounts and their corresponding credentials. The data engineer must establish a secure connection from the data producer's on-premises data center to AWS. The data engineer must not use the public internet to transfer data from an on-premises data center to AWS. Which solution will meet these requirements?

  • AInstruct the new data producer to create Amazon Machine Images (AMIs) on Amazon Elastic Container Service (Amazon ECS) to store the code base of the application. Create security groups in a public subnet that allow connections only to the on-premises data center.
  • BCreate an AWS Direct Connect connection to the on-premises data center. Store the service account credentials in AWS Secrets manager. (correct answer)
  • CCreate a security group in a public subnet. Configure the security group to allow only connections from the CIDR blocks that correspond to the data producer. Create Amazon S3 buckets than contain presigned URLS that have one-day expiration dates.
  • DCreate an AWS Direct Connect connection to the on-premises data center. Store the application keys in AWS Secrets Manager. Create Amazon S3 buckets that contain presigned URLS that have one-day expiration dates.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create an AWS Direct Connect connection to the on-premises data center. Store the service account credentials in AWS Secrets manager.

Explanation

AWS Direct Connect provides a dedicated, consistent private network link between on premises and AWS. AWS Secrets Manager stores and automatically rotates secrets such as database credentials.

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

A data engineer configured an AWS Glue Data Catalog for data that is stored in Amazon S3 buckets. The data engineer needs to configure the Data Catalog to receive incremental updates. The data engineer sets up event notifications for the S3 bucket and creates an Amazon Simple Queue Service (Amazon SQS) queue to receive the S3 events. Which combination of steps should the data engineer take to meet these requirements with LEAST operational overhead? (Choose two.)

  • ACreate an S3 event-based AWS Glue crawler to consume events from the SQS queue. (correct answer)
  • BDefine a time-based schedule to run the AWS Glue crawler, and perform incremental updates to the Data Catalog.
  • CUse an AWS Lambda function to directly update the Data Catalog based on S3 events that the SQS queue receives. (correct answer)
  • DManually initiate the AWS Glue crawler to perform updates to the Data Catalog when there is a change in the S3 bucket.
  • EUse AWS Step Functions to orchestrate the process of updating the Data Catalog based on S3 events that the SQS queue receives.
Reveal answer & explanation
Correct answer: A, C

The correct answer is A, C. Option A: Create an S3 event-based AWS Glue crawler to consume events from the SQS queue. Option C: Use an AWS Lambda function to directly update the Data Catalog based on S3 events that the SQS queue receives.

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 SQS is a fully managed message queue that decouples components and absorbs traffic spikes.

Topic 1 Β· Question 167

A company uses AWS Glue Data Catalog to index data that is uploaded to an Amazon S3 bucket every day. The company uses a daily batch processes in an extract, transform, and load (ETL) pipeline to upload data from external sources into the S3 bucket. The company runs a daily report on the S3 data. Some days, the company runs the report before all the daily data has been uploaded to the S3 bucket. A data engineer must be able to send a message that identifies any incomplete data to an existing Amazon Simple Notification Service (Amazon SNS) topic. Which solution will meet this requirement with the LEAST operational overhead?

  • ACreate data quality checks for the source datasets that the daily reports use. Create a new AWS managed Apache Airflow cluster. Run the data quality checks by using Airflow tasks that run data quality queries on the columns data type and the presence of null values. Configure Airflow Directed Acyclic Graphs (DAGs) to send an email notification that informs the data engineer about the incomplete datasets to the SNS topic.
  • BCreate data quality checks on the source datasets that the daily reports use. Create a new Amazon EMR cluster. Use Apache Spark SQL to create Apache Spark jobs in the EMR cluster that run data quality queries on the columns data type and the presence of null values. Orchestrate the ETL pipeline by using an AWS Step Functions workflow. Configure the workflow to send an email notification that informs the data engineer about the incomplete datasets to the SNS topic.
  • CCreate data quality checks on the source datasets that the daily reports use. Create data quality actions by using AWS Glue workflows to confirm the completeness and consistency of the datasets. Configure the data quality actions to create an event in Amazon EventBridge if a dataset is incomplete. Configure EventBridge to send the event that informs the data engineer about the incomplete datasets to the Amazon SNS topic. (correct answer)
  • DCreate AWS Lambda functions that run data quality queries on the columns data type and the presence of null values. Orchestrate the ETL pipeline by using an AWS Step Functions workflow that runs the Lambda functions. Configure the Step Functions workflow to send an email notification that informs the data engineer about the incomplete datasets to the SNS topic.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create data quality checks on the source datasets that the daily reports use. Create data quality actions by using AWS Glue workflows to confirm the completeness and consistency of the datasets. Configure the data qua...

Explanation

Amazon SNS is a managed pub/sub service for fan-out notifications to many subscribers. Amazon EventBridge routes events between services with rules, enabling event-driven, decoupled architectures. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

Topic 1 Β· Question 168

A company stores customer data that contains personally identifiable information (PII) in an Amazon Redshift cluster. The company's marketing, claims, and analytics teams need to be able to access the customer data. The marketing team should have access to obfuscated claim information but should have full access to customer contact information. The claims team should have access to customer information for each claim that the team processes. The analytics team should have access only to obfuscated PII data. Which solution will enforce these data access requirements with the LEAST administrative overhead?

  • ACreate a separate Redshift cluster for each team. Load only the required data for each team. Restrict access to clusters based on the teams.
  • BCreate views that include required fields for each of the data requirements. Grant the teams access only to the view that each team requires.
  • CCreate a separate Amazon Redshift database role for each team. Define masking policies that apply for each team separately. Attach appropriate masking policies to each team role. (correct answer)
  • DMove the customer data to an Amazon S3 bucket. Use AWS Lake Formation to create a data lake. Use fine-grained security capabilities to grant each team appropriate permissions to access the data.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a separate Amazon Redshift database role for each team. Define masking policies that apply for each team separately. Attach appropriate masking policies to each team role.

Explanation

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

Topic 1 Β· Question 169

A financial company recently added more features to its mobile app. The new features required the company to create a new topic in an existing Amazon Managed Streaming for Apache Kafka (Amazon MSK) cluster. A few days after the company added the new topic, Amazon CloudWatch raised an alarm on the RootDiskUsed metric for the MSK cluster. How should the company address the CloudWatch alarm?

  • AExpand the storage of the MSK broker. Configure the MSK cluster storage to expand automatically. (correct answer)
  • BExpand the storage of the Apache ZooKeeper nodes.
  • CUpdate the MSK broker instance to a larger instance type. Restart the MSK cluster.
  • DSpecify the Target Volume-in-GiB parameter for the existing topic.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Expand the storage of the MSK broker. Configure the MSK cluster storage to expand automatically.

Explanation

Amazon MSK provides fully managed Apache Kafka for streaming. AWS Config tracks resource configuration changes and evaluates compliance. This option meets the real-time / low-latency performance requirement.

Topic 1 Β· Question 170

A data engineer needs to build an enterprise data catalog based on the company's Amazon S3 buckets and Amazon RDS databases. The data catalog must include storage format metadata for the data in the catalog. Which solution will meet these requirements with the LEAST effort?

  • AUse an AWS Glue crawler to scan the S3 buckets and RDS databases and build a data catalog. Use data stewards to inspect the data and update the data catalog with the data format.
  • BUse an AWS Glue crawler to build a data catalog. Use AWS Glue crawler classifiers to recognize the format of data and store the format in the catalog. (correct answer)
  • CUse Amazon Macie to build a data catalog and to identify sensitive data elements. Collect the data format information from Macie.
  • DUse scripts to scan data elements and to assign data classifications based on the format of the data.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use an AWS Glue crawler to build a data catalog. Use AWS Glue crawler classifiers to recognize the format of data and store the format in the catalog.

Explanation

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

Topic 1 Β· Question 171

A company analyzes data in a data lake every quarter to perform inventory assessments. A data engineer uses AWS Glue DataBrew to detect any personally identifiable formation (PII) about customers within the data. The company's privacy policy considers some custom categories of information to be PII. However, the categories are not included in standard DataBrew data quality rules. The data engineer needs to modify the current process to scan for the custom PII categories across multiple datasets within the data lake. Which solution will meet these requirements with the LEAST operational overhead?

  • AManually review the data for custom PII categories.
  • BImplement custom data quality rules in DataBrew. Apply the custom rules across datasets. (correct answer)
  • CDevelop custom Python scripts to detect the custom PII categories. Call the scripts from DataBrew.
  • DImplement regex patterns to extract PII information from fields during extract transform, and load (ETL) operations into the data lake.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Implement custom data quality rules in DataBrew. Apply the custom rules across datasets.

Topic 1 Β· Question 172

A company receives a data file from a partner each day in an Amazon S3 bucket. The company uses a daily AWS Glue extract, transform, and load (ETL) pipeline to clean and transform each data file. The output of the ETL pipeline is written to a CSV file named Daily.csv in a second S3 bucket. Occasionally, the daily data file is empty or is missing values for required fields. When the file is missing data, the company can use the previous day’s CSV file. A data engineer needs to ensure that the previous day's data file is overwritten only if the new daily file is complete and valid. Which solution will meet these requirements with the LEAST effort?

  • AInvoke an AWS Lambda function to check the file for missing data and to fill in missing values in required fields.
  • BConfigure the AWS Glue ETL pipeline to use AWS Glue Data Quality rules. Develop rules in Data Quality Definition Language (DQDL) to check for missing values in required fields and empty files. (correct answer)
  • CUse AWS Glue Studio to change the code in the ETL pipeline to fill in any missing values in the required fields with the most common values for each field.
  • DRun a SQL query in Amazon Athena to read the CSV file and drop missing rows. Copy the corrected CSV file to the second S3 bucket.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Configure the AWS Glue ETL pipeline to use AWS Glue Data Quality rules. Develop rules in Data Quality Definition Language (DQDL) to check for missing values in required fields and empty files.

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 173

A marketing company uses Amazon S3 to store marketing data. The company uses versioning in some buckets. The company runs several jobs to read and load data into the buckets. To help cost-optimize its storage, the company wants to gather information about incomplete multipart uploads and outdated versions that are present in the S3 buckets. Which solution will meet these requirements with the LEAST operational effort?

  • AUse AWS CLI to gather the information.
  • BUse Amazon S3 Inventory configurations reports to gather the information.
  • CUse the Amazon S3 Storage Lens dashboard to gather the information. (correct answer)
  • DUse AWS usage reports for Amazon S3 to gather the information.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use the Amazon S3 Storage Lens dashboard to gather the information.

Explanation

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

Topic 1 Β· Question 174

A gaming company uses Amazon Kinesis Data Streams to collect clickstream data. The company uses Amazon Data Firehose delivery streams to store the data in JSON format in Amazon S3. Data scientists at the company use Amazon Athena to query the most recent data to obtain business insights. The company wants to reduce Athena costs but does not want to recreate the data pipeline. Which solution will meet these requirements with the LEAST management effort?

  • AChange the Firehose output format to Apache Parquet. Provide a custom S3 object YYYYMMDD prefix expression and specify a large buffer size. For the existing data, create an AWS Glue extract, transform, and load (ETL) job. Configure the ETL job to combine small JSON files, convert the JSON files to large Parquet files, and add the YYYYMMDD prefix. Use the ALTER TABLE ADD PARTITION statement to reflect the partition on the existing Athena table. (correct answer)
  • BCreate an Apache Spark job that combines JSON files and converts the JSON files to Apache Parquet files. Launch an Amazon EMR ephemeral cluster every day to run the Spark job to create new Parquet files in a different S3 location. Use the ALTER TABLE SET LOCATION statement to reflect the new S3 location on the existing Athena table.
  • CCreate a Kinesis data stream as a delivery destination for Firehose. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to run Apache Flink on the Kinesis data stream. Use Flink to aggregate the data and save the data to Amazon S3 in Apache Parquet format with a custom S3 object YYYYMMDD prefix. Use the ALTER TABLE ADD PARTITION statement to reflect the partition on the existing Athena table.
  • DIntegrate an AWS Lambda function with Firehose to convert source records to Apache Parquet and write them to Amazon S3. In parallel, run an AWS Glue extract, transform, and load (ETL) job to combine the JSON files and convert the JSON files to large Parquet files. Create a custom S3 object YYYYMMDD prefix. Use the ALTER TABLE ADD PARTITION statement to reflect the partition on the existing Athena table.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Change the Firehose output format to Apache Parquet. Provide a custom S3 object YYYYMMDD prefix expression and specify a large buffer size. For the existing data, create an AWS Glue extract, transform, and load (ETL)...

Explanation

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

Topic 1 Β· Question 175

A company needs a solution to manage costs for an existing Amazon DynamoDB table. The company also needs to control the size of the table. The solution must not disrupt any ongoing read or write operations. The company wants to use a solution that automatically deletes data from the table after 1 month. Which solution will meet these requirements with the LEAST ongoing maintenance?

  • AUse the DynamoDB TTL feature to automatically expire data based on timestamps. (correct answer)
  • BConfigure a scheduled Amazon EventBridge rule to invoke an AWS Lambda function to check for data that is older than 1 month. Configure the Lambda function to delete old data.
  • CConfigure a stream on the DynamoDB table to invoke an AWS Lambda function. Configure the Lambda function to delete data in the table that is older than 1 month.
  • DUse an AWS Lambda function to periodically scan the DynamoDB table for data that is older than 1 month. Configure the Lambda function to delete old data.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use the DynamoDB TTL feature to automatically expire data based on timestamps.

Explanation

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

Topic 1 Β· Question 176

A company uses Amazon S3 to store data and Amazon QuickSight to create visualizations, The company has an S3 bucket in an AWS account named Hub-Account. The S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. The company's QuickSight instance is in a separate account named BI-Account. The company updates the S3 bucket policy to grant access to the QuickSight service role. The company wants to enable cross-account access to allow QuickSight to interact with the S3 bucket. Which combination of steps will meet this requirement? (Choose two.)

  • AUse the existing AWS KMS key to encrypt connections from QuickSight to the S3 bucket.
  • BAdd the S3 bucket as a resource that the QuickSight service role can access.
  • CUse AWS Resource Access Manager (AWS RAM) to share the S3 bucket with the BI-Account account.
  • DAdd an IAM policy to the QuickSight service role to give QuickSight access to the KMS key that encrypts the S3 bucket.
  • EAdd the KMS key as a resource that the QuickSight service role can access. (correct answer)
Reveal answer & explanation
Correct answer: E

The correct answer is E. Option E: Add the KMS key as a resource that the QuickSight service role can access.

Explanation

Amazon QuickSight is a serverless business-intelligence and dashboard service. AWS KMS manages encryption keys and integrates with most AWS services for encryption at rest.

Topic 1 Β· Question 177

A car sales company maintains data about cars that are listed for sale in an area. The company receives data about new car listings from vendors who upload the data daily as compressed files into Amazon S3. The compressed files are up to 5 KB in size. The company wants to see the most up-to-date listings as soon as the data is uploaded to Amazon S3. A data engineer must automate and orchestrate the data processing workflow of the listings to feed a dashboard. The data engineer must also provide the ability to perform one-time queries and analytical reporting. The query solution must be scalable. Which solution will meet these requirements MOST cost-effectively?

  • AUse an Amazon EMR cluster to process incoming data. Use AWS Step Functions to orchestrate workflows. Use Apache Hive for one-time queries and analytical reporting. Use Amazon OpenSearch Service to bulk ingest the data into compute optimized instances. Use OpenSearch Dashboards in OpenSearch Service for the dashboard.
  • BUse a provisioned Amazon EMR cluster to process incoming data. Use AWS Step Functions to orchestrate workflows. Use Amazon Athena for one-time queries and analytical reporting. Use Amazon QuickSight for the dashboard.
  • CUse AWS Glue to process incoming data. Use AWS Step Functions to orchestrate workflows. Use Amazon Redshift Spectrum for one-time queries and analytical reporting. Use OpenSearch Dashboards in Amazon OpenSearch Service for the dashboard.
  • DUse AWS Glue to process incoming data. Use AWS Lambda and S3 Event Notifications to orchestrate workflows. Use Amazon Athena for one-time queries and analytical reporting. Use Amazon QuickSight for the dashboard. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use AWS Glue to process incoming data. Use AWS Lambda and S3 Event Notifications to orchestrate workflows. Use Amazon Athena for one-time queries and analytical reporting. Use Amazon QuickSight for the dashboard.

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 Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. This option delivers the requirement at the lowest cost.

Topic 1 Β· Question 178

A company has AWS resources in multiple AWS Regions. The company has an Amazon EFS file system in each Region where the company operates. The company’s data science team operates within only a single Region. The data that the data science team works with must remain within the team's Region. A data engineer needs to create a single dataset by processing files that are in each of the company's Regional EFS file systems. The data engineer wants to use an AWS Step Functions state machine to orchestrate AWS Lambda functions to process the data. Which solution will meet these requirements with the LEAST effort?

  • APeer the VPCs that host the EFS file systems in each Region with the VPC that is in the data science team’s Region. Enable EFS file locking. Configure the Lambda functions in the data science team's Region to mount each of the Region specific file systems. Use the Lambda functions to process the data.
  • BConfigure each of the Regional EFS file systems to replicate data to the data science team's Region. In the data science team’s Region, configure the Lambda functions to mount the replica file systems. Use the Lambda functions to process the data.
  • CDeploy the Lambda functions to each Region. Mount the Regional EFS file systems to the Lambda functions. Use the Lambda functions to process the data. Store the output in an Amazon S3 bucket in the data science team’s Region.
  • DUse AWS DataSync to transfer files from each of the Regional EFS files systems to the file system that is in the data science team's Region. Configure the Lambda functions in the data science team's Region to mount the file system that is in the same Region. Use the Lambda functions to process the data. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use AWS DataSync to transfer files from each of the Regional EFS files systems to the file system that is in the data science team's Region. Configure the Lambda functions in the data science team's Region to mount th...

Explanation

AWS Lambda runs code without provisioning servers and scales automatically, which minimizes operational overhead. Amazon EFS is a shared, elastic NFS file system that multiple instances can mount concurrently across AZs. AWS DataSync automates and accelerates online data transfer to AWS with minimal effort.

Topic 1 Β· Question 179

A company hosts its applications on Amazon EC2 instances. The company must use SSL/TLS connections that encrypt data in transit to communicate securely with AWS infrastructure that is managed by a customer. A data engineer needs to implement a solution to simplify the generation, distribution, and rotation of digital certificates. The solution must automatically renew and deploy SSL/TLS certificates. Which solution will meet these requirements with the LEAST operational overhead?

  • AStore self-managed certificates on the EC2 instances.
  • BUse AWS Certificate Manager (ACM). (correct answer)
  • CImplement custom automation scripts in AWS Secrets Manager.
  • DUse Amazon Elastic Container Service (Amazon ECS) Service Connect.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use AWS Certificate Manager (ACM).

Explanation

AWS Certificate Manager provisions and renews TLS certificates automatically.

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

A company saves customer data to an Amazon S3 bucket. The company uses server-side encryption with AWS KMS keys (SSE-KMS) to encrypt the bucket. The dataset includes personally identifiable information (PII) such as social security numbers and account details. Data that is tagged as PII must be masked before the company uses customer data for analysis. Some users must have secure access to the PII data during the pre-processing phase. The company needs a low-maintenance solution to mask and secure the PII data throughout the entire engineering pipeline. Which combination of solutions will meet these requirements? (Choose two.)

  • AUse AWS Glue DataBrew to perform extract, transform, and load (ETL) tasks that mask the PII data before analysis. (correct answer)
  • BUse Amazon GuardDuty to monitor access patterns for the PII data that is used in the engineering pipeline.
  • CConfigure an Amazon Macie discovery job for the S3 bucket.
  • DUse AWS Identity and Access Management (IAM) to manage permissions and to control access to the PII data. (correct answer)
  • EWrite custom scripts in an application to mask the PII data and to control access.
Reveal answer & explanation
Correct answer: A, D

The correct answer is A, D. Option A: Use AWS Glue DataBrew to perform extract, transform, and load (ETL) tasks that mask the PII data before analysis. Option D: Use AWS Identity and Access Management (IAM) to manage permissions and to control access to the PII data.

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. AWS IAM controls authenticated and authorized access to AWS resources with fine-grained policies.

Showing questions 161–180 of 313 Β· Page 9 of 16