AWS Study Deck - SAA > Chapter 4 - DATABASES: Amazon RDS, Amazon Aurora, Amazon DynamoDB, Elasticache, Amazon DocumentDB > Flashcards

Chapter 4 - DATABASES: Amazon RDS, Amazon Aurora, Amazon DynamoDB, Elasticache, Amazon DocumentDB Flashcards

(185 cards)

Study These Flashcards
1
Q

How can you increase the high availability of Amazon RDS?

  1. Create periodic snapshot of main DB Instance in another AZ
  2. Use RDS Multi-AZ deployment
  3. Use RDS Read Replicas
  4. Create two similar DB instances in separate AZ and do periodic synchronization
A
  1. Create periodic snapshot of main DB Instance in another AZ
  2. Use RDS Multi-AZ deployment
  3. Use RDS Read Replicas
  4. Create two similar DB instances in separate AZ and do periodic synchronization
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How Amazon RDS provides high availability? Choose 2.

  1. Amazon RDS provides high availability through Multi-AZ deployment
  2. Amazon RDS provides high availability through Read Replicas
  3. In a Multi-AZ deployment automatically provisions and maintains a synchronous standby replica in a different Availability Zone.
  4. In a Multi-AZ deployment automatically provisions and maintains an asynchronous standby read replica in a different Availability Zone.
A
  1. Amazon RDS provides high availability through Multi-AZ deployment
  2. Amazon RDS provides high availability through Read Replicas
  3. In a Multi-AZ deployment automatically provisions and maintains a synchronous standby replica in a different Availability Zone.
  4. In a Multi-AZ deployment automatically provisions and maintains an asynchronous standby read replica in a different Availability Zone.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which database engines are supported by Amazon RDS?

  1. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server
  2. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  3. MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  4. MySQL, MariaDB, Oracle, Microsoft SQL Server, Amazon Aurora
A
  1. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server
  2. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  3. MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  4. MySQL, MariaDB, Oracle, Microsoft SQL Server, Amazon Aurora
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which AWS database service will you choose for Online Transaction Processing (OLTP)?

  1. Amazon RDS
  2. Amazon Redshift
  3. Amazon Glacier
  4. Amazon DynamoDB
A
  1. Amazon RDS
  2. Amazon Redshift
  3. Amazon Glacier
  4. Amazon DynamoDB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are three types of instance classes supported by Amazon RDS?

  1. Standard
  2. Memory Optimized
  3. Burstable Performance
  4. Performance Optimized
A
  1. Standard
  2. Memory Optimized
  3. Burstable Performance
  4. Performance Optimized
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which automated monitoring tools you can use to watch Amazon RDS and report when something is wrong? Choose 4.

  1. Amazon RDS Events
  2. Database log files
  3. Amazon Inspector
  4. Amazon RDS Enhanced Monitoring
  5. Amazon CloudWatch
A
  1. Amazon RDS Events
  2. Database log files
  3. Amazon Inspector
  4. Amazon RDS Enhanced Monitoring
  5. Amazon CloudWatch
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does Amazon RDS manages on user’s behalf? Choose 2.

  1. Provisioning the infrastructure capacity requested to installing the database software.
  2. Once database is up and running, Amazon RDS automates common administrative tasks such as performing backups and patching the software that powers your database
  3. Managing the database settings that are specific to your application.
  4. Automatic performance tuning to optimize your database for your application’s workflow.
A
  1. Provisioning the infrastructure capacity requested to installing the database software.
  2. Once database is up and running, Amazon RDS automates common administrative tasks such as performing backups and patching the software that powers your database
  3. Managing the database settings that are specific to your application.
  4. Automatic performance tuning to optimize your database for your application’s workflow.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the steps taken by RDS when you modify DB instance in a Single-AZ deployment to be a Multi-AZ deployment (for engines other than SQL Server or Amazon Aurora)? Choose 2.

  1. Step 1. Amazon RDS takes a snapshot of the primary DB instance from your deployment and then restores the snapshot into another Availability Zone.
  2. Step 1. Amazon RDS creates a fresh DB instance with similar configuration as primary DB instance and then copies data from primary to secondary.
  3. Step2. Amazon RDS then sets up asynchronous replication between your primary DB instance and the new instance.
  4. Step2. Amazon RDS then sets up synchronous replication between your primary DB instance and the new instance.
A
  1. Step 1. Amazon RDS takes a snapshot of the primary DB instance from your deployment and then restores the snapshot into another Availability Zone.
  2. Step 1. Amazon RDS creates a fresh DB instance with similar configuration as primary DB instance and then copies data from primary to secondary.
  3. Step2. Amazon RDS then sets up asynchronous replication between your primary DB instance and the new instance.
  4. Step2. Amazon RDS then sets up synchronous replication between your primary DB instance and the new instance.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the possible scenarios in case of RDS Multi-AZ deployment when primary DB instance switches over automatically to the standby replica? Choose 3.

  1. An Availability Zone outage or when the primary DB instance fails.
  2. The DB instance’s server type is changed or the operating system of the DB instance is undergoing software patching.
  3. A manual failover of the DB instance was initiated using Reboot with failover or when an Availability Zone outage or when the primary DB instance fails.
  4. When server performance is deteriorating.
A
  1. An Availability Zone outage or when the primary DB instance fails.
  2. The DB instance’s server type is changed or the operating system of the DB instance is undergoing software patching.
  3. A manual failover of the DB instance was initiated using Reboot with failover or when an Availability Zone outage or when the primary DB instance fails.
  4. When server performance is deteriorating.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You are an IT administrator of a company which has a SaaS product developed using AWS platform. You have enabled multi-AZ deployment for the product RDS database. Few days after the release you get an alert from DB event notification on your mobile phone that your primary Amazon RDS instance has failed. What should you do ensure that your production environment is available to users by ensuring a fast seamless failover to secondary instance?

  1. Update the DB connection string used by application server to secondary database instance.
  2. Create a new primary instance by making a copy from the secondary instance.
  3. No need to do anything, Amazon RDS handles failovers automatically so you can resume database operations as quickly as possible without administrative intervention.
  4. Update the DNS record of the DB instance to point to the standby DB instance.
A
  1. Update the DB connection string used by application server to secondary database instance.
  2. Create a new primary instance by making a copy from the secondary instance.
  3. No need to do anything, Amazon RDS handles failovers automatically so you can resume database operations as quickly as possible without administrative intervention.
  4. Update the DNS record of the DB instance to point to the standby DB instance.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which database engines supported by Amazon RDS have multi-AZ?

  1. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server
  2. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  3. MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  4. MySQL, MariaDB, Oracle, Microsoft SQL Server, Amazon Aurora
A
  1. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server
  2. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  3. MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora
  4. MySQL, MariaDB, Oracle, Microsoft SQL Server, Amazon Aurora
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You are an IT administrator of a company which has a SaaS product developed using AWS platform. You have enabled multi-AZ deployment for the product RDS database. You know that AWS automatically failovers to secondary instance when primary instance fails. Before going to production you want to simulate and test this failover. What is the simplest way to test?

  1. You have to wait for the new software patch to download for the DB instance.
  2. Initiate the snapshot creation of primary instance which will make AWS switch to secondary.
  3. Reboot the primary instance.
  4. Delete the primary instance.
A
  1. You have to wait for the new software patch to download for the DB instance.
  2. Initiate the snapshot creation of primary instance which will make AWS switch to secondary.
  3. Reboot the primary instance.
  4. Delete the primary instance.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are the features provided by Amazon RDS Multi-AZ deployments? Choose 2.

  1. Enhanced availability
  2. Enhanced Durability
  3. Enhanced performance
  4. Network latency reduction
A
  1. Enhanced availability
  2. Enhanced Durability
  3. Enhanced performance
  4. Network latency reduction
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the differences between Single-AZ and Multi-AZ deployment during backup activity? Choose 3.

  1. In Single-AZ deployments, I/O activity is suspended on your primary during backup.
  2. In Multi-AZ deployments, I/O activity is not suspended on your primary during backup, because the backup is taken from the standby.
  3. In Multi-AZ deployments, I/O activity is suspended on your primary during backup.
  4. There will be elevated latencies for a few minutes during backups for Multi-AZ deployments.
A
  1. In Single-AZ deployments, I/O activity is suspended on your primary during backup.
  2. In Multi-AZ deployments, I/O activity is not suspended on your primary during backup, because the backup is taken from the standby.
  3. In Multi-AZ deployments, I/O activity is suspended on your primary during backup.
  4. There will be elevated latencies for a few minutes during backups for Multi-AZ deployments.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How is instance failure handled in Amazon Aurora deployment? Choose 2.

  1. Amazon Aurora uses RDS Multi-AZ technology to automate failover to one of up to 15 Amazon Aurora Replicas created in any of three Availability Zones.
  2. Amazon Aurora Multi-AZ deployment feature has to be enabled specifically to automate failover to one of up to 15 Amazon Aurora Replicas created in any of three Availability Zones.
  3. If no Amazon Aurora Replicas have been provisioned, in the case of a failure, you have to manually create a new Amazon Aurora DB instance.
  4. f no Amazon Aurora Replicas have been provisioned, in the case of a failure, Amazon RDS will attempt to create a new Amazon Aurora DB instance for you automatically.
A
  1. Amazon Aurora uses RDS Multi-AZ technology to automate failover to one of up to 15 Amazon Aurora Replicas created in any of three Availability Zones.
  2. Amazon Aurora Multi-AZ deployment feature has to be enabled specifically to automate failover to one of up to 15 Amazon Aurora Replicas created in any of three Availability Zones.
  3. If no Amazon Aurora Replicas have been provisioned, in the case of a failure, you have to manually create a new Amazon Aurora DB instance.
  4. If no Amazon Aurora Replicas have been provisioned, in the case of a failure, Amazon RDS will attempt to create a new Amazon Aurora DB instance for you automatically.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How Amazon Aurora MySQL provides Fault-Tolerant and Self-Healing Storage? Choose 3.

  1. Each 10GB chunk of your database volume is replicated six ways, across three Availability Zones.
  2. Transparently handles the loss of up to two copies of data without affecting database write availability and up to three copies without affecting read availability.
  3. Data blocks and disks are continuously scanned for errors and replaced automatically.
  4. Each 10GB chunk of your database volume is replicated three ways, across three Availability Zones.
A
  1. Each 10GB chunk of your database volume is replicated six ways, across three Availability Zones.
  2. Transparently handles the loss of up to two copies of data without affecting database write availability and up to three copies without affecting read availability.
  3. Data blocks and disks are continuously scanned for errors and replaced automatically.
  4. Each 10GB chunk of your database volume is replicated three ways, across three Availability Zones.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

You are designing an application whose storage needs is very hard to predict. You don’t want to continuously monitor and increase the storage size of your RDBMS database. You want to use MySQL DB. Cost, availability and reliability is also your consideration. Which Amazon service you will use? Choose 2.

  1. MySQL installed on EC2
  2. RDS with MySQL
  3. Aurora with MySQL
  4. Serverless Aurora
A
  1. MySQL installed on EC2
  2. RDS with MySQL
  3. Aurora with MySQL
  4. Serverless Aurora
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the maximum retention value you can set in RDS?

  1. 15 days
  2. 35 days
  3. 25 days
  4. 45 days
A
  1. 15 days
  2. 35 days
  3. 25 days
  4. 45 days
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

How many copies of your data Aurora stores?

  1. 3
  2. 4
  3. 5
  4. 6
A
  1. 3
  2. 4
  3. 5
  4. 6
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is Aurora Global Database? Choose 2

  1. Aurora global database consists of one primary AWS Region where your data is mastered, and one read-only, secondary AWS Region
  2. urora global database consists of one primary AWS AZ where your data is mastered, and one read-only, secondary AZ
  3. Only the primary cluster performs write operations.
  4. Secondary performs both read and write.
A
  1. Aurora global database consists of one primary AWS Region where your data is mastered, and one read-only, secondary AWS Region
  2. urora global database consists of one primary AWS AZ where your data is mastered, and one read-only, secondary AZ
  3. Only the primary cluster performs write operations.
  4. Secondary performs both read and write.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is the default backup retention period if you create the RDS DB instance using the console?

  1. 1 day
  2. 7 days
  3. 35 days
  4. 0 day
A
  1. 1 day
  2. 7 days
  3. 35 days
  4. 0 day
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is the default backup retention period if you create the RDS DB instance using Amazon RDS API or the AWS CLI.?

  1. 1 day
  2. 7 days
  3. 35 days
  4. 0 day
A
  1. 1 day
  2. 7 days
  3. 35 days
  4. 0 day
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

You can set up the RDS backup retention period to between 0 and 35 days. What is the effect of setting the value to 0?

  1. Retention period is set to 1 hour
  2. Retention period is set to default value of seven days
  3. Disables automated backups
  4. Retention period is set to default value of one day
A
  1. Retention period is set to 1 hour
  2. Retention period is set to default value of seven days
  3. Disables automated backups
  4. Retention period is set to default value of one day
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Which of the following statements are correct about RDS backups? Choose 3.

  1. Amazon RDS creates and saves automated backups of your DB instance.
  2. Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases.
  3. Amazon RDS creates a storage volume snapshot of your DB instance, backing up only individual databases chosen by you.
  4. You can also back up your DB instance manually, by manually creating a DB snapshot.
A
  1. Amazon RDS creates and saves automated backups of your DB instance.
  2. Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases.
  3. Amazon RDS creates a storage volume snapshot of your DB instance, backing up only individual databases chosen by you.
  4. You can also back up your DB instance manually, by manually creating a DB snapshot.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
You have used Multi-AZ deployment for Amazon RDS instances for your web application to achieve enhanced database availability and durability. You know that Amazon RDS maintains an up-to-date standby instance which is synchronously updated. What happens during Multi-AZ failover? Choose 2. 1. Failover is automatically handled by Amazon RDS so that you can resume database operations as quickly as possible without administrative intervention. 2. Amazon RDS simply flips the canonical name record (CNAME) for your DB instance to point at the standby, which is in turn promoted to become the new primary. 3. Amazon RDS simply flips the canonical name record (CNAME) for your DB instance to point at alternate ‘failover’ record which needs to be created by you in the Route 53 hosted zone . 4. Amazon RDS simply flips the A Record type for your DB instance to point at the standby, which is in turn promoted to become the new primary. 5. Amazon RDS simply flips the A Record type for your DB instance to point at alternate ‘failover’ record which needs to be created by you in the Route 53 hosted zone.
1. **Failover is automatically handled by Amazon RDS so that you can resume database operations as quickly as possible without administrative intervention.** 2. **Amazon RDS simply flips the canonical name record (CNAME) for your DB instance to point at the standby, which is in turn promoted to become the new primary.** 3. Amazon RDS simply flips the canonical name record (CNAME) for your DB instance to point at alternate ‘failover’ record which needs to be created by you in the Route 53 hosted zone . 4. Amazon RDS simply flips the A Record type for your DB instance to point at the standby, which is in turn promoted to become the new primary. 5. Amazon RDS simply flips the A Record type for your DB instance to point at alternate ‘failover’ record which needs to be created by you in the Route 53 hosted zone.
26
Which of the following statements is correct about RDS backups? 1. Amazon RDS creates automated backups of your DB instance during the backup window of your DB instance. 2. Amazon RDS saves the automated backups of your DB instance according to the backup retention period that you specify. 3. You can recover your database to any point in time during the backup retention period. 4. All of the above
1. Amazon RDS creates automated backups of your DB instance during the backup window of your DB instance. 2. Amazon RDS saves the automated backups of your DB instance according to the backup retention period that you specify. 3. You can recover your database to any point in time during the backup retention period. 4. **All of the above**
27
RDS Automated backups occur daily during the preferred backup window. While creating the RDS DB instance you didn’t specified the preferred backup window. What will happen? 1. RDS will not take automated backups. 2. RDS assigns a default 30-minute backup window. 3. RDS will not allow to take manual backups. 4. RDS will not create the DB instance.
1. RDS will not take automated backups. 2. **RDS assigns a default 30-minute backup window.** 3. RDS will not allow to take manual backups. 4. RDS will not create the DB instance.
28
RDS gives you the flexibility of automated backup as well as manual backup by taking snapshots. Which of the following three statements are correct? Choose 3. 1. The first snapshot of a DB instance contains the data for the full DB instance. 2. Subsequent snapshots of the same DB instance are incremental, which means that only the data that has changed after your most recent snapshot is saved. 3. Subsequent snapshots of the same DB instance also contains the data of the full DB instance. 4. You can copy both automatic and manual DB snapshots, and share manual DB snapshots.
1. **The first snapshot of a DB instance contains the data for the full DB instance.** 2. **Subsequent snapshots of the same DB instance are incremental, which means that only the data that has changed after your most recent snapshot is saved.** 3. Subsequent snapshots of the same DB instance also contains the data of the full DB instance. 4. **You can copy both automatic and manual DB snapshots, and share manual DB snapshots.**
29
You are sun setting an application. As part of the process you are going to delete the RDS DB instance but you want to retain the automated backups. What step can you take? 1. If you delete a RDS DB Instance there is no option to retain the automated backups. 2. You have to manually create copies of automated backups. 3. You can take snapshot of DB Instance before deleting it. 4. Choose Retain automated backups when you delete a DB instance.
1. If you delete a RDS DB Instance there is no option to retain the automated backups. 2. You have to manually create copies of automated backups. 3. You can take snapshot of DB Instance before deleting it. 4. **Choose Retain automated backups when you delete a DB instance.**
30
What is DB parameter group and DB option group? Choose 2. 1. A DB option group acts as a container for engine configuration values that are applied to one or more DB instances. 2. A DB parameter group acts as a container for engine feature which is empty by default. 3. A DB parameter group acts as a container for engine configuration values that are applied to one or more DB instances. 4. A DB option group acts as a container for engine feature which is empty.
1. A DB option group acts as a container for engine configuration values that are applied to one or more DB instances. 2. A DB parameter group acts as a container for engine feature which is empty by default. 3. **A DB parameter group acts as a container for engine configuration values that are applied to one or more DB instances.** 4. **A DB option group acts as a container for engine feature which is empty.**
31
What is Recovery Time Objective (RTO)? 1. The time it takes after a disruption to restore a database to its service level, as defined by the operational level agreement (OLA). 2. The acceptable amount of performance loss measured in time. 3. The time it takes after a disruption to restore a business process to its service level, as defined by the operational level agreement (OLA). 4. The acceptable amount of data loss measured in time.
1. The time it takes after a disruption to restore a database to its service level, as defined by the operational level agreement (OLA). 2. The acceptable amount of performance loss measured in time. 3. **The time it takes after a disruption to restore a business process to its service level, as defined by the operational level agreement (OLA).** 4. The acceptable amount of data loss measured in time.
32
What is Recovery Point Objective (RPO)? 1. The time it takes after a disruption to restore a database to its service level, as defined by the operational level agreement (OLA). 2. The acceptable amount of performance loss measured in time. 3. The time it takes after a disruption to restore a business process to its service level, as defined by the operational level agreement (OLA). 4. The acceptable amount of data loss measured in time.
1. The time it takes after a disruption to restore a database to its service level, as defined by the operational level agreement (OLA). 2. The acceptable amount of performance loss measured in time. 3. The time it takes after a disruption to restore a business process to its service level, as defined by the operational level agreement (OLA). 4. **The acceptable amount of data loss measured in time.**
33
Which Amazon RDS storage types will you choose for High-performance OLTP workloads and Database workloads with moderate I/O requirements? Choose 2. 1. High-performance OLTP workloads: Amazon RDS Provisioned IOPS (SSD) Storage 2. Database workloads with moderate I/O requirements: Amazon RDS General Purpose (SSD) Storage 3. High-performance OLTP workloads: Amazon RDS General Purpose (SSD) Storage 4. Database workloads with moderate I/O requirements: Amazon RDS Provisioned IOPS (SSD) Storage
1. **High-performance OLTP workloads: Amazon RDS Provisioned IOPS (SSD) Storage** 2. **Database workloads with moderate I/O requirements: Amazon RDS General Purpose (SSD) Storage** 3. High-performance OLTP workloads: Amazon RDS General Purpose (SSD) Storage 4. Database workloads with moderate I/O requirements: Amazon RDS Provisioned IOPS (SSD) Storage
34
Where are RDS automated backups and DB snapshots stored? 1. EBS 2. DynamoDB 3. S3 4. DocumentDB
1. EBS 2. DynamoDB 3. **S3** 4. DocumentDB
35
What DB instances for Amazon RDS for MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server use for database and log storage? 1. S3 2. EBS 3. EFS 4. Redshift
1. S3 2. **EBS** 3. EFS 4. Redshift
36
If a disaster occurs at 12:00 PM (noon) and the RTO is eight hours, by what time the DR process should restore the business process to the acceptable service level? 1. 8 PM 2. 4 AM 3. 4 PM 4. 8AM
1. **8 PM** 2. 4 AM 3. 4 PM 4. 8AM
37
If a disaster occurs at 12:00 PM (noon) and the RPO is one hour, by how much time system should recover data? 1. 11 PM 2. 11 AM 3. 1 PM 4. 1 AM
1. 11 PM 2. **11 AM** 3. 1 PM 4. 1 AM
38
DB instances for Amazon RDS use following for database and log storage. 1. Elastic Block Store (Amazon EBS) volumes 2. Amazon S3 3. Amazon Aurora 4. MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server
1. **Elastic Block Store (Amazon EBS) volumes** 2. Amazon S3 3. Amazon Aurora 4. MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server
39
What are the three storage types provided by RDS? 1. Throughput Optimized 2. General Purpose SSD 3. Provisioned IOPS 4. Magnetic
1. Throughput Optimized 2. **General Purpose SSD** 3. **Provisioned IOPS** 4. **Magnetic**
40
Which storage types provided by RDS will you use for production application that requires fast and consistent I/O performance? 1. Throughput Optimized 2. General Purpose SSD 3. Provisioned IOPS 4. Magnetic
1. Throughput Optimized 2. General Purpose SSD 3. **Provisioned IOPS** 4. Magnetic
41
What are the characteristics of RDS Provisioned IOPS SSD Storage type? Choose 3. 1. Delivers predictable performance, and consistently low latency. 2. Optimized for online transaction processing (OLTP) workloads that have consistent performance requirements. 3. When you create a DB instance, you specify an IOPS rate and the size of the volume. 4. Designed for throughput-intensive workloads.
1. **Delivers predictable performance, and consistently low latency.** 2. **Optimized for online transaction processing (OLTP) workloads that have consistent performance requirements.** 3. **When you create a DB instance, you specify an IOPS rate and the size of the volume.** 4. Designed for throughput-intensive workloads.
42
What are the factors that can affect RDS storage performance? 1. System activities: Multi-AZ standby creation, Read replica creation, changing storage types 2. Database or application design resulting in concurrency issues, locking, or other forms of database contention. 3. Instance type not with enough bandwidth to support your storage type. 4. All of the above
1. System activities: Multi-AZ standby creation, Read replica creation, changing storage types 2. Database or application design resulting in concurrency issues, locking, or other forms of database contention. 3. Instance type not with enough bandwidth to support your storage type. 4. **All of the above**
43
Which amazon RDS database engine supports read replica? 1. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server 2. MySQL, MariaDB, PostgreSQL, Oracle, Amazon Aurora 3. MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora 4. MySQL, MariaDB, Oracle, Microsoft SQL Server, Amazon Aurora
1. MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server 2. **MySQL, MariaDB, PostgreSQL, Oracle, Amazon Aurora** 3. MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Amazon Aurora 4. MySQL, MariaDB, Oracle, Microsoft SQL Server, Amazon Aurora
44
Which of the following scenarios are apt for deploying one or more Read Replicas for a given source DB instance? Choose 2. 1. Scaling beyond the compute or I/O capacity of a single DB instance for read-heavy database workloads. 2. Serving read traffic while the source DB instance is unavailable. 3. Improving performance of a single DB instance for update heavy database workloads. 4. Serving update traffic while the source DB instance is unavailable.
1. **Scaling beyond the compute or I/O capacity of a single DB instance for read-heavy database workloads.** 2. **Serving read traffic while the source DB instance is unavailable.** 3. Improving performance of a single DB instance for update heavy database workloads. 4. Serving update traffic while the source DB instance is unavailable.
45
Which of the following scenarios are apt for deploying one or more Read Replicas for a given source DB instance? Choose 2. 1. Business reporting or data warehousing scenarios where you might want business reporting queries to run against a Read Replica, rather than your primary, production DB instance. 2. For storing user session data. 3. Implementing disaster recovery. 4. All of the above.
1. **Business reporting or data warehousing scenarios where you might want business reporting queries to run against a Read Replica, rather than your primary, production DB instance.** 2. For storing user session data. 3. **Implementing disaster recovery.** 4. All of the above.
46
Which of the following statements are true regarding Amazon RDS Read Replica? Choose 2. 1. Amazon RDS takes a snapshot of the source instance and creates a read-only instance from the snapshot. 2. Amazon RDS uses the synchronous replication method for the DB engine to update the Read Replica whenever there is a change to the source DB instance. 3. You have to create manually a separate copy of the main primary DB instance and mark it as Read Replica. 4. Amazon RDS uses the asynchronous replication method for the DB engine to update the Read Replica whenever there is a change to the source DB instance.
1. **Amazon RDS takes a snapshot of the source instance and creates a read-only instance from the snapshot.** 2. Amazon RDS uses the synchronous replication method for the DB engine to update the Read Replica whenever there is a change to the source DB instance. 3. You have to create manually a separate copy of the main primary DB instance and mark it as Read Replica. 4. **Amazon RDS uses the asynchronous replication method for the DB engine to update the Read Replica whenever there is a change to the source DB instance.**
47
Which of the following statements are true regarding Amazon RDS Read Replica? Choose 2. 1. The Read Replica operates as a DB instance that allows update-only connections. 2. Amazon RDS replicates only those databases chosen by the user in the source DB instance. 3. The Read Replica operates as a DB instance that allows read-only connections. 4. Amazon RDS replicates all databases in the source DB instance.
1. The Read Replica operates as a DB instance that allows update-only connections. 2. Amazon RDS replicates only those databases chosen by the user in the source DB instance. 3. **The Read Replica operates as a DB instance that allows read-only connections.** 4. **Amazon RDS replicates all databases in the source DB instance.**
48
Which of the following statements are false regarding Amazon RDS Read Replica? Choose 2. 1. Amazon RDS doesn't support circular replication. 2. Amazon RDS supports circular replication. 3. Read Replica can resides in a different AWS Region than its source DB instance. 4. Read Replica cannot resides in a different AWS Region than its source DB instance.
1. Amazon RDS doesn't support circular replication. 2. **Amazon RDS supports circular replication.** 3. Read Replica can resides in a different AWS Region than its source DB instance. 4. **Read Replica cannot resides in a different AWS Region than its source DB instance.**
49
Which Amazon RDS database engine is fully compatible with MySQL and PostgreSQL? 1. Amazon RDS for MySQL 2. Amazon RDS for PostgreSQL 3. Amazon RDS Aurora 4. Amazon RDS for Oracle
1. Amazon RDS for MySQL 2. Amazon RDS for PostgreSQL 3. **Amazon RDS Aurora** 4. Amazon RDS for Oracle
50
What are the characteristics of Amazon Aurora DB Cluster? Choose 3. 1. Two types of DB instances make up an Aurora DB cluster: Primary DB instance & Aurora Replica 2. For primary DB instance failover you need to have a separate instance apart from Replica. 3. Primary DB instance supports read and write operations, and performs all of the data modifications to the cluster volume. Each Aurora DB cluster has one primary DB instance. 4. Aurora Replica connects to the same storage volume as the primary DB instance and supports only read operations. Each Aurora DB cluster can have up to 15 Aurora Replicas in addition to the primary DB instance.
1. **Two types of DB instances make up an Aurora DB cluster: Primary DB instance & Aurora Replica** 2. For primary DB instance failover you need to have a separate instance apart from Replica. 3. **Primary DB instance supports read and write operations, and performs all of the data modifications to the cluster volume. Each Aurora DB cluster has one primary DB instance.** 4. **Aurora Replica connects to the same storage volume as the primary DB instance and supports only read operations. Each Aurora DB cluster can have up to 15 Aurora Replicas in addition to the primary DB instance.**
51
What are different endpoints available in RDS Aurora? Choose 3. 1. Cluster endpoint 2. Reader endpoint 3. Write endpoint 4. Custom endpoint
1. **Cluster endpoint** 2. **Reader endpoint** 3. Write endpoint 4. **Custom endpoint**
52
Select statements which are correct for RDS Aurora storage? Choose 3. 1. Aurora cluster volumes automatically grow as the amount of data in your database increases. 2. An Aurora cluster volume can grow to a maximum size of 64 tebibytes (TiB). 3. An Aurora cluster volume can grow to a maximum size of 64 terabytes (TB). 4. Aurora data is stored in the cluster volume consisting of copies of the data across multiple Availability Zones in a single AWS Region.
1. **Aurora cluster volumes automatically grow as the amount of data in your database increases.** 2. **An Aurora cluster volume can grow to a maximum size of 64 tebibytes (TiB).** 3. An Aurora cluster volume can grow to a maximum size of 64 terabytes (TB). 4. **Aurora data is stored in the cluster volume consisting of copies of the data across multiple Availability Zones in a single AWS Region.**
53
You are the architect of a payment gateway provider and anticipating a fivefold increase in traffic in the upcoming shopping season. You are using RDS with MySQL as database engine. During load testing you notice a decrease in query performance with increase in traffic. Which of the following options you could do immediately to increase database performance? 1. Instead of MySQL use Oracle or SQL Server. 2. Instead of MySQL use DynamoDB. 3. Use Multi-AZ deployment option to increase read and write performance. 4. Use Read Replicas and redirect read queries to those replicas.
1. Instead of MySQL use Oracle or SQL Server. 2. Instead of MySQL use DynamoDB. 3. Use Multi-AZ deployment option to increase read and write performance. 4. **Use Read Replicas and redirect read queries to those replicas.**
54
How many read replicas you can create for RDS MySQL? 1. 5 2. 10 3. 15 4. 20
1. **5** 2. 10 3. 15 4. 20
55
How many read replicas you can create for RDS Aurora? 1. 5 2. 10 3. 15 4. 20
1. 5 2. 10 3. **15** 4. 20
56
What is the main benefit of Read Replica? 1. Improving performance 2. Improving Security 3. Improving Availability 4. Improving Durability
1. **Improving performance** 2. Improving Security 3. Improving Availability 4. Improving Durability
57
How does read replica provide increase availability? Choose 2. 1. You can make a snapshot from a read replica and promote if the source DB instance fails. 2. You can promote a read replica if the source DB instance fails. 3. You can set up a read replica with its own standby instance in different AZ. 4. Read replica automatically enables Multi-AZ deployment.
1. You can make a snapshot from a read replica and promote if the source DB instance fails. 2. **You can promote a read replica if the source DB instance fails.** 3. **You can set up a read replica with its own standby instance in different AZ.** 4. Read replica automatically enables Multi-AZ deployment.
58
Which RDS features you can combine to architect your application database for high availability and read scalability? Choose 2. 1. Configure source database as Multi-AZ for high availability 2. Create Read Replica for read scalability 3. Create Read Replica for high availability 4. Configure Multi-AZ for read scalability
1. **Configure source database as Multi-AZ for high availability** 2. **Create Read Replica for read scalability** 3. Create Read Replica for high availability 4. Configure Multi-AZ for read scalability
59
With RDS for MySQL, MariaDB, PostgreSQL, and Oracle how you can use the read replica as a DR target? 1. Read Replicas are enabled as DR target by default. 2. Set the read replica as Multi-AZ, allowing you to use the read replica as a DR target. 3. Set the read replica as Single-AZ, allowing you to use the read replica as a DR target. 4. None of the above.
1. Read Replicas are enabled as DR target by default. 2. **Set the read replica as Multi-AZ, allowing you to use the read replica as a DR target.** 3. Set the read replica as Single-AZ, allowing you to use the read replica as a DR target. 4. None of the above.
60
Amazon RDS read replicas complement Multi-AZ deployments. While both features maintain a second copy of your data, choose two differences from the following list. 1. In Read Replicas only database engine on primary instance is active while in Multi-AZ all replicas are accessible and can be used for read scaling. 2. Multi-AZ Deployments have synchronous replication and is highly durable while Read Replicas have Asynchronous replication and is highly scalable. 3. In Multi-AZ only database engine on primary instance is active while in Read Replicas all read replicas are accessible and can be used for read scaling. 4. Read Replicas have synchronous replication and is highly durable while Multi-AZ have Asynchronous replication and is highly scalable.
1. In Read Replicas only database engine on primary instance is active while in Multi-AZ all replicas are accessible and can be used for read scaling. 2. **Multi-AZ Deployments have synchronous replication and is highly durable while Read Replicas have Asynchronous replication and is highly scalable.** 3. **In Multi-AZ only database engine on primary instance is active while in Read Replicas all read replicas are accessible and can be used for read scaling.** 4. Read Replicas have synchronous replication and is highly durable while Multi-AZ have Asynchronous replication and is highly scalable.
61
Amazon RDS read replicas complement Multi-AZ deployments. While both features maintain a second copy of your data, choose two differences from the following list. 1. In Multi-AZ Automated backups are taken from standby while in Read Replicas no backups configured by default. 2. In Read Replicas Automated backups are taken from standby while In Multi-AZ no backups configured by default. 3. Read Replicas always span two Availability Zones within a single Region while Multi-AZ can be within an Availability Zone, Cross-AZ, or Cross-Region. 4. Multi-AZ always span two Availability Zones within a single Region while Read Replicas can be within an Availability Zone, Cross-AZ, or Cross-Region.
1. **In Multi-AZ Automated backups are taken from standby while in Read Replicas no backups configured by default.** 2. In Read Replicas Automated backups are taken from standby while In Multi-AZ no backups configured by default. 3. Read Replicas always span two Availability Zones within a single Region while Multi-AZ can be within an Availability Zone, Cross-AZ, or Cross-Region. 4. **Multi-AZ always span two Availability Zones within a single Region while Read Replicas can be within an Availability Zone, Cross-AZ, or Cross-Region.**
62
Which of the following statements are correct for RDS Multi-AZ and Read Replica? Choose 2. 1. In Multi-AZ automatic failover to standby when a problem is detected. 2. In Read Replica automatic failover to standby when a problem is detected. 3. In Multi-AZ, instance can be manually promoted to a standalone database instance. 4. In Read Replica, instance can be manually promoted to a standalone database instance.
1. **In Multi-AZ automatic failover to standby when a problem is detected.** 2. In Read Replica automatic failover to standby when a problem is detected. 3. In Multi-AZ, instance can be manually promoted to a standalone database instance. 4. **In Read Replica, instance can be manually promoted to a standalone database instance.**
63
In RDS when you deploy in single AZ, what is the effect on I/O operation when a database snapshot or backup is being taken? 1. I/O may be briefly suspended while the backup process initializes (typically under a few seconds) and you may experience a brief period of elevated latency. 2. No effect on I/O 3. There is no I/O suspension, since the backup is taken from the standby. 4. None of the above
1. **I/O may be briefly suspended while the backup process initializes (typically under a few seconds) and you may experience a brief period of elevated latency.** 2. No effect on I/O 3. There is no I/O suspension, since the backup is taken from the standby. 4. None of the above
64
Your company has SaaS product which provides different kind of reports to various subscribed customers. The reports ranges from adhoc, daily and monthly on various metrics. This is resulting in very high read traffic to underlying Amazon RDS MySQL instance. What can you do to improve the performance without affecting the user experience? 1. Ensure that underlying RDS MySQL instance is Multi-AZ enabled. 2. Create a read replica for underlying RDS MySQL. 3. Change the RDS instance from MySQL to PostgreSQL. 4. Analyze and improve the performance of read queries.
1. Ensure that underlying RDS MySQL instance is Multi-AZ enabled. 2. **Create a read replica for underlying RDS MySQL**. 3. Change the RDS instance from MySQL to PostgreSQL. 4. Analyze and improve the performance of read queries.
65
You are sunsetting an application along with its backend RDS. You had enabled automated backups for RDS instance during the life of application. What step you should take before deleting the instance so that in future you can re-create the RDS instance again? 1. No need to do anything, automated backup are retained even after deleting the DB instance. 2. Create a final user created DB snapshot upon deletion. 3. No need to do anything, RDS automatically creates a final DB snapshot when deleting the DB instance is initiated. 4. There is no way to recreate a RDS instance after it is deleted.
1. No need to do anything, automated backup are retained even after deleting the DB instance. 2. **Create a final user created DB snapshot upon deletion.** 3. No need to do anything, RDS automatically creates a final DB snapshot when deleting the DB instance is initiated. 4. There is no way to recreate a RDS instance after it is deleted.
66
Your company is launching a new SaaS application for mortgage industry. Which of the following are two options for session management in AWS? 1. Sticky Sessions with Local Session Caching including a client-side cookies or via configurable duration parameters that can be set at the load balancer which routes requests to the web servers. 2. Distributed Session Management using ElastiCache, Redshift, RDS 3. Distributed Session Management using ElastiCache, DynamoDB, RDS 4. Distributed Session Management using ElastiCache, S3, RDS
1. **Sticky Sessions with Local Session Caching including a client-side cookies or via configurable duration parameters that can be set at the load balancer which routes requests to the web servers.** 2. Distributed Session Management using ElastiCache, Redshift, RDS 3. **Distributed Session Management using ElastiCache, DynamoDB, RDS** 4. Distributed Session Management using ElastiCache, S3, RDS
67
What is a DB subnet group? 1. A collection of subnets that you may want to designate for your RDS DB Instances in a VPC. 2. When creating a DB Instance in VPC, you will need to select a DB Subnet Group. 3. When creating a DB Instance in VPC, you don’t need to select a DB Subnet Group. 4. Each DB Subnet Group should have at least one subnet for every Availability Zone in a given Region.
1. **A collection of subnets that you may want to designate for your RDS DB Instances in a VPC.** 2. **When creating a DB Instance in VPC, you will need to select a DB Subnet Group.** 3. When creating a DB Instance in VPC, you don’t need to select a DB Subnet Group. 4. **Each DB Subnet Group should have at least one subnet for every Availability Zone in a given Region.**
68
Which of the following statements are true regarding Multi-AZ and Read Replicas? Choose 2. 1. You cannot create a read replica with a Multi-AZ DB instance deployment as its source. 2. You can create a read replica with a Multi-AZ DB instance deployment as its source. 3. You can configure read replicas themselves as Multi-AZ 4. You cannot configure read replicas themselves as Multi-AZ
1. You cannot create a read replica with a Multi-AZ DB instance deployment as its source. 2. **You can create a read replica with a Multi-AZ DB instance deployment as its source.** 3. **You can configure read replicas themselves as Multi-AZ** 4. You cannot configure read replicas themselves as Multi-AZ
69
If read replica(s) uses a Multi-AZ DB instance deployment as a source, what happens if Multi-AZ failover occurs? 1. You cannot create a read replica with a Multi-AZ DB instance deployment as its source. 2. Any associated and available read replicas will automatically resume replication once failover has completed. 3. You have to manually map the read replicas to newly promoted primary to resume replication. 4. You have to delete the old read replicas and new read replicas will be created by RDS after a new primary is promoted.
1. You cannot create a read replica with a Multi-AZ DB instance deployment as its source. 2. **Any associated and available read replicas will automatically resume replication once failover has completed.** 3. You have to manually map the read replicas to newly promoted primary to resume replication. 4. You have to delete the old read replicas and new read replicas will be created by RDS after a new primary is promoted.
70
What are DB Parameter groups? Choose 2. 1. A database parameter group (DB Parameter Group) acts as a “container” for engine configuration values that can be applied to one or more DB Instances. 2. You cannot create a new DB parameter group with custom configuration engine values. 3. RDS provides a default parameter group optimized for DB instance. 4. It is mandatory to specify a DB parameter group when creating a DB instance.
1. **A database parameter group (DB Parameter Group) acts as a “container” for engine configuration values that can be applied to one or more DB Instances.** 2. You cannot create a new DB parameter group with custom configuration engine values. 3. **RDS provides a default parameter group optimized for DB instance.** 4. It is mandatory to specify a DB parameter group when creating a DB instance.
71
What are the metrics provided by Amazon RDS that you can use to determine how your DB instance is performing? Choose 4 1. IOPS 2. Latency 3. Network Bandwidth 4. Throughput 5. Queue Depth
1. **IOPS** 2. **Latency** 3. Network Bandwidth 4. **Throughput** 5. **Queue Depth**
72
Which of the following factor will not have negative affect on DB Instance storage performance? 1. Multi-AZ standby creation. 2. Read replica creation. 3. Changing storage types. 4. EBS-optimized instances and instances with 10-gigabit network connectivity.
1. Multi-AZ standby creation. 2. Read replica creation. 3. Changing storage types. 4. **EBS-optimized instances and instances with 10-gigabit network connectivity.**
73
You have web application architecture with web servers running on EC2 instances in auto scaling group and using RDS MySQL database. Due to sensitive nature of application you have to encrypt the in-transit data between web server and RDS database. How can you do it? 1. Download Amazon RDS root CA certificate to your web server and use Secure Socket Layer (SSL) or Transport Layer Security (TLS) from your application to encrypt a connection to DB instance. 2. All the connection between EC2 instances and RDS databases are by default encrypted. 3. Force all connections to your DB instance to use SSL by setting the rds.force\_ssl parameter to 1 (on) 4. Add the SSL option to the option group associated with the DB instance.
1. **Download Amazon RDS root CA certificate to your web server and use Secure Socket Layer (SSL) or Transport Layer Security (TLS) from your application to encrypt a connection to DB instance.** 2. All the connection between EC2 instances and RDS databases are by default encrypted. 3. Force all connections to your DB instance to use SSL by setting the rds.force\_ssl parameter to 1 (on) 4. Add the SSL option to the option group associated with the DB instance.
74
Because of a new regulatory compliance requirement you have to encrypt all your encrypted existing application RDS DB instances. You know that in AWS RDS DB instance you can only enable encryption for an Amazon RDS DB instance when you create it, not after the DB instance is created. What steps you should take to meet the compliance requirements? Choose 2. 1. Step1: You create a new DB instance with encryption enabled 2. Step 2: Copy data from the old DB instance to new encrypted DB instance 3. Step1: You can create a snapshot of your DB instance, and then create an encrypted copy of that snapshot. 4. Step2: You can then restore a DB instance from the encrypted snapshot, and thus you have an encrypted copy of your original DB instance.
1. Step1: You create a new DB instance with encryption enabled 2. Step 2: Copy data from the old DB instance to new encrypted DB instance 3. **Step1: You can create a snapshot of your DB instance, and then create an encrypted copy of that snapshot.** 4. **Step2: You can then restore a DB instance from the encrypted snapshot, and thus you have an encrypted copy of your original DB instance.**
75
What is the encryption algorithm used in Amazon RDS to encrypt DB instances data on the server that hosts your Amazon RDS DB instances? 1. AES-128 2. AES-256 3. DES-256 4. DES-128
1. AES-128 2. **AES-256** 3. DES-256 4. DES-128
76
Which of the following statements are correct regarding enabling Amazon RDS Encryption for a DB Instance? Choose 3. 1. When you create an encrypted DB instance, you can also supply the AWS KMS key identifier for your encryption key. 2. If you don't specify an AWS KMS key identifier, then Amazon RDS uses your default encryption key for your new DB instance. 3. Once you have created an encrypted DB instance, you can change the type of encryption key used by that DB instance. 4. Once you have created an encrypted DB instance, you can't change the type of encryption key used by that DB instance.
1. **When you create an encrypted DB instance, you can also supply the AWS KMS key identifier for your encryption key.** 2. **If you don't specify an AWS KMS key identifier, then Amazon RDS uses your default encryption key for your new DB instance.** 3. Once you have created an encrypted DB instance, you can change the type of encryption key used by that DB instance. 4. **Once you have created an encrypted DB instance, you can't change the type of encryption key used by that DB instance.**
77
Which three types of security groups are used with DB Instance? 1. DB security group 2. VPC security group 3. EC2 security group 4. RDS Security group
1. **DB security group** 2. **VPC security group** 3. **EC2 security group** 4. RDS Security group
78
Three types of security groups are used with Amazon RDS: DB security groups, VPC security groups, and Amazon EC2 security groups. Choose three correct statement pertaining to DB security groups (SG) and VPC security groups. 1. DB SG controls access to DB instances outside a VPC while VPC SG controls access to DB instances in VPC. 2. In both DB SG and VPC SG when you add a rule to a group, you need to specify the protocol as TCP. In addition, specify the same port number that you used to create the DB instances (or options) that you plan to add as members to the group. 3. In DB SG when you add a rule to a group, you don't need to specify port number or protocol. In VPC SG when you add a rule to a group, you need to specify the protocol as TCP. In addition, specify the same port number that you used to create the DB instances (or options) that you plan to add as members to the group. 4. DB SG allow access from EC2 security groups in your AWS account or other accounts. VPC SG allow access from other VPC security groups in your VPC only.
1. **DB SG controls access to DB instances outside a VPC while VPC SG controls access to DB instances in VPC.** 2. In both DB SG and VPC SG when you add a rule to a group, you need to specify the protocol as TCP. In addition, specify the same port number that you used to create the DB instances (or options) that you plan to add as members to the group. 3. **In DB SG when you add a rule to a group, you don't need to specify port number or protocol. In VPC SG when you add a rule to a group, you need to specify the protocol as TCP. In addition, specify the same port number that you used to create the DB instances (or options) that you plan to add as members to the group.** 4. **DB SG allow access from EC2 security groups in your AWS account or other accounts. VPC SG allow access from other VPC security groups in your VPC only.**
79
What are the impacts of disabling automated backups in Amazon RDS? Choose 2. 1. Once you disable and you cannot re-enable automated backups 2. It disables point-in-time recovery 3. Deletes all existing automated backups for the instance 4. Existing automated backups for the instance are retained
1. Once you disable and you cannot re-enable automated backups 2. **It disables point-in-time recovery** 3. **Deletes all existing automated backups for the instance** 4. Existing automated backups for the instance are retained
80
You are the DB administrator for your company. You are responsible for running the database update scripts for a recent patch release that needs to be done over the weekend. You are using Amazon RDS MySQL which was created through console with default settings. The plan is to do patch update over the weekend when there is no user activity and in case there is any issue all changes should be rolled back. What feature of RDS can you use to roll back the changes? 1. You have to manually delete new scripts to come back to original state. 2. RDS MySQL has the feature ‘Restore to point in time’ to restore a DB instance to a specific point in time. 3. To manage risk first do the patch release in a DB copy without impacting original DB. 4. Enable Read Replica before making changes, to roll back delete the main DB.
1. You have to manually delete new scripts to come back to original state. 2. **RDS MySQL has the feature ‘Restore to point in time’ to restore a DB instance to a specific point in time.** 3. To manage risk first do the patch release in a DB copy without impacting original DB. 4. Enable Read Replica before making changes, to roll back delete the main DB.
81
How can you encrypt your Amazon RDS DB instances and snapshots at rest? Choose 2. 1. No configuration required as Amazon RDS always encrypts the data at rest. 2. You can encrypt data in RDS DB instance but cannot encrypt snapshots. 3. Enabling the encryption option for your Amazon RDS DB instances while creation. 4. While database creation supply the AWS KMS key identifier for your encryption key otherwise Amazon RDS uses your default encryption key for your new DB instance.
1. No configuration required as Amazon RDS always encrypts the data at rest. 2. You can encrypt data in RDS DB instance but cannot encrypt snapshots. 3. **Enabling the encryption option for your Amazon RDS DB instances while creation.** 4. **While database creation supply the AWS KMS key identifier for your encryption key otherwise Amazon RDS uses your default encryption key for your new DB instance.**
82
You are using RDS MySQL database for your web application. To achieve fault tolerance and read performance, you have also enabled Multi-AZ deployment and Read Replicas. You want to monitor different metrics ( CPU Utilization, Free Memory, Active Memory, Device Write I//Os etc) in real time for the operating system (OS) that your DB instance runs on for the primary DB instance and its Multi-AZ standby replica as well. Which of the following is the appropriate AWS feature you will use? 1. Enable RDS Enhanced Monitoring 2. Use Amazon CloudWatch to monitor 3. Create custom program which collect data for any metric. 4. Use Amazon Cloudtrail logs to extract data for any metric.
1. **Enable RDS Enhanced Monitoring** 2. Use Amazon CloudWatch to monitor 3. Create custom program which collect data for any metric. 4. Use Amazon Cloudtrail logs to extract data for any metric.
83
Which of the following is not correct about RDS reserved instances? 1. Reserved Instance prices cover instance costs only. Storage and I/O are still billed separately. 2. The RI discounted rate will apply to usage of Single-AZ configurations only for the same database engine and instance family. It will not be applicable for Multi-AZ configuration. 3. Reserved Instances are available in all the AWS regions and for all supported DB Engines. 4. Reserved Instances for the MySQL, MariaDB, PostgreSQL, and Amazon Aurora database engines as well as the “Bring your own license” (BYOL) edition of the Oracle database engine offer instance size flexibility.
1. Reserved Instance prices cover instance costs only. Storage and I/O are still billed separately. 2. **The RI discounted rate will apply to usage of Single-AZ configurations only for the same database engine and instance family. It will not be applicable for Multi-AZ configuration.** 3. Reserved Instances are available in all the AWS regions and for all supported DB Engines. 4. Reserved Instances for the MySQL, MariaDB, PostgreSQL, and Amazon Aurora database engines as well as the “Bring your own license” (BYOL) edition of the Oracle database engine offer instance size flexibility.
84
Which of the following Data transfer scenario is not free for RDS MySQL? Choose 2. 1. Data transferred between Amazon RDS and Amazon EC2 Instances in the same Availability Zone 2. Data transferred between Availability Zones for replication of Multi-AZ deployments 3. Data transferred to copy the DB snapshot data across regions. 4. Data transferred between an Amazon EC2 instance and Amazon RDS DB Instance in different Availability Zones of the same Region
1. Data transferred between Amazon RDS and Amazon EC2 Instances in the same Availability Zone 2. Data transferred between Availability Zones for replication of Multi-AZ deployments 3. **Data transferred to copy the DB snapshot data across regions.** 4. **Data transferred between an Amazon EC2 instance and Amazon RDS DB Instance in different Availability Zones of the same Region**
85
You have a blog site that is only used for a few minutes several times per day. You want to design the application on Serverless architecture so that you consume resources on usage basis. You also don’t want to compromise on scalability and performance. Which AWS services you will use? Choose 2 1. Lambda 2. Aurora Serverless 3. S3 4. RDS MySQL
1. **Lambda** 2. **Aurora Serverless** 3. S3 4. RDS MySQL
86
Which use cases are apt for using Aurora Serverless? Choose 3. 1. Predictable workloads 2. Infrequently used applications 3. New applications where you are unsure of capacity requirements. 4. Variable and unpredictable workloads
1. Predictable workloads 2. **Infrequently used applications** 3. **New applications where you are unsure of capacity requirements.** 4. **Variable and unpredictable workloads**
87
Your company does a quarterly customer survey and uses an Amazon Elastic Compute Cloud (Amazon EC2) instance to host the customer survey website and a DB instance that is used to store the survey results. How can you save the cost in most optimized way? 1. Take a DB snapshot of the DB instance after the survey is completed, delete the DB instance, and then restore the DB instance along with web application on EC2 when you need to conduct the survey again. 2. AWS will not charge for EC2 and DB instance between the quarters when application is not being used. 3. Buy reserve capacity for EC2 and DB instance. 4. After the quarterly survey, when the application is not being used till next survey, change the instance class and storage of both EC2 and DB to lowest possible
1. **Take a DB snapshot of the DB instance after the survey is completed, delete the DB instance, and then restore the DB instance along with web application on EC2 when you need to conduct the survey again**. 2. AWS will not charge for EC2 and DB instance between the quarters when application is not being used. 3. Buy reserve capacity for EC2 and DB instance. 4. After the quarterly survey, when the application is not being used till next survey, change the instance class and storage of both EC2 and DB to lowest possible
88
Which storage type should you use for most RDS database workloads if your key criteria is cost optimization? 1. Magnetic Storage 2. Provisioned IOPS Storage 3. General Purpose SSD Storage 4. Throughput Optimized Storage
1. Magnetic Storage 2. Provisioned IOPS Storage 3. **General Purpose SSD Storage** 4. Throughput Optimized Storage
89
You are a DB Architect who is designing AWS RDS MySQL configuration for an intranet application. You don’t need high I/O performance for most of the time apart from daily nightly batch data load. You have been given the mandate to design a cost optimized solution. Which RDS database storage type will you choose? 1. Magnetic Storage 2. Provisioned IOPS Storage 3. Throughput Optimized Storage 4. General Purpose SSD Storage
1. Magnetic Storage 2. Provisioned IOPS Storage 3. Throughput Optimized Storage 4. **General Purpose SSD Storage**
90
How is reserved instances applicable for RDS Multi-AZ and Read Replicas? Choose 2. 1. Reserved instances are not available for RDS Multi-AZ 2. Reserved instances are not available for RDS Read Replicas 3. Reserved instances are available for RDS Multi-AZ 4. Reserved instances are available for RDS Read Replicas
1. Reserved instances are not available for RDS Multi-AZ 2. Reserved instances are not available for RDS Read Replicas 3. **Reserved instances are available for RDS Multi-AZ** 4. **Reserved instances are available for RDS Read Replicas**
91
You are the DB administrator for your company. You are responsible for running the database update scripts for a recent patch release that needs to be done over the weekend. You are using Amazon Aurora MySQL which was created through console with default settings. The plan is to do patch update over the weekend when there is no user activity and in case there is any issue all changes should be rolled back. What feature of RDS can you use to roll back the changes? Choose 2. 1. You have to manually delete new scripts to come back to original state. 2. RDS Aurora MySQL has the feature ‘Restore to point in time’ to restore a DB cluster to a specific point in time. 3. To manage risk first do the patch release in a DB copy without impacting original DB. 4. RDS Aurora MySQL has the feature to backtrack a DB Cluster to specific point in time, without restoring data from backup.
1. You have to manually delete new scripts to come back to original state. 2. **RDS Aurora MySQL has the feature ‘Restore to point in time’ to restore a DB cluster to a specific point in time.** 3. To manage risk first do the patch release in a DB copy without impacting original DB. 4. **RDS Aurora MySQL has the feature to backtrack a DB Cluster to specific point in time, without restoring data from backup.**
92
What are the different automated monitoring tool options for Amazon RDS? Choose 3. 1. Amazon RDS Enhanced Monitoring 2. Amazon CloudWatch 3. Amazon RDS Events and Database log files 4. Amazon Flow logs
1. **Amazon RDS Enhanced Monitoring** 2. **Amazon CloudWatch** 3. **Amazon RDS Events and Database log files** 4. Amazon Flow logs
93
What are the features of performance insights? Choose 3. 1. Monitors your Amazon RDS DB instance load so that you can analyze and troubleshoot your database performance. 2. The central metric for Performance Insights is DB Load, which represents the average number of active sessions for the DB engine. 3. The central metric for Performance Insights is DB Session, which represents the average number of active sessions for the DB engine. 4. You can visualize the database load and filter the load by waits, SQL statements, hosts, or users.
1. **Monitors your Amazon RDS DB instance load so that you can analyze and troubleshoot your database performance.** 2. **The central metric for Performance Insights is DB Load, which represents the average number of active sessions for the DB engine.** 3. The central metric for Performance Insights is DB Session, which represents the average number of active sessions for the DB engine. 4. **You can visualize the database load and filter the load by waits, SQL statements, hosts, or users.**
94
If you have trouble connecting to your RDS DB instance in a public subnet of a VPC from your home computer, what are the checks you will do? Choose 6 1. Publicly Accessible property of the instance should be set to No. 2. Publicly Accessible property of the instance should be set to Yes. 3. The RDS DB instance is in a state other than available, so it can't accept connections. 4. The source you use to connect to the instance is missing from the sources authorized to access the RDS DB instance in your security group, network ACLs, or local firewalls. 5. The incorrect DNS name or endpoint was used to connect to the DB instance. 6. The Multi-AZ instance failed over, and the secondary instance uses a subnet or route table that doesn't allow inbound connections. 7. The user authentication is incorrect.
1. Publicly Accessible property of the instance should be set to No. 2. **Publicly Accessible property of the instance should be set to Yes.** 3. **The RDS DB instance is in a state other than available, so it can't accept connections.** 4. **The source you use to connect to the instance is missing from the sources authorized to access the RDS DB instance in your security group, network ACLs, or local firewalls.** 5. **The incorrect DNS name or endpoint was used to connect to the DB instance.** 6. **The Multi-AZ instance failed over, and the secondary instance uses a subnet or route table that doesn't allow inbound connections.** 7. **The user authentication is incorrect.**
95
You are solution architect for a sports media company that hosts its websites on AWS. Most of the users visits the website for reading latest news, videos and articles on different sports available on the website, only minority of users write reviews or comments. Website server runs on Amazon EC2 auto scale enabled instances along with single EC2 instance for MySQL. With increase in the popularity of the website you have been tasked to make it more resilient and improve the performance. How can you do that? Choose 2. 1. Migrate MySQL to Amazon RDS with Multi-AZ for performance. 2. Migrate MySQL to Amazon RDS with Multi-AZ for resiliency. 3. Enable Read Replicas on Amazon RDS and distribute read traffic for performance improvement. 4. Enable Read Replicas on Amazon RDS and distribute read traffic for resiliency.
1. Migrate MySQL to Amazon RDS with Multi-AZ for performance. 2. **Migrate MySQL to Amazon RDS with Multi-AZ for resiliency.** 3. **Enable Read Replicas on Amazon RDS and distribute read traffic for performance improvement.** 4. Enable Read Replicas on Amazon RDS and distribute read traffic for resiliency.
96
Which of the following AWS service provide caching services to improve performance? Choose 4 1. Amazon EBS 2. Amazon ElastiCache 3. Amazon DynamoDB Accelerator (DAX) 4. Amazon CloudFront 5. AWS Greengrass 6. Route 53
1. Amazon EBS 2. **Amazon ElastiCache** 3. **Amazon DynamoDB Accelerator (DAX)** 4. **Amazon CloudFront** 5. **AWS Greengrass** 6. **Route 53**
97
Which of the following services provide high availability by being inherently Multi-AZ and you don’t have to enable or configure it explicitly? Choose 3 1. RDS 2. DynamoDB 3. S3 4. EC2 5. SQS 6. ELB
1. RDS 2. **DynamoDB** 3. **S3** 4. EC2 5. **SQS** 6. ELB
98
Which of the following AWS services does not provide cost savings through reservation model? 1. EC2 2. EBS 3. RDS 4. ElastiCache 5. Redshift 6. DynamoDB 7. S3
1. EC2 2. **EBS** 3. RDS 4. ElastiCache 5. Redshift 6. DynamoDB 7. **S3**
99
How DynamoDB provides high durability and availability? 1. You can take DynamoDB snapshots and store it in S3. 2. You can enable Multi-AZ deployment of DynamoDB. 3. You can enable Read Replica of DynamoDB in different AZ. 4. Data is automatically replicated across multiple Availability Zones in an AWS Region.
1. You can take DynamoDB snapshots and store it in S3. 2. You can enable Multi-AZ deployment of DynamoDB. 3. You can enable Read Replica of DynamoDB in different AZ. 4. **Data is automatically replicated across multiple Availability Zones in an AWS Region.**
100
For a website which AWS database service you will choose that has no servers to provision, patch, or manage and no software to install, maintain, or operate, it automatically scales tables up and down to adjust for capacity and maintain performance, with built-in security, backup and restore, and in-memory caching for internet-scale applications ? 1. ElastiCache 2. RDS 3. DynamoDB 4. Redshift
1. ElastiCache 2. RDS 3. **DynamoDB** 4. Redshift
101
Which AWS database service will you choose for non-relational database? 1. Amazon RDS 2. Amazon Redshift 3. Amazon Glacier 4. Amazon DynamoDB
1. Amazon RDS 2. Amazon Redshift 3. Amazon Glacier 4. **Amazon DynamoDB**
102
Which of the following statements are correct for DynamoDB? Choose 3 1. DynamoDB is a NoSQL database that supports key-value and document data models. 2. DynamoDB global tables replicate your data automatically across your choice of AWS Regions and automatically scale capacity to accommodate your workloads. 3. With DynamoDB, there are no servers to provision, patch, or manage, and no software to install, maintain, or operate. 4. DynamoDB is a RDBMS database that supports key-value and document data models.
1. **DynamoDB is a NoSQL database that supports key-value and document data models.** 2. **DynamoDB global tables replicate your data automatically across your choice of AWS Regions and automatically scale capacity to accommodate your workloads.** 3. **With DynamoDB, there are no servers to provision, patch, or manage, and no software to install, maintain, or operate.** 4. DynamoDB is a RDBMS database that supports key-value and document data models.
103
Which data types are allowed for DynamoDB primary key attributes? Choose 3. 1. JSON 2. String 3. Number 4. Binary
1. JSON 2. **String** 3. **Number** 4. **Binary**
104
Which of the following statements are true about DynamoDB? Choose 3. 1. DynamoDB automatically spreads the data and traffic for your tables over a sufficient number of servers to handle your throughput and storage requirements, while maintaining consistent and fast performance. 2. All of your data is stored on solid state disks (SSDs) and automatically replicated across multiple Availability Zones in an AWS region, providing built-in high availability and data durability. 3. Amazon DynamoDB does not provide on-demand backup capability. 4. Amazon DynamoDB provides on-demand backup capability.
1. **DynamoDB automatically spreads the data and traffic for your tables over a sufficient number of servers to handle your throughput and storage requirements, while maintaining consistent and fast performance.** 2. **All of your data is stored on solid state disks (SSDs) and automatically replicated across multiple Availability Zones in an AWS region, providing built-in high availability and data durability.** 3. Amazon DynamoDB does not provide on-demand backup capability. 4. **Amazon DynamoDB provides on-demand backup capability.**
105
What are the two types of read consistency supported by DynamoDB? 1. Read After Write 2. Eventually Consistent Reads 3. Strongly Consistent Reads 4. Lazy Read
1. Read After Write 2. **Eventually Consistent Reads** 3. **Strongly Consistent Reads** 4. Lazy Read
106
What are the two type of read/write capacity mode in DynamoDB? 1. Reserved 2. On-Demand 3. Provisioned 4. Spot
1. Reserved 2. **On-Demand** 3. **Provisioned** 4. Spot
107
For which of the following scenarios will DynamoDB on-demand read/write capacity mode is appropriate. Choose 3. 1. Able to forecast capacity requirements to control costs. 2. Creating new tables with unknown workloads. 3. Unpredictable application traffic. 4. Prefer the ease of paying for only what you use.
1. Able to forecast capacity requirements to control costs. 2. **Creating new tables with unknown workloads.** 3. **Unpredictable application traffic.** 4. **Prefer the ease of paying for only what you use.**
108
For which of the following scenarios will DynamoDB provisioned read/write capacity mode is appropriate. Choose 3. 1. Ability to forecast capacity requirements to control costs. 2. Predictable application traffic. 3. Unpredictable application traffic. 4. Applications whose traffic is consistent or ramps gradually.
1. **Ability to forecast capacity requirements to control costs.** 2. **Predictable application traffic**. 3. Unpredictable application traffic. 4. **Applications whose traffic is consistent or ramps gradually.**
109
DocumentDB provides compatibility to workloads from which of the following database? 1. MongoDB 2. MySQL 3. PostgreSQL 4. Redis
1. **MongoDB** 2. MySQL 3. PostgreSQL 4. Redis
110
Which of the following statements are correct for read capacity of a DynamoDB provisioned table? Choose 2. 1. A read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 4 KB in size. 2. A read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 8 KB in size. 3. Transactional read requests require two read capacity units to perform one read per second for items up to 4 KB. 4. Transactional read requests require two read capacity units to perform one read per second for items up to 8 KB.
1. **A read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 4 KB in size.** 2. A read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 8 KB in size. 3. **Transactional read requests require two read capacity units to perform one read per second for items up to 4 KB.** 4. Transactional read requests require two read capacity units to perform one read per second for items up to 8 KB.
111
Which of the following statements are correct for read capacity of a DynamoDB provisioned table? Choose 3. 1. If you perform a read operation on an item that does not exist, DynamoDB still consumes provisioned read throughput. 2. If you perform a read operation on an item that does not exist, DynamoDB does not consumes provisioned read throughput. 3. One read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 4 KB in size. 4. Transactional read requests require two read capacity units to perform one read per second for items up to 4 KB.
1. **If you perform a read operation on an item that does not exist, DynamoDB still consumes provisioned read throughput.** 2. If you perform a read operation on an item that does not exist, DynamoDB does not consumes provisioned read throughput. 3. **One read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 4 KB in size.** 4. **Transactional read requests require two read capacity units to perform one read per second for items up to 4 KB.**
112
Which of the following statements are correct for write capacity of a DynamoDB provisioned table? Choose 2. 1. One write capacity unit represents one write per second for an item up to 2 KB in size. 2. Transactional write requests require 1 write capacity units to perform one write per second for items up to 2 KB. 3. One write capacity unit represents one write per second for an item up to 1 KB in size. 4. Transactional write requests require 2 write capacity units to perform one write per second for items up to 1 KB.
1. One write capacity unit represents one write per second for an item up to 2 KB in size. 2. Transactional write requests require 1 write capacity units to perform one write per second for items up to 2 KB. 3. **One write capacity unit represents one write per second for an item up to 1 KB in size.** 4. **Transactional write requests require 2 write capacity units to perform one write per second for items up to 1 KB.**
113
Which database will you use for storing non-relational data? 1. Amazon RDS 2. Amazon DynamoDB 3. Amazon Redshift 4. Amazon S3
1. Amazon RDS 2. **Amazon DynamoDB** 3. Amazon Redshift 4. Amazon S3
114
Suppose that you created a DynamoDB provisioned table with 6 read capacity units. With these settings, choose three options which your application could do. 1. Perform strongly consistent reads of up to 24 KB per second 2. Perform eventually consistent reads of up to 24 KB per second 3. Perform eventually consistent reads of up to 48 KB per second 4. Perform transactional read requests of up to 12 KB per second.
1. **Perform strongly consistent reads of up to 24 KB per second** 2. Perform eventually consistent reads of up to 24 KB per second 3. **Perform eventually consistent reads of up to 48 KB per second** 4. **Perform transactional read requests of up to 12 KB per second.**
115
Suppose that you created a DynamoDB provisioned table with 6 write capacity units. With these settings, choose two options which your application could do. 1. Write up to 6 KB per second. 2. Perform transactional write requests of up to 6 KB per second. 3. Write up to 3 KB per second. 4. Perform transactional write requests of up to 3 KB per second.
1. **Write up to 6 KB per second.** 2. Perform transactional write requests of up to 6 KB per second. 3. Write up to 3 KB per second. 4. **Perform transactional write requests of up to 3 KB per second.**
116
What is the default consistency model in DynamoDB? 1. Eventually consistent reads 2. Strongly consistent reads 3. Eventually consistent write 4. Strongly consistent write
1. **Eventually consistent reads** 2. Strongly consistent reads 3. Eventually consistent write 4. Strongly consistent write
117
You are designing a B2B ecommerce application that will have hundreds of concurrent users. Which database will you use to store the user session data? 1. Amazon RDS 2. Amazon Redshift 3. Amazon DynamoDB 4. Amazon S3
1. Amazon RDS 2. Amazon Redshift 3. **Amazon DynamoDB** 4. Amazon S3
118
What are the two different primary keys supported in a DynamoDB table? Choose 2. 1. Partition key 2. Global secondary key 3. Local secondary key 4. Partition key and sort key
1. **Partition key** 2. Global secondary key 3. Local secondary key 4. **Partition key and sort key**
119
Which two secondary indexes you can create on a DynamoDB table? Choose 2. 1. Global secondary index – An index with a partition key and sort key that can be different from those on the table. 2. Local secondary index – An index that has the same partition key as the table, but a different sort key. 3. Global secondary index – An index with a partition key and sort key that can be same as those on the table. 4. Local secondary index – An index that has the same partition key as the table, but two different sort key.
1. **Global secondary index – An index with a partition key and sort key that can be different from those on the table.** 2. **Local secondary index – An index that has the same partition key as the table, but a different sort key.** 3. Global secondary index – An index with a partition key and sort key that can be same as those on the table. 4. Local secondary index – An index that has the same partition key as the table, but two different sort key.
120
You are architecting an IoT application to store time series information from water pump installed at different manufacturing plants across the country. Each water pump will have its own device id and will be sending different machine parameter values every 5 minutes. Which database will be best to be used for storing this information? 1. Amazon RDS 2. Amazon Redshift 3. Amazon DynamoDB 4. Amazon S3
1. Amazon RDS 2. Amazon Redshift 3. **Amazon DynamoDB** 4. Amazon S3
121
# Choose three best practices for NoSQL design in DynamoDB database? 1. You should start designing your schema only after you have understood business problems and the application use cases. 2. You design for flexibility without worrying about implementation details or performance. 3. You should maintain as few tables as possible in a DynamoDB application. 4. You design your schema specifically to make the most common and important queries as fast and as inexpensive as possible.
1. **You should start designing your schema only after you have understood business problems and the application use cases.** 2. You design for flexibility without worrying about implementation details or performance. 3. **You should maintain as few tables as possible in a DynamoDB application.** 4. **You design your schema specifically to make the most common and important queries as fast and as inexpensive as possible.**
122
You have a company social network application where employees in the company can exchange messages, have discussion, create profile pages and post photos. DynamoDB is the core database service used in the architecture to store the data. Database workloads is expected to be cyclical in nature or difficult to predict in advance as it is rolled out across global employee base. You don’t want to manually intervene to scale database resources up or down in response to varying usage levels or sudden burst in activity. Your application is running on EC2. Which of the following two options you should do to ensure that performance of DynamoDB is at optimum level? 1. Manage Throughput Capacity Automatically with DynamoDB Auto Scaling 2. Use DAX which is in-memory cache for DynamoDB 3. Use Internal Application Load Balancer with DynamoDB 4. Use EC2 auto scaling for DynamoDB.
1. **Manage Throughput Capacity Automatically with DynamoDB Auto Scaling** 2. **Use DAX which is in-memory cache for DynamoDB** 3. Use Internal Application Load Balancer with DynamoDB 4. Use EC2 auto scaling for DynamoDB.
123
What factors you will consider for choosing initial throughput settings on DynamoDB provisioned tables? Choose 3. 1. Item sizes 2. Expected read and write request rates 3. Read consistency requirement 4. Write consistency requirement
1. **Item sizes** 2. **Expected read and write request rates** 3. **Read consistency requirement** 4. Write consistency requirement
124
You have an intranet project collaboration chat messaging application where employees in the company can exchange messages with each other. You are storing all the messages in DynamoDB table having attributes: employeeid, message, and timestamp. Which attributes should you choose for partition key and sort key? 1. Timestamp, Employeeid 2. Employeeid, Timestamp 3. Message, Employeename 4. Employeeid, message
1. Timestamp, Employeeid 2. **Employeeid, Timestamp** 3. Message, Employeename 4. Employeeid, message
125
Which DynamoDB feature captures data modification events in DynamoDB tables? 1. DynamoDB Events 2. DynamoDB Streams 3. DynamoDB DAX 4. DynamoDB Triggers
1. DynamoDB Events 2. **DynamoDB Streams** 3. DynamoDB DAX 4. DynamoDB Triggers
126
Which of the following is not a use case for using DynamoDB Streams? 1. An application in one AWS Region modifies the data in a DynamoDB table. A second application in another Region reads these data modifications and writes the data to another table, creating a replica that stays in sync with the original table. 2. A popular mobile app modifies data in a DynamoDB table, at the rate of thousands of updates per second. Another application captures and stores data about these updates, providing near-real-time usage metrics for the mobile app. 3. A global multi-player game has a multi-master topology, storing data in multiple AWS Regions. Each master stays in sync by consuming and replaying the changes that occur in the remote Regions. 4. Tracking the session time inactivity for a website user and logging out it after pre-defined duration expiry. 5. An application automatically sends notifications to the mobile devices of all friends in a group as soon as one friend uploads a new picture. 6. A new customer adds data to a DynamoDB table. This event invokes another application that sends a welcome email to the new customer.
1. An application in one AWS Region modifies the data in a DynamoDB table. A second application in another Region reads these data modifications and writes the data to another table, creating a replica that stays in sync with the original table. 2. A popular mobile app modifies data in a DynamoDB table, at the rate of thousands of updates per second. Another application captures and stores data about these updates, providing near-real-time usage metrics for the mobile app. 3. A global multi-player game has a multi-master topology, storing data in multiple AWS Regions. Each master stays in sync by consuming and replaying the changes that occur in the remote Regions. 4. **Tracking the session time inactivity for a website user and logging out it after pre-defined duration expiry.** 5. An application automatically sends notifications to the mobile devices of all friends in a group as soon as one friend uploads a new picture. 6. A new customer adds data to a DynamoDB table. This event invokes another application that sends a welcome email to the new customer.
127
You are determining the initial throughput settings for a DynamoDB provisioned table which has following Read Requirements: * You want to read 80 items per second from a table. * The items are 3 KB in size, and you want strongly consistent reads. Which of the following two statements are correct for this scenario? 1. Each read will require half provisioned read capacity unit. 2. You have to set the table's provisioned read throughput to 40 read capacity units. 3. Each read will require one provisioned read capacity unit. 4. You have to set the table's provisioned read throughput to 80 read capacity units.
1. Each read will require half provisioned read capacity unit. 2. You have to set the table's provisioned read throughput to 40 read capacity units. 3. **Each read will require one provisioned read capacity unit.** 4. **You have to set the table's provisioned read throughput to 80 read capacity units.**
128
Which of the following statements are true regarding DynamoDB secondary indexes? Choose 2. 1. A global secondary index is considered "global" because queries on the index can span all of the data in the base table, across all partitions. 2. A global secondary index is considered "global" because queries on the index cannot span all of the data in the base table, across all partitions. 3. A local secondary index is "local" in the sense that every partition of a local secondary index is scoped to a base table partition that has the same partition key value. 4. A local secondary index is "local" in the sense that every partition of a local secondary index is scoped to a base table partition that has the different partition key value.
1. **A global secondary index is considered "global" because queries on the index can span all of the data in the base table, across all partitions.** 2. A global secondary index is considered "global" because queries on the index cannot span all of the data in the base table, across all partitions. 3. **A local secondary index is "local" in the sense that every partition of a local secondary index is scoped to a base table partition that has the same partition key value.** 4. A local secondary index is "local" in the sense that every partition of a local secondary index is scoped to a base table partition that has the different partition key value.
129
Which of the following statements are true regarding DynamoDB secondary indexes? Choose 4. 1. Queries on global secondary indexes support eventual consistency only. 2. Every local secondary index has its own provisioned throughput settings for read and write activity. 3. When you query a local secondary index, you can choose either eventual consistency or strong consistency. 4. Every global secondary index has its own provisioned throughput settings for read and write activity. 5. Queries or scans on a local secondary index consume read capacity units from the base table.
1. **Queries on global secondary indexes support eventual consistency only.** 2. Every local secondary index has its own provisioned throughput settings for read and write activity. 3. **When you query a local secondary index, you can choose either eventual consistency or strong consistency.** 4. **Every global secondary index has its own provisioned throughput settings for read and write activity.** 5. **Queries or scans on a local secondary index consume read capacity units from the base table.**
130
You are determining the initial throughput settings for a DynamoDB provisioned table which has following requirements: * Write Requirements: You want to write 100 items per second to your table, and that the items are 512 bytes in size. Which of the following two statements are correct for this scenario? 1. Each write will require half provisioned write capacity unit. 2. You have to set the table's provisioned throughput to 50 write capacity units. 3. Each write will require one provisioned write capacity unit. 4. You have to set the table's provisioned write throughput to 100 write capacity units.
1. Each write will require half provisioned write capacity unit. 2. You have to set the table's provisioned throughput to 50 write capacity units. 3. **Each write will require one provisioned write capacity unit.** 4. **You have to set the table's provisioned write throughput to 100 write capacity units.**
131
What is DynamoDB Accelerator (DAX)? Choose 3. 1. DAX is a DynamoDB-compatible caching service that enables you to benefit from fast in-memory performance. 2. DAX is a DynamoDB-compatible auto scaling service that enables you to benefit from fast in-memory performance. 3. DAX is suitable for use case where you have applications that are read-intensive, but are also cost-sensitive. 4. DAX is suitable for use case where you have applications that require repeated reads against a large set of data.
1. **DAX is a DynamoDB-compatible caching service that enables you to benefit from fast in-memory performance.** 2. DAX is a DynamoDB-compatible auto scaling service that enables you to benefit from fast in-memory performance. 3. **DAX is suitable for use case where you have applications that are read-intensive, but are also cost-sensitive.** 4. **DAX is suitable for use case where you have applications that require repeated reads against a large set of data.**
132
You are the solution architect for an online gaming portal where users will have an account and can play any games available on the portal. You are saving the user games data in DynamoDB table named GameScores that tracks users and scores. Each item in GameScores is identified by a partition key (UserId) and a sort key (GameTitle). The following diagram shows how the items in the table is organized. Which of the following statements are correct about the design? Choose 2. 1. A query that specified the key attributes (UserId and GameTitle) would be very efficient for a leaderboard application to display top scores for each game for a given userid. 2. A query that specified the key attributes (UserId and GameTitle) would be very inefficient for a leaderboard application to display top scores for each game for a given userid. 3. If the application needed to retrieve data from GameScores based on GameTitle only, it would need to use a Scan operation. 4. If the application needed to retrieve data from GameScores based on GameTitle only, it would need to use a Query operation.
1. **A query that specified the key attributes (UserId and GameTitle) would be very efficient for a leaderboard application to display top scores for each game for a given userid.** 2. A query that specified the key attributes (UserId and GameTitle) would be very inefficient for a leaderboard application to display top scores for each game for a given userid. 3. **If the application needed to retrieve data from GameScores based on GameTitle only, it would need to use a Scan operation.** 4. If the application needed to retrieve data from GameScores based on GameTitle only, it would need to use a Query operation.
133
Based on the table design in previous question 131. As part of the new features your product manager wants to display following leaderboards: * top score ever recorded for every game * a user’s highest score for every game What changes if required will you do in the DynamoDB table design? 1. No change required, the table design will work efficiently for retrieving required data. 2. Create a global secondary index with attributes, partition key of GameTitle and a sort key of TopScore. 3. Create a global secondary index with attributes, partition key of GameTitle and a sort key of UserID. 4. Create a global secondary index with attributes, partition key of UserID and a sort key of GameTitle.
1. No change required, the table design will work efficiently for retrieving required data. 2. **Create a global secondary index with attributes, partition key of GameTitle and a sort key of TopScore.** 3. Create a global secondary index with attributes, partition key of GameTitle and a sort key of UserID. 4. Create a global secondary index with attributes, partition key of UserID and a sort key of GameTitle.
134
You are the chief architect of an online gaming company which has a very popular car racing game and uses DynamoDB as database for the gaming application. Your company is going to launch a new version of the game which will be available for only North American users for subscription. You are expecting a major spike in the usage only during day time in North American regions and then the load will decrease during night. This day night spike and down is expected at least for a month. What you should you do for the Dynamo DB database layer to meet this scenario in cost effective way? 1. Create new instances of DynamoDB and other application layer which caters only to North American user for one month. 2. Increase the provisioned capacity of DynamoDB tables during day time and decrease it during night 3. Use DynamoDB auto scaling to dynamically adjust provisioned throughput capacity on your behalf, in response to actual traffic patterns. 4. Create more secondary indexes for every table to optimize the query performance
1. Create new instances of DynamoDB and other application layer which caters only to North American user for one month. 2. Increase the provisioned capacity of DynamoDB tables during day time and decrease it during night 3. **Use DynamoDB auto scaling to dynamically adjust provisioned throughput capacity on your behalf, in response to actual traffic patterns.** 4. Create more secondary indexes for every table to optimize the query performance
135
Which of the following statements are true about DynamoDB Streams? Choose 3. 1. When a new item is added to the table, the stream captures an image of the entire item, including all of its attributes. 2. When an item is updated in the table, the stream captures the "before" and "after" image of any attributes that were modified in the item. 3. When an item is updated in the table, the stream captures only the “after" image of any attributes that were modified in the item. 4. When an item is deleted from the table, the stream captures an image of the entire item before it was deleted.
1. **When a new item is added to the table, the stream captures an image of the entire item, including all of its attributes.** 2. **When an item is updated in the table, the stream captures the "before" and "after" image of any attributes that were modified in the item.** 3. When an item is updated in the table, the stream captures only the “after" image of any attributes that were modified in the item. 4. **When an item is deleted from the table, the stream captures an image of the entire item before it was deleted.**
136
Which of the following use cases are ideal for using DynamoDB DAX? Choose 4. 1. Applications that require the fastest possible response time for reads. 2. Applications that read a small number of items more frequently than others. 3. Applications that are write-intensive, or that do not perform much read activity. 4. Applications that are read-intensive, but are also cost-sensitive. 5. Applications that require repeated reads against a large set of data.
1. **Applications that require the fastest possible response time for reads.** 2. **Applications that read a small number of items more frequently than others.** 3. Applications that are write-intensive, or that do not perform much read activity. 4. **Applications that are read-intensive, but are also cost-sensitive.** 5. **Applications that require repeated reads against a large set of data.**
137
Which of the following is correct about attribute projection in DynamoDB Global Secondary Index? Choose 2. 1. The partition key and sort key of the table are always projected into the index. 2. You can project other attributes apart from partition and sort key. 3. Only the partition key of the table is projected into the index. 4. Only the sort key of the table is projected into the index. 5. You can project maximum of three attributes apart from partition and sort key.
1. **The partition key and sort key of the table are always projected into the index.** 2. **You can project other attributes apart from partition and sort key.** 3. Only the partition key of the table is projected into the index. 4. Only the sort key of the table is projected into the index. 5. You can project maximum of three attributes apart from partition and sort key.
138
Which engines are supported by Amazon ElastiCache? 1. Memcached only 2. Redis Only 3. Memcached and Redis 4. Varnish 5. Varnish, Memcached and Redis
1. Memcached only 2. Redis Only 3. **Memcached and Redis** 4. Varnish 5. Varnish, Memcached and Redis
139
You are using DynamoDB table to track the session history of your application users. You want to delete an entry from the table two hours after it was created. How can you achieve this in an efficient way? 1. Enable Time to Live on the session data table. 2. Write a program which continuously reads the table entries and deletes records which are expired. 3. Write a program which runs every two hours, reads the table entries and deletes records which are expired. 4. Write a stored procedure which deletes records which are more than two hours old.
1. **Enable Time to Live on the session data table.** 2. Write a program which continuously reads the table entries and deletes records which are expired. 3. Write a program which runs every two hours, reads the table entries and deletes records which are expired. 4. Write a stored procedure which deletes records which are more than two hours old.
140
Which of the following use cases are not ideal for using DynamoDB DAX? Choose 4. 1. Applications that require strongly consistent reads. 2. Applications that do not require microsecond response times for reads, or that do not need to offload repeated read activity from underlying tables. 3. Applications that are write-intensive, or that do not perform much read activity. 4. Applications that are already using a different caching solution with DynamoDB, and are using their own client-side logic for working with that caching solution. 5. Application that require eventually consistent reads.
1. **Applications that require strongly consistent reads.** 2. **Applications that do not require microsecond response times for reads, or that do not need to offload repeated read activity from underlying tables.** 3. **Applications that are write-intensive, or that do not perform much read activity.** 4. **Applications that are already using a different caching solution with DynamoDB, and are using their own client-side logic for working with that caching solution.** 5. Application that require eventually consistent reads.
141
Which AWS service can be used for application where the requirement is to have an in-memory database to have real time access to data and the latency should be at microsecond? 1. Amazon ElastiCache 2. Amazon Neptune 3. Amazon DynamoDB 4. Amazon DocumentDB
1. **Amazon ElastiCache** 2. Amazon Neptune 3. Amazon DynamoDB 4. Amazon DocumentDB
142
What are differences between Memcached and Redis engines? Choose 3. 1. Memcached supports transactions which let you execute a group of commands as an isolated and atomic operation. Redis does not. 2. Memcached is multithreaded and Redis is not. 3. Redis supports snapshots and replications. Memcached does not. 4. Redis has geospatial support, Memcached does not.
1. Memcached supports transactions which let you execute a group of commands as an isolated and atomic operation. Redis does not. 2. **Memcached is multithreaded and Redis is not.** 3. **Redis supports snapshots and replications. Memcached does not.** 4. **Redis has geospatial support, Memcached does not.**
143
You are developing an online car racing gaming website. One of the feature you will be having is a leaderboard displaying top 10 scores. Which caching service you will use to develop this feature? 1. Amazon ElastiCache for Redis 2. Amazon ElastiCache for Memcached 3. Amazon DynamoDB 4. Amazon S3
1. **Amazon ElastiCache for Redis** 2. Amazon ElastiCache for Memcached 3. Amazon DynamoDB 4. Amazon S3
144
When should you consider caching your data? Choose 3. 1. It is slow or expensive to acquire when compared to cache retrieval. 2. It is accessed with sufficient frequency. 3. It is dynamic, or if rapidly changing, it should be real time value. 4. It is relatively static, or if rapidly changing, staleness is not a significant issue.
1. **It is slow or expensive to acquire when compared to cache retrieval.** 2. **It is accessed with sufficient frequency.** 3. It is dynamic, or if rapidly changing, it should be real time value. 4. **It is relatively static, or if rapidly changing, staleness is not a significant issue.**
145
What are the different strategies for caching data? Choose 3. 1. Lazy loading strategy that loads data into the cache only when necessary. 2. Write through strategy adds data or updates data in the cache whenever data is written to the database. 3. Periodic time based refreshing of whole data in the cache. 4. Adding a time to live (TTL) value to each write.
1. **Lazy loading strategy that loads data into the cache only when necessary.** 2. **Write through strategy adds data or updates data in the cache whenever data is written to the database.** 3. Periodic time based refreshing of whole data in the cache. 4. **Adding a time to live (TTL) value to each write.**
146
When should you choose Memcached? Choose 3. 1. You need the simplest model possible. 2. You need complex data types, such as strings, hashes, lists, sets, sorted sets, and bitmaps. 3. You need to run large nodes with multiple cores or threads. 4. You need the ability to scale out and in, adding and removing nodes as demand on your system increases and decreases. You need to cache objects, such as a database.
1. **You need the simplest model possible.** 2. You need complex data types, such as strings, hashes, lists, sets, sorted sets, and bitmaps. 3. **You need to run large nodes with multiple cores or threads.** 4. **You need the ability to scale out and in, adding and removing nodes as demand on your system increases and decreases. You need to cache objects, such as a database.**
147
For an AWS discussion forum portal you have designed following DynamoDB ‘Thread’ table with Forumname as the partition key and Subject as the sort key. Suppose that an application needs to find all of the threads that have been posted within the last three months and display ‘ForumName’ ‘Subject’. What change in the design you should do? 1. No change required in the current table design. 2. Create a local secondary index having partition key with Subject, but with sort key as LastPostDateTime. 3. Create a local secondary index having partition key with LastPostDateTime, but with sort key as Subject. 4. Create a local secondary index having partition key same as that of the Thread table, but with sort key as LastPostDateTime.
1. No change required in the current table design. 2. Create a local secondary index having partition key with Subject, but with sort key as LastPostDateTime. 3. Create a local secondary index having partition key with LastPostDateTime, but with sort key as Subject. 4. **Create a local secondary index having partition key same as that of the Thread table, but with sort key as LastPostDateTime.**
148
Which of the following DynamoDB table partition key schemes will result in better provisioned throughput efficiency? Choose 2. 1. User ID, where the application has many users. 2. Status code, where there are only a few possible status codes. 3. Item creation date, rounded to the nearest time period (for example, day, hour, or minute). 4. Device ID, where each device accesses data at relatively similar intervals. 5. Device ID, where even if there are many devices being tracked, one is by far more popular than all the others.
1. **User ID, where the application has many users.** 2. Status code, where there are only a few possible status codes. 3. Item creation date, rounded to the nearest time period (for example, day, hour, or minute). 4. **Device ID, where each device accesses data at relatively similar intervals.** 5. Device ID, where even if there are many devices being tracked, one is by far more popular than all the others.
149
You have a web application using RDS MySQL database with read replica enabled. To further boost the application performance you are planning to add an in-memory caching layer to your relational database. You will implement a cache-aside strategy using Amazon ElastiCache for Redis on top of MySQL database. How Amazon ElastiCache improves database performance? 1. By serving high-volume application read traffic. 2. By caching the database query results. 3. By delivering up to a 10x performance improvement – from milliseconds to microseconds – even at millions of requests per second. 4. By securely delivering data, videos, applications, and APIs to customers globally with low latency, high transfer speed.
1. By serving high-volume application read traffic. 2. **By caching the database query results.** 3. By delivering up to a 10x performance improvement – from milliseconds to microseconds – even at millions of requests per second. 4. By securely delivering data, videos, applications, and APIs to customers globally with low latency, high transfer speed.
150
You are using DynamoDB to host a discussion forum website on AWS topics (S3, VPC, ELB….). Users can subscribe to notification whenever there is a new discussion thread or post on topics they have chosen. For example user Smith has chosen to be notified for (RDS, EC2, ECS). How can you achieve this? 1. Use Lambda with DynamoDB stream to capture the new post or topic record insertion in the table, function will have logic to query the list of users subscribed to that discussion topic then it will send notification to subscribed users through SNS. 2. Use Cloudwatch with DynamoDB stream to capture the new post or topic record insertion in the table, trigger a Lambda to query the list of users subscribed to that discussion topic then it will send notification to subscribed users through SNS. 3. Use Cloudtrail with DynamoDB stream to capture the new post or topic record insertion in the table, trigger a Lambda to query the list of users subscribed to that discussion topic then it will send notification to subscribed users through SNS. 4. Use a scheduled job running in an EC2 server to continuously read the DynamoDB table and send the notification to subscribed users through SNS.
1. **Use Lambda with DynamoDB stream to capture the new post or topic record insertion in the table, function will have logic to query the list of users subscribed to that discussion topic then it will send notification to subscribed users through SNS.** 2. Use Cloudwatch with DynamoDB stream to capture the new post or topic record insertion in the table, trigger a Lambda to query the list of users subscribed to that discussion topic then it will send notification to subscribed users through SNS. 3. Use Cloudtrail with DynamoDB stream to capture the new post or topic record insertion in the table, trigger a Lambda to query the list of users subscribed to that discussion topic then it will send notification to subscribed users through SNS. 4. Use a scheduled job running in an EC2 server to continuously read the DynamoDB table and send the notification to subscribed users through SNS.
151
When should you choose Redis for caching strategy? Choose 3. 1. You need complex data types, such as strings, hashes, lists, sets, sorted sets, and bitmaps. 2. You need to sort or rank in-memory datasets. You need persistence of your key store. 3. You need to replicate your data from the primary to one or more read replicas for read intensive applications. 4. You need to store object data types only.
1. **You need complex data types, such as strings, hashes, lists, sets, sorted sets, and bitmaps.** 2. **You need to sort or rank in-memory datasets. You need persistence of your key store.** 3. **You need to replicate your data from the primary to one or more read replicas for read intensive applications.** 4. You need to store object data types only.
152
When should you choose Redis for caching strategy? Choose 3. 1. You don’t need automatic failover if your primary node fails. 2. You need automatic failover if your primary node fails. 3. You need publish and subscribe (pub/sub) capabilities—to inform clients about events on the server. 4. You need backup and restore capabilities. You need to support multiple databases.
1. You don’t need automatic failover if your primary node fails. 2. **You need automatic failover if your primary node fails.** 3. **You need publish and subscribe (pub/sub) capabilities—to inform clients about events on the server.** 4. **You need backup and restore capabilities. You need to support multiple databases.**
153
What are the features of ElastiCache for Redis to enhance reliability? Choose 4. 1. Automatic detection and recovery from cache node failures. 2. Multi-AZ with automatic failover of a failed primary cluster to a read replica in Redis clusters that support replication. 3. Multi-AZ with automatic failover of a failed primary cluster to a standby instance in Redis clusters that support replication. 4. Redis (cluster mode enabled) supports partitioning your data across up to 90 shards. 5. Starting with Redis version 3.2.6, all subsequent supported versions support in-transit and at-rest encryption with authentication so you can build HIPAA-compliant applications
1. **Automatic detection and recovery from cache node failures.** 2. **Multi-AZ with automatic failover of a failed primary cluster to a read replica in Redis clusters that support replication.** 3. Multi-AZ with automatic failover of a failed primary cluster to a standby instance in Redis clusters that support replication. 4. **Redis (cluster mode enabled) supports partitioning your data across up to 90 shards.** 5. **Starting with Redis version 3.2.6, all subsequent supported versions support in-transit and at-rest encryption with authentication so you can build HIPAA-compliant applications**
154
What are the components of an ElastiCache for Redis? Choose 3. 1. Node 2. Shards 3. Cluster 4. Threads
1. **Node** 2. **Shards** 3. **Cluster** 4. Threads
155
How many shards a Redis cluster has in cluster mode disabled? 1. 1 shard 2. 1-30 shards 3. 1-60 shards 4. 1-90 shards
1. **1 shard** 2. 1-30 shards 3. 1-60 shards 4. 1-90 shards
156
How many shards a Redis cluster can have in cluster mode enabled? 1. 1 shard 2. 1-30 shards 3. 1-60 shards 4. 1-90 shards
1. 1 shard 2. 1-30 shards 3. 1-60 shards 4. **1-90 shards**
157
You are designing an online gaming portal where uses can register to play variety of games. You are planning to use DynamoDB database to store the user’s scores. The pattern of the workload will be unpredictable. What are the best practices you should follow so that read or write operations on Amazon DynamoDB table are not throttled and cost is also optimized? Choose 2. 1. Distribute read and write operations as evenly as possible across your table. 2. Enable Adaptive capacity to run imbalanced workloads indefinitely. 3. Use DynamoDB Auto Scaling with reserved capacity. 4. Use On-demand capacity mode.
1. **Distribute read and write operations as evenly as possible across your table.** 2. Enable Adaptive capacity to run imbalanced workloads indefinitely. 3. **Use DynamoDB Auto Scaling with reserved capacity.** 4. Use On-demand capacity mode.
158
You are designing an online gaming application for users across the world. As the game comprise of augmented reality, high performance and very low latency is one of the important criteria for providing best gaming experience. Because of this reason you want to design a multiregional architecture using DynamoDB as the database. Which of the following will you use in the application to meet these design criteria? Choose 2. 1. Use Cloudfront with DynamoDB as origin 2. Enable DynamoDB Accelerator (DAX) and DynamoDB auto scaling 3. Use DynamoDB Global Tables 4. Enable DynamoDB Adaptive Capacity
1. Use Cloudfront with DynamoDB as origin 2. **Enable DynamoDB Accelerator (DAX) and DynamoDB auto scaling** 3. **Use DynamoDB Global Tables** 4. Enable DynamoDB Adaptive Capacity
159
If you are launching a RDS instance inside a VPC group, which of the following will not be applicable? Choose 2. 1. Your VPC must have at least two subnets. These subnets must be in two different Availability Zones in the AWS Region where you want to deploy your DB instance. 2. If you want your DB instance in the VPC to be publicly accessible, you must enable the VPC attributes DNS hostnames and DNS resolution. 3. You create a DB subnet group by specifying the subnets you created. Amazon RDS uses that DB subnet group and your preferred Availability Zone to choose a subnet and an IP address within that subnet to assign to your DB instance. 4. Your VPC must have at least three subnets. These subnets must be in three different Availability Zones in the AWS Region where you want to deploy your DB instance. 5. If you want your DB instance in the VPC to be publicly accessible, you must enable the RDS attributes DNS hostnames and DNS resolution.
1. Your VPC must have at least two subnets. These subnets must be in two different Availability Zones in the AWS Region where you want to deploy your DB instance. 2. If you want your DB instance in the VPC to be publicly accessible, you must enable the VPC attributes DNS hostnames and DNS resolution. 3. You create a DB subnet group by specifying the subnets you created. Amazon RDS uses that DB subnet group and your preferred Availability Zone to choose a subnet and an IP address within that subnet to assign to your DB instance. 4. **Your VPC must have at least three subnets. These subnets must be in three different Availability Zones in the AWS Region where you want to deploy your DB instance.** 5. **If you want your DB instance in the VPC to be publicly accessible, you must enable the RDS attributes DNS hostnames and DNS resolution.**
160
What is a Redis Shards? Choose 3. 1. A shard (API/CLI: node group) is a collection of one to six Redis nodes. 2. A Redis (cluster mode enabled) cluster will never have more than one shard. 3. Redis (cluster mode enabled) clusters can have from 1 to 90 shards. 4. A Redis (cluster mode disabled) cluster will never have more than one shard.
1. **A shard (API/CLI: node group) is a collection of one to six Redis nodes.** 2. A Redis (cluster mode enabled) cluster will never have more than one shard. 3. **Redis (cluster mode enabled) clusters can have from 1 to 90 shards.** 4. **A Redis (cluster mode disabled) cluster will never have more than one shard.**
161
What are the two ways in which Redis implements replication? Choose 2. 1. With a single shard that contains all of the cluster's data in each node—Redis cluster mode disabled 2. With data partitioned across up to 90 shards—Redis cluster mode enabled 3. With a single shard that contains all of the cluster's data in each node—Redis cluster mode enabled 4. With data partitioned across up to 90 shards—Redis cluster mode disabled
1. **With a single shard that contains all of the cluster's data in each node—Redis cluster mode disabled** 2. **With data partitioned across up to 90 shards—Redis cluster mode enabled** 3. With a single shard that contains all of the cluster's data in each node—Redis cluster mode enabled 4. With data partitioned across up to 90 shards—Redis cluster mode disabled
162
What is the range option of Redis cluster possible? Choose 2. 1. 90 replicas and 0 shards 2. 90 shards and 0 replicas 3. 15 shards and 5 replicas 4. 5 shards and 0 replicas
1. 90 replicas and 0 shards 2. **90 shards and 0 replicas** 3. **15 shards and 5 replicas** 4. 5 shards and 0 replicas
163
You were doing a PoC for a web application using a simple three tier architecture as shown below. Now you want to leverage other AWS services and features to change this architecture for production environment for global user base. The key architecture criteria are: * It should be resilient. * It should be elastic to grow for handling the increased load. * Reduce latency for global user base and high performance. * Though application is stateless, it should be able to track user session. * Storage for static assets and backups. What services you will use to meet above criteria? 1. Application Load Balancer, RDS Multi-AZ & Read Replica, Web EC2 Instance Auto Scale Multi AZ, ElastiCache, Cloudfront, S3 2. Application Load Balancer, RDS , Web EC2 Instance Auto Scale Multi AZ, DynamoDB, ElastiCache, Cloudfront, S3 3. Application Load Balancer, RDS Multi-AZ & Read Replica, Web EC2 Instance Auto Scale Multi AZ, S3 4. Application Load Balancer, RDS, Web EC2 Instance Auto Scale Multi AZ, DynamoDB, ElastiCache, Cloudfront, S3
1. **Application Load Balancer, RDS Multi-AZ & Read Replica, Web EC2 Instance Auto Scale Multi AZ, ElastiCache, Cloudfront, S3** 2. Application Load Balancer, RDS , Web EC2 Instance Auto Scale Multi AZ, DynamoDB, ElastiCache, Cloudfront, S3 3. Application Load Balancer, RDS Multi-AZ & Read Replica, Web EC2 Instance Auto Scale Multi AZ, S3 4. Application Load Balancer, RDS, Web EC2 Instance Auto Scale Multi AZ, DynamoDB, ElastiCache, Cloudfront, S3
164
You are designing an ecommerce application where you want to capture ‘like’ or ‘dislike’ for a product by the user and keep updating the count. You also want to maintain a list of everyone who has liked or disliked a product. Which AWS service will be most apt to implement this functionality where performance and low latency is also a consideration? 1. ElastiCache for Memcache 2. ElastiCache for Redis 3. RDS 4. DynamoDB
1. ElastiCache for Memcache 2. **ElastiCache for Redis** 3. RDS 4. DynamoDB
165
How is replication implemented in ElastiCache for Redis? Choose 2. 1. With a single shard that contains all of the cluster's data in each node—Redis cluster mode enabled 2. With data partitioned across up to 90 shards—Redis cluster mode disabled 3. With a single shard that contains all of the cluster's data in each node—Redis cluster mode disabled 4. With data partitioned across up to 90 shards—Redis cluster mode enabled
1. With a single shard that contains all of the cluster's data in each node—Redis cluster mode enabled 2. With data partitioned across up to 90 shards—Redis cluster mode disabled 3. **With a single shard that contains all of the cluster's data in each node—Redis cluster mode disabled** 4. **With data partitioned across up to 90 shards—Redis cluster mode enabled**
166
Which of the following statements are correct about ElastiCache Redis cluster mode disabled? Choose 4. 1. It has a single shard, inside of which is a collection of Redis nodes; one primary read/write node and up to five secondary, read-only replica nodes. 2. Each read replica maintains a copy of the data from the cluster's primary node. Asynchronous replication mechanisms are used to keep the read replicas synchronized with the primary. 3. Applications can read from any node in the cluster. Applications can write only to the primary node. 4. Read replicas improve read throughput and guard against data loss in cases of a node failure. 5. Each read replica maintains a part of the data from the cluster's primary node. Synchronous replication mechanisms are used to keep the read replicas synchronized with the primary.
1. **It has a single shard, inside of which is a collection of Redis nodes; one primary read/write node and up to five secondary, read-only replica nodes.** 2. **Each read replica maintains a copy of the data from the cluster's primary node. Asynchronous replication mechanisms are used to keep the read replicas synchronized with the primary.** 3. **Applications can read from any node in the cluster. Applications can write only to the primary node.** 4. **Read replicas improve read throughput and guard against data loss in cases of a node failure.** 5. Each read replica maintains a part of the data from the cluster's primary node. Synchronous replication mechanisms are used to keep the read replicas synchronized with the primary.
167
Which of the following statements are correct about ElastiCache Redis cluster mode enabled? 1. Cluster is comprised of from 1 to 90 shards (API/CLI: node groups). Each shard has a primary node and up to five read-only replica nodes. 2. The configuration can range from 90 shards and 0 replicas to 15 shards and 5 replicas, which is the maximum number or replicas allowed. 3. Data is partitioned across the shards. 4. Each shard contains full copy of the data, data is not partitioned across the shards. 5. Each read replica in a shard maintains a copy of the data from the shard's primary. Asynchronous replication mechanisms are used to keep the read replicas synchronized with the primary.
1. **Cluster is comprised of from 1 to 90 shards (API/CLI: node groups). Each shard has a primary node and up to five read-only replica nodes.** 2. **The configuration can range from 90 shards and 0 replicas to 15 shards and 5 replicas, which is the maximum number or replicas allowed.** 3. **Data is partitioned across the shards.** 4. Each shard contains full copy of the data, data is not partitioned across the shards. 5. **Each read replica in a shard maintains a copy of the data from the shard's primary. Asynchronous replication mechanisms are used to keep the read replicas synchronized with the primary.**
168
When choosing between Redis (cluster mode disabled) or Redis (cluster mode enabled), which of the following factors you will consider? Choose 3. 1. Availability and Resiliency 2. Scaling v. partitioning 3. Node size v. number of nodes 4. Reads v. writes
1. Availability and Resiliency 2. **Scaling v. partitioning** 3. **Node size v. number of nodes** 4. **Reads v. writes**
169
You are designing a gaming application for training your company employees and decided to use ElastiCache for Redis. Based on your analysis you estimate that data size will not be huge, the functionality requires more read than write and there will be need to scale your read capacity as the application is rolled out across different offices resulting in increase in number of users. Between Redis (cluster mode disabled) and Redis (cluster mode enabled) which will you choose? 1. Redis (cluster mode disabled) 2. Redis (cluster mode enabled)
1. **Redis (cluster mode disabled)** 2. Redis (cluster mode enabled)
170
You are designing an online gaming application and decided to use ElastiCache for Redis. Based on your analysis you estimate that data size will be huge, the functionality requires more write than read and there will be need to scale your capacity as the application number of users increases. Between Redis (cluster mode disabled) or Redis (cluster mode enabled) which will you choose? 1. Redis (cluster mode disabled) 2. Redis (cluster mode enabled)
1. Redis (cluster mode disabled) 2. **Redis (cluster mode enabled)**
171
Which of the following are NoSQL database services offered by AWS? Choose 2. 1. Amazon RDS 2. Amazon DynamoDB 3. Amazon DocumentDB 4. Amazon Aurora
1. Amazon RDS 2. **Amazon DynamoDB** 3. **Amazon DocumentDB** 4. Amazon Aurora
172
ElastiCache for Memcached clusters are comprised of how many nodes? 1. 1-20 nodes 2. 1-10 nodes 3. 1-100 nodes 4. 1-90 nodes
1. **1-20 nodes** 2. 1-10 nodes 3. 1-100 nodes 4. 1-90 nodes
173
What is Auto Discovery supported by AWS ElastiCache in clusters running the Memcached engine? Choose 2. 1. The ability for client programs to automatically identify primary node in the cluster. 2. Your application does not need to manually connect to individual cache nodes; instead, your application connects to one primary Memcached node. 3. The ability for client programs to automatically identify all of the nodes in a cache cluster, and to initiate and maintain connections to all of these nodes. 4. Your application does not need to manually connect to individual cache nodes; instead, your application connects to one Memcached node and retrieves the list of nodes.
1. The ability for client programs to automatically identify primary node in the cluster. 2. Your application does not need to manually connect to individual cache nodes; instead, your application connects to one primary Memcached node. 3. **The ability for client programs to automatically identify all of the nodes in a cache cluster, and to initiate and maintain connections to all of these nodes.** 4. **Your application does not need to manually connect to individual cache nodes; instead, your application connects to one Memcached node and retrieves the list of nodes.**
174
You have an application server in Amazon EC2 which is using Memcached currently. What you should do to migrate to Amazon ElastiCache? Choose 2. 1. Update application's Memcached config file to include the endpoints of the servers (nodes). 2. Recompile and re-linking application as the libraries currently used will not continue to work. 3. Switch to using Amazon ElastiCache without recompiling or re-linking your applications - the libraries currently being used will continue to work. 4. You can migrate your application after making code changes as Amazon ElastiCache is not protocol-compliant with Memcached.
1. **Update application's Memcached config file to include the endpoints of the servers (nodes).** 2. Recompile and re-linking application as the libraries currently used will not continue to work. 3. **Switch to using Amazon ElastiCache without recompiling or re-linking your applications - the libraries currently being used will continue to work.** 4. You can migrate your application after making code changes as Amazon ElastiCache is not protocol-compliant with Memcached.
175
You are using Amazon ElastiCache for Memcache to cache queries of your web application RDS MySQL. You have just released the web application to beta users with minimum number of nodes in the ElastiCache cluster. As the number of users will increase you will need to increase the number of cluster nodes. What you should do minimize the changes in your caching when scale out is done? 1. On adding new nodes, update the list of cache node endpoints manually in the configuration file and re-initialize the application by restarting it. 2. Auto Discovery capable client must be used to connect to Amazon ElastiCache Cluster. 3. Auto Discovery capable server must be used to connect to Amazon ElastiCache Cluster. 4. None of the above
1. On adding new nodes, update the list of cache node endpoints manually in the configuration file and re-initialize the application by restarting it. 2. **Auto Discovery capable client must be used to connect to Amazon ElastiCache Cluster.** 3. Auto Discovery capable server must be used to connect to Amazon ElastiCache Cluster. 4. None of the above
176
Which of the following is not a type of NoSQL database in AWS? 1. Key value: DynamoDB 2. Document: DocumentDB 3. Relational: RDS 4. Graph: Neptune 5. In-memory: ElastiCache 6. Search: Elasticsearch
1. Key value: DynamoDB 2. Document: DocumentDB 3. **Relational: RDS** 4. Graph: Neptune 5. In-memory: ElastiCache 6. Search: Elasticsearch
177
You are the chief cloud architect for a multinational company having offices all across the world. You are designing a web application which will be hosted on AWS and used by global user base of employees. Which AWS database service you will you use that provides a fully managed, multiregion, and multimaster database so that you can deliver low-latency data access to your users no matter where they are located on the globe ? 1. RDS instance in different AWS regions with Multi-AZ deployment 2. DynamoDB with Global Tables 3. S3 with cross region replication 4. Database deployed in EC2 instances with EBS volumes
1. RDS instance in different AWS regions with Multi-AZ deployment 2. **DynamoDB with Global Tables** 3. S3 with cross region replication 4. Database deployed in EC2 instances with EBS volumes
178
What are the steps involved in adding encryption to a previously unencrypted database instance? 1. Create a snapshot of the unencrypted database instance. 2. Copy the snapshot to a new, encrypted snapshot. Enable encryption and specify the desired KMS key as you do so. 3. Create a new database instance with encryption enabled. 4. Copy the data from existing to new database. 5. Restore the encrypted snapshot to a new database instance
1. **Create a snapshot of the unencrypted database instance.** 2. **Copy the snapshot to a new, encrypted snapshot. Enable encryption and specify the desired KMS key as you do so.** 3. **Create a new database instance with encryption enabled.** 4. Copy the data from existing to new database. 5. Restore the encrypted snapshot to a new database instance
179
How can you implement disaster recovery or fault tolerance for my Amazon ElastiCache Redis cluster? 1. Multi-AZ with Automatic Failover 2. Daily automatic backups 3. Manual backups using Redis append-only file (AOF) 4. All of the above
1. Multi-AZ with Automatic Failover 2. Daily automatic backups 3. Manual backups using Redis append-only file (AOF) 4. **All of the above**
180
An ElastiCache Redis replication group is comprised of a single primary node which your application can both read from and write to, and from 1 to 5 read-only replica nodes. Whenever data is written to the primary node it is also asynchronously updated on the read replica nodes. What happens when a read replica fails? 1. ElastiCache detects the failed read replica. 2. ElastiCache takes the failed node off line. 3. ElastiCache launches and provisions a replacement node in the same AZ. 4. ElastiCache launches and provisions a replacement node in the same or different AZ. 5. The new node synchronizes with the one of most updated Read Replica. 6. The new node synchronizes with the Primary node.
1. **ElastiCache detects the failed read replica.** 2. **ElastiCache takes the failed node off line.** 3. **ElastiCache launches and provisions a replacement node in the same AZ.** 4. ElastiCache launches and provisions a replacement node in the same or different AZ. 5. **The new node synchronizes with the one of most updated Read Replica.** 6. The new node synchronizes with the Primary node.
181
In case of ElastiCache Redis choose the two correct statements applicable for a Primary node failure when Multi-AZ with Auto Failover is enabled and when it is disabled? 1. Enabled: ElastiCache promotes the read replica node with the least replication lag to primary node, the other replicas sync with the new primary node and new replica is created in failed primary’s AZ. 2. Disabled: ElastiCache promotes the read replica node with the least replication lag to primary node, the other replicas sync with the new primary node and new replica is created in failed primary’s AZ. 3. Enabled: ElastiCache creates and provisions a new Primary node to replace the failed Primary and syncs the new Primary with one of the existing replicas. 4. Disabled: ElastiCache creates and provisions a new Primary node to replace the failed Primary and syncs the new Primary with one of the existing replicas.
1. **Enabled: ElastiCache promotes the read replica node with the least replication lag to primary node, the other replicas sync with the new primary node and new replica is created in failed primary’s AZ.** 2. Disabled: ElastiCache promotes the read replica node with the least replication lag to primary node, the other replicas sync with the new primary node and new replica is created in failed primary’s AZ. 3. Enabled: ElastiCache creates and provisions a new Primary node to replace the failed Primary and syncs the new Primary with one of the existing replicas. 4. **Disabled: ElastiCache creates and provisions a new Primary node to replace the failed Primary and syncs the new Primary with one of the existing replicas.**
182
What are the use cases for using Amazon DocumentDB? Choose 2. 1. Content management applications such as blogs and video platforms. 2. For storing catalog information such as in an e-commerce application. 3. Real-time bidding applications such as buying and selling of online ad impressions. 4. Gaming leaderboard shows a gamer's position relative to other players of a similar rank.
1. **Content management applications such as blogs and video platforms.** 2. **For storing catalog information such as in an e-commerce application.** 3. Real-time bidding applications such as buying and selling of online ad impressions. 4. Gaming leaderboard shows a gamer's position relative to other players of a similar rank.
183
Which of the following are features of Amazon DocumentDB? Choose 5. 1. Compatible with MongoDB 3.6 drivers and tools. 2. Compatible with DynamoDB 3.6 drivers and tools. 3. Automatically grows the size of your storage volume as your database storage needs grow. Your storage volume grows in increments of 10 GB, up to a maximum of 64 TB. 4. You can increase read throughput to support high-volume application requests by creating up to 15 replica instances. 5. You can increase write throughput to support high-volume application requests by creating up to 15 replica instances. 6. Automates failover to one of up to 15 Amazon DocumentDB replicas you have created in any of three Availability Zones. If no Amazon DocumentDB replicas have been provisioned, in the case of a failure, Amazon DocumentDB will attempt to create a new instance for you automatically. 7. Each 10GB portion of your storage volume is replicated six ways, across three Availability Zones.
1. **Compatible with MongoDB 3.6 drivers and tools.** 2. Compatible with DynamoDB 3.6 drivers and tools. 3. **Automatically grows the size of your storage volume as your database storage needs grow. Your storage volume grows in increments of 10 GB, up to a maximum of 64 TB.** 4. **You can increase read throughput to support high-volume application requests by creating up to 15 replica instances.** 5. You can increase write throughput to support high-volume application requests by creating up to 15 replica instances. 6. **Automates failover to one of up to 15 Amazon DocumentDB replicas you have created in any of three Availability Zones. If no Amazon DocumentDB replicas have been provisioned, in the case of a failure, Amazon DocumentDB will attempt to create a new instance for you automatically.** 7. **Each 10GB portion of your storage volume is replicated six ways, across three Availability Zones.**
184
Which of the following are components of DocumentDB cluster? Choose 2. 1. Cluster volume 2. Writer Volume 3. Reader Volume 4. Instances
1. **Cluster volume** 2. Writer Volume 3. Reader Volume 4. **Instances**
185
How is failover handled in DocumentDB? Choose 2. 1. If you do not have an Amazon DocumentDB replica, you will need to create a new one manually in the same or a different Availability Zone, then flip the canonical name record (CNAME) for your cluster endpoint to new instance. 2. If you have an Amazon DocumentDB replica, in the same or a different Availability Zone, when failing over, Amazon DocumentDB flips the canonical name record (CNAME) for your cluster endpoint to a healthy replica, which is in turn is promoted to become the new primary. 3. If you do not have an Amazon DocumentDB Replica (i.e. single instance), Amazon DocumentDB will first attempt to create a new instance in the same Availability Zone as the original instance. If unable to do so, Amazon DocumentDB will attempt to create a new instance in a different Availability Zone. 4. If you have an Amazon DocumentDB Replica, Amazon DocumentDB will first attempt to create a new instance in the same Availability Zone as the original instance. If unable to do so, Amazon DocumentDB will attempt to create a new instance in a different Availability Zone.
1. If you do not have an Amazon DocumentDB replica, you will need to create a new one manually in the same or a different Availability Zone, then flip the canonical name record (CNAME) for your cluster endpoint to new instance. 2. **If you have an Amazon DocumentDB replica, in the same or a different Availability Zone, when failing over, Amazon DocumentDB flips the canonical name record (CNAME) for your cluster endpoint to a healthy replica, which is in turn is promoted to become the new primary.** 3. **If you do not have an Amazon DocumentDB Replica (i.e. single instance), Amazon DocumentDB will first attempt to create a new instance in the same Availability Zone as the original instance. If unable to do so, Amazon DocumentDB will attempt to create a new instance in a different Availability Zone.** 4. If you have an Amazon DocumentDB Replica, Amazon DocumentDB will first attempt to create a new instance in the same Availability Zone as the original instance. If unable to do so, Amazon DocumentDB will attempt to create a new instance in a different Availability Zone.
AWS Study Deck - SAA
flashcards
Decks in class (18)
# Cards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2026 Bold Learning Solutions. Terms and Conditions