NTC 302 Wk 4 – Practice: Knowledge Check – Databases

Question 1

3

/ 3

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

Amazon Simple Storage Service Glacier

Amazon Redshift

Amazon Relational Database Service (Amazon RDS)

Amazon DynamoDB

Question 2

3

/ 3

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 be an ideal database for this use case?

Amazon Aurora

Amazon RDS

Amazon DynamoDB

Amazon Redshift

Question 3

3

/ 3

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 DynamoDB

Amazon Redshift

Amazon Relational Database Service (Amazon RDS)

Amazon ElastiCache

Question 4

3

/ 3

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 Simple Storage Service (Amazon S3)

Amazon DynamoDB

Amazon Redshift

Amazon Relational Database Service (Amazon RDS)

Question 5

3

/ 3

In Amazon DynamoDB, what does the query operation enable you to do?

All of the above

Query a table using the partition key and an optional sort key filter

Efficiently retrieve items from a table or secondary index

Query any secondary indexes that exist for a table

Question 6

3

/ 3

In Amazon DynamoDB, an attribute is ______.

a collection of items

a collection of attributes

a fundamental data element

Question 7

3

/ 3

Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

T

True

F

False

Question 8

3

/ 3

What should you consider when choosing a database type?

All of the above

Query frequency

Highly available

Data access period

Data size

Question 9

3

/ 3

You need to find an item in an Amazon DynamoDB table using an attribute other than the item’s primary key. Which of the following operations should you use?

PutItem

GetItem

Query

Scan

Question 10

3

/ 3

Which of the following use cases is appropriate for using Amazon Relational Database Service (Amazon RDS)?

Simple GET or PUT requests

Massive read/write rates

Complex transactions

All of the above