Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
What sets apart a materialized view from a standard database view?
A
A materialized view can only be used in relational databases, while a standard view is specific to NoSQL databases.
B
There is no difference; both are terms used interchangeably in the context of database management.
C
A materialized view stores the output of a query physically on disk, whereas a standard view does not store any data but provides a virtual view based on a query.
D
A materialized view automatically updates in real-time as the underlying data changes, whereas a standard view requires manual refresh.