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. Materialized view
• B. Table
• C. View
• D. Stored procedure

A lead designer receives this requirement:
Every time a record is modified, the data changed must be stored for audit.
Which design is the most efficient and has the least impact on the Appian application? (Choose the best answer.)

• A. Create a web API call to an audit history system and write the audit trail to file.
• B. Create a custom plugin that can write an audit trail to a log file.
• C. Create an Appian process to capture the change history and write the audit trail to the database.
• D. Create a trigger on the database table to capture the audit trail to a table.

You need to build a process model that transforms a large data set.
Which two things should you ensure to include in your process model? (Choose two.)

• A. A subprocess is called using "Multiple Node Instances (MNI)" to perform the transformation on each item in the data set.
• B. The transformation is applied with an expression rule that takes the data set as an input, and loops through the dataset using a looping function, such as foreach.
• C. A loop is created within the process model that increments on each iteration, updating that particular row in the data set.
• D. An XOR gateway is added before the transformation node, to check for empty/null values.

Users are reporting that their application is slow to load customer records with many transactions.
Using performance monitoring tools, you find that the following interface definition is responsible for the vast majority of page load time:

You also notice that both queries (rule!APP_GetTransactionsWithFilters and rule!APP_GetTransactionTypeWithFilters) take about 25 milliseconds each to execute when you test them using expression editor.
Which change would decrease the load time of this interface component the most? (Choose the best answer.)

• A. Prefetched transation types and use the displayvalue() function to display the Transaction Type for each transaction.
• B. Don't fetch total count when getting transactions.
• C. Use a synced record for Transactions to improve the query response time for the query performed on line 6.
• D. On line 4, increase the paginginfo batch size to 50 so more data is prefetched.