A company uses Amazon EC2 instances to receive files from external vendors throughout each day. At the end of each day, the EC2 instances combine the files into a single file, perform gzip compression, and upload the single file to an Amazon S3 bucket. The total size of all the files is approximately 100 GB each day. When the files are uploaded to Amazon S3, an AWS Batch job runs a COPY command to load the files into an Amazon Redshift cluster. Which solution will MOST accelerate the COPY process?

A company uses Amazon Connect to manage its contact center. The company uses Salesforce to manage its customer relationship management (CRM) dat a. The company must build a pipeline to ingest data from Amazon Connect and Salesforce into a data lake that is built on Amazon S3. Which solution will meet this requirement with the LEAST operational overhead?

A company wants to use a data lake that is hosted on Amazon S3 to provide analytics services for historical dat a. The data lake consists of 800 tables but is expected to grow to thousands of tables. More than 50 departments use the tables, and each department has hundreds of users. Different departments need access to specific tables and columns. Which solution will meet these requirements with the LEAST operational overhead?

A US-based sneaker retail company launched its global website. All the transaction data is stored in Amazon RDS and curated historic transaction data is stored in Amazon Redshift in the us-east-1 Region. The business intelligence (BI) team wants to enhance the user experience by providing a dashboard for sneaker trends. The BI team decides to use Amazon QuickSight to render the website dashboards. During development, a team in Japan provisioned Amazon QuickSight in ap- northeast-1. The team is having diffic

A company wants to improve user satisfaction for its smart home system by adding more features to its recommendation engine. Each sensor asynchronously pushes its nested JSON data into Amazon Kinesis Data Streams using the Kinesis Producer Library (KPL) in Java. Statistics from a set of failed sensors showed that, when a sensor is malfunctioning, its recorded data is not always sent to the cloud. The company needs a solution that offers near-real-time analytics on the data from the most updated sensors. Whi

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

A company has 10-15 of uncompressed .csv files in Amazon S3. The company is evaluating Amazon Athena as a one-time query engine. The company wants to transform the data to optimize query runtime and storage costs.Which option for data format and compression meets these requirements?

A company is building an analytical solution that includes Amazon S3 as data lake storage and Amazon Redshift for data warehousing. The company wants to use Amazon Redshift Spectrum to query the data that is stored in Amazon S3. Which steps should the company take to improve performance when the company uses Amazon Redshift Spectrum to query the S3 data files? (Select THREE ) Use gzip compression with individual file sizes of 1-5 GB

A central government organization is collecting events from various internal applications using Amazon Managed Streamingfor Apache Kafka (Amazon MSK). The organization has configured a separate Kafka topic for each application to separatethe data. For security reasons, the Kafka cluster has been configured to only allow TLS encrypted data and it encrypts thedata at rest.A recent application update showed that one of the applications was configured incorrectly, resulting in writing data to aKafka topic that

A mobile gaming company wants to capture data from its gaming app and make the data available for analysis immediately.The data record size will be approximately 20 KB. The company is concerned about achieving optimal throughput from eachdevice. Additionally, the company wants to develop a data stream processing application with dedicated throughput for eachconsumer.Which solution would achieve this goal?

A data analytics specialist is building an automated ETL ingestion pipeline using AWS Glue to ingest compressed files thathave 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?

A retail company is building its data warehouse solution using Amazon Redshift. As a part of that effort, the company is loading hundreds of files into the fact table created in its Amazon Redshift cluster. The company wants the solution to achieve the highest throughput and optimally use cluster resources when loading data into the company’s fact table. How should the company meet these requirements?

A university intends to use Amazon Kinesis Data Firehose to collect JSON-formatted batches of water quality readings in Amazon S3. The readings are from 50 sensors scattered across a local lake. Students will query the stored data using Amazon Athena to observe changes in a captured metric over time, such as water temperature or acidity. Interest has grown in the study, prompting the university to reconsider how data will be stored. Which data format and partitioning choices will MOST significantly reduce c

A healthcare company uses AWS data and analytics tools to collect, ingest, and store electronic health record (EHR) data about its patients. The raw EHR data is stored in Amazon S3 in JSON format partitioned by hour, day, and year and is updated every hour. The company wants to maintain the data catalog and metadata in an AWS Glue Data Catalog to be able to access the data using Amazon Athena or Amazon Redshift Spectrum for analytics. When defining tables in the Data Catalog, the company has the following r

A social media company is using business intelligence tools to analyze data for forecasting. The company is using Apache Kafka to ingest dat a. The company wants to build dynamic dashboards that include machine learning (ML) insights to forecast key business trends. The dashboards must show recent batched data that is not more than 75 minutes old. Various teams at the company want to view the dashboards by using Amazon QuickSight with ML insights. Which solution will meet these requirements?

A transportation company uses IoT sensors attached to trucks to collect vehicle data for its global delivery fleet. Thecompany currently sends the sensor data in small .csv files to Amazon S3. The files are then loaded into a 10-node AmazonRedshift cluster with two slices per node and queried using both Amazon Athena and Amazon Redshift. The company wantsto optimize the files to reduce the cost of querying and also improve the speed of data loading into the Amazon Redshiftcluster.Which solution meets these