Your manager has assigned you a task to write an API that will extract data from a DynamoDB table with 30 columns and more than 10,000 rows of open data. Not all the columns are relevant for your use-case. Hence your manager has asked you to filter out only 6 columns out of all and store them in your in-house data warehouse tool. How can you achieve this?

Answer options:

A.Use DataFilter operation while performing Scan operation.
B.Use ProjectionExpression operation while performing Query operation.
C.Use ProjectionExpression operation while performing Scan operation.
D.Use ColumnProjection operation while performing Query operation.

Correct Answer: C
Using ProjectionExpression with Scan operation is the correct answer because scan operation will fetch the entire table for you with only the columns mentioned in the ProjectionExpression attribute.
A is incorrect: DataFilter is an invalid attribute.
B is incorrect: Query operation is performed when you want to filter out data using Primary/Sort key combination, whereas, in the question, there is no such requirement. The task wants you to filter out data based on columns.
D is incorrect: ColumnProjection is an invalid attribute.
Reference: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Expressions.ProjectionExpressions.html