Which solution will meet these requirements with the LEAST operational overhead?

A data engineer has a one-time task to read data from objects that are in Apache Parquet format in an Amazon S3 bucket. The data engineer needs to query only one column of the data. Which solution will meet these requirements with the LEAST operational overhead?A . Confiqure an AWS...

February 4, 2025 No Comments READ MORE +

Which AWS service should the data engineer use to transfer the data in the MOST operationally efficient way?

A data engineer needs to securely transfer 5 TB of data from an on-premises data center to an Amazon S3 bucket. Approximately 5% of the data changes every day. Updates to the data need to be regularly proliferated to the S3 bucket. The data includes files that are in multiple...

February 3, 2025 No Comments READ MORE +

Which solution will meet these requirements with the LOWEST latency?

A manufacturing company collects sensor data from its factory floor to monitor and enhance operational efficiency. The company uses Amazon Kinesis Data Streams to publish the data that the sensors collect to a data stream. Then Amazon Kinesis Data Firehose writes the data to an Amazon S3 bucket. The company...

February 3, 2025 No Comments READ MORE +

Which actions should the data engineer take to improve the performance of the AWS Glue jobs?

A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day. A data engineer discovers...

February 1, 2025 No Comments READ MORE +

Which combination of AWS services will implement a data mesh?

A financial company wants to implement a data mesh. The data mesh must support centralized data governance, data analysis, and data access control. The company has decided to use AWS Glue for data catalogs and extract, transform, and load (ETL) operations. Which combination of AWS services will implement a data...

February 1, 2025 No Comments READ MORE +

Which solution will meet these requirements with the LEAST operational overhead?

A company is planning to upgrade its Amazon Elastic Block Store (Amazon EBS) General Purpose SSD storage from gp2 to gp3. The company wants to prevent any interruptions in its Amazon EC2 instances that will cause data loss during the migration to the upgraded storage. Which solution will meet these...

January 30, 2025 No Comments READ MORE +

Which solution will MOST speed up the Athena query performance?

A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column. Which solution will MOST speed up...

January 27, 2025 No Comments READ MORE +

Which solution will meet this requirement with the LEAST operational effort?

A data engineer must use AWS services to ingest a dataset into an Amazon S3 data lake. The data engineer profiles the dataset and discovers that the dataset contains personally identifiable information (PII). The data engineer must implement a solution to profile the dataset and obfuscate the PII. Which solution...

January 24, 2025 No Comments READ MORE +

How should the data engineer invoke the Lambda function to write load statuses to the DynamoDB table?

A company loads transaction data for each day into Amazon Redshift tables at the end of each day. The company wants to have the ability to track which tables have been loaded and which tables still need to be loaded. A data engineer wants to store the load statuses of...

January 19, 2025 No Comments READ MORE +

Which solution will run the Glue jobs in the MOST cost-effective way?

A data engineer needs to schedule a workflow that runs a set of AWS Glue jobs every day. The data engineer does not require the Glue jobs to run or finish at a specific time. Which solution will run the Glue jobs in the MOST cost-effective way?A . Choose the...

January 18, 2025 No Comments READ MORE +