Unit 4: Databases and Data Management - Practice Quiz

1 Which of the following best describes the primary use case for a Relational Database Management System (RDBMS) in the cloud?

2 In the context of Amazon RDS, what is the primary responsibility of AWS under the Shared Responsibility Model?

3 Which Amazon RDS feature provides a fully managed, highly available database proxy that manages thousands of concurrent connections to relational databases?

4 When configuring Amazon RDS, which deployment option should be selected to ensure high availability and automatic failover during a hardware outage?

5 Which of the following database engines is NOT available as a managed service within Amazon RDS?

6 What happens to the I/O operations of a Single-AZ Amazon RDS instance during a database snapshot?

7 To improve the read performance of a heavy read-intensive application using Amazon RDS, which feature should be implemented?

8 What is the maximum retention period for Amazon RDS automated backups?

9 Which Amazon RDS feature allows you to revert the database to any specific second during the retention period?

10 Amazon DynamoDB is best categorized as which type of database?

11 Which Amazon Aurora feature allows the database to automatically start up, shut down, and scale capacity based on application needs?

12 A developer needs to store session state data that requires sub-millisecond latency. Which AWS service is best suited for this?

13 When migrating a schema from a proprietary database (like Oracle) to an open-source engine (like PostgreSQL) on AWS, which tool assists in converting the schema?

14 Which AWS service is specifically designed for analyzing relationships between highly connected data, such as social networks?

15 What is the primary difference between Amazon RDS Multi-AZ and Read Replicas regarding data replication?

16 In Amazon DynamoDB, which capacity mode is best suited for unpredictable workloads with sudden traffic spikes?

17 Which Well-Architected principle is applied when using Amazon RDS IAM Authentication instead of hardcoded database passwords?

18 Which AWS database service is serverless, fully managed, and specifically designed for time-series data?

19 A company requires a database that provides an immutable, cryptographically verifiable log of data changes. Which service should they choose?

20 When performing a heterogeneous database migration using AWS DMS, what role does the Replication Instance play?

21 Which feature of Amazon Aurora allows it to create a clone of a production database in seconds without copying the data initially?

22 To encrypt Amazon RDS data at rest, what service is integrated with RDS?

23 What is the result of promoting an Amazon RDS Read Replica?

24 Which Amazon DynamoDB feature enables in-memory caching for read-heavy workloads, reducing latency from milliseconds to microseconds?

25 Under the Well-Architected Framework's 'Reliability' pillar, how does Amazon Aurora store data?

26 Which option allows a database administrator to securely manage database credentials without embedding them in application code?

27 Which AWS database service is fully compatible with MongoDB workloads?

28 For a global application requiring low-latency local reads and writes in multiple regions, which DynamoDB feature is appropriate?

29 When migrating a database using AWS DMS, what is 'CDC'?

30 Which RDS feature allows you to control the parameters and configuration settings that apply to a DB instance?

31 What is the recommended method to allow an EC2 instance to connect to an RDS database within a VPC?

32 Which database service is a Petabyte-scale data warehouse used for Online Analytical Processing (OLAP)?

33 In the context of 'Cost Optimization', what is a benefit of using Amazon Aurora I/O-Optimized configuration?

34 Which AWS service allows you to run Apache Cassandra workloads with a managed serverless experience?

35 What happens to the automated backups of an RDS instance if the instance is deleted without a final snapshot?

36 How does Amazon DynamoDB Streams facilitate event-driven architectures?

37 Which mechanism ensures that an RDS database is deployed in a private network and not accessible from the public internet?

38 When applying 'Performance Efficiency' to a database layer, what does 'Selection' refer to?

39 What is the primary function of a DB Subnet Group in Amazon RDS?

40 Which Amazon RDS engine supports the 'Backtrack' feature to rewind the database cluster to a specific time without restoring from a backup?

41 For a read-heavy workload on DynamoDB, which error indicates that the provisioned throughput has been exceeded?

42 Which tool can efficiently move large amounts of data (Exabytes) from on-premises to AWS offline, useful for initial large-scale database migrations?

43 In terms of connection management, what is a 'Connection Storm'?

44 Which scaling strategy involves changing the instance type of an RDS database (e.g., from t3.medium to r5.large)?

45 What is the purpose of the 'Primary Key' in Amazon DynamoDB?

46 When migrating a database to AWS, which strategy involves moving the application and database with minimal changes?

47 Which Aurora feature allows a single database to span multiple AWS Regions with low-latency replication?

48 How does Amazon RDS Storage Auto Scaling work?

49 Which of the following is NOT a benefit of using managed database services like RDS over self-managed databases on EC2?

50 When utilizing Amazon Redshift for data warehousing, what is the role of 'Spectrum'?