A company stores its sales and marketing data that includes personally identifiable information (PII) in Amazon S3. The company allows its analysts to launch their own Amazon EMR cluster and run analytics reports with the data. To meet compliance requirements, the company must ensure the data is not publicly accessible throughout this process. A data engineer has secured Amazon S3 but must ensure the individual EMR clusters created by the analysts are not exposed to the public internet. Which solution shoul

A banking company is currently using Amazon Redshift for sensitive data. An audit found that the current cluster isunencrypted. Compliance requires that a database with sensitive data must be encrypted using a hardware security module(HSM) with customer managed keys.Which modifications are required in the cluster to ensure compliance?

A company hosts an Apache Flink application on premises. The application processes data from several Apache Kafka clusters. The data originates from a variety of sources, such as web applications mobile apps and operational databases The company has migrated some of these sources to AWS and now wants to migrate the Flink application. The company must ensure that data that resides in databases within the VPC does not traverse the internet The application must be able to process all the data that comes from t

A bank wants to migrate a Teradata data warehouse to the AWS Cloud The bank needs a solution for reading large amounts of data and requires the highest possible performance. The solution also must maintain the separation of storage and compute Which solution meets these requirements?

A power utility company is deploying thousands of smart meters to obtain real-time updates about power consumption. The company is using Amazon Kinesis Data Streams to collect the data streams from smart meters. The consumer application uses the Kinesis Client Library (KCL) to retrieve the stream data. The company has only one consumer application. The company observes an average of 1 second of latency from the moment that a record is written to the stream until the record is read by a consumer application.

A software company hosts an application on AWS, and new features are released weekly. As part of the application testing process, a solution must be developed that analyzes logs from each Amazon EC2 instance to ensure that the application is working as expected after each deployment. The collection and analysis solution should be highly available with the ability to display new information with minimal delays. Which method should the company use to collect and analyze the logs?

A company has developed several AWS Glue jobs to validate and transform its data from Amazon S3 and load it intoAmazon RDS for MySQL in batches once every day. The ETL jobs read the S3 data using a DynamicFrame. Currently, theETL developers are experiencing challenges in processing only the incremental data on every run, as the AWS Glue jobprocesses all the S3 input data on each run.Which approach would allow the developers to solve the issue with minimal coding effort?

A hospital uses wearable medical sensor devices to collect data from patients. The hospital is architecting a near-real-timesolution that can ingest the data securely at scale. The solution should also be able to remove the patients protected healthinformation (PHI) from the streaming data and store the data in durable storage.Which solution meets these requirements with the least operational overhead?

A company launched a service that produces millions of messages every day and uses Amazon Kinesis Data Streams asthe streaming service.The company uses the Kinesis SDK to write data to Kinesis Data Streams. A few months after launch, a data analyst foundthat write performance is significantly reduced. The data analyst investigated the metrics and determined that Kinesis isthrottling the write requests. The data analyst wants to address this issue without significant changes to the architecture.Which actions

A company needs to store objects containing log data in JSON format. The objects are generated by eight applicationsrunning in AWS. Six of the applications generate a total of 500 KiB of data per second, and two of the applications cangenerate up to 2 MiB of data per second.A data engineer wants to implement a scalable solution to capture and store usage data in an Amazon S3 bucket. Theusage data objects need to be reformatted, converted to .csv format, and then compressed before they are stored inAmazon S3

A company has a business unit uploading .csv files to an Amazon S3 bucket. The companys data platform team has set upan AWS Glue crawler to do discovery, and create tables and schemas. An AWS Glue job writes processed data from thecreated tables to an Amazon Redshift database. The AWS Glue job handles column mapping and creating the AmazonRedshift table appropriately. When the AWS Glue job is rerun for any reason in a day, duplicate records are introduced intothe Amazon Redshift table.Which solution will up

A company wants to use an automatic machine learning (ML) Random Cut Forest (RCF) algorithm to visualize complex real-world scenarios, such as detecting seasonality and trends, excluding outers, and imputing missing values.The team working on this project is non-technical and is looking for an out-of-the-box solution that will require the LEASTamount of management overhead.Which solution will meet these requirements?

A company has several Amazon EC2 instances sitting behind an Application Load Balancer (ALB) The company wants its IT Infrastructure team to analyze the IP addresses coming into the company's ALB The ALB is configured to store access logs in Amazon S3 The access logs create about 1 TB of data each day, and access to the data will be infrequent The company needs a solution that is scalable, cost-effective and has minimal maintenance requirements Which solution meets these requirements?

A company has an encrypted Amazon Redshift cluster. The company recently enabled Amazon Redshift audit logs and needs to ensure that the audit logs are also encrypted at rest. The logs are retained for 1 year. The auditor queries the logs once a month. What is the MOST cost-effective way to meet these requirements?

A financial services company needs to aggregate daily stock trade data from the exchanges into a data store. The company requires that data be streamed directly into the data store, but also occasionally allows data to be modified using SQL. The solution should integrate complex, analytic queries running with minimal latency. The solution must provide a business intelligence dashboard that enables viewing of the top contributors to anomalies in stock prices. Which solution meets the company’s requirements?

A company is building a data lake and needs to ingest data from a relational database that has time-series data. Thecompany wants to use managed services to accomplish this. The process needs to be scheduled daily and bring incrementaldata only from the source into Amazon S3.What is the MOST cost-effective approach to meet these requirements?

A large university has adopted a strategic goal of increasing diversity among enrolled students. The data analytics team is creating a dashboard with data visualizations to enable stakeholders to view historical trends. All access must be authenticated using Microsoft Active Directory. All data in transit and at rest must be encrypted. Which solution meets these requirements?

A company uses Amazon Redshift as its data warehouse. A new table includes some columns that contain sensitive dataand some columns that contain non-sensitive data. The data in the table eventually will be referenced by several existingqueries that run many times each day.A data analytics specialist must ensure that only members of the companys auditing team can read the columns that containsensitive data. All other users must have read-only access to the columns that contain non-sensitive data.Which soluti

A market data company aggregates external data sources to create a detailed view of product consumption in different countries. The company wants to sell this data to external parties through a subscription. To achieve this goal, the company needs to make its data securely available to external parties who are also AWS users. What should the company do to meet these requirements with the LEAST operational overhead?

A team of data scientists plans to analyze market trend data for their company’s new investment strategy. The trend data comes from five different data sources in large volumes. The team wants to utilize Amazon Kinesis to support their use case. The team uses SQL-like queries to analyze trends and wants to send notifications based on certain significant patterns in the trends. Additionally, the data scientists want to save the data to Amazon S3 for archival and historical re- processing, and use AWS managed

A manufacturing company has been collecting IoT sensor data from devices on its factory floor for a year and is storing thedata in Amazon Redshift for daily analysis. A data analyst has determined that, at an expected ingestion rate of about 2 TBper day, the cluster will be undersized in less than 4 months. A long-term solution is needed. The data analyst has indicatedthat most queries only reference the most recent 13 months of data, yet there are also quarterly reports that need to query allthe data gener

A data analytics specialist is building an automated ETL ingestion pipeline using AWS Glue to ingest compressed files that have been uploaded to an Amazon S3 bucket. The ingestion pipeline should support incremental data processing. Which AWS Glue feature should the data analytics specialist use to meet this requirement?