Unit 4: Databases and Data Management - Practice Quiz

1 Which database type is most appropriate for structured data that requires joins and ACID transactions?

2 Which factor should be considered when selecting a database for an application?

3 Which database characteristic is most important for an online payment system?

4 What is Amazon Relational Database Service (Amazon RDS)?

5 Which Amazon RDS feature pools and shares database connections to improve application scalability?

6 What should an application normally use to connect to an Amazon RDS database instance?

7 Which task is generally managed by Amazon RDS?

8 What is a primary purpose of Amazon RDS automated backups?

9 What is the main purpose of an Amazon RDS read replica?

10 How is data typically copied from an Amazon RDS source database to a read replica?

11 What type of database is Amazon DynamoDB?

12 Which key component determines how Amazon DynamoDB distributes data across partitions?

13 Which AWS database service is designed for highly connected graph data?

14 Which AWS service is designed primarily for in-memory caching?

15 Which AWS service helps migrate data between databases while minimizing application downtime?

16 Which AWS tool helps convert a source database schema to a different target database engine?

17 What should an organization do before beginning a database migration to AWS?

18 Which practice improves database availability in the AWS Cloud?

19 Which security principle grants database users only the permissions they need?

20 Which practice supports cost optimization for the database layer?

21 An application requires complex joins, strong referential integrity, and transactions across several related tables. Which database type is the most appropriate choice?

22 A social networking application frequently queries relationships such as friends, followers, and mutual connections. Which database model best fits this workload?

23 An application stores session data using a unique session identifier and needs very fast lookups without complex queries. Which database pattern is most suitable?

24 A team wants Amazon RDS to apply minor database engine patches during a predictable maintenance window. Which configuration should they use?

25 An application should continue connecting to an RDS database after a failover without changing its configured endpoint. Which endpoint should it use?

26 A connection pool keeps many idle connections open and causes the database to reach its connection limit. Which change most directly addresses the issue?

27 An organization needs database credentials to rotate automatically without storing long-lived passwords in application configuration files. Which approach is most appropriate?

28 A company wants to restore an RDS database to a specific point during the last seven days after accidental data deletion. Which feature should it enable?

29 A reporting workload is increasing read traffic on a production RDS database. The reports can tolerate slightly stale data. What is the best solution?

30 A read replica has increasing replication lag during large reporting queries. Which action is most likely to reduce the impact?

31 A database must remain available if the underlying Availability Zone becomes unavailable, with automatic failover for the primary workload. Which RDS option should be selected?

32 A DynamoDB table is queried by CustomerId and sorted by OrderDate. Which key design best supports this access pattern?

33 A DynamoDB workload has unpredictable traffic and requires automatic capacity adjustment while maintaining low latency. Which feature is most appropriate?

34 An application needs to retrieve DynamoDB items by email address, but the table's primary key is UserId. What should be created?

35 A financial application needs highly durable, scalable storage for immutable event records that are rarely updated. Which purpose-built option is most suitable?

36 A company needs to migrate a running on-premises database to AWS while minimizing downtime. Which AWS service is designed for this requirement?

37 A migration project moves from one database engine to another and requires schema and code conversion. Which AWS tool should be used with the migration service?

38 Before migrating a large database, the team wants to identify unsupported features and estimate conversion effort. What should it do first?

39 A database contains sensitive customer information. Which design best supports the security pillar of the AWS Well-Architected Framework?

40 A database workload varies significantly during the day, and the team wants to control costs without reducing required performance. Which practice aligns best with cost optimization?

41 A financial application requires strongly consistent balances, multi-row ACID transactions, complex joins, and auditable point-in-time recovery. Which database architecture best satisfies these requirements?

42 An order system receives unpredictable traffic spikes. Most requests retrieve an order by customer ID and timestamp, while writes must remain durable and highly available. Which design most directly improves scalability without introducing cross-record joins?

43 A team plans to select a database solely by comparing benchmarked transactions per second. Which additional evaluation is most important before making the decision?

44 An Amazon RDS database experiences connection exhaustion whenever the application scales out. Query latency is normal, but many connections remain idle. Which change best addresses the root cause?

45 An application must reconnect automatically after an RDS Multi-AZ failover. Which connection strategy is most appropriate?

46 A production RDS instance is in a private subnet, while an application runs in another VPC. The application cannot connect even though the RDS security group allows its port. Which missing condition is most likely?

47 A database administrator changes an RDS parameter, but the engine behavior does not change immediately. Which explanation is most accurate?

48 A company needs recovery to any point within the last 21 days after accidental deletes. It also needs to offload reporting queries from the production database. Which combination is correct?

49 A read replica is several minutes behind the primary during a reporting burst. The business requires reports to reflect committed transactions immediately after an order confirmation. What is the best change?

50 A read replica is promoted after a primary failure. Which operational consequence must the application team account for?

51 A team wants a read replica in another Region for disaster recovery. Which issue most directly affects the recovery design?

52 An RDS backup window overlaps with a nightly batch job and causes unacceptable I/O contention. Which response best reduces operational impact?

53 A DynamoDB table uses tenantId as its partition key. One tenant generates 70% of all traffic, causing throttling despite unused total table capacity. What is the best redesign?

54 A DynamoDB workload requires atomic updates to an account balance and a ledger item, rejecting the operation if either condition is invalid. Which feature best fits?

55 A DynamoDB item is updated with a conditional expression, but a client retry may submit the same logical request twice after a timeout. Which mechanism most directly prevents duplicate business effects?

56 A product catalog requires full-text search, relevance ranking, faceting, and typo tolerance, while the authoritative records remain transactional. Which architecture is most suitable?

57 A large production database must migrate to AWS with minimal downtime. The target schema is compatible, and changes must continue replicating during the initial data load. Which approach is most appropriate?

58 During a heterogeneous migration from a commercial relational engine to Aurora PostgreSQL, incompatibilities exist in stored procedures and data types. Which sequence best reduces cutover risk?

59 A migration validation report shows equal row counts, but users report missing relationships and incorrect timestamps. Which validation improvement is most important?

60 A database design uses Multi-AZ for failover but has no tested restore process, no defined recovery objectives, and no alerting for replication lag. Which Well-Architected concern is most evident?