dynamoDB Global Tables

Question 1

What does DynamoDB Global Tables allow you to do?

Answer 1

DynamoDB Global Tables allows you to automatically replicate tables across AWS regions.

Question 2

How are tables synchronized in DynamoDB Global Tables?

Answer 2

Tables are synchronized via DynamoDB Streams.

Question 3

What Streams view type should be enabled to use Global Tables?

Answer 3

To use global tables, enable the NEW_AND_OLD_IMAGES Streams view type.

Question 4

What conflict resolution strategy does DynamoDB use?

Answer 4

DynamoDB uses LAST WRITER WINS to resolve conflicts.

Question 5

Is failover automatic in DynamoDB Global Tables?

Answer 5

No, failover is not automatic. If a region goes down, you need to implement failover in your application.

Question 6

What should be considered when selecting regions in DynamoDB Global Tables?

Answer 6

You still need to consider latency. Latency will be higher the further away data has to be replicated.

Question 7

What is PartiQL used for in DynamoDB?

Answer 7

PartiQL allows you to run SQL queries on DynamoDB tables.

Question 8

What are the requirements for running queries with PartiQL?

Answer 8

Table and column names need to match case when using PartiQL.

Question 9

Can WHERE clauses be used on non-partitioned key columns in DynamoDB PartiQL?

Answer 9

Yes, WHERE clauses can be used on non-partitioned key columns, but under the covers, PartiQL will just run a full SCAN and filter the results.

Question 10

What should be used to keep DynamoDB PartiQL queries efficient?

Answer 10

Use indexes to keep DynamoDB PartiQL queries efficient.