Amazon Athena is used by a business to do ad-hoc searches on data stored in Amazon S3. To comply with internal security regulations, the organization 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?
Correct Answer:
C
🗳️
Reference:
https://aws.amazon.com/athena/faqs/
A real estate business uses Apache HBase on Amazon EMR to power a mission-critical application. A single master node is setup for Amazon EMR. The company's data is kept on a Hadoop Distributed File System in excess of 5 TB (HDFS). The organization is looking for a cost-effective way to increase the availability of its HBase data.
Which architectural design best fulfills the needs of the business?
Correct Answer:
C
🗳️
Reference:
https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-hbase-s3.html
An Internet of Things business is developing a new gadget that will gather data on sleep patterns while sleeping on an intelligent mattress. Sensors will transmit data to an Amazon S3 bucket. 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?
Correct Answer:
A
🗳️
A human resources organization runs analytics queries on the company's data using a 10-node Amazon Redshift cluster. The Amazon Redshift cluster comprises two tables: one for products and one for transactions, both of which have a product sku field. The tables span more than 100 GB. Both tables are used in the majority of queries.
Which distribution pattern should the organization adopt to optimize query speed for the two tables?
Correct Answer:
B
🗳️