1. 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 each device. Additionally, the company wants to develop a data stream processing application with dedicated throughput for each consumer.Which solution would achieve this goal?
A) Have the app call the PutRecords API to send data to Amazon Kinesis Data Streams. Use the enhanced fan-out feature while consuming the data. B) Have the app call the PutRecordBatch API to send data to Amazon Kinesis Data Firehose. Submit a support case to enable dedicated throughput on the account. C) Have the app use Amazon Kinesis Producer Library (KPL) to send data to Kinesis Data Firehose. Use the enhanced fan-out feature while consuming the data. D) Have the app call the PutRecords API to send data to Amazon Kinesis Data Streams. Host the stream-processing application on Amazon EC2 with Auto Scaling.
2. A marketing company wants to improve its reporting and business intelligence capabilities. During the planning phase, the company interviewed the relevant stakeholders, and discovered that:' The operations team reports are run hourly for the current month's data.' The sales team wants to use multiple Amazon QuickSight dashboards to show a rolling view of the last 30 days based on several categories. The sales team also wants to view the data as soon as it reaches the reporting backend.' The finance team's reports are run daily for last month's data and once a month for the last 24 months of data.Currently, there is 400 TB of data in the system with an expected additional 100 TB added every month. The company is looking for a solution that is as cost- effective as possible.Which solution meets the company's requirements?
A) Store the last 24 months of data in Amazon Redshift. Configure Amazon QuickSight with Amazon Redshift as the data source. B) Store the last 2 months of data in Amazon Redshift and the rest of the months in Amazon S3. Set up an external schema and table for Amazon Redshift Spectrum. Configure Amazon QuickSight with Amazon Redshift as the data source. C) Store the last 24 months of data in Amazon S3 and query it using Amazon Redshift Spectrum. Configure Amazon QuickSight with Amazon Redshift Spectrum as the data source. D) Store the last 2 months of data in Amazon Redshift and the rest of the months in Amazon S3. Use a long-running Amazon EMR with Apache Spark cluster to query the data as needed. Configure Amazon QuickSight with Amazon EMR as the data source.
3. A media company wants to perform machine learning and analytics on the data residing in its Amazon S3 data lake. There are two data transformation requirements that will enable the consumers within the company to create reports:' Daily transformations of 300 GB of data with different file formats landing in Amazon S3 at a scheduled time.' One-time transformations of terabytes of archived data residing in the S3 data lake.Which combination of solutions cost-effectively meets the company's requirements for transforming the data? (Choose three.)(Select 3answers)
A) For daily incoming data, use AWS Glue crawlers to scan and identify the schema. B) For daily incoming data, use Amazon Athena to scan and identify the schema. C) For daily incoming data, use Amazon Redshift to perform transformations. D) For daily incoming data, use AWS Glue workflows with AWS Glue jobs to perform transformations. E) For archived data, use Amazon EMR to perform data transformations. F) For archived data, use Amazon SageMaker to perform data transformations.
4. A company is migrating its existing on-premises ETL jobs to Amazon EMR. The code consists of a series of jobs written in Java. The company needs to reduce overhead for the system administrators without changing the underlying code. Due to the sensitivity of the data, compliance requires that the company use root device volume encryption on all nodes in the cluster. Corporate standards require that environments be provisioned though AWS CloudFormation when possible.Which solution satisfies these requirements?
A) Install open-source Hadoop on Amazon EC2 instances with encrypted root device volumes. Configure the cluster in the CloudFormation template. B) Use a CloudFormation template to launch an EMR cluster. In the configuration section of the cluster, define a bootstrap action to enable TLS. C) Create a custom AMI with encrypted root device volumes. Configure Amazon EMR to use the custom AMI using the CustomAmild property in the CloudFormation template. D) Use a CloudFormation template to launch an EMR cluster. In the configuration section of the cluster, define a bootstrap action to encrypt the root device volume of every node.
5. A transportation company uses IoT sensors attached to trucks to collect vehicle data for its global delivery fleet. The company currently sends the sensor data in small .csv files to Amazon S3. The files are then loaded into a 10-node Amazon Redshift cluster with two slices per node and queried using both Amazon Athena and Amazon Redshift. The company wants to optimize the files to reduce the cost of querying and also improve the speed of data loading into the AmazonRedshift cluster.Which solution meets these requirements?
A) Use AWS Glue to convert all the files from .csv to a single large Apache Parquet file. COPY the file into Amazon Redshift and query the file with Athena from Amazon S3. B) Use Amazon EMR to convert each .csv file to Apache Avro. COPY the files into Amazon Redshift and query the file with Athena from Amazon S3. C) Use AWS Glue to convert the files from .csv to a single large Apache ORC file. COPY the file into Amazon Redshift and query the file with Athena from Amazon S3. D) Use AWS Glue to convert the files from .csv to Apache Parquet to create 20 Parquet files. COPY the files into Amazon Redshift and query the files with Athena from Amazon S3.
1. Right Answer: A Explanation: Developing Custom Consumers with Dedicated Throughput (Enhanced Fan-Out)Referencehttps://docs.aws.amazon.com/streams/latest/dev/enhanced-consumers.html
2. Right Answer: B Explanation: Although the requirement is most cost-effective, I think they also consider performance because of this sentence -- 'The sales team also wants to view the data as soon as it reaches the reporting backend.'
3. Right Answer: A,D,E Explanation: Notice that the answers given are paired so if you were to break it down: Identify schema --> Glue Transformations --> Glue Jobs Archived TBs worth of data --> EMRIncorrect Answers:B. Athena will use Glue (option A) C. Its an antipattern to use Redshift to do transformations.F. Would pick EMR instead of Sagemaker to do one time transformations
4. Right Answer: C Explanation: Referencehttps://aws.amazon.com/premiumsupport/knowledge-center/cloudformation-root-volume-property/
5. Right Answer: D Explanation: In fact each nodes have 2 slices so ideally we can parrelize the copy process by sending a multiple of 20.Referencehttps://docs.aws.amazon.com/redshift/latest/dg/t_Loading_tables_with_the_COPY_command.html
Leave a comment