Module 5

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

Which statement that compares a database service that Amazon Web Services (AWS) manages with a database on an Amazon Elastic Compute Cloud (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 database 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.

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 Amazon Web Services (AWS)

A small company is deciding which service to use for an enrollment system for their online training website. Choices are MySQL on Amazon Elastic Compute Cloud (Amazon EC2), MySQL in Amazon Relational Database Service (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 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.

Which scenarios are good use cases for Amazon DynamoDB? (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

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 Relational Database Service (Amazon RDS) to store data for 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, each with different attributes

• Quick search and retrieval of player-created objects

• High amount of read activity on player-created objects

Which techniques should you use to secure an Amazon Relational Database Service (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

• A virtual private gateway (VGW) to filter traffic from restricted networks

• A virtual private cloud (VPC) to provide instance isolation and firewall protection

• Encryption to protect sensitive data

Which techniques should you use to secure Amazon DynamoDB? (Select THREE)

• Encryption to protect sensitive data

• A virtual private gateway (VGW) to filter traffic from restricted networks

• An Amazon Virtual Private Cloud (Amazon VPC) gateway endpoint to prevent traffic from traversing the internet

• Security groups to control network access to individual instances

• AWS Identity and Access Management (IAM) policies to define access at the table, item, or attribute level

: 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.

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 Service (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 in the target database in the VPC