AWS CLF-C02 3-Day Intensive

Instructions: Click one option per question. You will see immediate feedback. The score bar updates live. Target: 85% (10/12 correct) to proceed.

Databases Quiz

Select one answer per question. You will receive immediate feedback.

1. A company wants to run an Oracle database in the cloud without managing OS patches, database backups, or hardware. Which service should they use?

Amazon EC2 with Oracle installedAmazon RDSAmazon DynamoDBAmazon Redshift

2. A company needs high availability for a MySQL database. If the primary database fails, failover must happen automatically with no application code changes. Which RDS feature provides this?

Read replicasMulti-AZ deploymentAutomated backupsProvisioned IOPS

3. A read-heavy reporting application is overloading the primary RDS instance. Which feature offloads read queries to a separate copy?

Multi-AZ deploymentRead replicasEncryption at restDatabase snapshots

4. Which Amazon Aurora capability distinguishes it from standard RDS?

Support for SQL queriesUp to 15 low-latency read replicas and auto-repair storage across three AZsCompatibility with MySQLAutomated database backups

5. A gaming company needs a database for user session data with single-digit millisecond latency at massive scale. The data model is simple key-value lookups. Which service is best?

Amazon RDSAmazon AuroraAmazon DynamoDBAmazon Redshift

6. Items in a DynamoDB table must have a key. Which key type is composed of two attributes?

Partition key onlySort key onlyPartition key and sort keyForeign key

7. A financial services company needs to run complex SQL queries across petabytes of historical transaction data using existing BI tools. Which service should they use?

Amazon DynamoDBAmazon RDSAmazon AuroraAmazon Redshift

8. Which Amazon Redshift feature allows querying data directly in Amazon S3 without loading it into the cluster?

Redshift SpectrumDynamoDB AcceleratorAurora Global DatabaseRDS Read Replicas

9. How does DynamoDB scale to handle increased read/write throughput?

By requiring manual instance type upgradesThrough manual provisioning or automatic scaling of read/write capacityBy adding read replicas in other RegionsBy migrating tables to Amazon RDS

10. An application requires complex transactions with joins across multiple tables and a query rate of 20,000 reads per second. What should be used?

Amazon DynamoDBAmazon RDSAmazon RedshiftAmazon S3

11. A company migrates an Oracle database to Amazon Aurora PostgreSQL. They need to convert the database schema and stored procedures. Which tool handles this?

AWS Database Migration ServiceAWS Schema Conversion ToolAWS DataSyncAWS Transfer Family

12. Which AWS service migrates databases to AWS while keeping the source database fully operational during the migration?

AWS DMSAWS SCTAWS DataSyncAWS Storage Gateway

Progress: 0/12 correct (0%). Answer all questions to see the final recommendation.

Ask your teacher: Scoring: 10/12 (83%) or higher = proceed to Networking. 8-9/12 (67-75%) = review missed questions. 7/12 or below = revisit the relevant database lessons before continuing.

Primary Source: AWS Academy Module 8: Databases (module-8.pdf).

Lesson 0013: Quiz: Databases

Databases Quiz