Module 8 - Databases [Knowledge Check]

In Amazon DynamoDB, what does the query operation enable you to do? (Select the best answer) - Query a table using the partition key and an optional sort key filter - Query any secondary indexes that exist for a table - Efficiently retrieve items from a table or secondary index. - All of the above

All of the above

______ is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases.

Amazon Aurora

A company has an application, which consists of a .NET layer that connects to a MySQL database. They want to move this application on to AWS and use AWS features such as high availability and automated backups. Which of the following would an ideal database for this use case?

Amazon Aurora It is a MySQL- and PostreSQL- compatible relational database that would be ideal for this use case.

You are designing an ecommerce web application that will scale to hundreds of thousands of concurrent users. Which database technology is best suited to hold the session state in this example?

Amazon DynamoDB NoSQL databases like Amazon DynamoDB excel at scaling to hundreds of thousands of requests with key/value access to user profile and session.

If you are developing an application that requires a database with extremely fast performance, fast scalability, and flexibility in the database schema, which service should you consider?

Amazon DynomoDB

Which AWS Cloud service is best suited for analyzing your data by using a standard structured query language (SQL) and your existing business intelligence (BI) tools?

Amazon Redshift best suited for analyzing data

Which of the following use cases is appropriate for using Amazon Relational Database Service (Amazon RDS)? (Select the best answer) - Massive read/write rates - Simple read/write rates - Complex transactional / complex queries - All of the above

Complex transactional / complex queries

In Amazon DynamoDB, an attribute is ___.

Fundamental data element

When you create a table in Amazon DynamoDB, in addition to the table name, you must specify the _____ of the table.

Primary Key

You need to find an item in an Amazon DynamoDB table using an attribute other than item's primary key. Which of the following operations should you use? - PutItem - Scan - Query - GetItem

Scan