Which combination of steps should the data engineering team take to meet this requirement with the LEAST operational overhead?

A company has five offices in different AWS Regions. Each office has its own human resources (HR) department that uses a unique IAM role. The company stores employee records in a data lake that is based on Amazon S3 storage. A data engineering team needs to limit access to the...

February 23, 2025 No Comments READ MORE +

Which extract, transform, and load (ETL) service will meet these requirements?

A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options. The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The...

February 18, 2025 No Comments READ MORE +

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

A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application. Which solution will meet these requirements with the LEAST...

February 13, 2025 No Comments READ MORE +

Which combination of steps will meet these requirements MOST cost-effectively?

A data engineer must orchestrate a series of Amazon Athena queries that will run every day. Each query can run for more than 15 minutes. Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)A . Use an AWS Lambda function and the Athena Boto3 client start_query_execution API...

February 9, 2025 No Comments READ MORE +

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 +