NTC 302 Week 4 Practice Knowledge Check Databases

NTC 302 Week 4 Practice Knowledge Check Databases

Question 1

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

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

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

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

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

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

In Amazon DynamoDB, an attribute is ______.

 

 

Question 7

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.

Question 8

What should you consider when choosing a database type?

 

 

Question 9

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?

 

 

Question 10

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