Question 1

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

AWS manages database patches for a database on a managed database service.
AWS manages operating system (OS) patches for a database on an EC2 instance.
Configuring backups for a database on an EC2 instance isn't needed.
Configuring backups for a database on a managed database service isn’t needed.

AWS patches the database system as part of a managed database service, which enables the customer to focus on their application. AWS managed database services also provide high availability, scalability, and backups as built-in options that the customer can configure.

Question 2

A small startup company is deciding which database service to use for an enrollment system for their online training website. Which requirements might lead them to select Amazon RDS rather than Amazon DynamoDB? (Select TWO.)

The data is highly structured.
Student, course, and registration data are stored in many different tables.
The enrollment system must be highly available.
Data and transactions must be encrypted to protect personal information.
Data must be backed up in case of disasters.

Amazon RDS is a better choice for uses cases that require complex joins of data from many different tables. It is also better when the data is highly structured (the database uses a strict schema).

Question 3

A startup company is building an order inventory system with a web frontend and is looking for a real-time transactional database. Which service would best meet their needs?

Amazon Redshift
Amazon DynamoDB
Amazon Neptune
Amazon DocumentDB (with MongoDB compatibility)

Amazon DynamoDB is a fully managed nonrelational database that provides fast, consistent performance that can support nearly any online transaction processing (OLTP) workload in real time.

Question 4

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 for player-created objects. Which proposed online game object features could make Amazon DynamoDB a better solution? (Select TWO.)

Game items that can be modified using data contained in other tables
A high amount of read activity on player-created objects and a low amount of writes
A set of common object attributes for player-created objects
Unpredictable object attributes for player-created objects
Game data items that include binary data and might exceed 700 MB

Because players create their own objects, the object attributes are unpredictable and the database schema cannot be determined beforehand. A high amount of read activity requires fast response times, which DynamoDB supports and would be expensive with Amazon RDS.

Question 5

An organization is concerned about an increase in fraud. Which service could help with building real-time graph database queries for fraud detection?

Amazon RDS
Amazon Redshift
Amazon DynamoDB
Amazon Neptune

Amazon Neptune is a fully managed graph database service built for the cloud that helps to build and run graph applications that work with highly connected datasets.

Question 6

A data engineer must host a new Microsoft SQL Server database in AWS for a project. Which service could they use to accomplish this task?

Amazon DynamoDB
Amazon Neptune
Amazon DocumentDB (with MongoDB compatibility)
Amazon Aurora

Aurora is a relational database management system that was built for the cloud with full MySQL and PostgreSQL compatibility.

Question 7

Which techniques should be used to secure an Amazon RDS database? (Select THREE.)

A virtual private cloud (VPC) to provide instance isolation
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 RDS instances
Encryption both at rest and in transit to protect sensitive data

Because Amazon RDS uses server instances, they deploy in an Amazon VPC, and the cloud architect controls network access to them by using security groups. It is always a good idea to use encryption to protect sensitive data in Amazon RDS, both at rest and in transit.

Question 8

Which techniques should be used to secure Amazon DynamoDB? (Select THREE.)

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

IAM controls access to tables and data in DynamoDB. A VPC gateway endpoint provides a route to DynamoDB that does not traverse the internet. Data in DynamoDB is encrypted by default; it is a good idea to use client-side encryption to encrypt sensitive data in transit.

Question 9

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

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

AWS SCT analyzes the schema of the source database, does the conversion, and then creates the schema in the target database. AWS DMS then copies the data to the target database.

Question 10

A cloud architect is setting up an application to use an Amazon RDS MySQL DB instance. The database must be architected for high availability across Availability Zones and AWS Regions with minimal downtime. How should they meet this requirement?

Set up an RDS MySQL Multi-AZ DB instance. Configure an appropriate backup window.
Set up an RDS MySQL Single-AZ DB instance. Copy automated snapshots to at least one other Region.
Set up an RDS MySQL Multi-AZ DB instance. Configure a read replica in a different Region.
Set up an RDS MySQL Single-AZ DB instance. Configure a read replica in a different Region.

This architecture ensures high availability across Availability Zones and AWS Regions, providing resilience and minimizing downtime.

CLD120 Module 6 Knowledge Check

Adding a Database Layer

Keyboard Shortcuts