Module 5: Adding a Database Layer

Question 1

Which use cases indicate that a non-relational database might be a better solution than a relational database? (Select TWO.)

• Horizontal scaling for massive data volume
• ACID compliance for all database transactions
• Data with unpredictable attributes
• Strong read-after-write consistency
• High availability and fault tolerance

Answer 1

• Horizontal scaling for massive data volume
• Data with unpredictable attributes

Question 2

Which statement that compares a database service that Amazon Web Services (AWS) manages with a database on an Amazon EC2 instance is true?

• You do not need to configure backups for a database on a managed database service.
• AWS manages DB patches for a database on a managed databases service.
• AWS manages operating system (OS) patches for a database on an EC2 instance.
• You do not need to configure backups for a database on an EC2 instance.

Answer 2

• AWS manages DB patches for a database on a managed databases service.

Question 3

Which examples are good use cases for Amazon Relational Database Service (Amazon RDS)? (Select THREE.)

• Thousands of distributed concurrent writes per second
• An application that requires the database to enforce syntax rules
• An application that requires complex joins of data
• A petabyte-scale data warehouse
• Running a Microsoft SQL Server in AWS
• Database for serverless architectures

Answer 3

• An application that requires the database to enforce syntax rules
• An application that requires complex joins of data
• Running a Microsoft SQL Server in AWS

Question 4

A small company is deciding which service to use for an enrollment system for their online training website. Choices are MySQL on Amazon EC2, MySQL in Amazon RDS, and Amazon DynamoDB. Which combination of use cases suggests using Amazon RDS? (Select THREE)

• Data and transactions must be encrypted to protect personal information.
• The data which is highly structured.
• Student, course, and registration data are stored in many different tables.
• The enrollment system must be highly available.
• The company doesn’t want to manage database patches.

Answer 4

(All three options support encryption for data and transactions. Managed services provide high availability and backups as configurable options. They can be implemented for Amazon EC2 as part of the architecture design.)

Question 5

Which scenarios are good use cases for Amazon Dynamo DB (Select THREE.)

• Database for serverless architectures
• Applications that require ACID transactions
• Applications that combine data from many tables
• Graph database to trace relationships between entities
• Document database for JavaScript Object Notation (JSON)-based documents
• Binary large object (BLOB) storage

Answer 5

(Amazon DynamoDB is better when data can be stored in a few tables. An RDBMS is better suited to joining data from many tables. DynamoDB is not a graph database; use Amazon Neptune instead. Do not store BLOBS in Dynamo DB, store a link to the BLOB that is stored in S3.)

• Database for serverless architectures
• Applications that require ACID transactions
• Document database for JavaScript Object Notation (JSON)-based documents

Question 6

A small game company is designing an online game, where thousands of players can create their own in-game objects. The current design uses a MySQL database in Amazon RDS to store data from player-created objects. Which use cases suggest that DynamoDB might be a better solution? (Select TWO.)

• A set of common attributes that all player-created objects have
• Unpredictable attributes for player-created objects
• Large number of player-created objects, weach with different attributes
• Quick search and retrieval of player-created objects
• High amount of read activity on player-created objects

Answer 6

• Unpredictable attributes for player-created objects
• Large number of player-created objects, weach with different attributes

( Because players create their own objects, the object attributes are unpredictable, and the database schema cannot be determined beforehand. A large number of objects, each with potentially different attributes, is a good use case for Amazon Dynamo DB)

Question 7

Which techniques should you use to secure an Amazon RDS database? (Select THREE.)

• AWS Identity and Access Management (IAM) policies to define access at the table, row and column levels
• Security groups to control network access to individual instances
• An Amazon VPC gateway endpoint to prevent traffic from traversing the internet
• A virtual private gateway (VPG) to filter traffic from restricted networks
• A virtual private cloud (VPC) to provide instance isolation and firewall protection
• Encryption to protect sensitive data

Answer 7

( The RDBMS controls access to the tables and data, and IAM does not. VPC gateway endpoints are not available for Amazon RDS; use network ACLs, security groups, and VPC interface endpoints to restrict traffic. A VGW is used in AWS Direct Connect, not to filter traffic.)

Question 8

Which techniques should you use to secure Amazon Dynamo DB? (Select THREE.)

• An Amazon VPC gateway endpoint to prevent traffic from traversing the internet.
• AWS Identity and Access Management (IAM) polices to define access at the table, item, or attribute level
• Security groups to control network access to individual instances
• A virtual private gateway (VGW) to filter traffic from restricted networks
• Encryption to protect sensitive data
• A virtual private cloud (VPC) to provide instance isolation and firewall protection

Answer 8

• AWS Identity and Access Management (IAM) polices to define access at the table, item, or attribute level
• Encryption to protect sensitive data
• A virtual private cloud (VPC) to provide instance isolation and firewall protection

(Because DynamoDB is serverless, it does not have instances that deploy in a VPC and use security groups. A VGW is used in Direct Connect, not to filter traffic.)

Question 9

A company wants to migrate their on-premises Oracle database to Amazon Aurora MySQL. Which process describes the high-level steps?

• Use AWS Database Migration Service (AWS DMS) to migrate from the Oracle database to Amazon Aurora MySQL.
• Use AWS Database Migration Service (AWS DMS) to migrate the data, and then use AWS Schema Conversion Tool to convert the schema
• Use AWS Schema Conversion Tool to convert the schema, and then use AWS Database Migration Service (AWS DMS) to migrate the data.
• Use AWS Schema Conversion Tool to synchronously convert the schema and migrate the data.

Answer 9

• Use AWS Schema Conversion Tool to convert the schema, and then use AWS Database Migration Service (AWS DMS) to migrate the data.

Question 10

You must perform a heterogeneous migration from your on-premises facility to a database in a virtual private cloud (VPC). You will use AWS Snowball Edge and AWS Database Migration Services (AWS DMS). At which point do you use AWS Schema Conversion Tool (AWS SCT)?

• At the start, to extract data from the source database into the Snowball Edge, before shipping the device
• After extracting the data from the source database by using AWS DMS, but before shipping the Snowball Edge
• After the data is in the VPC, but before using AWS DMS to load the data into the target database
• After using AWS DMS to load the data into the target database in the VPC

Answer 10

• At the start, to extract data from the source database into the Snowball Edge, before shipping the device