Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AWS Solutions Architect - Book example questions > Ch7 Databases > Flashcards

Ch7 Databases Flashcards

1
Q

Which AWS database service is best suited for traditional Online Transaction Processing
(OLTP)?
A. Amazon Redshift
B. Amazon Relational Database Service (Amazon RDS)
C. Amazon Glacier
D. Elastic Database

A

B. Amazon RDS is best suited for traditional OLTP transactions. Amazon Redshift, on the
other hand, is designed for OLAP workloads. Amazon Glacier is designed for cold
archival storage.

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

Which AWS database service is best suited for non-relational databases?
A. Amazon Redshift
B. Amazon Relational Database Service (Amazon RDS)
C. Amazon Glacier
D. Amazon DynamoDB

A

D. Amazon DynamoDB is best suited for non-relational databases. Amazon RDS and
Amazon Redshift are both structured relational databases.

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

You are a solutions architect working for a media company that hosts its website on
AWS. Currently, there is a single Amazon Elastic Compute Cloud (Amazon EC2) Instance
on AWS with MySQL installed locally to that Amazon EC2 Instance. You have been asked
to make the company’s production environment more resilient and to increase
performance. You suggest that the company split out the MySQL database onto an
Amazon RDS Instance with Multi-AZ enabled. This addresses the company’s increased
resiliency requirements. Now you need to suggest how you can increase performance.
Ninety-nine percent of the company’s end users are magazine subscribers who will be
reading additional articles on the website, so only one percent of end users will need to
write data to the site. What should you suggest to increase performance?
A. Alter the connection string so that if a user is going to write data, it is written to the
secondary copy of the Multi-AZ database.
B. Alter the connection string so that if a user is going to write data, it is written to the
primary copy of the Multi-AZ database.
C. Recommend that the company use read replicas, and distribute the traffic across
multiple read replicas.
D. Migrate the MySQL database to Amazon Redshift to take advantage of columnar
storage and maximize performance.

A

C. In this scenario, the best idea is to use read replicas to scale out the database and thus
maximize read performance. When using Multi-AZ, the secondary database is not
accessible and all reads and writes must go to the primary or any read replicas.

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

Which AWS Cloud service is best suited for Online Analytics Processing (OLAP)?
A. Amazon Redshift
B. Amazon Relational Database Service (Amazon RDS)
C. Amazon Glacier
D. Amazon DynamoDB

A

A. Amazon Redshift is best suited for traditional OLAP transactions. While Amazon RDS
can also be used for OLAP, Amazon Redshift is purpose-built as an OLAP data
warehouse.

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

You have been using Amazon Relational Database Service (Amazon RDS) for the last year to run an important application with automated backups enabled. One of your team
members is performing routine maintenance and accidentally drops an important table,
causing an outage. How can you recover the missing data while minimizing the duration
of the outage?
A. Perform an undo operation and recover the table.
B. Restore the database from a recent automated DB snapshot.
C. Restore only the dropped table from the DB snapshot.
D. The data cannot be recovered.

A

B. DB Snapshots can be used to restore a complete copy of the database at a specific
point in time. Individual tables cannot be extracted from a snapshot.

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

Which Amazon Relational Database Service (Amazon RDS) database engines support
Multi-AZ?
A. All of them
B. Microsoft SQL Server, MySQL, and Oracle
C. Oracle, Amazon Aurora, and PostgreSQL
D. MySQL

A

A. All Amazon RDS database engines support Multi-AZ deployment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which Amazon Relational Database Service (Amazon RDS) database engines support
read replicas?
A. Microsoft SQL Server and Oracle
B. MySQL, MariaDB, PostgreSQL, and Aurora
C. Aurora, Microsoft SQL Server, and Oracle
D. MySQL and PostgreSQL

A

B. Read replicas are supported by MySQL, MariaDB, PostgreSQL, and Aurora.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Your team is building an order processing system that will span multiple Availability
Zones. During testing, the team wanted to test how the application will react to a
database failover. How can you enable this type of test?
A. Force a Multi-AZ failover from one Availability Zone to another by rebooting the
primary instance using the Amazon RDS console.
B. Terminate the DB instance, and create a new one. Update the connection string.
C. Create a support case asking for a failover.
D. It is not possible to test a failover.

A

A. You can force a failover from one Availability Zone to another by rebooting the
primary instance in the AWS Management Console. This is often how people test a
failover in the real world. There is no need to create a support case.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You are a system administrator whose company has moved its production database to
AWS. Your company monitors its estate using Amazon CloudWatch, which sends alarms
using Amazon Simple Notification Service (Amazon SNS) to your mobile phone. One
night, you get an alert that your primary Amazon Relational Database Service (Amazon
RDS) Instance has gone down. You have Multi-AZ enabled on this instance. What should
you do to ensure the failover happens quickly?
A. Update your Domain Name System (DNS) to point to the secondary instance’s new
IP address, forcing your application to fail over to the secondary instance.
B. Connect to your server using Secure Shell (SSH) and update your connection stringsso that your application can communicate to the secondary instance instead of the
failed primary instance.
C. Take a snapshot of the secondary instance and create a new instance using this
snapshot, then update your connection string to point to the new instance.
D. No action is necessary. Your connection string points to the database endpoint, and
AWS automatically updates this endpoint to point to your secondary instance.

A

D. Monitor the environment while Amazon RDS attempts to recover automatically. AWS
will update the DB endpoint to point to the secondary instance automatically.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You are working for a small organization without a dedicated database administrator on
staff. You need to install Microsoft SQL Server Enterprise edition quickly to support an
accounting back office application on Amazon Relational Database Service (Amazon
RDS). What should you do?
A. Launch an Amazon RDS DB Instance, and select Microsoft SQL Server Enterprise
Edition under the Bring Your Own License (BYOL) model.
B. Provision SQL Server Enterprise Edition using the License Included option from the
Amazon RDS Console.
C. SQL Server Enterprise edition is only available via the Command Line Interface
(CLI). Install the command-line tools on your laptop, and then provision your new
Amazon RDS Instance using the CLI.
D. You cannot use SQL Server Enterprise edition on Amazon RDS. You should install
this on to a dedicated Amazon Elastic Compute Cloud (Amazon EC2) Instance.

A

A. Amazon RDS supports Microsoft SQL Server Enterprise edition and the license is
available only under the BYOL model.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

You are building the database tier for an enterprise application that gets occasional
activity throughout the day. Which storage type should you select as your default option?
A. Magnetic storage
B. General Purpose Solid State Drive (SSD)
C. Provisioned IOPS (SSD)
D. Storage Area Network (SAN)-attached

A

B. General Purpose (SSD) volumes are generally the right choice for databases that have
bursts of activity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You are designing an e-commerce web application that will scale to potentially hundreds
of thousands of concurrent users. Which database technology is best suited to hold the
session state for large numbers of concurrent users?
A. Relational database using Amazon Relational Database Service (Amazon RDS)
B. NoSQL database table using Amazon DynamoDB
C. Data warehouse using Amazon Redshift
D. Amazon Simple Storage Service (Amazon S3)

A

B. NoSQL databases like Amazon DynamoDB excel at scaling to hundreds of thousands
of requests with key/value access to user profile and session.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which of the following techniques can you use to help you meet Recovery Point
Objective (RPO) and Recovery Time Objective (RTO) requirements? (Choose 3 answers)
A. DB snapshots
B. DB option groups
C. Read replica
D. Multi-AZ deployment

A

A, C, D. DB snapshots allow you to back up and recover your data, while read replicas and
a Multi-AZ deployment allow you to replicate your data and reduce the time to failover.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

When using Amazon Relational Database Service (Amazon RDS) Multi-AZ, how can you
offload read requests from the primary? (Choose 2 answers)
A. Configure the connection string of the clients to connect to the secondary node and
perform reads while the primary is used for writes.
B. Amazon RDS automatically sends writes to the primary and sends reads to the
secondary.
C. Add a read replica DB instance, and configure the client’s application logic to use a
read-replica.
D. Create a caching environment using ElastiCache to cache frequently used data.
Update the application logic to read/write from the cache.

A

C, D. Amazon RDS allows for the creation of one or more read-replicas for many engines
that can be used to handle reads. Another common pattern is to create a cache using
Memcached and Amazon ElastiCache to store frequently used queries. The secondary
slave DB Instance is not accessible and cannot be used to offload queries.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You are building a large order processing system and are responsible for securing the
database. Which actions will you take to protect the data? (Choose 3 answers)
A. Adjust AWS Identity and Access Management (IAM) permissions for administrators.
B. Configure security groups and network Access Control Lists (ACLs) to limit network
access.
C. Configure database users, and grant permissions to database objects.
D. Install anti-virus software on the Amazon RDS DB Instance.

A

A, B, C. Protecting your database requires a multilayered approach that secures the
infrastructure, the network, and the database itself. Amazon RDS is a managed service
and direct access to the OS is not available.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Your team manages a popular website running Amazon Relational Database Service
(Amazon RDS) MySQL back end. The Marketing department has just informed you
about an upcoming television commercial that will drive thousands of new visitors to the
website. How can you prepare your database to handle the load? (Choose 3 answers)
A. Vertically scale the DB Instance by selecting a more powerful instance class.
B. Create read replicas to offload read requests and update your application.
C. Upgrade the storage from Magnetic volumes to General Purpose Solid State Drive
(SSD) volumes.
D. Upgrade to Amazon Redshift for faster columnar storage.

A

A, B, C. Vertically scaling up is one of the simpler options that can give you additional
processing power without making any architectural changes. Read replicas require some application changes but let you scale processing power horizontally. Finally, busy
databases are often I/O- bound, so upgrading storage to General Purpose (SSD) or
Provisioned IOPS (SSD) can often allow for additional request processing.

17
Q

You are building a photo management application that maintains metadata on millions
of images in an Amazon DynamoDB table. When a photo is retrieved, you want to display
the metadata next to the image. Which Amazon DynamoDB operation will you use to
retrieve the metadata attributes from the table?
A. Scan operation
B. Search operation
C. Query operation
D. Find operation

A

C. Query is the most efficient operation to find a single item in a large table.

18
Q

You are creating an Amazon DynamoDB table that will contain messages for a social chat
application. This table will have the following attributes: Username (String), Timestamp
(Number), Message (String). Which attribute should you use as the partition key? The sort key?
A. Username, Timestamp
B. Username, Message
C. Timestamp, Message
D. Message, Timestamp

A

A. Using the Username as a partition key will evenly spread your users across the
partitions. Messages are often filtered down by time range, so Timestamp makes sense
as a sort key.

19
Q

Which of the following statements about Amazon DynamoDB tables are true? (Choose 2
answers)
A. Global secondary indexes can only be created when the table is being created.
B. Local secondary indexes can only be created when the table is being created.
C. You can only have one global secondary index.
D. You can only have one local secondary index.

A

B, D. You can only have a single local secondary index, and it must be created at the same
time the table is created. You can create many global secondary indexes after the table
has been created.

20
Q

Which of the following workloads are a good fit for running on Amazon Redshift?
(Choose 2 answers)
A. Transactional database supporting a busy e-commerce order processing website
B. Reporting database supporting back-office analytics
C. Data warehouse used to aggregate multiple disparate data sources
D. Manage session state and user profile data for thousands of concurrent users

A

B, C. Amazon Redshift is an Online Analytical Processing (OLAP) data warehouse
designed for analytics, Extract, Transform, Load (ETL), and high-speed querying. It is not
well suited for running transactional applications that require high volumes of small
inserts or updates.

AWS Solutions Architect - Book example questions (14 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions