A telecommunications company collects network usage data throughout each day at a rate of several thousanddata points each second. The company runs an application to process the usage data in real time. Thecompany aggregates and stores the data in an Amazon Aurora DB instance.Sudden drops in network usage usually indicate a network outage. The company must be able to identifysudden drops in network usage so the company can take immediate remedial actions.Which solution will meet this requirement with the LEAST latency?

A Data Engineering Team is working on optimizing a complex query that involves numerous joins and aggregations on a large dataset. The dataset is stored in a graph data structure for which the relationships between entities are as crucial as the entities themselves.

The team is deciding on the most appropriate data structure or AWS service to use for this task to ensure both performance efficiency and query optimization. Which of the following should they consider?

As a Data Engineer, you are tasked with setting up a batch data ingestion pipeline for a substantial financial dataset. This data is currently housed in an Amazon RDS database, stemming from various financial services and trading platforms. The dataset is complex and heterogeneous, predominantly in JSON format, and is updated nightly, typically ranging between 100-200 GB.

Your primary objective is to efficiently transfer this data from the RDS database to a data lake in AWS, ensuring reliable storage and preparing the dataset for analytical processing with minimal yet capable transformation steps due to its complexity.

Which combination of AWS services would be most appropriate?

An organization's primary transaction processing system is powered by an Amazon RDS for PostgreSQL database. The workload is write-heavy, which is causing consistently high CPU utilization, leading to performance degradation of the system.

What measures should the data engineer implement to alleviate the CPU load on the RDS instance? (Select TWO.)

A Cloud Data Engineering Consultant has been tasked with organizing access control for a team of analysts using an Amazon Redshift data warehouse. The team requires varying levels of access to sensitive financial data for reporting and analysis. The consultants need to define a strategy that provides the necessary access for the analysts to perform their duties while ensuring that principles of least privilege and data governance are upheld.

Which of the following actions should the consultant take to appropriately manage user access and permissions within the Amazon Redshift database? (Select TWO)