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 questionsThe 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.
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.
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".
Keep practicing
Take the free ACD200 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ACD200 practice questions
- Question 9Which of the following is a sign that an application’s performance is degrading and shoul…
- Question 10You need to build a QC review process for a factory that allows a technician to review ea…
- Question 11Which two statements about the a!queryEntity() function are true? (Choose two.)
- Question 13In the next year, you expect the number of concurrent active users of your application to…
- Question 14When creating a Web API, which two items are configured in the Administration Console? (C…
- Question 15You need to insert the deleted row of a table into a history table for audit purposes. Wh…
