Question 1

You need to update the archival settings for a process model. You modified the automatic process
clean-up settings and selected the archive processes option with ‘n’ days.
Which instances of that process model will be affected? (Choose the best

Accepted Answer

Answer available on page.

Question 2

You are creating a table to store book information for a library. The boot has a reference number
(ISBN_ID), as well as a unique identifier (BOOK_ID).
For the CDT to be created, which data type should you choose for the BOOK_ID? (Choose the best

Accepted Answer

NUMBER (INTEGER)

Explanation: The BOOKID field is intended to be the unique identifier, or primary key, for the book data. According to Appian best practices for data design, the primary key for a Custom Data Type (CDT) that is mapped to a database table should be an auto-generating integer. The Number (Integer) data type is the correct selection to implement this. When this type is chosen and designated as the primary key in the CDT designer, Appian configures the underlying database column to automatically increment. This ensures a unique numeric value is generated for each new record, which is the standard and most efficient method for managing primary keys.

Question 3

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

Accepted Answer

USE A DATABASE TRIGGER.

Explanation: A database trigger is the most efficient design as it operates directly at the data source level, independent of the Appian execution engines. When a record is modified via any Appian action, the database trigger automatically captures the changes and writes them to an audit table within the same database transaction. This approach completely offloads the auditing logic from the Appian application, resulting in the lowest possible performance impact on Appian's servers. The auditing process is transparent to the Appian objects (e.g., process models, interfaces) that perform the data modification, ensuring minimal overhead and complexity within the application itself.

Question 4

HOTSPOT Match each of the business data concepts to an Appian data type. Each data type may be used once, more than once, or not at all. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Appian_ACD200/page_17_img_1.jpg

Accepted Answer

Answer available on page.

Question 5

As a developer, you have created a Web API. To execute the API, what is the minimum privilege the end user should have? (Choose the best

Accepted Answer

VIEWER

Explanation: To execute an Appian Web API, the calling user or service account must have a minimum of Viewer permissions to the Web API object. This aligns with the principle of least privilege, granting only the necessary rights to invoke the endpoint without allowing modification. Higher permission levels, such as Editor or Administrator, also permit execution but provide additional capabilities (e.g., editing the object's definition, managing security) that are not required for an end user to simply call the API. Therefore, Viewer is the correct minimum privilege level.

Question 6

Which review format is the most efficient way to coach team members and improve code quality? (Choose the best

Accepted Answer

Answer available on page.

Question 7

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

Accepted Answer

DATABASE VIEW

Explanation: A database view is the recommended and most performant solution for combining data from multiple tables into a single, denormalized source for Appian. This approach directly addresses the requirement to join five large tables. The view encapsulates the complex join logic at the database level. This view can then be used as the source for an Appian record type with data sync enabled. This pattern satisfies the performance and data freshness requirements by querying the fast, cached data source and refreshing it on the specified two-hour interval, avoiding costly real-time joins for every data request.

Question 8

You need to create a plug-in to perform a job in the background. The plug-in should not be available
under an expression rule, connected system, or the process model.
What type of plug-in should you create? (Choose the best

Accepted Answer

SERVLET

Explanation: A Servlet plug-in exposes a URL endpoint that executes custom Java code on the server when accessed. This allows it to perform background jobs when triggered by an external system or scheduler. Unlike other plug-in types, it is not designed to be directly available within the expression editor (like a Function plug-in), the process model palette (like a Smart Service plug-in), or as a Connected System template. This architecture meets all the requirements for a background job that is isolated from the standard Appian design objects mentioned in the question.

Question 9

Which of the following is a sign that an application’s performance is degrading and should be addressed with changes to the application design?

Accepted Answer

B

Explanation: A low completion percentage for frequently executed process models is a strong indicator of a design-related performance issue. It means that a significant number of process instances are starting but not finishing, remaining active in the system's memory. These lingering instances consume server resources, and as their numbers grow, they can lead to system-wide performance degradation. This problem is typically caused by design flaws such as unhandled exceptions, logic errors that lead to infinite loops, or poorly designed user tasks that are frequently abandoned. Rectifying this requires analyzing and redesigning the process models to ensure they run to completion efficiently.

Question 10

You need to build a QC review process for a factory that allows a technician to review each
production line on a regular basis.
A QC technician has 30 minutes to complete their review, after which time the review will expire and
be marked as a “missed review.” If this, occurs, a supervisor should be notified via email and the
review data should not be saved. Additional requirements are as follows:
The user should be able to save a draft of their review before submission, and come back to work on
it later.
Once submitted, the review data should be saved to the database.
Which option needs to be implemented to meet the requirements?

Accepted Answer

A

Explanation: This scenario requires a mechanism that both interrupts a task after a specific duration and triggers an alternative process flow. An exception timer on the User Input Task is the correct implementation. When the 30-minute timer expires, the exception path is triggered, which cancels the active task, preventing the user from submitting. This exception flow can then be directed to a Send Email smart service to notify the supervisor. Because the main flow is bypassed, the subsequent node to save data to the database is never executed, fulfilling all requirements.

Question 11

Which two statements about the a!queryEntity() function are true? (Choose two.)

Accepted Answer

C, D

Explanation: The a!queryEntity() function is a fundamental component for retrieving data from a data store entity in Appian. Option C is correct because the entity parameter of this function requires a direct reference to a Data Store Entity object, which must be passed as a constant. This ensures that the query target is statically defined, allowing Appian to perform necessary validations and optimizations. Option D is correct because the fetchTotalCount parameter, when set to true within the a!pagingInfo() configuration, triggers a second, separate query to count all records matching the filter criteria. Avoiding this extra database call by setting fetchTotalCount to false (which is the default behavior) improves performance, especially for large datasets.

Question 12

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?

Accepted Answer

C

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.

Question 13

In the next year, you expect the number of concurrent active users of your application to increase
from approximately 50 to 500.
Which two recommendations for your Appian environment would address the performance risk of
this large increase in users? (Choose two.)

Accepted Answer

B, C

Explanation: A tenfold increase in concurrent users places significant strain on the Appian environment's ability to process transactions and manage user sessions. 1. Adding more process execution engines (B) directly addresses the increased transactional load. Each engine can handle a finite number of active processes. Scaling out the execution engines distributes the workload, allowing the environment to process a much higher volume of concurrent user actions and process instances without creating a bottleneck. 2. Adding more application server memory (C) is crucial for accommodating the increased number of user sessions. Each active user consumes memory on the application server. Insufficient memory can lead to excessive garbage collection and OutOfMemoryError exceptions, severely degrading performance for all users.

Question 14

When creating a Web API, which two items are configured in the Administration Console? (Choose two.)

Accepted Answer

B, D

Explanation: When securing a Web API, two key components are managed within the Appian Administration Console. First, API Keys are generated and managed in the Admin Console to provide a credential for external systems to authenticate their requests. Second, Service Accounts, which are a special type of user account, are also created and managed in the Admin Console. These accounts are typically used in the "Run As" field of the Web API object to define the security context and permissions the API will have when executing its logic within the Appian environment.

Question 15

You need to insert the deleted row of a table into a history table for audit purposes. What is the most efficient method to achieve this?

Accepted Answer

D

Explanation: A database trigger is the most efficient method for this requirement. A trigger is a specialized stored procedure that executes automatically in response to a specific data modification event (e.g., DELETE) on a table. By using an AFTER DELETE trigger, the deleted row's data can be captured and inserted into a history table within the same database transaction. This approach is highly efficient as it occurs at the database level, minimizing network latency and application server overhead, and ensuring the audit action is atomic with the deletion.

Free Appian ACD200 Actual Exam Questions