A CustomerOrders DynamoDB table has the following items.
Customer Name (PK)
Order Item
Cost
Albert Einstein
Candle
15
Albert Einstein
Spaceship Toy
50
Albert Einstein
Hair Comb
5
Isaac Newton
Bag of Apples
15
Which operation would you use to find all orders with costs greater than 10?

Answer options:

A.query operation with “--key-condition-expression” parameter
B.query operation with “--filter-expression” parameter
C.scan operation with “--filter-expression” parameter
D.scan operation with “--projection-expression” parameter

Answer: C
Option A is incorrect because a query operation requires a partition key name and value to be specified (Customer Name in this case). This would limit results to a specific customer.
Option B is incorrect because a query operation requires a partition key name and value to be specified (Customer Name in this case). This would limit results to a specific customer.
Option C is CORRECT because a scan operation can be used to read every item in a table.A filter expression parameter can be used to narrow down the results based on some required criteria (Cost of the item in this case).
Option D is incorrect because the projection-expression parameter is used to limit what attributes are returned as part of the result.
Reference:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Query.html
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Scan.html