DynamoDB Query Params Flashcards

1
Q

What Are the DB Query Params

A

TableName
KeyConditionExpression
ExpressionAttributeValues
ProjectionExpression
FilterExpression
Limit
ExclusiveStartKey
ConsistentRead

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

TableName

A

Name of table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

KeyConditionExpression

A

specify the partition key and sort key (together make the composite primary key)
Example: Partition Key: author_id
Sort Key: post_date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

ExpressionAttributeValues

A

like values array in sql queries (for injection attacks)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ProjectionExpression

A

Specify which columns you want

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

FilterExpression

A

condition for filtering

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Limit

A

limit number of items evaluated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

ExclusiveStartKey

A

Used for pagination. It’s the last key in a previously received response, allowing you to retrieve the next set of results from where the last query left off.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

ConsistentRead

A

Query uses “eventually consistent” reads. Setting this to true, all responses are up to date.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly