
Ultimate access to all questions.
A stocks managing firm stores the stocks prices data in a delta table. The data engineer from the firm needs to create a relational entity that can provide data to the end users for only those stocks that fall under the technical category. The relational entity should have physical storage and the end users should be able to refresh the data, as and when required. Which of the following relational entities can be used by the data engineer?
A
A temporary view that should be re-created daily.
B
A DataFrame should be used as filter transformations can be applied to it.
C
A materialized view should be used as it can be refreshed by the end users, as and when required.
D
A delta table should be used as it has physical storage.
E
Access to the original table should be given to all the users.