Database Layer

What must every relational database table contain?​

• A foreign key​

• A primary key​

• An attribute

• A row

How many database engines can an RDS database instance run?​

• Six​

• One

• Two

• Four

Which database engines are compatible with existing MySQL databases? (Choose all that apply)​

• Microsoft SQL Server​

• MariaDB

• Aurora

• PostgresSQL

If you host your database on Amazon EC2 instances, which of the following operations must you manage? (Choose all that apply)

• Application optimization​

• OS Installation

• OS patches

• Database Backups

Which of the following is not a non-relational database?​

• DynamoDB

• Neptune

• Redshift

• Elasticache

Amazon DynamoDB works well with which of the following application use cases? (Choose two)

• An application that has simple high-volume data

• An application that use structured data​

• An application that needs to scale quickly​

• An application that processes complex joins

Which of the following application use cases are best suited for Amazon RDS? (Choose all that apply)​

• The application has complex data sets​

• The application needs to combine and join data sets​

• The application needs to scale quickly​

• The application has strict syntax rules

To ensure best performance, in which of the following situations would you choose to store data in a NoSQL database instead of a relational database?​

• You need to perform a variety of complex queries against the data​

• You need to query data based on only one attribute​

• You need to store JSON documents​

• The data will be used by different applications​