AWS Solutions Architect Professional Flashcards
What are the 5 pillars of the well-architected framework?
- Operational Excellence
- Security
- Reliability
- Performance Effeciency
- Cost Optimization
- Sustainablility (not on current exam)
What is a homogenous migration in DMS?
In homogeneous database migrations, the source and target database engines are the same or are compatible—like Oracle to Amazon RDS for Oracle, MySQL to Amazon Aurora, MySQL to Amazon RDS for MySQL, or Microsoft SQL Server to Amazon RDS for SQL Server. Since the schema structure, data types, and database code are compatible between the source and target databases, this kind of migration is a one-step process.
What is a heterogenous migration in DMS?
In heterogeneous database migrations, the source and target databases engines are different—like in the case of Oracle to Amazon Aurora, Oracle to PostgreSQL, or Microsoft SQL Server to MySQL migrations. In this case, the schema structure, data types, and database code of source and target databases can be quite different, requiring a schema and code transformation before the data migration starts. That makes heterogeneous migrations a two-step process. First, use the AWS Schema Conversion Tool to convert the source schema and code to match that of the target database.
What tool can be used to covert schema to a different db format?
AWS schema conversion tool
What are the supported source db formats for DMS?
Oracle Microsoft SQL Server MySQL MariaDB PostgreSQL MongoDB SAP IBM db2 Azure SQL Google Cloud for MySQL s3 documentDB Aurora MySQL and PostgreSQL
What are the supported target db formats for DMS?
Oracle Microsoft SQL Server MySQL MariaDB PostgreSQL SAP Redis v6 Redshift s3 OpenSearch/Elasticsearch Elasticache Redis Kinesis Data Streams DcoumentDB Neptune Kafka Babelfish for PostgreSQL
What is the limit of records per shard in kinesis?
1000 records per shard, or 1MB/s, or 1000 writes/s
What are the components of a kinesis record?
partition key, sequence number, and data blob
What is the size limit of kinesis data blob?
1MB
What are the default and max retention times for kinesis stream?
default 24h
max 7 days
How is Kinesis firehose different than data streams
firehose simply delivers data to a storage destination such as s3. It doesn’t allow processing on the stream.
What is Kinesis Analytics?
lets you analyze and transform data in real time with Apache Flink. Works with both streams and firehose.
What is the dynamo db max item size?
400kb
What is a partition in dynamo db?
physical space where data is stored
What is a partition key in dynamo db?
unique identifier for each key. Records can have the same partition key if the sort key is different.
What is a sort key in dynamo db?
Combined with partition key to for defining storage order
What chunk size are dynamo db partitions divided into?
10gb
What is the formula for determining # of dynamo db partitions by capacity?
(total RCU/3000) + (total WCU/1000)
What is the formula for determing # of dynamo db partisions by size?
total size / 10gb
How to determine number of partitions in a dynamo db table?
round up MAX(by capacity, by size)
What is a dynamo db secondary global index?
Think of it as a copy of the original table. Can have different partition and sort keys
What autoscaling method does dynamo db use?
It uses target tracking for WCU and RCU utilization
What are some limitations of dynamo db scale down?
It won’t scale down automatically if consumption drops completely to 0.
What is dynamo db accelerator (DAX)
an in memory cache in front of dynamo db for speeding up latency