Timedora
Free Practice Quiz Question List

1 Choosing an AWS Database Online Quiz Questions

Use this free practice quiz with 20 questions to review 1 Choosing an AWS Database, test your knowledge, and prepare for your next test or exam.

20 questions
01
True or false
1 point

True or false: Amazon Redshift is designed to be the primary database for an application's frequent, small transactional reads and writes.

  1. A

    True

  2. B

    False

02
True or false
1 point

True or false: When choosing DynamoDB, an application can assume arbitrary relational joins will be available and efficient.

  1. A

    True

  2. B

    False

03
Fill in the blank
1 point

In DynamoDB, tables and keys should be designed around the application's required .

04
Fill in the blank
1 point

Before choosing based on service names alone, a short using realistic data and access patterns can help evaluate a database design.

05
Written response
1 point

A workload stores JSON-like documents and needs richer queries across document fields. Which AWS database service does the material suggest considering?

06
Written response
1 point

What RDS availability option can help provide high availability if an instance or Availability Zone fails?

07
Choose one
1 point

A booking application must check availability and create reservations while preventing conflicting updates. Which database choice is the most appropriate starting point?

  1. A

    Amazon Redshift

  2. B

    Amazon RDS or Amazon Aurora

  3. C

    Amazon DynamoDB

  4. D

    Amazon DocumentDB

08
Choose one
1 point

A shopping-cart service retrieves or updates each cart directly by customer or cart identifier and must handle high request volume. Which service is the best fit to evaluate first?

  1. A

    Amazon Redshift

  2. B

    Amazon DynamoDB

  3. C

    Amazon RDS for Oracle

  4. D

    Amazon Aurora

09
Choose one
1 point

Executives need to compare sales across regions, products, and months using years of historical data. Which service is designed for this analytical workload?

  1. A

    Amazon RDS

  2. B

    Amazon DynamoDB

  3. C

    Amazon Redshift

  4. D

    Amazon Aurora

10
Choose one
1 point

A small application needs a familiar PostgreSQL engine and has moderate, predictable demand. Which service is a reasonable starting choice before comparing alternatives?

  1. A

    Amazon RDS for PostgreSQL

  2. B

    Amazon Redshift

  3. C

    Amazon DynamoDB

  4. D

    Amazon DocumentDB

11
Choose all
1 point

Select all workload requirements that point toward Amazon RDS or Aurora.

  1. A

    The application needs joins across related entities.

  2. B

    Requests are mostly known lookups by key at very high throughput.

  3. C

    The application needs constraints to keep related records correct.

  4. D

    Transactions must span multiple related records.

  5. E

    Queries scan and aggregate large historical datasets.

12
Choose all
1 point

Select all statements about DynamoDB read consistency that are supported by the material.

  1. A

    Strongly consistent reads are supported for some table reads.

  2. B

    Global secondary indexes support strongly consistent reads.

  3. C

    Strongly consistent reads are supported for local-secondary-index reads.

  4. D

    Streams support strongly consistent reads.

  5. E

    Every DynamoDB read is strongly consistent by default.

13
Open ended
1 point

A retailer needs to process live orders and also analyze sales trends across years of transactions. Propose a database approach for both workloads and explain how you would validate that the choices meet the retailer's needs.

14
Written response
1 point

A retailer needs to analyze large historical datasets with aggregations and reports. Which AWS database service is designed for this analytical workload?

15
Choose one
1 point

An application is moving to a managed service but must continue using a familiar PostgreSQL engine. Which option is the most direct starting point?

  1. A

    Amazon RDS for PostgreSQL

  2. B

    Amazon Redshift

  3. C

    Amazon DynamoDB

  4. D

    Amazon DocumentDB

16
Choose one
1 point

An application stores JSON-like documents and must query across their fields. Which option is the best fit to consider?

  1. A

    Amazon DynamoDB, because arbitrary relational joins are available by default

  2. B

    Amazon DocumentDB, because it is document-oriented

  3. C

    Amazon Redshift, because it is designed for small transactional lookups

  4. D

    Amazon RDS, because it is a key-value database

17
True or false
1 point

True or false: Read replicas can help serve read traffic, but they are not a substitute for choosing an appropriate high-availability configuration.

  1. A

    True

  2. B

    False

18
Choose one
1 point

A booking system must check availability and create a reservation while preventing conflicting updates. Which database choice is the most natural starting point?

  1. A

    Amazon Redshift, because analytical scans are its main strength

  2. B

    Amazon DynamoDB, because key lookups provide arbitrary joins

  3. C

    Amazon RDS or Aurora, because relational transactions and relationships fit the workload

  4. D

    Amazon DocumentDB, because document-field queries prevent conflicting reservations

19
Written response
1 point

When designing DynamoDB tables and keys, what should they be designed around?

20
Choose one
1 point

A team is comparing databases for a workload with sharp demand peaks. Which approach is most reliable for evaluating cost?

  1. A

    Choose the service with the highest theoretical peak scale, since that guarantees the lowest bill

  2. B

    Compare only storage prices because requests and replicas do not affect total cost

  3. C

    Assume on-demand scaling is always cheaper when demand varies

  4. D

    Estimate and test viable options using representative workloads and relevant cost drivers