Analytics

Question 1

A company needs to query logs stored in S3 in JSON format using SQL without loading them into a database. The solution must be serverless and pay only for executed queries. Which service should the architect use?

Accepted Answer

Amazon Athena

Answer

Amazon Redshift

Answer

Amazon EMR

Answer

Amazon RDS with Aurora

Question 2

A streaming application receives millions of events per second from IoT devices. Data must be processed in real-time and stored for later analysis. Which services should the architect use? (Select TWO)

Accepted Answer

Answer

Amazon Kinesis Data Streams for ingestion

Answer

Amazon SQS for real-time processing

Answer

Amazon Kinesis Data Firehose for storage in S3

Answer

Amazon SNS for event processing

Answer

Amazon RDS for event storage

Question 3

A company has a data warehouse in Amazon Redshift processing complex analytical queries. Users report slow queries during peak hours. Which features should the architect implement to improve performance? (Select TWO)

Accepted Answer

Answer

Implement appropriate Distribution Keys on tables

Answer

Migrate to Amazon RDS Multi-AZ

Answer

Configure Sort Keys on frequently filtered columns

Answer

Use Amazon ElastiCache to cache results

Answer

Migrate to Amazon DynamoDB

Question 4

An architect needs to process large volumes of data using Apache Spark for machine learning analysis. The solution must be fully managed and automatically scalable. Which AWS service should be used?

Accepted Answer

Amazon EMR (Elastic MapReduce)

Answer

Amazon EC2 with manually installed Spark

Answer

Amazon Athena

Answer

AWS Lambda with Spark libraries

Question 5

A company needs to create interactive business intelligence dashboards with data from multiple sources (S3, Redshift, RDS). The solution must be serverless and allow sharing dashboards with users. Which service should be used?

Accepted Answer

Amazon QuickSight

Answer

Amazon CloudWatch Dashboards

Answer

Grafana on EC2

Answer

Tableau installed on-premises

Question 6

An application processes real-time data from Kinesis Data Streams. The architect needs to guarantee each record is processed exactly once, even during failures. Which Kinesis feature must be enabled?

Accepted Answer

Kinesis Producer Library (KPL) with checkpointing

Answer

Enhanced Fan-Out

Answer

Kinesis Data Analytics

Answer

Server-Side Encryption

Question 7

An architect needs to reduce Athena query costs scanning terabytes of data in S3. Data is in JSON format and queries frequently filter by date and region. Which optimizations should be implemented? (Select TWO)

Accepted Answer

Answer

Convert data to columnar Parquet format

Answer

Implement partitioning by date and region

Answer

Migrate data to Amazon Redshift

Answer

Use GZIP compression on JSON files

Answer

Enable S3 Intelligent-Tiering

Question 8

A video streaming application generates 50GB of logs per hour that must be transformed and loaded to S3 for analysis with Athena. The solution must be fully managed. Which service should the architect use?

Accepted Answer

Amazon Kinesis Data Firehose

Answer

AWS Glue ETL Jobs

Answer

AWS Lambda with S3 triggers

Answer

Amazon EMR with custom scripts

Question 9

A Redshift data warehouse must maintain backup copies in another region for disaster recovery. Snapshots must be automatic and retained for 30 days. What should the architect configure?

Accepted Answer

Enable automated snapshots and configure cross-region snapshot copy

Answer

Use AWS Backup to manage Redshift snapshots

Answer

Configure S3 Cross-Region Replication to copy data

Answer

Create Lambda function to copy snapshots manually

Question 10

An application needs to execute real-time SQL queries on Kinesis data streams to detect anomalies and send alerts. Which service should the architect use?

Accepted Answer

Amazon Kinesis Data Analytics

Answer

Amazon Athena

Answer

AWS Glue with triggers

Answer

Amazon EMR with Spark Streaming