Appian Lead Developer (ACD200) — Question 1

You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result set after executing the Joins.
The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority.
What should you use? (Choose the best answer.)

Answer options

• A. Table
• B. View
• C. Stored procedure
• D. Materialized view

Correct answer: D

Explanation

A Materialized view is the best choice because it stores the result of the query physically, allowing for quicker access and improved performance, especially with large datasets. Other options like a Table and View do not provide the same performance benefits for large joins, while a Stored procedure is more suited for dynamic data retrieval rather than precomputed results.