Databases and Analytics

Question 1

Amazon Relational Database Service (RDS)

Answer 1

• RDS uses EC2 instances, so you must choose an instance
  family/type
• Relational databases are known as Structured Query Language
  (SQL) databases
• RDS is an Online Transaction Processing (OLTP) type of database
• Easy to setup, highly available, fault tolerant, and scalable

Question 2

RDS Encryption

Answer 2

• Can encrypt your Amazon RDS instances and snapshots at rest
• Encryption uses AWS Key Management Service (KMS)

Question 3

RDS DB support types?

Answer 3

SQL Server, Oracle, MySQL Server, PostgreSQL, Aurora,
MariaDB

Question 4

RDS scaling measures and DR?

Answer 4

• Scales up by increasing instance size (compute and storage)
• Read replicas option for read heavy workloads (scales out for
  reads/queries only)
• Disaster recovery with Multi-AZ option

Question 5

Amazon Aurora

Answer 5

• Amazon Aurora is an AWS database offering in the RDS
  family
• Amazon Aurora is a MySQL and PostgreSQLcompatible relational database built for the cloud
• Amazon Aurora features a distributed, fault-tolerant, self healing storage system that auto-scales up to 128TB per database instance

Question 6

Amazon DynamoDB

Answer 6

• Fully managed NoSQL database service
• Key/value store and document store
• It is a non-relational, key-value type of database
• Fully serverless service
• Push button scaling

Question 7

Amazon DynamoDB features and benefits

Answer 7

Serverless - Fully managed, fault tolerant, service
Highly available - 99.99% availability SLA – 99.999% for Global Tables
NoSQL type of database with Name / Value
structure - Flexible schema, good for when data is not well structured or unpredictable
Horizontal scaling - Seamless scalability to any scale with push button scaling or Auto Scaling
DynamoDB Accelerator (DAX) - Fully managed in-memory cache for DynamoDB that increases performance (microsecond latency)
Backup - Point-in-time recovery down to the second in last 35 days; On-demand backup and restore
Global Tables - Fully managed multi-region, multi-master solution

Question 8

Amazon RedShift

Answer 8

• RedShift is a SQL based data warehouse used for analytics
  applications
• RedShift is a relational database that is used for Online
  Analytics Processing (OLAP) use cases
• RedShift uses Amazon EC2 instances, so you must choose an
  instance family/type
• RedShift always keeps three copies of your data
• RedShift provides continuous/incremental backups

Question 9

Amazon EMR

Answer 9

• Managed cluster platform that simplifies running big data
  frameworks including Apache Hadoop and Apache Spark
• Used for processing data for analytics and business
  intelligence
• Can also be used for transforming and moving large amounts
  of data
• Performs extract, transform, and load (ETL) functions

Question 10

Amazon ElastiCache

Answer 10

• Fully managed implementations Redis and Memcached
• ElastiCache is a key/value store
• In-memory database offering high performance and low
  latency
• Can be put in front of databases such as RDS and DynamoDB

Question 11

Amazon Athena

Answer 11

• Athena queries data in S3 using SQL
• Can be connected to other data sources with Lambda
• Data can be in CSV, TSV, JSON, Parquet and ORC formats
• Uses a managed Data Catalog (AWS Glue) to store
  information and schemas about the databases and tables

Question 12

AWS Glue

Answer 12

• Fully managed extract, transform and load (ETL) service
• Used for preparing data for analytics
• AWS Glue runs the ETL jobs on a fully managed, scale-out
  Apache Spark environment
• Works with data lakes (e.g. data on S3), data warehouses
  (including RedShift), and data stores (including RDS or EC2
  databases)

Question 13

Amazon Kinesis Data Streams

Answer 13

• Producers send data which is stored in shards for up to 7
  days
• Consumers process the data and save to another service

Question 14

Amazon Kinesis Data Firehose

Answer 14

• No shards, completely automated and elastically scalable
• Saves data directly to another service such as S3, Splunk,
  RedShift, or Elasticsearch

Question 15

Amazon Kinesis Data Analytics

Answer 15

• Provides real-time SQL processing for streaming data

Question 16

AWS Data Pipeline

Answer 16

AWS Data Pipeline
* Processes and moves data between different AWS compute and
storage services
* Save results to services including S3, RDS, DynamoDB, and EMR

Question 17

Amazon QuickSight

Answer 17

Amazon QuickSight
* Business intelligence (BI) service
* Create and publish interactive BI dashboards for Machine
Learning-powered insights

Question 18

Amazon Neptune

Answer 18

Amazon Neptune
* Fully managed graph database service

Question 19

Amazon DocumentDB

Answer 19

Amazon DocumentDB
* Fully managed document database service (non-relational)
* Supports MongoDB workloads
* Queries and indexes JSON data

Question 20

Amazon QLDB

Answer 20

• Fully managed ledger database for immutable change history
• Provides cryptographically verifiable transaction logging

Question 21

Amazon Managed Blockchain

Answer 21

• Fully managed service for joining public and private networks
  using Hyperledger Fabric and Ethereum

Question 22

AWS Migration Hub

Answer 22

• Provides a single location to track the progress of application
  migrations across multiple AWS and partner solutions

Question 23

AWS Database Migration Service (DMS)

Answer 23

• AWS Database Migration Service helps you migrate
  databases to AWS quickly and securely.
• The source database remains fully operational during the
  migration, minimizing downtime to applications that rely on
  the database

Question 24

AWS Server Migration Service (SMS)

Answer 24

• Migrates servers and virtual machines to Amazon EC2
• Agentless service which makes it easier and faster for you to
  migrate thousands of on-premises workloads to AWS
• Automate, schedule, and track incremental replications of
  live server volumes

Question 25

AWS DataSync

Answer 25

* Online data transfer service * Transfer data between on-premises and AWS storage services

Question 26

Snowball Family

Answer 26

* AWS Snowball and Snowmobile are used for migrating large volumes of data to AWS Uses a secure storage device for physical transportation * Snowball (80TB) (50TB ) “petabyte scale” * Snowball Edge (100TB) “petabyte scale” * Snowmobile – “exabyte scale” with up to 100PB per Snowmobile Types Snowball Edge Compute Optimized Snowball Edge Storage Optimized Snowcone

Question 27

Snowball Edge Compute Optimized

Answer 27

* Provides block and object storage and optional GPU * Edge computing use cases

Question 28

Snowball Edge Storage Optimized

Answer 28

* Provides block storage and Amazon S3-compatible object storage * Use for local storage and large-scale data transfer

Question 29

Snowcone

Answer 29

* Small device used for edge computing, storage and data transfer * Can transfer data offline or online with AWS DataSync agent

Question 30

AWS Rekognition

Answer 30

* Add image and video analysis to your applications * Identify objects, people, text, scenes, and activities in images and videos

Question 31

Amazon Transcribe

Answer 31

* Add speech to text capabilities to applications * Recorded speech can be converted to text before it can be used in applications

Question 32

Amazon Translate

Answer 32

* Neural machine translation service that delivers fast, highquality, and affordable language translation * Localize content such as websites and applications for your diverse users

Question 33

Amazon Sagemaket

Answer 33

* Helps data scientists and developers to prepare, build, train, and deploy high-quality machine learning (ML) models

Question 34

Amazon Comprehend

Answer 34

* Natural-language processing (NLP) service * Uses machine learning to uncover information in unstructured data

Question 35

Amazon Lex

Answer 35

* Conversational AI for Chatbots * Build conversational interfaces into any application using voice and text

Question 36

Amazon Polly

Answer 36

* Turns text into lifelike speech * Create applications that talk, and build entirely new categories of speech-enabled products

Question 37

Amazon Workspaces

Answer 37

* Managed Desktop-as-a-Service (DaaS) solution * Provision either Windows or Linux desktops

Question 38

AWS AppStream 2.0

Answer 38

* Fully managed non-persistent application streaming service * Alternative to popular products such as Citrix XenApp

Question 39

AWS Worklink

Answer 39

* Provides secure, one-click access to your internal websites and web apps using mobile phone browsers * Does not require VPN client or App

Question 40

AWS WorkDocs

Answer 40

* Fully managed, secure content creation, storage, and collaboration service * Create, edit, and share content that’s centrally stored on AWS

Question 41

AWS IoT Core

Answer 41

* Lets you connect IoT devices to the AWS cloud without the need to provision or manage servers