2024 AWS SOLUTIONS ARCHITECT
(DATABASES) EXAM WITH
CORRECT ANSWERS
Simple querying, selecting or retrieving data, simple data manipulations.
Amazon RDS could be used for this purpose - CORRECT-ANSWERSOnline
Transaction Processing (OLTP)
Manipulation of information to create business intelligence in support of
strategic decision making; it could used for data warehousing; it pulls lots of
records, queries, used to determine data trends and make predictions.
Amazon Redshift and Elasticache could be used for this. - CORRECT-
ANSWERSOnline Analytical Processing (OLAP)
What are serverless AWS DB solutions? - CORRECT-ANSWERSSolution:
Aurora
What are relational database Amazon DB solutions? - CORRECT-
ANSWERSSolution: RDS, Redshift
What are NOSQL Amazon DB solutions? - CORRECT-ANSWERSSolution:
DynamoDB
Fully managed, highly available, in-memory cache for DynamoDB that
delivers up to 1-x performance improvement. Use case would be to improve
write performance and to prepare for shutouts as it provides fail-over to
another AZ. - CORRECT-ANSWERSDynamoDB Accelerator (DAX)
The grouping of multiple actions together. - CORRECT-ANSWERSTransaction
Used for new product launches; offers pay-per-request pricing to balance
cost and performance. There is no charge for read/write but you pay more
per request than with provisioned capacity. - CORRECT-ANSWERSOn-
Demand Capacity
Protects against accidental writes or deletes, restores to any moment in the
last 35 days, incremental backups, must be enabled, latest restorable
timestamp is 5 minutes in the past. - CORRECT-ANSWERSPoint-in-Time
Recovery (PITR)
, A time-ordered sequence of item-level changes in a table which contain of
stream records and shards. - CORRECT-ANSWERSStreams
Used to manage multi-master, multi-region replication based on DynamoDB
streams. - CORRECT-ANSWERSGlobal Tables
A cloud web service that helps in the migration of data from one data source
to another. It is used to migrate your data into the AWS Cloud, between on-
prem, instances (through an AWS Cloud setup), or between combinations of
cloud and on-prem setups. - CORRECT-ANSWERSDatabase Migration Service
(DMS)
Name (6) security measures for AWS Databases. (Solution:) - CORRECT-
ANSWERSSolution: Encryption at rest using KMS, Site-to-site VPN, Direct
Connect (DX), IAM policies and roles, Cloudwatch and CloudTrail, VPC
Endpoints.
What are (4) services that have caching capabilities? (Solution:) - CORRECT-
ANSWERSSolution: CloudFront, API Gateway, ElastiCache, Dynamo DB
Accelerator
The industry-leading cloud big data platform for processing vast amounts of
data using open-source tools such as Apache Spark, Apache Hive, Apache
HBase, Apache Flink, Apache Hudi, and Presto. - CORRECT-ANSWERSAmazon
Elastic MapReduce (EMR)
Collection of EC2 Instances - CORRECT-ANSWERSCluster
A node that manages the cluster by tracking the status of tasks and monitors
the health of the cluster. - CORRECT-ANSWERSMaster node
A node with software components that runs tasks and stores data in the
Hadoop Distributed File (HDFS) on your cluster. - CORRECT-ANSWERSCore
node
A node with software components that only runs tasks and does not store
data in HDFS. - CORRECT-ANSWERSTask node
What happens if there is an outage and you need the log data in the master
node to persist, what do you do? (Solution:) - CORRECT-ANSWERSSolution:
Configure a cluster to periodically archive log files stored on the master node
to Amazon S3
(DATABASES) EXAM WITH
CORRECT ANSWERS
Simple querying, selecting or retrieving data, simple data manipulations.
Amazon RDS could be used for this purpose - CORRECT-ANSWERSOnline
Transaction Processing (OLTP)
Manipulation of information to create business intelligence in support of
strategic decision making; it could used for data warehousing; it pulls lots of
records, queries, used to determine data trends and make predictions.
Amazon Redshift and Elasticache could be used for this. - CORRECT-
ANSWERSOnline Analytical Processing (OLAP)
What are serverless AWS DB solutions? - CORRECT-ANSWERSSolution:
Aurora
What are relational database Amazon DB solutions? - CORRECT-
ANSWERSSolution: RDS, Redshift
What are NOSQL Amazon DB solutions? - CORRECT-ANSWERSSolution:
DynamoDB
Fully managed, highly available, in-memory cache for DynamoDB that
delivers up to 1-x performance improvement. Use case would be to improve
write performance and to prepare for shutouts as it provides fail-over to
another AZ. - CORRECT-ANSWERSDynamoDB Accelerator (DAX)
The grouping of multiple actions together. - CORRECT-ANSWERSTransaction
Used for new product launches; offers pay-per-request pricing to balance
cost and performance. There is no charge for read/write but you pay more
per request than with provisioned capacity. - CORRECT-ANSWERSOn-
Demand Capacity
Protects against accidental writes or deletes, restores to any moment in the
last 35 days, incremental backups, must be enabled, latest restorable
timestamp is 5 minutes in the past. - CORRECT-ANSWERSPoint-in-Time
Recovery (PITR)
, A time-ordered sequence of item-level changes in a table which contain of
stream records and shards. - CORRECT-ANSWERSStreams
Used to manage multi-master, multi-region replication based on DynamoDB
streams. - CORRECT-ANSWERSGlobal Tables
A cloud web service that helps in the migration of data from one data source
to another. It is used to migrate your data into the AWS Cloud, between on-
prem, instances (through an AWS Cloud setup), or between combinations of
cloud and on-prem setups. - CORRECT-ANSWERSDatabase Migration Service
(DMS)
Name (6) security measures for AWS Databases. (Solution:) - CORRECT-
ANSWERSSolution: Encryption at rest using KMS, Site-to-site VPN, Direct
Connect (DX), IAM policies and roles, Cloudwatch and CloudTrail, VPC
Endpoints.
What are (4) services that have caching capabilities? (Solution:) - CORRECT-
ANSWERSSolution: CloudFront, API Gateway, ElastiCache, Dynamo DB
Accelerator
The industry-leading cloud big data platform for processing vast amounts of
data using open-source tools such as Apache Spark, Apache Hive, Apache
HBase, Apache Flink, Apache Hudi, and Presto. - CORRECT-ANSWERSAmazon
Elastic MapReduce (EMR)
Collection of EC2 Instances - CORRECT-ANSWERSCluster
A node that manages the cluster by tracking the status of tasks and monitors
the health of the cluster. - CORRECT-ANSWERSMaster node
A node with software components that runs tasks and stores data in the
Hadoop Distributed File (HDFS) on your cluster. - CORRECT-ANSWERSCore
node
A node with software components that only runs tasks and does not store
data in HDFS. - CORRECT-ANSWERSTask node
What happens if there is an outage and you need the log data in the master
node to persist, what do you do? (Solution:) - CORRECT-ANSWERSSolution:
Configure a cluster to periodically archive log files stored on the master node
to Amazon S3
