MCQs on Introduction to DynamoDB | DynamoDB MCQ Question & Answer

Dive into this comprehensive guide of AWS DynamoDB MCQ questions and answers to enhance your understanding of DynamoDB basics. Covering key topics like NoSQL databases, tables, items, and attributes, core features, and use cases, these MCQs are ideal for beginners and professionals preparing for DynamoDB-related certifications or interviews.

AWS DynamoDB MCQs

Overview of NoSQL Databases

1. What is a key characteristic of NoSQL databases?
   a) Relational schemas are mandatory.
   b) They require SQL for data queries.
   c) They handle unstructured and semi-structured data efficiently.
   d) They are only used for small datasets.
2. Which of the following is a NoSQL database?
   a) MySQL
   b) DynamoDB
   c) PostgreSQL
   d) Oracle
3. NoSQL databases are best suited for:
   a) Storing large volumes of structured data.
   b) Applications with rapidly changing schema requirements.
   c) High-transaction banking systems.
   d) Fixed-schema enterprise systems.
4. What does “NoSQL” primarily stand for?
   a) Not Only SQL
   b) Non-Standard Query Language
   c) No Structured Query Language
   d) No Schema Query Language
5. NoSQL databases like DynamoDB are typically used for:
   a) High-performance transaction processing.
   b) Flexible, scalable data storage.
   c) Fixed-schema relational data modeling.
   d) Data warehousing and analytics only.

Key Concepts: Tables, Items, Attributes

6. In DynamoDB, a table is:
   a) A collection of items.
   b) Equivalent to a database in SQL.
   c) A single unit of storage.
   d) A predefined schema with fixed rows.
7. What is an item in DynamoDB?
   a) A column in a table.
   b) A group of tables.
   c) A single record in a table.
   d) A predefined schema.
8. Attributes in DynamoDB are:
   a) Identical to rows in a relational database.
   b) Key-value pairs associated with an item.
   c) Used to define the table’s schema.
   d) Always indexed by default.
9. What is a partition key in DynamoDB?
   a) The unique primary key for each table.
   b) A single attribute used to uniquely identify items in a table.
   c) A combination of two keys to identify items.
   d) A metadata field for table items.
10. A composite key in DynamoDB consists of:
    a) Partition key and sort key
    b) Partition key and global secondary index
    c) Sort key and local secondary index
    d) Table name and attributes

Core Features of DynamoDB

11. DynamoDB provides:
    a) ACID transactions
    b) Global scalability
    c) Built-in security features
    d) All of the above
12. Which of the following is true about DynamoDB on-demand capacity mode?
    a) You need to predefine read and write capacity units.
    b) It automatically scales based on traffic.
    c) It does not charge for idle tables.
    d) It requires complex configuration.
13. What does the DynamoDB Streams feature allow?
    a) Backing up DynamoDB tables automatically.
    b) Capturing a time-ordered sequence of item-level changes in a table.
    c) Configuring automatic scaling for tables.
    d) Managing access permissions for a table.
14. Which DynamoDB feature provides in-memory caching?
    a) DynamoDB Accelerator (DAX)
    b) Global Tables
    c) On-demand Backup
    d) Auto Scaling
15. What is a Local Secondary Index (LSI) in DynamoDB?
    a) An index with the same partition key but a different sort key.
    b) An index with a different partition key from the base table.
    c) A primary key used for all queries.
    d) A backup mechanism for the base table.

Use Cases and Benefits

16. Which of the following is NOT a typical use case for DynamoDB?
    a) Mobile app development
    b) IoT data storage
    c) Transactional banking systems
    d) Real-time analytics
17. DynamoDB is best suited for:
    a) High-volume reads and writes
    b) Batch data processing
    c) Fixed-schema data storage
    d) Static reporting
18. What is a primary advantage of DynamoDB’s serverless architecture?
    a) Requires manual scaling
    b) No need to manage infrastructure
    c) Requires constant monitoring of traffic
    d) Fixed pricing structure
19. For an e-commerce application requiring high-speed order processing, which AWS service is ideal?
    a) Amazon RDS
    b) DynamoDB
    c) Amazon Redshift
    d) Elastic Beanstalk
20. Which feature makes DynamoDB suitable for global applications?
    a) High latency response
    b) Global Tables for multi-region replication
    c) Fixed capacity provisioning
    d) Relational data modeling

Getting Started: Setting up AWS Account and DynamoDB

21. To use DynamoDB, which prerequisite is required?
    a) Create an IAM role for access.
    b) Create an AWS account.
    c) Deploy an EC2 instance.
    d) Configure S3 buckets.
22. DynamoDB offers which type of interface for creating tables?
    a) CLI only
    b) AWS Management Console and CLI
    c) SDK only
    d) Database Migration Tool
23. After creating a table in DynamoDB, you need to define:
    a) The partition key and sort key (if applicable).
    b) The exact table schema.
    c) The table size in GB.
    d) The backup policy immediately.
24. AWS Free Tier includes how many write requests per month for DynamoDB?
    a) 1 million
    b) 100,000
    c) 50,000
    d) 25,000
25. Which is a required step to set up DynamoDB?
    a) Enable table encryption.
    b) Configure read and write capacity units.
    c) Enable DynamoDB Streams.
    d) Set up CloudWatch alarms.

Mixed Questions

26. How does DynamoDB ensure high availability?
    a) By replicating data across multiple Availability Zones.
    b) By providing manual backups.
    c) By running on a single node.
    d) By enforcing a fixed data schema.
27. What happens when you exceed the provisioned capacity of a DynamoDB table?
    a) Requests are throttled.
    b) Data is automatically archived.
    c) Read and write operations stop completely.
    d) The table automatically scales up.
28. How can you monitor DynamoDB performance?
    a) Using AWS CloudTrail
    b) Using Amazon CloudWatch
    c) Using AWS Trusted Advisor
    d) Using S3 Bucket Metrics
29. What is a benefit of DynamoDB’s automatic scaling?
    a) Reduces the need for backup services
    b) Optimizes cost by adjusting capacity dynamically
    c) Increases table size limits
    d) Allows for manual traffic management
30. DynamoDB charges are based on:
    a) Number of requests and storage used
    b) CPU and memory usage
    c) Fixed monthly cost
    d) Network bandwidth usage

Answers