AWS SAA: Database Exam Questions And Correct Answers New Update (A+ Pass)
5 views 0 purchase
Course
AWS SAA
Institution
AWS SAA
AWS SAA: Database Exam Questions And Correct Answers New Update (A+ Pass)
What is RDS? - Answers -DBSaaS (Database Server as a Service)
- a managed service
Types of DB in RDS? - Answers -- MySQL
- Oracle
- PostgreSQL
Types of RDS MultiAZ - Answers -- MultiAZ instance
- MultiAZ Cluste...
Can DynamoDB be deployed inside a VPC? - Answers -No
Can DynamoDB uses interface endpoint? - Answers -No. Only gateway endpoint as it is
a public service.
Any public aws service cannot be directly put inside a vpc.
Auto Scaling in DynamoDB can be enabled via? - Answers -CLI only
In RDS MultiAZ Instance, Primary to Standby is asynchronous? - Answers -No.
Synchronous.
Protect RDS authentication from EC2 using? - Answers -IAM DB Authentication
What provides asynchronous replication of RDS? - Answers -RDS Read Replicas
Where does RDS stores data? - Answers -EBS Volumes
IAM DB Authentication is applicable in which type of DBs? - Answers -- MYSQL
- PostgreSQL
Which is synchronous: Multi-AZ replication, Multi-Region replication or both? - Answers
-Multi-AZ
, Can we use TDE in RDS MSSQL or Oracle for encrypting data in transit? - Answers -
No. it only encrypts data at rest.
Are DynamoDB streams enabled by default? - Answers -No.
What is DyanmoDB Stream Kinesis Adapter? - Answers -For real-time fetching and
action taking on DynamoDB streams.
BUT FIRST DYNAMODB STREAM NEEDS TO BE ENABLED.
RedShift Spectrum runs on which infrastructure? - Answers -EC2
Redshift Spectrum vs Athena: cost effective? - Answers -Athena
Can Aurora do analytical workload? - Answers -No. Only transactional. (relational
database)
Relation between DynamoDB RCU and WCU? - Answers -RCU = WCU/2
DynamoDB scales horizontally or vertically? - Answers -Horizontally
How many standby replicas in RDS MultiAZ Instance? - Answers -ONE
Replicas in RDS MultiAZ Instance can be written to? - Answers -No. Only read.
How many in RDS MultiAZ Cluster? - Answers -1 Writer
2 Reader
both in different AZs
Which RDS Instance has read scalability? - Answers -RDS MultiAZ Cluster
Charges apply for cross-region data copy for RDS. - Answers -<NIL>
Are RDS restores fast? - Answers -Nope.
Does creating new RDS instance creates a new address? - Answers -Yes.
How many direct read replicas per DB instance in RDS? - Answers -5
Do Read Replicas really offer near 0 RTO? - Answers -No. near 0 RPO (more data
replicated hence available at time of failure).
What is the security of RDS in transit? - Answers -SSL/TLS (available)
Does RDS supports EBS volume encryption? - Answers -yes. through KMS.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Stuviaascorers. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.