Analytics

You are Head of Digits in DreamCompany. You are assigned to ingest, store and transform unstructured and semi structured data so that your Data Scientists can work with the exceptionally well curated data. Your boss, the Vice-President of Digits and Numbers, requires you to store the data in the most cost-efficient way possible.

How would you design your solution?

• Store your entire data solely in Redshift and perform ELT operations straight in Redshift.

• Store your data in Relational databases and perform highly efficient SQL-ETL queries straight in the DB.

• Store your data in S3 with intelligent tiering and perform ETL jobs on different services.

• Store your data in DynamoDB for the most efficient, low-latency queries and perform the ETL on different services.

You are Head of Risk Management at Lehman Bank. Your department uses Amazon Athena to do ad-hoc searches on data stored in S3. To comply with internal security regulations, Lehman Bank wishes to incorporate additional restrictions to isolate query execution and history among individuals, teams, or apps operating in the same AWS account. Which solution satisfies these criteria?

• Create an S3 bucket for each given use case, create an S3 bucket policy that grants permissions to appropriate individual IAM users. and apply the S3 bucket policy to the S3 bucket.

• Create an Athena workgroup for each given use case, apply tags to the workgroup, and create an IAM policy using the tags to apply appropriate permissions to the workgroup.

• Create an IAM role for each given use case, assign appropriate permissions to the role for the given use case, and add the role to associate the role with Athena.

• Create a Glue Data Catalog resource policy for each given use case that grants permissions to appropriate individual IAM users, and apply the resource policy to the specific tables used by Athena.

You are Head of Streaming at IoT. IoT is developing a new gadget that will gather data on sleep patterns while sleeping on a smart mattress. Sensors will transmit data to S3. Each night, around 2 MB of data is created for each bed. Each user's data must be analyzed and summarized, and the findings must be made accessible as quickly as feasible. Time windowing and other operations are included as part of the procedure. Each run, based on testing using a Python script, will need around 1 GB of RAM and will take a few minutes to finish.Which option is the MOST cost-effective approach to execute the script?

• AWS Lambda with a Python script

• AWS Glue with a Scala job

• AWS Glue with a PySpark job

• Amazon EMR with an Apache Spark script

You are Head of Words at AnalyzerComp. You are using S3 to store campaign response data. Each campaign's data was compiled from a consistent set of sources. The data is uploaded to S3 in the form of.csv files. You have to examine the data from each campaign using Athena. The organization requires a reduction in the cost of continuing data analysis using Athena. Which steps should you perform in combination to achieve these requirements? (CHOOSE TWO.)

• Convert the .csv files to Apache Parquet.

• Convert the .csv files to Apache Avro.

• Partition the data by campaign.

• Partition the data by sources.

• Compress the .csv files.

You are Head of Social Media Analytics for a microblogging service. You notice that specific individuals can influence stock market prices with some of their posts. Your Boss wants you to stop this posts from landing on your application.

How would you solve this problem with minimal management?

• Delete the account of the specific individuals.

• Assign identity-based policies to those individuals and manually review every post of them to potentially delete the post.

• Train a NLP classifier to identify posts that influence prices and integrate this classifier to your application.

• Assign resource-based policies to every post of the individuals and limit the posts to specific IP addresses.