DynanoDB, RDS, Kinesis, ElastiCache & etc. Flashcards
A fleet of global IOT sensors writes 1337 million
items into a DynamoDB table every day. Processing
occurs once every 24 hours and once completed the
ITEMS are no longer required. What’s the MOST
efficient way remove the records every day?
Create a new table daily, and delete the entire table once processing has finished
Which two statements best describe Amazon Athena?
Source data stays the same
Used for ad hoc querying
A company’s marketing website utilizes an RDS database instance to store transactional data. As the user visits grow, the IT department decides to implement a caching service for faster database performance and to maintain high availability for the RDS instance.
Which combination of steps should the SysOps admin perform to accomplish the requirement? (SELECT TWO.)
– Utilize Amazon ElastiCache for Redis data store to support the demands of the database.
– Activate Multi-AZ deployment for the data store.
A startup recently launched a web application that uses Amazon ElastiCache for Memcached to store session state. A SysOps Administrator has been tasked to monitor the ElastiCache performance in Amazon CloudWatch. After checking the cache metric data, the Administrator noticed that the number of evictions in the cluster is increasing.
Which of the following options should the Administrator do to improve the performance of the cluster? (Select TWO.)
-Change the node size of your cluster.
-Increase the number of nodes in your cluster.
Evictions occur when memory is overfilled or greater than the max memory setting in the cache. The node type and the number of nodes will define the cache memory limit. If the eviction rate is steady and your cache hit rate isn’t abnormal, then your cache probably has enough memory. But if the number of evictions is increasing, you should add more nodes to your existing Memcached Cluster. To resolve the evictions in the cluster, we need to scale up the cluster using a larger node type or scale out by adding more nodes to accommodate the additional data.
A leading bank has a web application that is heavily using the RDS instance for its database tier. The SysOps Administrator is instructed to monitor how the different processes or threads on a DB instance use the CPU such as the percentage of the CPU bandwidth and total memory consumed by each process.
Which of the following is the most suitable solution to properly monitor the database?
Enable Enhanced Monitoring in RDS.
Take note that there are certain differences between CloudWatch and Enhanced Monitoring Metrics. CloudWatch gathers metrics about CPU utilization from the hypervisor for a DB instance, and Enhanced Monitoring gathers its metrics from an agent on the instance. As a result, you might find differences between the measurements, because the hypervisor layer performs a small amount of work.
A SysOps Administrator is managing a web application that uses Amazon ElastiCache for Memcached to cache frequently accessed data. The customers have been complaining about the system performance for the past 3 months. The Administrator monitors the metrics of each service using Amazon CloudWatch. Upon checking, the metrics of the EC2 instances of the web tier are normal but the eviction count has exceeded its threshold.
What should the Administrator do to rectify this issue?
Scale the cluster by increasing the number of nodes.
The option that says: Scale the cluster by increasing the number of read replicas is incorrect because this option is only applicable in Amazon ElastiCache for Redis. Remember that the web application uses Amazon Elasticache for Memcached. Redis cluster uses read replicas to increase the cluster’s read throughput and to serve high-volume applications’ read traffic.
EVICTIONS=INCREASE RD NODES
A large accounting firm has a web application that consists of an Application Load Balancer and an Auto Scaling Group of EC2 Instances running Linux and Apache HTTP servers. For its database tier, they also have a running RDS instance to host the MySQL database.
Which security measures fall within AWS responsibilities?
Protecting against network packet sniffing
NOT Install latest security packet sniffing
A shoe company provisioned an Amazon Aurora database cluster with MySQL support. In addition, backtracking, point-in-time recovery, and automatic backup are enabled for the database cluster. However, a developer mistakenly performed a DELETE query without a WHERE clause on the database. The SysOps administrator needs to roll back the database cluster to a specific point in time within the last 72 hours and ensure that the database restore procedure will be done on the same DB instance and not by creating a new one.
What should the SysOps administrator do to restore the database?
Rewind the Aurora database cluster to the desired recovery point by using BACKTRACKING.
A leading advertising company is using Lambda to run a serverless application in AWS. The application processes transactions on an Amazon RDS database instance with MySQL support. As the company grows, the number of users has started to increase. As a result, your Lambda function is beginning to receive “too many connections” errors when attempting to connect to the RDS database. When the SysOps administrator checked the database settings, the max_connections parameter is already set to the maximum possible value.
What step should the Sysops administrator perform to resolve the issue?
Provision an Amazon RDS Proxy and update the database connection string in your Lambda function.
NOT Enable Multi-AZ setting for the RDS database instance is incorrect because this just creates a failover instance that is on standby and waits for failover to happen. It will not improve the performance of the database to resolve the increased number of database connections.
A company would like to hire a new Administrators who will manage the backups of their AWS resources. However, doing so will increase the company’s operating expenses, and thus, they are looking for ways to automate their processes to cut costs. The company is using point-in-time snapshots of its resources provisioned on AWS.
Which of the following services provides you with a user-configurable automatic backup service and storage scaling without the need for regular user intervention? (Select TWO)
Amazon RDS and Amazon Aurora are the correct answers.
NOT Amazon EBS is incorrect. Although EBS volumes can be automatically backed up using AWS Backup, they don’t support auto-scaling storage-wise.
A FinTech startup has an application hosted in a Spot Fleet of Amazon EC2 instances and uses Amazon RDS for its database. Based on the system monitoring, the SysOps Administrator noticed that the database performs poorly on heavily used SQL data queries and decided to optimize the reporting queries of the application. However, the issue still persists after making the change.
Which combination of the following options can the Administrator implement to resolve this performance issue? (Select TWO.)
– Launch a new Read Replica for the RDS database and use its endpoint for reporting queries
– Implement database caching using Amazon ElastiCache
