Exam ACD200 topic 1 question 9 discussion

Actual exam question from Appian's ACD200

Question #: 9
Topic #: 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.)

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

Show Suggested Answer

Suggested Answer: C 🗳️

by Anx at Nov. 12, 2022, 6:18 a.m.

Comments

Submit Cancel

[Removed]

10 months, 3 weeks ago

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

upvoted 1 times

...

jordan26923

1 year, 4 months ago

Selected Answer: D

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

upvoted 1 times

...

harshmp1007

1 year, 5 months ago

Correct answer is C) Stored Procedure.

upvoted 1 times

...

jreaver

1 year, 7 months ago

Selected Answer: D

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.

upvoted 1 times

...

Jdhar1566

1 year, 7 months ago

Correct Answer is Materialized View

upvoted 1 times

...

Anx

2 years ago

why not "Materialize View" is the correct answer

upvoted 2 times

Tumadre

1 year, 11 months ago

Did you pass the examen?

upvoted 1 times

...