A client application requires operating system privileges on a relational database server. What is an
appropriate configuration for a highly available database architecture?
A.
A standalone Amazon EC2 instance
B.
Amazon RDS in a Multi-AZ configuration
C.
Amazon EC2 instances in a replication configuration utilizing a single Availability Zone
D.
Amazon EC2 instances in a replication configuration utilizing two different Availability Zones
I think this answer is B.
Multi-AZ is a very important keyword in representing “highly available database architecture”.
Conversely, I never heard “EC2 instances in a replication configuration utilizing two different Availability Zones”.
I think its D
http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.ReplicationInstance.html
Not B. Needs OS access. You don’t get that with RDS
“A client application requires operating system privileges”
You cant have it using RDS.
D. You can’t have access to an RDS instance and you need high availability.
D
I choose D
I go with D
D
D
D
EC2 replication configurations are for Database Migration Service and the question says nothing about moving the database. I think B should be the correct option.
It’s B.
Amazon RDS provides high availability and failover support for DB instances using Multi-AZ
deployments. Multi-AZ deployments for Oracle, PostgreSQL, MySQL, and MariaDB DB instances use
Amazon technology, while SQL Server DB instances use SQL Server Mirroring.
D is wrong, Ec2 Instances are not used for RDS. RDS itself has it’s own instance service, so if the RDS database is deployed then that instance is from the RDS section and not from Ec2. Only you can configure Ec2 instance for read replica and here in answer red replica is not mentioned and read replica is not providing HA for write and question related to highly available database architecture?
But the client won’t have OS level access with RDS.
Why cannot say A..?
A client application requires OS privileges on a RDB Server.
in the RDS cannot have a privilege.
if client wants to have privileges, client should make own EC2 instance. isn’t it?
yes, but must be highly available database architecture, so i thing D is the right answer.
answer is D
B makes much more sense
D. With RDS, you don’t have access to OS privileges on RDS.
The question never asks fro RDS. It just says a relational database server, which can be mysql on its own not hosted with AWS. 🙂
D is correct
D
D
Since the client wants privilege on the RDS, option B is not valid. Since there is a requirement for highly availability, you cannot have just one AZ and one EC2 instance. Hence D is the right answer.
Please refer below link showing an architecture example to enable Oracle database high availability on EC2 server.
http://docs.aws.amazon.com/quickstart/latest/oracle-database/architecture.html
For more information, please read the below link: http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.ReplicationInstance.html
option 😀
option D
I choose B
but D also makes sense
anybody give us clarification