Exam ACD200 topic 1 question 9 discussion

Materialized View MariaDB: https://community.appian.com/success/w/guide/3323/use-database-and-materialized-views-in-appian

Materialized View is the correct answer. Because the question mentions refresh window of 2 hours we can assume its directly referring to a materialized view's ability to update at intervals. That being said you could also create a read only table that is updated via a stored procedure. As Materialized views are not support in the default MariaDB but they would be supported in something like Postgres

Correct answer is C) Stored Procedure.

A materialised view is a physical table that holds the results of the SQL that a VIEW would normally be constructed from and can be generated periodically.

Correct Answer is Materialized View

why not "Materialize View" is the correct answer