DynamoDB Fundamentals

<p>3</p> Signup and view all the answers

<p>To restrict user access to only their own records</p> Signup and view all the answers

<p>SSD</p> Signup and view all the answers

<p>The main table will be throttled even if there are enough WCUs</p> Signup and view all the answers

<p>Improved read performance</p> Signup and view all the answers

<p>To specify the number of data reads and writes per second</p> Signup and view all the answers

<p>On-Demand Capacity requires specifying requirements, while Provisioned Capacity does not</p> Signup and view all the answers

<p>To automatically delete items after an expiry date/time</p> Signup and view all the answers

<p>The ProvisionedThroughputExceededException error is thrown</p> Signup and view all the answers

<p>It defines the attributes that should be returned by the Scan operation.</p> Signup and view all the answers

<p>Eventually consistent reads are faster, while strongly consistent reads are more accurate.</p> Signup and view all the answers

<p>To ensure that multiple operations on multiple items within a table are performed as a single, atomic operation.</p> Signup and view all the answers

<p>Performing a complex calculation on a large dataset stored in DynamoDB.</p> Signup and view all the answers

<p>It specifies the conditions that must be met for an item to be returned by the Scan operation.</p> Signup and view all the answers

<p>A Partition is a physical storage unit for a table, and it can reduce performance if data is unevenly distributed.</p> Signup and view all the answers

<p>Setting the ConsistentRead parameter to true</p> Signup and view all the answers

<p>A Scan does not filter unwanted data while a Query does.</p> Signup and view all the answers

<p>It allows querying based on an alternative sort key.</p> Signup and view all the answers

<p>ScanIndexForward</p> Signup and view all the answers

<p>It speeds up queries on non-key attributes.</p> Signup and view all the answers

<p>Reduce the page size to use fewer read operations</p> Signup and view all the answers

<p>To manage the table size and reduce storage over time.</p> Signup and view all the answers

<p>DynamoDB Streams.</p> Signup and view all the answers

<p>They are recoverable using DynamoDB Streams.</p> Signup and view all the answers

<p>They gradually increase for improved flow control.</p> Signup and view all the answers

<p>CreateTable and UpdateTable.</p> Signup and view all the answers

<p>Use pointers to S3 for objects larger than 400KB.</p> Signup and view all the answers

<p>They must occur in the same AWS region.</p> Signup and view all the answers

<p>Automatic multi-master replication.</p> Signup and view all the answers

<p>No scaling down occurs for provisioned capacity.</p> Signup and view all the answers

<p>Automatic recovery features.</p> Signup and view all the answers

<p>Write capacity settings.</p> Signup and view all the answers

<p>Massively scaled applications with globally dispersed users.</p> Signup and view all the answers

<p>Eventual consistent reads.</p> Signup and view all the answers

<p>Aurora database.</p> Signup and view all the answers

<p>They automatically synchronize data changes across regions.</p> Signup and view all the answers

<p>Frequent RDS snapshots.</p> Signup and view all the answers

<p>To ensure the main table is not throttled</p> Signup and view all the answers

<p>It enables dynamic adjustment of provisioned capacity based on traffic patterns</p> Signup and view all the answers

<p>To improve read performance on DynamoDB tables</p> Signup and view all the answers

<p>Throttling occurs, and the AWS SDKs automatically retry the request</p> Signup and view all the answers

<p>To delete items after an expiry date or time</p> Signup and view all the answers

<p>The type of workloads they are suitable for</p> Signup and view all the answers

<p>It provides an alternative sort key organized by a different range.</p> Signup and view all the answers

<p>GSI can be created after the initial table setup.</p> Signup and view all the answers

<p>It filters data after retrieving the entire dataset.</p> Signup and view all the answers

<p>ConsistentRead</p> Signup and view all the answers

<p>It specifies which attributes to return.</p> Signup and view all the answers

<p>Set a smaller page size for scans.</p> Signup and view all the answers

<p>To replicate data across multiple Availability Zones</p> Signup and view all the answers

<p>Exceeding 1000 Write Capacity Units for a single partition</p> Signup and view all the answers

<p>ConsistentRead to true</p> Signup and view all the answers

<p>It ensures all operations within a transaction either succeed or fail as a unit</p> Signup and view all the answers

<p>Scan operations reading every item in a table</p> Signup and view all the answers

<p>They offer lower latency and higher throughput than strongly consistent reads</p> Signup and view all the answers

<p>Through synchronous replication across three facilities in a region</p> Signup and view all the answers

<p>Data can be stored as key-value pairs or documents, including JSON</p> Signup and view all the answers

<p>All access control is handled exclusively through IAM with identity-based policies</p> Signup and view all the answers

<p>Items must not exceed 400KB, including keys and all attributes</p> Signup and view all the answers

<p>Push button scaling</p> Signup and view all the answers

<p>When complex multi-table queries are frequently needed</p> Signup and view all the answers

<p>To manage retries by progressively increasing wait times</p> Signup and view all the answers

<p>Streams can serve as event sources for Lambda functions</p> Signup and view all the answers

<p>The item is retained for potential recovery via DynamoDB Streams</p> Signup and view all the answers

<p>Use S3 for objects larger than 400KB and store pointers in DynamoDB</p> Signup and view all the answers

<p>Simultaneous writes to the same item overwriting each other</p> Signup and view all the answers

<p>The request fails with a 400 HTTP code</p> Signup and view all the answers

<p>All strongly consistent reads must be performed in the same region.</p> Signup and view all the answers

<p>All replica tables must have identical write capacity settings.</p> Signup and view all the answers

<p>It does not scale down and remains at the current provisioned capacity.</p> Signup and view all the answers

<p>Designing high availability when running on EC2.</p> Signup and view all the answers

<p>They provide a fully managed solution with low-latency access.</p> Signup and view all the answers

<p>It is not strongly consistent.</p> Signup and view all the answers

<p>It increases provisioned read and write capacity automatically.</p> Signup and view all the answers

<p>Data can be read from any region without modifications.</p> Signup and view all the answers

<p>DynamoDB has inherent fault tolerance.</p> Signup and view all the answers

<p>Partial replication of selected items.</p> Signup and view all the answers

<p>It speeds up queries on non-key attributes</p> Signup and view all the answers

<p>It can use up the provisioned throughput in a single operation</p> Signup and view all the answers

<p>To get a consistent copy of the data as of the time the Scan begins</p> Signup and view all the answers

<p>An LSI has the same partition key as the table, while a GSI has a different partition key</p> Signup and view all the answers

<p>Setting a smaller page size to use fewer read operations</p> Signup and view all the answers

<p>A Scan operation returns all attributes, while a Query operation returns only specified attributes</p> Signup and view all the answers

<p>Your requests may be throttled, potentially leading to delays or failures.</p> Signup and view all the answers

<p>Eventually consistent reads are faster but may return stale data, while strongly consistent reads ensure the latest data is returned, potentially with a slight performance penalty.</p> Signup and view all the answers

<p>Transactions always execute successfully, ensuring no data loss or inconsistency.</p> Signup and view all the answers

<p>To specify the specific attributes that should be returned by the Scan operation.</p> Signup and view all the answers

<p>Global tables replicate data across multiple regions, ensuring high availability and low latency for users around the world.</p> Signup and view all the answers

<p>UpdateTable</p> Signup and view all the answers

<p>Auto Scaling allows for automatic adjustments to provisioned capacity based on the utilization rate.</p> Signup and view all the answers

<p>To provide a fully managed, in-memory cache for DynamoDB tables, primarily improving read performance.</p> Signup and view all the answers

<p>Provisioned Capacity requires specifying the number of Read and Write Capacity Units, while On-Demand Capacity does not.</p> Signup and view all the answers

<p>ProvisionedThroughputExceededException</p> Signup and view all the answers

<p>WCUs represent the total write capacity for a table, while rWCUs represent the write capacity available for each replica in a global table.</p> Signup and view all the answers

<p>Insufficient read capacity units (RCUs) for the table.</p> Signup and view all the answers

<p>Reduced latency by quickly retrying failed requests</p> Signup and view all the answers

<p>To store a time-ordered sequence of item-level modifications in a DynamoDB table</p> Signup and view all the answers

<p>They are deleted within 48 hours of expiration, and also removed from local and global secondary indexes.</p> Signup and view all the answers

<p>Store large objects in S3 and store pointers (S3 object IDs) in DynamoDB.</p> Signup and view all the answers

<p>It protects database writes from being overwritten by concurrent updates from other clients.</p> Signup and view all the answers

<p>Employ ElastiCache as a caching layer in front of DynamoDB.</p> Signup and view all the answers

<p>Items are collections of attributes with names and values.</p> Signup and view all the answers

<p>Data is stored on SSD storage with multi-AZ redundancy.</p> Signup and view all the answers

<p>IAM for identity-based access control only.</p> Signup and view all the answers

<p>They can be stored as pointers to S3 objects.</p> Signup and view all the answers

<p>Scaling can be done on-the-fly without downtime.</p> Signup and view all the answers

<p>Guaranteed durability and availability of data.</p> Signup and view all the answers

<p>To provide a distributed, multi-region, multi-master database for massively scaled applications.</p> Signup and view all the answers

<p>Global tables require applications to perform all strongly consistent reads and writes in the same region, regardless of the region used for other operations.</p> Signup and view all the answers

<p>It automatically adjusts provisioned capacity based on traffic patterns, preventing throttling and ensuring optimal performance.</p> Signup and view all the answers

<p>DynamoDB provides built-in fault tolerance, while RDS requires additional configuration for high availability.</p> Signup and view all the answers

<p>DynamoDB offers more advanced features for data analysis and reporting than RDS.</p> Signup and view all the answers

<p>All strongly consistent operations must be performed within the same AWS region.</p> Signup and view all the answers

<p>To ensure that the GSI can handle the same volume of write requests as the main table.</p> Signup and view all the answers

<p>Auto Scaling only scales provisioned capacity upwards, automatically increasing capacity during peak traffic.</p> Signup and view all the answers

<p>Amazon Aurora</p> Signup and view all the answers

<p>Creating frequent snapshots to minimize data loss.</p> Signup and view all the answers

<p>It has no schema</p> Signup and view all the answers

<p>It provides higher availability and data durability</p> Signup and view all the answers

<p>Storing session state data</p> Signup and view all the answers

<p>To manage access control and authentication</p> Signup and view all the answers

<p>It allows for easy scaling without downtime</p> Signup and view all the answers

<p>Both key-value and document</p> Signup and view all the answers

<p>A Scan operation filters out unwanted data, while a Query operation returns all data that matches the query criteria.</p> Signup and view all the answers

<p>To enable fast queries on specific columns</p> Signup and view all the answers

<p>A GSI has a different partition key and sort key than the main table, while an LSI has the same partition key.</p> Signup and view all the answers

<p>The Scan operation returns a strongly consistent read.</p> Signup and view all the answers

<p>To reduce the number of read operations</p> Signup and view all the answers

<p>It provides an alternative sort key to use for scans and queries.</p> Signup and view all the answers

<p>Requests might be throttled, preventing access to the table.</p> Signup and view all the answers

<p>Transactions provide ACID properties (atomicity, consistency, isolation, durability).</p> Signup and view all the answers

<p>Utilize the ProjectionExpression parameter to only return specific attributes.</p> Signup and view all the answers

<p>Minimize the number of distinct partition key values to improve performance.</p> Signup and view all the answers

<p>To partition the Scan operation across multiple threads for parallel processing.</p> Signup and view all the answers

<p>Eventually consistent reads offer lower latency than strongly consistent reads.</p> Signup and view all the answers

<p>It specifies the type of data that will be written to the stream when data in the table is modified.</p> Signup and view all the answers

<p>Store all data in a single table for easy access and management.</p> Signup and view all the answers

<p>400 Bad Request</p> Signup and view all the answers

<p>By using optimistic locking to prevent overwrites based on the item's last modified timestamp.</p> Signup and view all the answers

<p>To capture a time-ordered sequence of item-level modifications in DynamoDB tables.</p> Signup and view all the answers

<p>To prevent excessive load on the server by progressively increasing the time between retries.</p> Signup and view all the answers

<p>It provides a pay-per-use pricing model where you are charged based on actual usage.</p> Signup and view all the answers

<p>The application may experience throttling, resulting in the <code>ProvisionedThroughputExceededException</code> error.</p> Signup and view all the answers

<p>It simplifies application development by eliminating the need to modify code for caching interactions.</p> Signup and view all the answers

<p>To automatically delete expired items in DynamoDB, reducing storage costs and improving performance.</p> Signup and view all the answers

<p>They allow for querying data based on attributes that are not part of the primary key, offering flexibility in data retrieval.</p> Signup and view all the answers

<p>The GSI should have the same or higher RCU/WCU as the main table to prevent throttling on the main table.</p> Signup and view all the answers

<p>DynamoDB provides inherent fault tolerance.</p> Signup and view all the answers

<p>Provisioned capacity automatically scales down to reduce costs.</p> Signup and view all the answers

<p>Amazon Aurora</p> Signup and view all the answers

<p>To maintain consistent data across all replicas.</p> Signup and view all the answers

<p>Strongly consistent reads are only supported within a single AWS region.</p> Signup and view all the answers

<p>A data warehousing system for storing historical analytics data.</p> Signup and view all the answers

<p>Eventually consistent reads may return stale data, while strongly consistent reads return the most recent data.</p> Signup and view all the answers

<p>Design and implement HA solutions manually using EC2 instances and appropriate software.</p> Signup and view all the answers

<p>It eliminates the need for manual capacity adjustments.</p> Signup and view all the answers

<p>All write operations will be throttled until capacity is increased.</p> Signup and view all the answers

<p>To improve flow control and prevent overload</p> Signup and view all the answers

<p>They are deleted from the LSI / GSI</p> Signup and view all the answers

<p>It provides a log of item-level modifications</p> Signup and view all the answers

<p>Use pointers to store them in S3</p> Signup and view all the answers

<p>To prevent overwrite of data by concurrent updates</p> Signup and view all the answers

<p>Faster read performance for infrequently changed data</p> Signup and view all the answers

<p>To provide low-latency data access to globally dispersed users</p> Signup and view all the answers

<p>Performing all reads and writes in the same region</p> Signup and view all the answers

<p>DynamoDB does not scale down provisioned capacity to zero</p> Signup and view all the answers

<p>To ensure proper replication of data across regions</p> Signup and view all the answers

<p>To dynamically adjust provisioned throughput capacity in response to actual traffic patterns</p> Signup and view all the answers

<p>All of the above</p> Signup and view all the answers

<p>Eventual consistency returns stale data, while strong consistency returns up-to-date data</p> Signup and view all the answers

<p>Write capacity settings</p> Signup and view all the answers

<p>To protect against data corruption or failure</p> Signup and view all the answers

<p>DynamoDB has inherent fault tolerance</p> Signup and view all the answers

<p>The main table's write capacity is exceeding the GSI's write capacity, and you should increase the provisioned WCUs for the main table to match or exceed the GSI's WCUs.</p> Signup and view all the answers

<p>DynamoDB will automatically scale up to accommodate the surge in write requests, ensuring minimal performance impact, but you will incur higher costs for the increased capacity.</p> Signup and view all the answers

<p>A table with a very high read volume and infrequent write requests, especially during peak traffic periods.</p> Signup and view all the answers

<p>Leveraging DynamoDB Accelerator (DAX) to cache frequently accessed customer profile data.</p> Signup and view all the answers

<p>The increased WCUs for the GSI may cause the main table to experience write throttling, even if the main table's provisioned WCUs are sufficient.</p> Signup and view all the answers

<p>Your application will experience a temporary performance degradation as write requests are throttled, but DynamoDB will not automatically scale up the provisioned capacity.</p> Signup and view all the answers

<p>You obtain a strongly consistent read of the data at the time the query begins.</p> Signup and view all the answers

<p>LSI uses the same partition key but a different sort key compared to the main table.</p> Signup and view all the answers

<p>They consume a significant amount of provisioned throughput in a single operation.</p> Signup and view all the answers

<p>It restricts the attributes returned for each item to those specified in the expression.</p> Signup and view all the answers

<p>There is minimal read/write activity on the table or index being scanned.</p> Signup and view all the answers

<p>Indexes can only be created at the time of table creation and not later.</p> Signup and view all the answers

<p>Your requests might be throttled.</p> Signup and view all the answers

<p>DynamoDB automatically manages the allocation and replication of partitions.</p> Signup and view all the answers

<p>To simplify grouping multiple actions into a single operation that either succeeds or fails as a whole.</p> Signup and view all the answers

<p>It restricts the returned attributes to only those specified.</p> Signup and view all the answers

<p>Strongly consistent reads can be configured but are slower than eventually consistent reads.</p> Signup and view all the answers

<p>It must include both a partition key and a sort key.</p> Signup and view all the answers

<p>A database that requires a high level of write throughput and low latency for an application with millions of users.</p> Signup and view all the answers

<p>DynamoDB's lack of support for resource-based policies, relying solely on identity-based policies.</p> Signup and view all the answers

<p>Maintaining a database for a banking application that involves complex transactions and stringent data consistency requirements.</p> Signup and view all the answers

<p>The feasibility of using a combination of DynamoDB and Amazon S3 to store and manage the large objects.</p> Signup and view all the answers

<p>Leverage DynamoDB's Global Tables feature, which enables low-latency data access across multiple regions while ensuring strong consistency.</p> Signup and view all the answers

<p>GSIs can be used to index attributes that are not part of the primary key, providing flexibility for querying data based on different criteria, while LSIs are restricted to indexing attributes within the primary key.</p> Signup and view all the answers

<p>Tables</p> Signup and view all the answers

<p>It eliminates downtime during scaling</p> Signup and view all the answers

<p>To provide high availability and data durability</p> Signup and view all the answers

<p>Both key-value and document structures</p> Signup and view all the answers

<p>To manage access control and authentication</p> Signup and view all the answers

<p>A key serves as a unique identifier for a value</p> Signup and view all the answers

<p>A Scan retrieves all items from a table, while a Query retrieves items based on a specific key.</p> Signup and view all the answers

<p>To provide an alternative sort key for queries and scans, allowing for efficient retrieval of data based on different criteria.</p> Signup and view all the answers

<p>It is local to the hash key of the main table, providing a specific view within the same partition.</p> Signup and view all the answers

<p>SortKeyCondition</p> Signup and view all the answers

<p>ConsistentRead</p> Signup and view all the answers

<p>Eventually consistent reads are faster than strongly consistent reads but may lead to inconsistent data, while strongly consistent reads are slower but guarantee data consistency.</p> Signup and view all the answers

<p>To avoid throttling on the main table due to writes on the GSI.</p> Signup and view all the answers

<p>It allows for flexible scaling of capacity based on application usage patterns.</p> Signup and view all the answers

<p>To enhance the read performance of DynamoDB tables by caching data in memory.</p> Signup and view all the answers

<p>On-Demand Capacity allows for more flexibility in scaling than Provisioned Capacity.</p> Signup and view all the answers

<p>LSIs can be used to query data based on attributes that are not the partition key.</p> Signup and view all the answers

<p>GSIs are stored in a separate table and are globally available, while LSIs are stored in the same table as the primary key and are not globally available.</p> Signup and view all the answers

<p>To ensure the uniqueness of the data items</p> Signup and view all the answers

<p>Requests may be throttled</p> Signup and view all the answers

<p>Eventually consistent reads</p> Signup and view all the answers

<p>It provides atomicity and durability across multiple items</p> Signup and view all the answers

<p>The Segment and TotalSegments parameters must be provided</p> Signup and view all the answers

<p>Provisioned throughput across partitions</p> Signup and view all the answers

<p>It helps to reduce storage and manage table size over time.</p> Signup and view all the answers

<p>The item-level modifications in any DynamoDB table.</p> Signup and view all the answers

<p>Requests are throttled and can result in a Bad Request error.</p> Signup and view all the answers

<p>To improve flow control by waiting longer between retries.</p> Signup and view all the answers

<p>Use S3 to store large objects and reference them in DynamoDB.</p> Signup and view all the answers

<p>Concurrent updates overriding changes unexpectedly.</p> Signup and view all the answers

<p>Enables low-latency data access for globally dispersed users.</p> Signup and view all the answers

<p>To adjust provisioned throughput capacity based on actual traffic patterns.</p> Signup and view all the answers

<p>Multi-AZ RDS</p> Signup and view all the answers

<p>When using strongly consistent reads across multiple regions.</p> Signup and view all the answers

<p>DynamoDB provides built-in fault tolerance and self-healing capabilities.</p> Signup and view all the answers

<p>Deleting a replica table without impacting other replica tables in the global table.</p> Signup and view all the answers

<p>Auto Scaling is enabled by default when creating a table or global secondary index using the AWS Management Console.</p> Signup and view all the answers

<p>To ensure proper data replication and consistency across all replica tables.</p> Signup and view all the answers

<p>Reading data from a replica table in a different AWS region using eventually consistent reads.</p> Signup and view all the answers

<p>Multi-AZ RDS</p> Signup and view all the answers

<p>It provides an alternative range key local to the partition key.</p> Signup and view all the answers

<p>Query operations require a complete table scan to filter results.</p> Signup and view all the answers

<p>The main table will be throttled, even if there's sufficient WCU capacity allocated.</p> Signup and view all the answers

<p>Scan operations take longer and use more provisioned throughput.</p> Signup and view all the answers

<p>To avoid throttling on the main table due to capacity constraints on the GSI.</p> Signup and view all the answers

<p>Parallel scans can lead to increased latency for all read/write operations.</p> Signup and view all the answers

<p>When the application has a highly variable workload, with unpredictable spikes in traffic.</p> Signup and view all the answers

<p>To automatically expire and delete items based on a predefined time limit.</p> Signup and view all the answers

<p>GSIs create a new table with different partition and sort keys.</p> Signup and view all the answers

<p>Results will be returned in ascending order by default.</p> Signup and view all the answers

<p>Offers significant performance improvement for write operations, achieving a 10x speedup.</p> Signup and view all the answers

<p>Store large objects directly in DynamoDB, even if they exceed the 400KB limit.</p> Signup and view all the answers

<p>It provides a mechanism to automatically delete expired data based on a defined time frame.</p> Signup and view all the answers

<p>An LSI is used for indexing non-key attributes within the same partition, while a GSI allows indexing across multiple partitions.</p> Signup and view all the answers

<p>To provide a mechanism for auditing and tracking changes made to data in a DynamoDB table.</p> Signup and view all the answers

<p>A mobile gaming app with highly variable player engagement, experiencing spikes during promotions.</p> Signup and view all the answers

<p>Ensuring data consistency across multiple regions in a global table.</p> Signup and view all the answers

<p>The table continues to function, but read and write requests may be throttled.</p> Signup and view all the answers

<p>Items are composed of attributes that contain keys and associated values.</p> Signup and view all the answers

<p>Geographically distributed replicas of each table across three availability zones.</p> Signup and view all the answers

<p>The aggregate size of an item, including its keys and all attributes, cannot exceed 400KB.</p> Signup and view all the answers

<p>Identity-based policies managed through IAM for user access control.</p> Signup and view all the answers

<p>Using S3 pointers to link large items that cannot be stored directly in DynamoDB.</p> Signup and view all the answers

<p>DynamoDB primarily operates as a key-value and document database service.</p> Signup and view all the answers

<p>Exceeding provisioned throughput requirements</p> Signup and view all the answers

<p>It accesses every item in the table regardless of specific filters.</p> Signup and view all the answers

<p>When the application requires real-time data accuracy</p> Signup and view all the answers

<p>It enables the grouping of items by multiple attributes.</p> Signup and view all the answers

<p>Each operation must succeed for the entire transaction to be valid.</p> Signup and view all the answers

<p>Access patterns exceeding 3000 RCU or 1000 WCU</p> Signup and view all the answers

<p>They must be confined to a single region for consistency.</p> Signup and view all the answers

<p>All replica tables must contain the same data items as the primary table.</p> Signup and view all the answers

<p>The same write capacity settings must be identical for all replica tables and secondary indexes.</p> Signup and view all the answers

<p>When the consumed capacity drops to zero.</p> Signup and view all the answers

<p>Use RDS with Multi-AZ deployment for redundancy.</p> Signup and view all the answers

<p>It does not automatically scale down provisioned capacity if usage declines.</p> Signup and view all the answers

<p>Enhanced fault tolerance that supports automatic failovers.</p> Signup and view all the answers

<p>Creates identical tables and manages data change propagation.</p> Signup and view all the answers

<p>Auto scaling increases the provisioned throughput to match demand.</p> Signup and view all the answers

<p>Applications requiring high-frequency reads and minimal latency.</p> Signup and view all the answers