ACD200 practice question 12 of 15

An organization has decided to integrate with a third-party to scan incoming documents and capture the details in a table called [appian].[document]…

Full set: 77 questions
An organization has decided to integrate with a third-party to scan incoming documents and capture the details in a table called [appian].[document]. Each document will form a new case in Appian to be displayed on a Record List. The record needs to show data from both [appian].[document] and [appian].[caseData], which holds additional case information. What is the most efficient way to achieve this?
Answer options
A: Create a trigger on the [appian].[document] table to copy all the data across to the [appian].[caseData] table and point the record at [appian].[caseData].
B: Create a SSIS package to run at a regular interval.
C: Create a view between both the [appian].[document] and [appian].[caseData] tables to feed the record. Correct answer
D: Create a stored procedure to query the data from both the [appian].[document] and [appian].[caseData] tables.
Correct Answer:
C. Create a view between both the [appian].[document] and [appian].[caseData] tables to feed the record.
Explanation

The most efficient and standard Appian design pattern for this requirement is to use a database view. A view creates a virtual table by joining the [appian].[document] and [appian].[caseData] tables. Appian can then use this single view as the data source for the record type. This approach avoids data duplication, ensures data is always current, and centralizes the join logic within the database, which is optimized for such operations. This allows Appian's query engine to efficiently filter, sort, and page the combined data for the record list.

Why Incorrect

A. Creating a trigger to copy data results in data duplication. This is inefficient, increases storage requirements, and introduces potential data integrity and maintenance complexities.
B. An SSIS package is a batch process that runs on a schedule. This would introduce data latency, meaning the record list would not display real-time information.
D. An Appian record type cannot directly use a stored procedure as its queryable data source. Record types require a table or view that Appian can dynamically query for filtering, sorting, and paging.

References

1. Appian Documentation

Record Type Object: "The source of a record type can be a process model

a database table or view

or a Salesforce object." This confirms that a view is a valid and intended data source.

Source: Appian 23.4 Documentation

"Objects" -> "Record Type Object".

2. Appian Documentation

Database Schema Best Practices: "Use views to pre-join or de-normalize data. If you have a normalized schema

create views to de-normalize the data for use in Appian... This is the most common and recommended way to create a read-only data source for records and read-only grids."

Source: Appian 23.4 Documentation

"Data" -> "Database Schema Best Practices" -> "Denormalization".

Scroll to Top