Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

Aurora can have upto ________ low-latency replicas in ________ AZs.

Answer» AURORA can have upto ________ low-latency replicas in ________ AZs.
Choose the CORRECT option from below list
(1)10, 3
(2)15, 3
(3)10, 4
(4)15, 4

Answer:-(2)15, 3
2.

The service used for migration of the database to AWS is ________

Answer»

The service used for MIGRATION of the DATABASE to AWS is ________
Choose the correct option from below list
(1)SNOWBALL
(2)Snowmobile
(3)DMS
(4)All the options

Answer:-(3)DMS

3.

Read replicas can be promoted to become databases on their own.

Answer»

Read replicas can be promoted to become databases on their own.
Choose the CORRECT option from below list
(1)FALSE
(2)TRUE

Answer:-(2)True

4.

In DynamoDB, the default consistency model enabled is _____________

Answer»

In DynamoDB, the default CONSISTENCY model ENABLED is _____________
Choose the correct OPTION from below list
(1)Eventual Consistency
(2)Strong Consistency

Answer:-(1)Eventual Consistency

5.

The availability SLA of Aurora DB is __________

Answer»

The availability SLA of AURORA DB is __________
Choose the correct option from below list
(1)0.9995
(2)0.99
(3)0.9996
(4)0.9999

Answer:-(4)0.9999

6.

DynamoDB is backed by _________ type of disks, by default.

Answer»

DynamoDB is BACKED by _________ type of DISKS, by default.
Choose the correct OPTION from below list
(1)HDD
(2)SDD
(3)Magnetic tapes

Answer:-(2)SDD

7.

A multi-AZ DB will have a little downtime, and a single AZ will be unavailable during the scaling operation.

Answer»

A multi-AZ DB will have a little downtime, and a single AZ will be unavailable during the scaling operation.
Choose the CORRECT option from below LIST
(1)True
(2)False

Answer:-(1)True

8.

Which of the following search queries uses indexes?

Answer»

Which of the FOLLOWING search QUERIES uses indexes?
Choose the CORRECT option from below list
(1)Query
(2)Both the OPTIONS
(3)Scan

Answer:-(1)Query

9.

Which among the following is used for disaster recovery?

Answer»

Which among the following is USED for disaster recovery?
Choose the CORRECT OPTION from below LIST
(1)Multi-AZ
(2)Read-replicas

Answer:-(1)Multi-AZ

10.

Aurora is both MySQL and PostgreSQL compatible.

Answer» AURORA is both MySQL and PostgreSQL compatible.
Choose the correct OPTION from below list
(1)True
(2)False

Answer:-(1)True
11.

The Graph database service provided by AWS is __________

Answer»

The Graph database service PROVIDED by AWS is __________
Choose the correct option from below list
(1)NEPTUNE
(2)Redshift
(3)DYNAMODB
(4)MariaDB

Answer:-(1)Neptune

12.

The number of secondary indexes a table can have is ________

Answer»

The number of secondary INDEXES a table can have is ________
Choose the correct option from below LIST
(1)3
(2)5
(3)2
(4)4

Answer:-(4)4

13.

ElastiCache for memcached supports snapshots.

Answer» ELASTICACHE for memcached supports snapshots.
Choose the CORRECT option from below LIST
(1)False
(2)True

Answer:-(1)False
14.

Which scaling methodology is opted when the load is increased with nearly equal number of reads and writes?

Answer»

Which scaling methodology is opted when the LOAD is increased with nearly EQUAL NUMBER of reads and writes?
Choose the correct option from below LIST
(1)VERTICAL Scaling
(2)Any of the options
(3)Horizontal Scaling

Answer:-(1)Vertical Scaling

15.

Aurora is ________ times faster than the regular PostgreSQL database.

Answer»

Aurora is ________ times faster than the REGULAR POSTGRESQL database.
Choose the correct OPTION from below LIST
(1)2
(2)5
(3)4
(4)3

Answer:-(4)3

16.

Aurora can scale up to ___________

Answer»

Aurora can scale up to ___________
CHOOSE the CORRECT OPTION from below list
(1)64GB
(2)128GB
(3)128TB
(4)64TB

Answer:-(3)128TB

17.

In columnar database, compression of data is easy.

Answer»

In COLUMNAR database, compression of DATA is easy.
Choose the correct option from below LIST
(1)False
(2)TRUE

Answer:-(2)True

18.

Only DNS is provided for the SQL server, and not IPV4.

Answer»

Only DNS is PROVIDED for the SQL SERVER, and not IPV4.
Choose the correct option from below list
(1)TRUE
(2)False

Answer:-(1)True

19.

Can Multi AZ deployment be used for improving performance of DB?

Answer»

Can Multi AZ deployment be used for IMPROVING performance of DB?
Choose the correct option from below list
(1)True
(2)FALSE

Answer:-(2)False

20.

Which of the following services can have up to 15 read-replicas?

Answer»

Which of the FOLLOWING services can have up to 15 read-replicas?
Choose the correct option from below LIST
(1)SQL Server
(2)Redshift
(3)Aurora
(4)DynamoDB

Answer:-(3)Aurora

21.

Aurora is both MySQL and Postgre SQL compatible?

Answer» AURORA is both MYSQL and Postgre SQL compatible?
CHOOSE the CORRECT option from below list
(1)True
(2)False

Answer:-(1)True
22.

Reserved DB instances can be purchased for ________ months, similar to EC2.

Answer»

Reserved DB INSTANCES can be purchased for ________ months, similar to EC2.
Choose the correct option from below list
(1)10 or 30
(2)12 or 36
(3)15 or 30
(4)All the options

Answer:-(2)12 or 36