Uncategorised

AWS Certified SysOps Administrator – Chapter – 5

May 3, 2021 comments off

Review Questions

How are charges calculated for data transferred between Amazon Relational Database Service (Amazon RDS) and Amazon Elastic Computer Cloud (Amazon EC2) instance in the Availability Zone?

  • GB out from Amazon RDS
  • GB in from Amazon RDS
  • IOPS from Amazon EC2
  • There is no charge.

On an Amazon Elastic Compute Cloud (Amazon EC2) instance using an Amazon Elastic Block Store (Amazon EBS) volume for persistence, there is a large inconsistency in the response times of the database queries. While investigating the issue, you find that there is a large amount of wait time on the database’s disk volume.How can you improve the performance of the database’s storage while maintaining the current persistence of the data? (choose two.)

  • Move to a Solid-State Drive (SSD)-backed instance.
  • Use an Amazon EC2 instance with an Instance Store volume.
  • Use an Amazon EC2 instance type that is Amazon ESB-Optimized.
  • Use a Provisioned IOPs Amazon EBS volume.

Amazon Relational Database Service (Amazon RDS) automated backups and DB snapshots are currently supported for which storage engine?

  • JDBC
  • ODBC
  • InnoDB
  • MyISAM

In Amazon CloudWatch, which metric monitors the amount of free space on a DB instance?

  • FreeStorageTotal
  • FreeStorageVolume
  • FreeStorageSpace
  • FreeRDSStorage

In an Amazon DynamoDB table, what happens if the application performs more reads or writes than the provisioned capacity?

  • Requests above the provisioned capacity will be throttled, and it will return HTTP 400 error codes.
  • Requests above the provisioned capacity will be throttled, and it will return HTTP 400 error codes.
  • Requests above the provisioned capacity will be performed, but it will return HTTP 500 error codes.
  • Requests above the provisioned capacity will be throttled, and it will return HTTP 500 error codes.

Which metric should be monitored carefully in order to know when a Read Replica Should be recreated if it becomes out of sync due to replication errors?

  • ReadLag
  • ReadReplic
  • ReplicaLag
  • RaplicaThreshold

Can connections between my application and a DB instance be encrypted using Secure Sockets Layer (SSL)?

  • Yes
  • No
  • Yes, but only inside an Amazon Virtual Private Cloud (Amazon VPC)
  • Yes, but only inside certain regions

After inadvertently deleting a database table, which Amazon Relational Database Service (Amazon RDS) feature will allow you to restore a database reliably to within five minutes of the deletion?

  • Amazon RDS Automated Backup
  • Multi-AZ Amazon RDS
  • Amazon RDS Read Replicas
  • Amazon RDS Snapshots

What is the range, in days, to which the backup retention period can be set?

  • From 1 day to 7days
  • From 1 day to 28 days
  • From 1 day to 35 days
  • From 1 day to 90 days

Regarding Amazon DynamoDB, which of the following statements is correct?

  • Each item should have at least two value sets: a primary key and an attribute.
  • An item can have multiple attributes.
  • Primary keys must store a single value.
  • Individual attributes can have one or more sub-attributes.

The maximum Amazon DynameDB item size limit is which of the following?

  • 256 KB
  • 400 KB
  • 512 KB
  • 1,024 KB
  • Will a standby Amazon Relational Database Service (Amazon RDS) instance be in the same Availability Zone as the primary?
  • Yes
  • No
  • Only for Oracle and Microsoft SQL Server-based Amazon RDS instances
  • Only if configured at launch

For both Single and Multi-AZ deployments, defining a subnet for all Availability Zones in a region allows Amazon RDS to create a new standby by in another Availability Zone should the need arise. Is creating a Read Replica of another Read Replica supported inside Amazon Relational Database Service (Amazon RDS)?

  • No
  • Only in create regions
  • Only with MySQL-based Amazon RDS instance
  • Only for Oracle Amazon RDS DB instance

When running a DB instance as a Multi-AZ deployment, can the standby DB instance be used for read or write operations?

  • Yes
  • No
  • Only with Microsoft SQL Server-based Amazon Relational Database Service (Amazon RDS) DB instances
  • Only for Oracle-based Amazon RDS DB instances

If there multiple Read Replicas for a primary DB instance and one of them is promoted,
what happens to the rest of the Read Replicas?

  • The remaining Read Replicas will still replicate from the original primary DB instance.
  • The other Read Replicas will be deleted.
  • The remaining Read Replicas suspend operations.
  • Read Replicas cannot be promoted.

When using a Multi-AZ deployment, in the event of a planned or unplanned outage of the primary DB instance, Amazon RDS automatically switches to the standby replica. Which DNS record is updated by the automatic failover mechanism and points to the standby DB instance?

  • The a Record
  • CNAME
  • MX
  • SOA

When automatic failover occurs, Amazon Relational Database Service (Amazon RDS) will create a DB instance event. Using the AWS CLI, Which of the following will return information about the events related to the DB instance?

  • ReturnEventFailure
  • DescribeFailureEvent
  • DescribeEvents
  • ReturnEvents

Is it possible to force a failover for a MySQL Multi-AZ DB instance deployment?

  • Yes
  • No
  • Only in certain regions
  • Only in Amazon Virtual Private Cloud (Amazon VPC)

How does the Amazon Relational Database Service (Amazon RDS) Multi-AZ model work?

  • A second, standby database is deployed and maintained in a different Availability Zone from the primary database, using synchronous replication.
  • A second, standby database is deployed and maintained in a different region from the primary database, using synchronous replication.
  • A second, standby database is deployed and maintained in a different Availability Zone from the primary database, using synchronous replication.
  • A second, standby database is deployed and maintained in a different region from the primary database, using synchronous replication.

What does Amazon ElastiCache provide?

  • An Amazon Elastic Compute Cloud (Amazon EC2) instance with a large amount of memory and CPU
  • A managed in-memory cache service
  • An Amazon EC2 instance with Redis and Memcached preinstalled
  • A highly available and fast indexing service for searching

When developing a highly available web application using stateless web servers, which service are suitable for storing session-state data? (Choose three.)

  • Amazon Simple Queue Service (Amazon SQS)
  • Amazon Relation Database Service (Amazon RDS)
  • Amazon CloudWatch
  • Amazon ElastiCache
  • Amazon DynamoDB
  • Amazon CloudFront

Which statement bset describes Amazon ElastiCache?

  • It reduces the latency of a DB instance by splitting the workload across multiple availability Zones.
  • It provides a simple web interface to create and store multiple datasets, query your data easily, and return the results.
  • It is a managed service from AWS that makes it easy to set up, operate, and scale a relational database in the cloud.
  • It offloads the read traffic from a database in order to reduce latency caused by read-heavy workload.

Which two AWS Cloud services provide out-of-the-box, user-configurable, automatic backup-as-a-service and backup rotation options? (Choose two.)

  • AWS CloudFormation
  • Amazon Simple Storage Service (Amazon S3)
  • Amazon Relational Database Service (Amazon RDS)
  • Amazon Elastic Block Store (Amazon EBS)
  • Amazon DynamoDB
  • Amazon Redshift
Rajesh Kumar
Follow me
Latest posts by Rajesh Kumar (see all)