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

A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company's existing analytics platform. The company wants to minimize the effort and time required...

May 8, 2025 No Comments READ MORE +

Which solution will meet these requirements in the MOST operationally efficient way?

A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joins...

May 7, 2025 No Comments READ MORE +

Which solution will capture the changed data MOST cost-effectively?

A company uses Amazon S3 to store semi-structured data in a transactional data lake. Some of the data files are small, but other data files are tens of terabytes. A data engineer must perform a change data capture (CDC) operation to identify changed data from the data source. The data...

May 6, 2025 No Comments READ MORE +

Which solution will meet these requirements MOST cost-effectively?

A data engineer must ingest a source of structured data that is in .csv format into an Amazon S3 data lake. The .csv files contain 15 columns. Data analysts need to run Amazon Athena queries on one or two columns of the dataset. The data analysts rarely query the entire...

May 5, 2025 No Comments READ MORE +

Which actions will provide the FASTEST queries?

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3. Which actions will provide the FASTEST queries? (Choose two.)A ....

May 1, 2025 No Comments READ MORE +

Which combination of tasks will meet these requirements with the LEAST operational overhead?

A data engineer is building a data pipeline on AWS by using AWS Glue extract, transform, and load (ETL) jobs. The data engineer needs to process data from Amazon RDS and MongoDB, perform transformations, and load the transformed data into Amazon Redshift for analytics. The data updates must occur every...

May 1, 2025 No Comments READ MORE +

Which solution will meet this requirement?

A company uses an Amazon Redshift cluster that runs on RA3 nodes. The company wants to scale read and write capacity to meet demand. A data engineer needs to identify a solution that will turn on concurrency scaling. Which solution will meet this requirement?A . Turn on concurrency scaling in...

April 29, 2025 No Comments READ MORE +

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

A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that...

April 28, 2025 No Comments READ MORE +

Which solution will meet these requirements?

A company has a production AWS account that runs company workloads. The company's security team created a security AWS account to store and analyze security logs from the production AWS account. The security logs in the production AWS account are stored in Amazon CloudWatch Logs. The company needs to use...

April 27, 2025 No Comments READ MORE +

Which combination of steps will meet this requirement with the LEAST operational overhead?

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance. The developer needs to give the Lambda function the ability...

April 26, 2025 No Comments READ MORE +