AWS Databases Essentials

A high-performing database is crucial to any organization. Databases support the internal operations of companies and store interactions with customers and suppliers.

download Export
search_insights Statistics
stylus_note White Board
Quran
calculate Calculator
dictionary Dictionary
fullscreen Full Screen
QUESTION OF

volume_mute Read quiz aloud
Views #: 1269
Questions #: 50
Time: 10 minutes
Pass Score: 80.0%
Style
Mode

If you migrate and host your relational database in Amazon (non-managed environment), you are responsible for

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


In a managed AWS database environment, you are responsible for

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon RDS

1 pts
volume_mute

Amazon RDS is a managed database service customers can use to create and manage relational databases in the cloud without the operational burden of traditional database management.

note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon RDS supports commercial and open source options

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon RDS is built from storage only

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


A DB instance can contain multiple databases with the same engine

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Underneath the DB instance is an EC2 instance, which you can manage through Amazon EC2 console.

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Match the DB instance class with tis definition

1 pts
volume_mute
  • (1) provide a balance of compute, memory, and network resources. They are a good choice for many database workloads.
  • (2) accelerate performance for workloads that process large datasets in memory.
  • (3) provide a baseline level of CPU performance with the ability to burst above the baseline.
Please drag and drop the selected option in the right place or type it instead
Memory optimized instances
Burstable performance instances
Standard instances
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


The storage portion of DB instances for Amazon RDS use

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Choose the storage types Amazon RDS supports

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


for database storage, General Purpose SSD is recommended for production environments

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


A DB instance has to live in a VPC same as an EC2 instance

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


In Amazon RDS, automated backups are not turned on by default

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon DynamoDB is a NoSQL database

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


ElastiCache is a fully managed in-memory caching solution

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon DocumentDB is a NoSQL database

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon DocumentDB has API compatibility with MongoDB

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon DocumentDB work well for

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon Neptune can be used efficiently with social network systems

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon Quantom Ledger Database (Amazon QLDB) provides a complete and cryptographically verifiable history of all changes made in an application data

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


MemoryDB is a Redis-compatible, durable, in-memory database service

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


You can use Amazon keyspaces database service for high-scale application that need top-tier performance

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Amazon timestream is database service for Internet of Things (IoT) and operational applications

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Match each database with the best use case to serve

1 pts
volume_mute
Database Service Best Use Case
(1) High-traffic web applications requiring single-digit millisecond response times.
(2) Caching frequently accessed data to improve the performance of read-heavy applications.
(3) Managing session state or real-time leaderboards in gaming applications.
(4) Content management systems or catalogs that require flexible schema for semi-structured data.
(5) Applications needing highly scalable, globally distributed data storage with wide-column data.
(6) Social networking applications requiring graph-based relationships like friends and followers.
(7) Time-series data processing for IoT devices or monitoring system metrics.
(8) Systems needing a cryptographically verifiable transaction log, such as financial ledgers.
Please drag and drop the selected option in the right place or type it instead
Amazon DynamoDB
Amazon Quantum Ledger Database (Amazon QLDB)
Amazon ElastiCache
Amazon DocumentDB (with MongoDB compatibility)
Amazon Neptune
Amazon Keyspaces (for Apache Cassandra)
Amazon MemoryDB for Redis
Amazon Timestream
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


DynamoDB core components

1 pts
volume_mute

A table in DynamoDB is a collection of (1), and each (2) is a collection of attributes.

note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


DynamoDB core components definitions

1 pts
volume_mute
Component Definition
(1) A collection of data
(2) Group of attributes that is uniquely identifiable among all other items
(3) Fundamental data element that does not need to be broken down any further
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


All user data stored in DynamoDB is fully encrypted at rest

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Match each database, or set of database services, to the database type and use cases

1 pts
volume_mute
AWS Service(s) Database Type Use Cases
(1) Relational Traditional applications, ERP, CRM,
ecommerce
(2) Key-value High-traffic web applications, ecommerce systems, gaming applications
(3) In-memory Caching, session management, gaming leaderboards, geospatial applications
(4) Document Content management, catalogs, user profiles
(5) Wide column High-scale industrial applications for equipment maintenance, fleet management, route optimization
(6) Graph Fraud detection, social networking, recommendation engines

 

(7)

Time series IoT applications, Development Operations (DevOps), industrial telemetry
(8) Ledger Systems of record, supply chain, registrations, banking transactions
Please drag and drop the selected option in the right place or type it instead
Amazon Keyspaces
DynamoDB
Amazon ElastiCache for Memcached,
Amazon ElastiCache for Redis
Timestream
Amazon RDS, Aurora,
Amazon Redshift
Amazon DocumentDB
Amazon QLDB
Neptune
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


With Amazon RDS, you can scale components of the service. What does this mean?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Which database service to use?

1 pts
volume_mute

An organization needs a fully managed database service to build an application that requires high concurrency and connections for millions of users and millions of requests per second. Which AWS database service should the organization use?

note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


You can pay for Amazon RDS using which of the following instance types?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Which of the following statements are true of security in Amazon RDS?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


You can create and modify an Amazon RDS database instance using which of the following?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Which of the following database engines can be run by Amazon RDS?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Which of the following security groups can control access to your Amazon RDS database instance?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Identify the main concepts and terminologies in DynamoDB

1 pts
volume_mute
  1. DynamoDB stores data in (1) which is a collection of data.
  2. Each table contains zero or more (2). An item is a group of attributes that is uniquely identifiable among all other items. 
  3. An item is composed of one or more (3).  An attribute is a fundamental data element, something that does not need to be broken down any further.
  4. When you create a table, in addition to the table name, you must specify the (4) of the table. 
  5. You can create one or more (5) indexes on a table. 
  6. DynamoDB (6) is an optional feature that captures data modification events in DynamoDB tables. The events are near real time and occurs when an item is created, updated, or deleted.
  7. One (7) capacity unit (RCU) represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 4 KB in size.
  8. One (8) capacity unit (WCU) represents one write per second for an item up to 1 KB in size.
  9. (9) is the action of limiting the number of requests that a client can submit to a given operation in a given amount of time. 
  10. DynamoDB has two (10) capacity modes for processing read/write transactions on your tables (On demand and Provisioned).
Please drag and drop the selected option in the right place or type it instead
read/write
tables
attributes
items
primary key
secondary
write
Streams
Throttling
read
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


The data type of a partition key or a sort key can be a

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Identify local and global indexes in DynamoDB

1 pts
volume_mute

Indexes are local or global. A (1) secondary index has the same partition key as its base table but a different sort key. Use (2) secondary indexes to query attributes outside the primary key of your original table.

Please drag and drop the selected option in the right place or type it instead
global
local
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


The size information of tables in DynamoDB is updated in

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


You can use AWS CLI to list and describe tables in DynamoDB

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


DynamoDB is integrated with CloudTrail capturing all API calls for DynamoDB as events

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


Choose the sets of metrics that DynamoDB sends to CloudWatch

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


You can use either DynamoDB console or CloudWatch to monitor DynamoDB metrics, which are the same

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


CloudWatch Contributor Insights for DynamoDB is a diagnostic tool for identifying the most frequently accessed and throttled keys in your table or index at a glance

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


If you use DynamoDB for a service that receives requests with several peak times and abrupt workload spikes, then

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


A _______ partition in DynamoDB refers to a situation where one or a few partitions in your DynamoDB table are receiving a disproportionately high amount of read or write traffic compared to other partitions

1 pts
volume_mute
Missing
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


What happens when a DynamoDB table or index exceeds its provisioned throughput limits, and how can this affect application performance?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


How can hot partitions in a DynamoDB table contribute to increased latency, and what design strategy can help mitigate this issue?

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


DynamoDB can efficiently handle short activity spikes

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation


You can use AWS OpsWorks to create, configure, and manage your database servers

1 pts
volume_mute
note_alt Add notes
flag Flag
volume_mute

Correct Answer

Explanation