Exam AWS Certified Database - Specialty topic 1 question 151 discussion

BC is the correct Answer. A is NOT an issue. I've tested this by creating a different table name in a destination region with TWO GSIs one with the exact same name and indexes and one with a different name and index than the original table. GSIs are table specific. The Key constraint is a table with the same name should NOT exist and permissions to access should be there

A. A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired. If global secondary indexes are specified, then the following conditions must also be met: The global secondary indexes must have the same name. The global secondary indexes must have the same hash key and sort key (if present). https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_CreateGlobalTable.html The table must have the same name as all of the other replicas. (means B is out) C. No role with the dynamodb:CreateGlobalTable permission exists in the account. To create and maintain global tables in DynamoDB, you must have the dynamodb:CreateGlobalTable permission to access each of the following: The replica table that you want to add. Each existing replica that's already part of the global table. The global table itself. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/gt_IAM.html

AC "Requirements for adding a new replica table" If you want to add a new replica table to a global table, each of the following conditions must be true: The table must have the same partition key as all of the other replicas. The table must have the same write capacity management settings specified. The table must have the same name as all of the other replicas. The table must have DynamoDB Streams enabled, with the stream containing both the new and the old images of the item. None of the new or existing replica tables in the global table can contain any data. If global secondary indexes are specified, the following conditions must also be met: The global secondary indexes must have the same name. The global secondary indexes must have the same partition key and sort key (if present). https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/globaltables_reqs_bestpractices.html

AC An empty table is not a problem

To create and maintain global tables in DynamoDB, you must have the dynamodb:CreateGlobalTable permission to access each of the following: The global secondary indexes must have the same partition key and sort key (if present). https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/globaltables_reqs_bestpractices.html#globaltables_reqs_bestpractices.requirements

According doc: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/globaltables_reqs_bestpractices.html#globaltables_reqs_bestpractices.requirements 1. The global secondary indexes must have the same partition key and sort key (if present). . Thus, A B: Doc: None of the new or existing replica tables in the global table can contain any data. Thus, empty table with same name is OK

BC: GSI allow distinct combination of partition and sort key so A is not a problem. D and E are not an issue.

BC for me

Why not B & E . The CMK are region specific. There is no mention that there the DB specialst has the CMK for the new region --https://aws.amazon.com/about-aws/whats-new/2020/11/encrypt-your-amazon-dynamodb-global-tables-by-using-your-own-encryption-keys/

Anser AB https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/globaltables_reqs_bestpractices.html Requirements for adding a new replica table If you want to add a new replica table to a global table, each of the following conditions must be true: The table must have the same partition key as all of the other replicas. The table must have the same write capacity management settings specified. The table must have the same name as all of the other replicas. The table must have DynamoDB Streams enabled, with the stream containing both the new and the old images of the item. None of the new or existing replica tables in the global table can contain any data. If global secondary indexes are specified, the following conditions must also be met: The global secondary indexes must have the same name. The global secondary indexes must have the same partition key and sort key (if present).

A. No issue : as long as same index_name don't exist & it will create new 2nd index

B and C C: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/gt_IAM.html To create and maintain global tables in DynamoDB, you must have the dynamodb:CreateGlobalTable permission to access. B: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/globaltables.tutorial.html The console checks to ensure that a table with the same name doesn't exist in the selected Region. If a table with the same name does exist, you must delete the existing table before you can create a new replica table in that Region.

1. No role with DynamoDB, but Account with CreateGlobalTable permiession, so no issues to create Global table. 2. Change Sort key when replicate a table - don't think so 3. Name exists in another region - Error pop-up.

BC!!!!!

B,C https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/globaltables.tutorial.html From the Available replication Regions dropdown, choose US West (Oregon). The console checks to ensure that a table with the same name doesn't exist in the selected Region. If a table with the same name does exist, you must delete the existing table before you can create a new replica table in that Region.

Should be A and C

Options A and B.