Q.1 Which of the following is the Non-Relational DB service offered by AWS?
A. MariaDB
B. DynamoDB
C. SQL Server
D. Aurora
Ans : DynamoDB
Q.2 Which scaling methodology is opted when the load is increased with nearly equal number of reads and writes?
A. Vertical Scaling
B. Horizontal Scaling
C. Any of the options
Ans : Vertical Scaling
Q.3 The default duration of the backup window in RDS is ________
A. 90 minutes
B. 45 minutes
C. 30 minutes
D. 1 hour
Ans : 30 minutes
Q.4 Which of the following services can have up to 15 read-replicas?
A. SQL Server
B. Redshift
C. Aurora
D. DynamoDB
Ans : Aurora
Q.5 For heavy gaming, read-intensive apps, IoT, and video hosting sites, ________ is preferred.
A. DynamoDB
B. Neptune
C. Redshift
D. MariaDB
Ans : DynamoDB
Q.6 Database backup in S3 is free until 100% of database size.
A. True
B. False
Ans : True
Q.7 DAX is an in-memory cache for DynamoDB.
A. True
B. False
Ans : True
Q.8 The local secondary index can be created only while creating the table.
A. True
B. False
Ans : True
Q.9 DynamoDB is backed by _________ type of disks, by default.
A. HDD
B. SDD
C. Magnetic tapes
Ans : SDD
Q.10 ________ is/are used to trigger lambda functions for changes in DynamoDB.
A. Index
B. Query
C. Streams
D. Scan
Ans : Streams
Q.11 The availability SLA of Aurora DB is __________
A. 0.99
B. 0.9999
C. 0.9996
D. 0.9995
Ans : 0.9999
Q.12 By default, Aurora has ________ configured.
A. Backup
B. Multi-AZ
C. Read-replica
D. All the options
Ans : Multi-AZ
Q.13 Aurora can have upto ________ low-latency replicas in ________ AZs.
A. 10, 3
B. 10, 4
C. 15, 4
D. 15, 3
Ans : 15, 3
Q.14 The service used for migration of database to AWS is ______?
Ans : DMS
Q.15 Aurora is both MySQL and Postgre SQL compatible?
A. True
B. False
Ans : True
Q.16 ElastiCache for memcached supports snapshots.
A. True
B. False
Ans : False
Q.17 Only DNS is provided for the SQL server, and not IPV4.
A. True
B. False
Ans : True
Q.18 A multi-AZ DB will have a little downtime, and a single AZ will be unavailable during the scaling operation.
A. True
B. False
Ans : True
Q.19 Read replicas can be promoted to become databases on their own.
A. True
B. False
Ans : True
Q.20 Can Multi AZ deployment be used for improving performance of DB ?
A. True
B. False
Ans : False
Q.21 The maximum number of compute nodes a cluster can have is ____________.
A. 128
B. 64
C. 80
D. 160
Ans : 128
Q.22 Which of the following search queries uses indexes?
A. Scan
B. Query
C. Both the options
Ans : Query
Q.23 The service used for migration of the database to AWS is ________
A. Snowball
B. DMS
C. Snowmobile
D. All the options
Ans : DMS
Q.24 Reserved DB instances can be purchased for ________ months, similar to EC2.
A. 10 or 30
B. 12 or 36
C. 15 or 30
D. All the options
Ans : 12 or 36
Q.25 Aurora can scale up to ___________.
A. 128GB
B. 64TB
C. 128TB
D. 64GB
Ans : 128TB
Q.26 Aurora is ________ times faster than the regular PostgreSQL database.
A. 3
B. 5
C. 2
D. 4
Ans : 3
Q.27 Aurora is ________ times faster than the regular MySQL database.
A. 3
B. 5
C. 2
D. 4
Ans : 5
Q.28 In columnar database, compression of data is easy.
A. True
B. False
Ans : True
