DynamoDB Author: CloudVikas Published Date: 18 January 2021 Leave a Comment on DynamoDB Welcome to your DynamoDB 1. What are the correct options for DynamoDB? Deployable only on AWS and can be installed on individual desktops/servers DynamoDB scales horizontally by expanding a single table over multiple server Scalable - User can store unlimited amount of data. All data items are stored on Solid State Disks (SSDs) and automatically replicated across multiple availability zones in a region One year free tier allows more than 40 million database operations/month and pricing is based on throughput (read/write per second) rather than storage Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. Joins,Triggers,foreign keys concept are possible Querying data is not limited DynamoDB uses proven secured methods to authenticate users and prevent unauthorized data access DynamoDB lets you offload the administrative burdens of operating and scaling a distributed database, so that you don't have to worry about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling. DynamoDB offers encryption at rest, which eliminates the operational burden and complexity involved in protecting sensitive data.2. How to delete a Global Secondary Index in Amazon DynamoDB? Select the table from which you want to delete the Global Secondary index on the console, select the “indexes” tab under “Table items” and then click on the “Delete” button which is next to the delete index. None of these A Global secondary index can be deleted from the console or through an API call. A Global Secondary Index can not be deleted using the Update Table API call. A Global Secondary Index can also be deleted using the Update Table API call.3. What are API calls supported by a global secondary index? None of these “Query” is the API call that are supported by Global Secondary Index. “Scan” is the API call that are supported by Global Secondary Index.4. How many local secondary indexes can be created on one table?455. Can I delete local secondary indexes?YesNo6. Can I add local secondary indexes to an existing table?noyes7. What are Projections in Dynamodb? They are in addition to the index key attributes and primary key attributes which are automatically projected. Projections are the set of attributes that are copied or projected from the table to an index. Whenever you define a local secondary index, it is required to specify the attributes that are projected into the index. Each index consists of a minimum of 3 attributes, and they are: • Table partition key value • Attribute to serve as the index sort key • Table sort key value Projections are the set of indexesPlease fill in the comment box below. Time is Up! Author: CloudVikas
