Answer-first summary for fast verification
Answer: A materialized view should be used as it can be refreshed by the end users, as and when required.
A materialized view is a special type of view that has physical storage. Once a materialized view is registered, the query results are stored. Whenever the REFRESH command is executed over the materialized view, it recalculates its query results to incorporate any modifications or updates that have occurred in the upstream datasets. In essence, the materialized view can be brought up-to-date either manually or by using the CRON schedule, ensuring that it accurately reflects the most recent changes and data available from its source datasets. More Info: Materialized Views in Databricks
Author: LeetQuiz Editorial Team
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.
No comments yet.