Database

Question 1

What is OLAP

Answer 1

Online Analytical Processing Redshift

Question 2

Which of the following data formats does Amazon Athena support?

Answer 2

Apache ORC Apache Parquet JSON

Question 3

If you want your application to check RDS for an error, have it look for an __ code in the response from the Amazon RDS API.

Answer 3

Error

Question 4

MySQL installations default to port number ____.

Answer 4

3306

Question 5

RDS Reserved instances are available for multi-AZ deployments.

Answer 5

True

Question 6

In RDS, changes to the backup window take effect ____.

Answer 6

Immediately

Question 7

what is the maximum size RDS volume you can have by default

Answer 7

16TB

Question 8

With new RDS DB instances, automated backups are enabled by default?

Answer 8

True

Question 9

Which set of RDS database engines is currently available?

Answer 9

Oracle, SQL Server, MySQL, PostgreSQL

Question 10

OLTP

Answer 10

(Online Transactional Processing) RDS

Question 11

Which AWS DB platform is most suitable for OLTP?

Answer 11

RDS

Question 12

How many copies of my data does RDS - Aurora store by default?

Answer 12

6

Question 13

In RDS, what is the maximum value I can set for my backup retention period?

Answer 13

35 Days

Question 14

You are hosting a MySQL database on the root volume of an EC2 instance. The database is using a large number of IOPS, and you need to increase the number of IOPS available to it. What should you do?

Answer 14

Add 2 additional EBS SSD volumes and create a RAID 0 volume to host the database. Why is this incorrect? CloudFront does not increase IOPS, CloudFront is a Content Delivery Network that helps deliver content closer to the consumers of the content. Correct Answer: B Why is this correct? RAID 0 provides performance improvements compared with a single volume as data can be read and written to multiple disks simultaneously. 2 disks, each with a bandwidth of 4,000 IOPS will provide a combined bandwidth of 8,000 IOPS.

Question 15

Which of the following DynamoDB features are chargeable, when using a single region?

Answer 15

Read and Write Capacity Storage of Data

Question 16

RDS and Elasticache

Answer 16

You should consider; using ElastiCache, using RDS Read Replicas Scaling up may also resolve the contention, however it may be more expensive than offloading the read activities to cache or Read-Replicas. RDS Multi-AZ is for resilience only.

Boosting MySQL database performance with Amazon ElastiCache for Redis

Relational databases are a cornerstone of most applications. When it comes to scalability and low latency though, there’s only so much you can do to improve performance. Even if you add replicas to scale reads, there’s a physical limit imposed by disk based storage. The most effective strategy for coping with that limit is to supplement disk-based databases with in-memory caching.

https://aws.amazon.com/getting-started/hands-on/boosting-mysql-database-performance-with-amazon-elasticache-for-redis/

Question 17

Which of the following strategies does AWS use to deliver the promised levels of DynamoDB performance?

Answer 17

Data is stored on Solid State Disks.

The Database is partitioned across a number of nodes.

DynamoDB makes use of parallel processing to achieve predictable performance. You visualise each partition as an independent DB server of fixed size. Each responsible for a defined block of data. In SQL terminology it is called sharding. The documentation is specific about the SSDs, but makes no mention of read-replicas or EBS-Optimised. Caching in-front of DDB is an option (DAX), but it is not inherent to DDB.

Question 18

You have a database-style application that frequently has multiple reads and writes across the data set. Which of the following AWS storage services are capable of hosting this application?

thumb_upthumb_down

Answer 18

Elastic File Service (EFS)

EBS

NOT S3