NEW
Font size
WorksheetsDatabase n Analytics
Total questions: 8
Worksheet time: 5mins
You would like to have a database that is efficient at performing analytical queries on large sets of columnar data. You would like to connect to this Data Warehouse using a reporting and dashboard tool such as Amazon QuickSight. Which AWS technology do you recommend?
Amazon RDS
Amazon S3
Amazon Redshift
Amazon Neptune
You have a lot of log files stored in an S3 bucket that you want to perform a quick analysis, if possible Serverless, to filter the logs and find users that attempted to make an unauthorized action. Which AWS service allows you to do so?
Amazon DynamoDB
Amazon Redshift
S3 Glacier
Amazon Athena
As a Solutions Architect, you have been instructed you to prepare a disaster recovery plan for a Redshift cluster. What should you do?
Enable Multi-AZ
Enable Automated Snapshots, then configure your Redshift cluster to automatically copy snapshots to another AWS region
Take a snapshot then restore to a Redshift Global cluster
Which feature in Redshift forces all COPY and UNLOAD traffic moving between your cluster and data repositories through your VPCs?
Enhanced VPC Routing
Improved VPC Routing
Redshift Spectrum
You are running a gaming website that is using DynamoDB as its data store. Users have been asking for a search feature to find other gamers by name, with partial matches if possible. Which AWS technology do you recommend to implement this feature?
Amazon DynamoDB
Amazon Redshift
Amazon OpenSearch
Amazon Neptune
An AWS service allows you to create, run, and monitor ETL (extract, transform, and load) jobs in a few clicks.
AWS Glue
Amazon Redshift
Amazon RDS
Amazon DynamoDB
You have an RDS DB instance that's configured to push its database logs to CloudWatch. You want to create a CloudWatch alarm if there's an Error found in the logs. How would you do that?
Create s scheduled CloudWatch Event that triggers an AWS lambda every 1 hour, scans the logs, and notify you through SNS topic
Create a CloudWatch Logs Metric Filter that filter the logs for the keyword Error, then createa CloudWatch Alarm based on that Metric Filter
Create an AWS config Rule that monitors Error in your database logs and notify you through SNS topic
You have an application hosted on a fleet of EC2 instances managed by an Auto Scaling Group that you configured its minimum capacity to 2. Also, you have created a CloudWatch Alarm that is configured to scale in your ASG when CPU Utilization is below 60%. Currently, your application runs on 2 EC2 instances and has low traffic and the CloudWatch Alarm is in the ALARM state. What will happen?
One EC2 instance will be terminated and the ASG desired and minimum capicity will go to 1
The CloudWatch will remain in ALARM state but never decrease the number of EC2 instances in the ASG
The CloudWatch Alarm will be detached from my ASG
The CloudWatch Alarm will go in OK state
