Bird
0
0

Which of the following is the correct syntax to define a Global Secondary Index (GSI) in a DynamoDB table using AWS CloudFormation?

easy📝 Configuration Q12 of 15
AWS - DynamoDB
Which of the following is the correct syntax to define a Global Secondary Index (GSI) in a DynamoDB table using AWS CloudFormation?
A"GlobalSecondaryIndexes": [{"IndexName": "GSI1", "KeySchema": [{"AttributeName": "UserId", "KeyType": "HASH"}], "Projection": {"ProjectionType": "KEYS_ONLY"}}]
B"LocalSecondaryIndexes": [{"IndexName": "GSI1", "KeySchema": [{"AttributeName": "UserId", "KeyType": "HASH"}], "Projection": {"ProjectionType": "ALL"}}]
C"GlobalSecondaryIndexes": [{"IndexName": "GSI1", "KeySchema": [{"AttributeName": "UserId", "KeyType": "RANGE"}], "Projection": {"ProjectionType": "ALL"}}]
D"GlobalSecondaryIndexes": [{"IndexName": "GSI1", "KeySchema": [{"AttributeName": "UserId", "KeyType": "HASH"}], "Projection": {"ProjectionType": "ALL"}}]
Step-by-Step Solution
Solution:

  1. Step 1: Identify correct index type and key schema

    GlobalSecondaryIndexes is the correct property for GSI, and the partition key must have KeyType "HASH".

  2. Step 2: Check projection type and syntax

    ProjectionType "ALL" is valid and commonly used; syntax matches CloudFormation format.

  3. Final Answer:

    "GlobalSecondaryIndexes": [{"IndexName": "GSI1", "KeySchema": [{"AttributeName": "UserId", "KeyType": "HASH"}], "Projection": {"ProjectionType": "ALL"}}] -> Option D

  4. Quick Check:

    GSI uses GlobalSecondaryIndexes with HASH key [OK]
Quick Trick: GSI uses GlobalSecondaryIndexes with HASH key [OK]
Common Mistakes:
MISTAKES
  • Using LocalSecondaryIndexes for GSI
  • Setting KeyType to RANGE for partition key
  • Incorrect projection types or syntax errors

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More AWS Quizzes
API Gateway - Request and response mapping - Quiz 10hard AWS Lambda - Lambda pricing model - Quiz 15hard Auto Scaling - Scaling policies (target tracking, step, simple) - Quiz 7medium Auto Scaling - Scaling policies (target tracking, step, simple) - Quiz 11easy DynamoDB - Creating a DynamoDB table - Quiz 7medium DynamoDB - Creating a DynamoDB table - Quiz 13medium Elastic Load Balancing - ALB vs NLB decision - Quiz 10hard RDS and Relational Databases - RDS backup and snapshots - Quiz 3easy RDS and Relational Databases - RDS supported engines - Quiz 10hard SNS and SQS - SNS topics and subscriptions - Quiz 6medium