AWS SysOps Administrator - Associate Certification.png

awssys.tar.gz

SECRET_ACCESS_KEY

AWS_REGION

EMAIL_ID

ACCESS_KEY_ID

educative

educative-final

Cloud computing is necessary for organizations of all sizes, from large enterprises to small startups. Amazon Web Services (AWS) is a cloud provider with the largest customer share. An AWS SysOps Administrator operates and maintains the AWS infrastructure while handling cybersecurity, which is a high-demand skill.

This course provides in-depth coverage of core AWS Services, including EC2, Auto Scaling, ELB, VPC, IAM, S3, RDS, and more. You’ll learn AWS best practices for security, compliance, automation, monitoring, and troubleshooting through practical hands-on labs for key topics. You’ll test your knowledge by attempting quizzes and two full-length sample AWS SysOps Administrator - Associate practice exams at the end. 

By the end of the course, you’ll have gained practical experience through real-world examples and hands-on labs in administering systems and applications running on AWS to ace the AWS Certified SysOps Administrator - Associate exam.

AWS Certified SysOps Administrator - Associate Exam Prep

(True or False) RDS is a database.

What is the retention period of RDS (not Aurora) automatic backups?

What is the retention period of RDS (not Aurora) automatic backups?

SSH into the instance and run Linux commands.

Change or update the RDS database configuration via the AWS Management Console, API, or CLI.

Your manager wants you to patch the OS in the RDS instance. How can you do it?

Your manager wants you to patch the OS in the RDS instance. How can you do it?

**(Select all that apply.)** Which authentication methods are supported in RDS? 

(Select all that apply.) Which authentication methods are supported in RDS?

How many read replicas can an RDS database (not Aurora) have?

How many read replicas can an RDS database (not Aurora) have?

Read replicas make the database more available.

Read replicas improve the scalability of the database.

You can only perform read operations in a read replica.

To connect to a read replica, an application has to connect to the reader endpoint (if the database isn’t Aurora.)

Read replicas can have a standby read replica in a different AZ by using the Multi-AZ feature.

**(Select all that apply.)** Which statements are true for read replicas? 


(Select all that apply.) Which statements are true for read replicas?

**(True or False)** Multi-AZ configuration is for disaster recovery and failover. 

(True or False) Multi-AZ configuration is for disaster recovery and failover.

**(True or False)** In a Multi-AZ configuration, data is asynchronously copied from the primary database to the standby database. 

(True or False) In a Multi-AZ configuration, data is asynchronously copied from the primary database to the standby database.

Promote the Multi-AZ standby database to a read replica.

Create a new read replica. RDS will take care of the rest.

Create a new read replica and ask the application team to use the read replica connection endpoint for read operations.

Share the standby database connection endpoint with the application team and ask them to distribute requests between the two databases.

Your Oracle database is in a Multi-AZ configuration. You check the CPU utilization metrics and notice that it’s constantly high for the database instance. You troubleshoot and identify the issue because the database is unable to satisfy the read requirements of the application. 

How can you improve the situation cost-effectively?

Your Oracle database is in a Multi-AZ configuration. You check the CPU utilization metrics and notice that it’s constantly high for the database instance. You troubleshoot and identify the issue because the database is unable to satisfy the read requirements of the application.
How can you improve the situation cost-effectively?

Use an RDS Proxy to connect to the database.

Use parameter groups to force close connections.

Use subnet groups to force close connections.

Use a load balancer to connect to the database.

Your MySQL database is in a Multi-AZ configuration. You receive complaints from the application team that the database often throws the `TooManyConnections` error. You troubleshoot the issue and find that many Lambda functions that access this database don’t close their connection at the end. 

How can you resolve this issue quickly?

Your MySQL database is in a Multi-AZ configuration. You receive complaints from the application team that the database often throws the <code>TooManyConnections</code> error. You troubleshoot the issue and find that many Lambda functions that access this database don’t close their connection at the end.
How can you resolve this issue quickly?

If the RDS database is in a private subnet and its proxy is in a public subnet, Lambda functions and applications outside the VPC can access the database via proxy.

If the RDS database is in a private subnet and its proxy is in a private subnet, Lambda functions and applications outside the VPC can access the database via proxy.

If the RDS database is in a private subnet and its proxy is in a public subnet, Lambda functions and applications inside the VPC can access the database directly.

If the RDS database is in a private subnet and its proxy is in a public subnet, Lambda functions and applications outside the VPC can access the database directly.

**(Select all that apply.)** 
Which statements are true?  

(Select all that apply.)
Which statements are true?

Use this command:
```
GRANT SELECT ON <database>.*TO'<username>'@'%' IDENTIFIED BY '...' REQUIRE SSL;
```

Change the force SSL parameter in the RDS configuration to true.

Change the ```rds.force_ssl``` in parameter groups of the database to one.

Change the ```rds.enforce_ssl``` in parameter groups of the database to one.

How can you enforce SSL in PostgreSQL?

It collects data from the instance hypervisor.

It includes the RAM metric of the database instance.

It collects data from an agent on the database instance.

**(Select all that apply.)** Which statements are true for RDS basic monitoring? 

(Select all that apply.) Which statements are true for RDS basic monitoring?

Aurora can have up to five read replicas.

Aurora Read Replicas can scale automatically.

If two read replicas have the same priority, Aurora will promote the bigger read replica to the primary database.

Backups can’t be disabled for Amazon Aurora.

Aurora can backtrack a database for up to 120 hours.

You can migrate an RDS MySQL database snapshot to an Aurora MySQL cluster.

**(Select all that apply.)** Which statements are true for Amazon Aurora?

(Select all that apply.) Which statements are true for Amazon Aurora?

An organization can’t predict how much workload the database might face.

An organization has a very small test database that is accessed once every two months.

Developers need a database that can scale seamlessly so they don't have to worry about configuring it.

**(Select all that apply.)** Aurora Serverless is helpful for what cases? 

(Select all that apply.) Aurora Serverless is helpful for what cases?

Introduction

Getting Started with AWS

AWS IAM

AWS EC2

AWS Load Balancers and Auto Scaling Groups

AWS Storage Services

AWS Databases

AWS ElastiCache

AWS Elastic Beanstalk and CloudFront

AWS CloudFormation

AWS Monitoring

AWS VPC

AWS Route 53

AWS Security Services and Encryption

AWS Systems Manager

Important AWS Services

AWS SysOps Administrator Practice Exams

Quiz Yourself on AWS RDS