Premium

AWS Certified SysOps Administrator - Associate Questions and Answers (Dumps and Practice Questions)



Question :
Which of the following databases is not supported by RDS?

:
1. MySQL
2. Microsoft SQL Server
 3. Access Mostly Uused Products by 50000+ Subscribers
4. IBM DB2
5. None of the above


Correct Answer : Get Lastest Questions and Answer :

Explanation: Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient
and resizable capacity, while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle, SQL Server, or PostgreSQL database. This means that the code, applications, and tools you already use
today with your existing databases should work seamlessly with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for
a user-defined retention period. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your relational database instance
via a single API call or few clicks of the AWS Management Console . In addition, Amazon RDS makes it easy to use replication (currently supported for MySQL and Oracle database
engines) to enhance database availability, improve data durability, or scale beyond the capacity constraints of a single database instance for read-heavy database workloads. As with
all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use.





Question :
If Multi-AZ is enabled on your instance, the read replica (standby) instance will be located in the same availability zone.
:
1. True
2. False

Correct Answer : Get Lastest Questions and Answer :

Explanation: You can create a read replica from either Single-AZ or Multi-AZ DB instance deployments. You use a Multi-AZ deployment to improve the durability and availability of a critical
system, but you cannot use the Multi-AZ secondary to serve read-only queries. You must create read replicas from a high-traffic, Multi-AZ DB instance to offload read queries from the
source DB instance. If the source instance of a Multi-AZ deployment fails over to the secondary, any associated read replicas will be switched to use the secondary as their
replication source. It is possible that the read replicas cannot be switched to the secondary if some MySQL binlog events are not flushed during the failure. In this case, you must
manually delete and recreate the read replicas. You can reduce the chance of this happening in MySQL 5.1 or 5.5 by setting the sync-binlog=1 and innodb-xa-support=1 dynamic
variables. These settings may reduce performance, so test their impact before implementing the changes to a production environment. These problems are less likely to occur if you are
using MySQL 5.6. For instances running MySQL 5.6, the parameters are set by default to sync-binlog=1 and innodb-xa-support=1.





Question :
If using RDS, what do you not have access to?


:
1. Parameter Groups
2. MySQL Option Groups
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The operating system
5. None of the above


Correct Answer : Get Lastest Questions and Answer :

Explanation: Very well, you say, then what of an instance of EC2 running MySQL? Doesn't that provide the same functionality as RDS? True, but RDS pares the components to their MySQL
essentials. Unlike an EC2 instance, RDS requires no operating system configuration or management. Neither do you have to work out the details of connecting your EC2 instance to EBS
(Elastic Block Storage), nor worry over issues of backing up the EBS holding your database.



Related Questions

Question : A user has launched instances in EC-CLASSIC and attached elastic IPs to the five different instances in the US East region. The user is
creating a VPC in the same region. The user wants to assign an elastic IP to the VPC instance. How can the user achieve this?

 : A user has launched instances in EC-CLASSIC and attached elastic IPs to the five different instances in the US East region. The user is
1. The user has to request AWS to increase the number of elastic IPs associated with the account
2. AWS allows 10 EC2 Classic IPs per region; so it will allow to allocate new Elastic IPs to the same region
3. The AWS will not allow to create a new elastic IP in VPC; it will throw an error
4. The user can allocate a new IP address in VPC as it has a different limit than EC2


Question : A user has created a subnet in VPC and launched an EC instance within it. The user has not selected the option to assign the IP address while
launching the instance. Which of the below mentioned statements is true with respect to this scenario?
 : A user has created a subnet in VPC and launched an EC instance within it. The user has not selected the option to assign the IP address while
1. The instance will always have a public DNS attached to the instance by default
2. The user can directly attach an elastic IP to the instance
3. The instance will never launch if the public IP is not assigned
4. The user would need to create an internet gateway and then attach an elastic IP to the instance to connect from internet


Question : An organization has applied the below mentioned policy on an IAM group which has selected the IAM users. What entitlements do the IAM users avail with this policy?
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "*",
"Resource": "*"
}
]
}
 : An organization has applied the below mentioned policy on an IAM group which has selected the IAM users. What entitlements do the IAM users avail with this policy?
1. The policy is not created correctly. It will throw an error for wrong resource name
2. The policy is for the group. Thus, the IAM user cannot have any entitlement to this
3. It allows full access to all AWS services for the IAM users who are a part of this group
4. If this policy is applied to the EC2 resource, the users of the group will have full access to the EC2 Resources


Question : A user is configuring a CloudWatch alarm on RDS to receive a notification when the CPU utilization of RDS is higher than %. The user has
setup an alarm when there is some inactivity on RDS, such as RDS unavailability. How can the user configure this?
 : A user is configuring a CloudWatch alarm on RDS to receive a notification when the CPU utilization of RDS is higher than %. The user has
1. Setup the notification when the CPU is more than 75% on RDS
2. Setup the notification when the state is Insufficient Data
3. Setup the notification when the CPU utilization is less than 10%
4. It is not possible to setup the alarm on RDS




Question : George has shared an EC AMI created in the US East region from his AWS account with Stefano. George copies the same AMI to the US West
region. Can Stefano access the copied AMI of George's account from the US West region?
 : George has shared an EC AMI created in the US East region from his AWS account with Stefano. George copies the same AMI to the US West
1. No, copy AMI does not copy the permission
2. It is not possible to share the AMI with a specific account
3. Yes, since copy AMI copies all private account sharing permissions
4. Yes, since copy AMI copies all the permissions attached with the AMI



Question : A user has created a VPC with a subnet and a security group. The user has launched an instance in that
subnet and attached a public IP. The user is still unable to connect to the instance. The internet gateway has also been created. What can be the
reason for the error?
 : A user has created a VPC with a subnet and a security group. The user has launched an instance in that
1. The internet gateway is not configured with the route table
2. The private IP is not present
3. The outbound traffic on the security group is disabled
4. The internet gateway is not configured with the security group