DynamoDB Author: CloudVikas Published Date: 18 January 2021 Welcome to your DynamoDB 1. Can I delete local secondary indexes?NoYes2. Can I add local secondary indexes to an existing table?noyes3. What are the correct options for DynamoDB? 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. 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 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 Scalable - User can store unlimited amount of data. DynamoDB scales horizontally by expanding a single table over multiple server All data items are stored on Solid State Disks (SSDs) and automatically replicated across multiple availability zones in a region Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. DynamoDB offers encryption at rest, which eliminates the operational burden and complexity involved in protecting sensitive data. Deployable only on AWS and can be installed on individual desktops/servers (adsbygoogle = window.adsbygoogle || []).push({});4. What are API calls supported by a global secondary index? “Scan” is the API call that are supported by Global Secondary Index. “Query” is the API call that are supported by Global Secondary Index. None of these5. How to delete a Global Secondary Index in Amazon DynamoDB? A Global secondary index can be deleted from the console or through an API call. 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. A Global Secondary Index can also be deleted using the Update Table API call. A Global Secondary Index can not be deleted using the Update Table API call. None of these6. How many local secondary indexes can be created on one table?457. What are Projections in Dynamodb? 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 indexes They are in addition to the index key attributes and primary key attributes which are automatically projected.Please fill in the comment box below. Time is Up! Time's up Author: CloudVikas
