Unit 3: Database Services - Practice Quiz

1 In a relational database, data is primarily organized into which of the following structures?

2 Which language is most commonly used to query and manage relational databases?

3 What does the AWS service name 'Amazon RDS' stand for?

4 Which of the following tasks does Amazon RDS automate for the user?

5 Which of the following is a database engine supported by Amazon RDS?

6 Which database engine is AWS's own cloud-native relational engine available on Amazon RDS?

7 What does the 'License Included' model in Amazon RDS mean?

8 Which licensing model lets you use a license you already own on Amazon RDS?

9 What is the main purpose of a Database Option Group in Amazon RDS?

10 What does a DB instance class in Amazon RDS primarily determine?

11 Which DB instance class category is designed for workloads that require a balance of compute, memory, and network resources?

12 Which storage type in Amazon RDS is recommended for I/O-intensive workloads needing consistent, high performance?

13 What does the Amazon RDS storage autoscaling feature do?

14 What is the primary purpose of a Read Replica in Amazon RDS?

15 Data from the primary database is copied to a Read Replica using which type of replication?

16 Which Amazon RDS feature provides high availability by maintaining a standby copy in a different Availability Zone?

17 In a Multi-AZ RDS deployment, what happens automatically if the primary database instance fails?

18 In a single-master database architecture, how many nodes can accept write operations?

19 What is the key characteristic of a multi-master database configuration?

20 Amazon Redshift is best described as which type of service?

21 A development team wants to migrate a self-managed MySQL database to a fully managed service that handles patching, backups, and failover automatically. Which AWS service best fits this requirement?

22 Which of the following is not a database engine supported by Amazon RDS?

23 A company wants to run Oracle on RDS without purchasing separate Oracle licenses, instead paying for the license as part of the hourly instance cost. Which licensing model should they choose?

24 An application experiences heavy read traffic that is slowing down the primary database. Which RDS feature most directly addresses this by offloading read queries?

25 In an RDS Multi-AZ deployment, what is the primary purpose of the standby instance in a different Availability Zone?

26 A workload needs high memory-to-vCPU ratio for an in-memory caching database running on RDS. Which category of RDS instance class is most appropriate?

27 An RDS database has unpredictable but occasionally high I/O demands and the team wants consistent, provisioned IOPS performance. Which storage type should they select?

28 A developer needs single-digit millisecond latency for key-value lookups at any scale, with no server management. Which AWS database service is the best fit?

29 A business intelligence team needs to run complex analytical queries across petabytes of structured data. Which AWS service is purpose-built for this data warehousing workload?

30 Which characteristic best distinguishes a non-relational (NoSQL) database from a relational database?

31 An RDS Oracle database needs the Oracle Enterprise Manager and additional advanced features enabled. Which RDS construct is used to enable such engine-specific optional features?

32 In an Amazon Aurora Multi-Master cluster, what is the key capability that differentiates it from a single-master configuration?

33 In a standard single-master RDS deployment with read replicas, where must all write operations be directed?

34 Which property of relational database transactions guarantees that a transaction either completes entirely or has no effect at all?

35 A team notices that data queried from an RDS read replica is slightly behind the primary. What is the most likely cause?

36 What is the main difference between RDS Multi-AZ and Read Replicas regarding their primary purpose?

37 In DynamoDB, which component uniquely identifies an item and determines how data is partitioned across storage?

38 Why does Amazon Redshift use columnar storage rather than row-based storage for analytical workloads?

39 An RDS instance using General Purpose SSD (gp2) storage occasionally runs out of burst I/O credits. What primarily determines the baseline IOPS for gp2 volumes?

40 A company already owns valid Microsoft SQL Server licenses and wants to reuse them on RDS to reduce costs. Which licensing approach supports this?

41 A team runs Amazon RDS for PostgreSQL in a single AZ. They enable automated backups with a 7-day retention and set the backup window to overlap peak traffic. Which statement most accurately describes the I/O behavior during the backup on a Single-AZ instance?

42 An application uses one RDS for MySQL primary with 5 read replicas. The team notices a replica consistently serves stale data by several minutes under heavy write load. What is the most likely root cause?

43 In an RDS Multi-AZ (single standby) deployment, which of the following does the standby instance NOT provide?

44 An architect evaluates Amazon Aurora Multi-Master to allow writes to multiple nodes. Which consequence must they design around?

45 A DynamoDB table uses a partition key userId. During a flash sale, one userId receives 10x the traffic of others and gets throttled despite low overall provisioned capacity usage. What is the correct diagnosis?

46 You need a query returning items where status = 'ACTIVE' and createdAt > X, but status is not the table's partition key. The most efficient DynamoDB design is to:

47 A read of a DynamoDB item immediately after a write sometimes returns the old value. The client used the default read setting. Which change guarantees the latest committed data on reads?

48 A Redshift table joined frequently on customer_id and filtered by order_date performs poorly with heavy data redistribution during joins. Which distribution and sort choice best addresses this?

49 Which statement best explains why Amazon Redshift outperforms a traditional row-store RDBMS for large analytical aggregations?

50 A company wants Oracle on RDS but prefers not to purchase separate Oracle licenses. Which RDS licensing model fits, and what is its key constraint?

51 A DBA needs Oracle TDE and Oracle APEX enabled on an RDS instance. Which RDS construct is used to enable these engine-specific features, and how is it applied?

52 An RDS workload is memory-bound with a large buffer cache but modest CPU usage. Which instance class family is the most appropriate choice?

53 An RDS instance on General Purpose (gp2) SSD intermittently hits an I/O ceiling during batch jobs despite low average load. What best explains this and the appropriate fix?

54 A team wants a MySQL-compatible engine that provides storage auto-scaling to 128 TB, 6-way replication across 3 AZs, and faster recovery than standard RDS MySQL. Which engine should they choose?

55 In a relational database enforcing ACID, a transaction transfers funds between two accounts. A crash occurs after debiting account A but before crediting account B. Which ACID property ensures the system does not persist a half-completed transfer?

56 An application stores flexible, schema-varying JSON documents and needs horizontal scalability without complex multi-table joins. Why is a NoSQL store generally preferable to a relational schema here?

57 In a single-master RDS deployment with read replicas, an application mistakenly sends UPDATE statements to a read replica endpoint. What happens?

58 During an RDS Multi-AZ failover, the application reconnects quickly without changing its connection string. What mechanism makes this possible?

59 A company needs to migrate an RDS MySQL database to a different region with minimal downtime and also offload analytics reads there. Which read replica capability supports this?

60 A DynamoDB application must process every item change in near real time to update a search index. Which approach is the intended, scalable solution?