Amazon DynamoDB is a fully managed proprietary NoSQL database service that supports key–value and document data structures and is offered by Amazon.com as part of the Amazon Web Services portfolio. (Read more at Wikipedia).
DynamoDB MCQs: This section contains multiple-choice questions and answers on the various topics of DynamoDB. Practice these MCQs to test and enhance your skills on DynamoDB.
List of DynamoDB MCQs
1. DynamoDB is a ____ database?
- NoSQL
- SQL
Answer: A) NoSQL
Explanation:
DynamoDB is a NoSQL database.
2. How many types of primary keys does DynamoDB use?
- 5
- 4
- 3
- 2
Answer: D) 2
Explanation:
DynamoDB uses Two types of Primary keys:
- Partition Key
- Partition key and Sort Key
3. Partition key and Sort Key are also known as ____?
- Clear primary key
- Composite primary key
- Dependent primary key
Answer: B) Composite primary key
Explanation:
The partition key and Sort Key is also known as Composite primary key.
4. This straightforward primary key consists of a single property known as the ____?
- partition key
- sort key
Answer: A) partition key
Explanation:
This straightforward primary key consists of a single property known as the “partition key.”
5. ____ indexes enable you to query table data using a different key?
- Composite
- Secondary
- Primary
Answer: B) Secondary
Explanation:
Secondary indexes enable you to query table data using a different key.
6. DynamoDB uses how many types of secondary indexes?
- 5
- 4
- 2
- 3
Answer: C) 2
Explanation:
DynamoDB uses two types of secondary indexes:
- Global secondary indexes
- Local secondary indexes
7. Partition and sort keys may differ from table keys in ____ type of secondary index.
- Global secondary indexes
- Local secondary indexes
Answer: A) Global secondary indexes
Explanation:
Partition and sort keys may differ from table keys in the Global secondary index.
8. Which of the following type of secondary index has the same partition key as the table, but its sort key is different?
- Global secondary indexes
- Local secondary indexes
Answer: B) Local secondary indexes
Explanation:
secondary indexes index has the same partition key as the table, but its sort key is different.
9. DynamoDB uses which of the following consistent reads to support dynamic application needs?
- Eventually consistent
- Strongly consistent
- Both
Answer: C) Both
Explanation:
To satisfy the demands of dynamic applications, DynamoDB employs eventually consistent and strongly consistent reads.
10. Eventually Consistent readings always return current data?
- True
- False
Answer: B) False
Explanation:
False, Eventually Consistent readings do not always return current data.
11. Do The strongly consistent reads always deliver current data?
- True
- False
Answer: A) True
Explanation:
The strongly consistent reads always deliver current data.
12. How many types of data type categories does DynamoDB support?
- 2
- 3
- 4
- 5
Answer: B) 3
Explanation:
Each data type in DynamoDB falls into one of the three categories:
- Scalar
- Document
- Set
13. Which of the following data type category in DynamoDB represent a single value, and include number, string, binary, Boolean, and null?
- Scalar
- Document
- Set
Answer: A) Scalar
Explanation:
Scalar type in DynamoDB represent a single value, and includes number, string, binary, Boolean, and null.
14. ____ types represent a complex structure possessing nested attributes and include lists and maps.
- Scalar
- Document
- Set
Answer: B) Document
Explanation:
Document types represent a complex structure possessing nested attributes, and include lists and maps.
15. DynamoDB tables are ____?
- Schema less
- Schema Full
- Mix
Answer: A) Schema less
Explanation:
DynamoDB tables are Schema less.
16. ____ must-have elements of the same type, whether they be numbers, strings, or binary.
- Map
- List
- Sets
Answer: C) Sets
Explanation:
Sets must-have elements of the same type, whether they be numbers, strings, or binary.
17. For Table Maintenance, DynamoDB provides how many low-level operations?
- 2
- 3
- 4
- 5
Answer: D) 5
Explanation:
For Table Maintenance, DynamoDB provides five low-level operations:
- CreateTable
- ListTable
- Update Table
- Describe table
- Delete Table
18. Which of the following operation in DynamoDB returns table metadata such as status, size, and indexes?
- CreateTable
- ListTable
- Update Table
- Describe table
Answer: D) Describe table
Explanation:
Describe table operation returns table metadata such as status, size, and indexes.
19. For data reading, DynamoDB provides how many low-level operations?
- 2
- 4
- 5
- 6
Answer: B) 4
Explanation:
For data reading, DynamoDB provides four low-level operations:
- GetItem
- BatchGetItem
- Scan
- Query
20. Which of the following data-reading action in DynamoDB receives a primary key and returns the corresponding item’s attributes?
- GetItem
- BatchGetItem
- Scan
- Query
Answer: A) GetItem
Explanation:
GetItem action receives a primary key and returns the corresponding item’s attributes.
21. Which of the following data-reading action, does many GetItem calls on various items using primary keys, with the option of using one or more tables?
- GetItem
- BatchGetItem
- Scan
- Query
Answer: B) BatchGetItem
Explanation:
BatchGetItem does many GetItem calls on various items using primary keys, with the option of using one or more tables.
22. DynamoDB offers ____ low-level actions for data modification.
- 2
- 3
- 4
- 5
Answer: C) 4
Explanation:
DynamoDB offers four low-level actions for data modification:
- PutItem
- BatchWriteItem
- UpdateItem
- DeleteItem
23. DynamoDB often ensures consistency across all copies in less than a second.
- True
- False
Answer: A) True
Explanation:
DynamoDB often ensures consistency across all copies in less than a second.
24. Do Batch writes have the ability to alter things across a single table?
- True
- False
Answer: B) False
Explanation:
Batch writes can alter things across several tables.
25. What is the limit to create a global secondary index per table?
- 4
- 5
- 6
- 7
- No Limit
Answer: B) 5
Explanation:
A maximum of five global secondary indexes are permitted per table.
26. What is the limit to create a local secondary index per table?
- 4
- 5
- 6
- 7
- No Limit
Answer: B) 5
Explanation:
A maximum of five local secondary indexes are permitted per table.
27. Global Secondary Index supports which of the following API?
- Query
- Scan
- Both
- None
Answer: C) Both
Explanation:
Global Secondary Index supports the API functions “Query” and “Scan.”
28. All local secondary indexes retain partition and sort keys from parent tables by default?
- True
- False
Answer: A) True
Explanation:
All local secondary indexes retain partition and sort keys from parent tables by default.
29. Tables using a local secondary index must adhere to a size restriction of ____ per partition key value.
- 100GB
- 50GB
- 10GB
Answer: C) 10GB
Explanation:
Tables using a local secondary index must adhere to a size restriction of 10GB per partition key value.
30. Does DynamoDB provide Aggregation functions?
- Yes
- No
Answer: B) No
Explanation:
Aggregation functions are not available in DynamoDB.
31. How many IAM roles are needed to use the data pipeline?
- 3
- 4
- 5
- 2
Answer: D) 2
Explanation:
To utilize Data Pipeline, you must have two IAM roles:
- DataPipelineDefaultRole
- DataPipelineDefaultResourceRole
32. Tags are not supported by DynamoDB.
- True
- False
Answer: A) True
Explanation:
Tags are not supported by DynamoDB.
33. ____ can export and import data to and from a table, file, or S3 bucket.
- Sharding
- Data Pipeline
- Data Shifting
Answer: B) Data Pipeline
Explanation:
Data Pipeline can export and import data to and from a table, file, or S3 bucket.
34. Which of the following IAM role includes all of the activities you’ve given the pipeline permission to do?
- DataPipelineDefaultRole
- DataPipelineDefaultResourceRole
Answer: A) DataPipelineDefaultRole
Explanation:
DataPipelineDefaultRole includes all of the activities you’ve given the pipeline permission to do.
35. ____ logs low-level API calls from or for DynamoDB in an account and sends them to an S3 bucket.
- CloudWatch
- CloudTrail
- EMR
- CloudMonitor
Answer: B) CloudTrail
Explanation:
CloudTrail logs low-level API calls from or for DynamoDB in an account and sends them to an S3 bucket.
36. ____ service allows you to handle large amounts of data rapidly and effectively?
- Amazon’s Elastic MapReduce (EMR)
- Amazon’s MapReduce
- Amazon’s Hive MapReduce
Answer: A) Amazon’s Elastic MapReduce (EMR)
Explanation:
Amazon’s Elastic MapReduce (EMR) service allows you to handle large amounts of data rapidly and effectively.
37. Binary and binary set properties supported by the DynamoDB/EMR connection?
- True
- False
Answer: B) False
Explanation:
Binary and binary set properties are not supported by the DynamoDB/EMR connection.
38. Can you connect to EC2 instances without the key pair?
- Yes
- No
Answer: B) No
Explanation:
No, Without the key pair, you cannot connect to EC2 instances.
39. ____ is a collection of properties that are transferred or anticipated from a table to an index.
- Forecasted
- Projection
- Estimation
Answer: B) Projection
Explanation:
A projection is a collection of properties that are transferred or anticipated from a table to an index.
40. You may generate an access key and a secret key by establishing a user in Amazon IAM (Identity Access Management).
- True
- False
Answer: A) True
Explanation:
You may generate an access key and a secret key by establishing a user in Amazon IAM (Identity Access Management).
41. Can I get rid of local secondary indexes?
- Yes
- No
Answer: B) No
Explanation:
Currently, Amazon DynamoDB is unable to remove the table’s local secondary indexes once they have been established.
42. Which of the following atomic operation does DynamoDB supports?
- Increment atomic operation
- Decrement atomic operation
- Both
- None
Answer: C) Both
Explanation:
Amazon DynamoDB supports atomic increment and decrement operations.
43. Does Null values supported by DynamoDB?
- Yes
- No
Answer: A) Yes
Explanation:
Yes, DynamoDB supports Null values.
44. A ____ operation reads all of the elements in the table.
- PutItem
- GetItem
- Scan
- Query
Answer: C) Scan
Explanation:
A scan operation reads all of the elements in the table.
45. With DynamoDB, the maximum size of an object is ____?
- 100MB
- 5MB
- 2MB
- 1MB
Answer: D) 1MB
Explanation:
With DynamoDB, the maximum size of an object is 1 MB.
46. A DynamoDB table has no default TTL value?
- True
- False
Answer: A) True
Explanation:
A DynamoDB table has no default TTL value.
47. DynamoDB allows ____ attributes?
- 50
- 100
- 20
- 30
Answer: C) 20
Explanation:
DynamoDB allows 20 attributes.
48. The usage of reserved words as names is prohibited by DynamoDB?
- True
- False
Answer: B) False
Explanation:
The usage of reserved words as names is not prohibited by DynamoDB.
49. ____ are used by DynamoDB to store data?
- Sections
- Units
- Partitions
- Segments
Answer: C) Partitions
Explanation:
Partitions are used by DynamoDB to store data.
50. DynamoDB offers how many ways to conduct operations?
- 3
- 4
- 5
- 6
Answer: A) 3
Explanation:
DynamoDB offers three ways to conduct operations: a web-based Graphical interface, a JavaScript shell, and your preferred programming language.