A company has a data lake on AWS that ingests sources of data from multiple business units and uses Amazon Athena for queries. The storage layer is Amazon S3 using the AWS Glue Data Catalog. The company wants to make the data available to its data scientists and business analysts. However, the company first needs to manage data access for Athena based on user roles and responsibilities.
What should the company do to apply these access controls with the LEAST operational overhead?

1. A. Define security policy-based rules for the users and applications by role in AWS Lake Formation.
2. B. Define security policy-based rules for the users and applications by role in AWS Identity and Access Management (IAM).
3. C. Define security policy-based rules for the tables and columns by role in AWS Glue.
4. D. Define security policy-based rules for the tables and columns by role in AWS Identity and Access Management (IAM).

Correct Answer: D

A technology company is creating a dashboard that will visualize and analyze time-sensitive data. The data will come in through Amazon Kinesis Data Firehose with the butter interval set to 60 seconds. The dashboard must support near-real-time data.
Which visualization solution will meet these requirements?

1. A. Select Amazon Elasticsearch Service (Amazon ES) as the endpoint for Kinesis Data Firehos
2. B. Set up a Kibana dashboard using the data in Amazon ES with the desired analyses and visualizations.
3. C. Select Amazon S3 as the endpoint for Kinesis Data Firehos
4. D. Read data into an Amazon SageMaker Jupyter notebook and carry out the desired analyses and visualizations.
5. E. Select Amazon Redshift as the endpoint for Kinesis Data Firehos
6. F. Connect Amazon QuickSight with SPICE to Amazon Redshift to create the desired analyses and visualizations.
7. G. Select Amazon S3 as the endpoint for Kinesis Data Firehos
8. H. Use AWS Glue to catalog the data and Amazon Athena to query i
9. I. Connect Amazon QuickSight with SPICE to Athena to create the desired analyses and visualizations.

Correct Answer: A

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?

1. A. Copy the data into Amazon Redshift and query the data
2. B. Use Amazon EMR and Apache Hive to query the S3 data
3. C. Use Amazon Athena to query the S3 data
4. D. Use Amazon Redshift Spectrum to query the S3 data

Correct Answer: D

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. The company must reduce this latency to 500 milliseconds.
Which solution meets these requirements?

1. A. Use enhanced fan-out in Kinesis Data Streams.
2. B. Increase the number of shards for the Kinesis data stream.
3. C. Reduce the propagation delay by overriding the KCL default settings.
4. D. Develop consumers by using Amazon Kinesis Data Firehose.

Correct Answer: C
The KCL defaults are set to follow the best practice of polling every 1 second. This default results in average propagation delays that are typically below 1 second.

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 difficulty connecting Amazon QuickSight from ap-northeast-1 to Amazon Redshift in us-east-1.
Which solution will solve this issue and meet the requirements?

1. A. In the Amazon Redshift console, choose to configure cross-Region snapshots and set the destination Region as ap-northeast-1. Restore the Amazon Redshift Cluster from the snapshot and connect to Amazon QuickSight launched in ap-northeast-1.
2. B. Create a VPC endpoint from the Amazon QuickSight VPC to the Amazon Redshift VPC so Amazon QuickSight can access data from Amazon Redshift.
3. C. Create an Amazon Redshift endpoint connection string with Region information in the string and use this connection string in Amazon QuickSight to connect to Amazon Redshift.
4. D. Create a new security group for Amazon Redshift in us-east-1 with an inbound rule authorizing access from the appropriate IP address range for the Amazon QuickSight servers in ap-northeast-1.

Correct Answer: B