DynamoDB Author: CloudVikas Published Date: 18 January 2021 Welcome to your DynamoDB 1. What are the correct options for DynamoDB? DynamoDB offers encryption at rest, which eliminates the operational burden and complexity involved in protecting sensitive data. Scalable - User can store unlimited amount of data. Deployable only on AWS and can be installed on individual desktops/servers Querying data is not limited DynamoDB scales horizontally by expanding a single table over multiple server DynamoDB uses proven secured methods to authenticate users and prevent unauthorized data access Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. 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 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. All data items are stored on Solid State Disks (SSDs) and automatically replicated across multiple availability zones in a region Joins,Triggers,foreign keys concept are possible2. What are Projections in Dynamodb? 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 attributes that are copied or projected from the table to an index. They are in addition to the index key attributes and primary key attributes which are automatically projected. Projections are the set of indexes3. Can I add local secondary indexes to an existing table?yesno (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. None of these “Query” is the API call that are supported by Global Secondary Index.5. 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. A Global Secondary Index can also be deleted using the Update Table API call. None of these 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 not be deleted using the Update Table API call.6. How many local secondary indexes can be created on one table?547. Can I delete local secondary indexes?NoYesPlease fill in the comment box below. Time is Up! Time's up Author: CloudVikas
