You’re currently working with a table in DynamoDB. Your program has inserted several rows in the table. You now need to read the data from the table and only retrieve certain attributes in the query. Which of the following would you use for this purpose?

Answer options:

A.The scan operation only since only this supports the filtering of certain attributes.
B.The query operation only since only this supports the filtering of certain attributes.
C.Use the Projection Expression.
D.Use the Index name.

Answer – C
The AWS Documentation mentions the following.
To read data from a table, you use operations such as GetItem, Query, or Scan. DynamoDB returns all of the item attributes by default. To get just some, rather than all of the attributes, use a projection expression.
A projection expression is a string that identifies the attributes you want. To retrieve a single attribute, specify its name. For multiple attributes, the names must be comma-separated.
Options A and B are incorrect since Projection Expression is available in both the scan and query operation.
Option D is invalid since you need to use the Projection Expression.
For more information on projection expressions, please refer to the below URL-
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Expressions.ProjectionExpressions.html