I85PREP
⌘ K
Appian ACD201 study materials
Appian ACD201 study resources

Appian ACD201 practice questions

One question at a time. Build your Appian ACD201 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Modeling and Data Management

In Appian, which object is used to define the structure of a record type and its fields?

  1. A process model with a script task
  2. A constant of type Text
  3. The record type object itself, configured with fields in the data model Correct answer.
  4. An interface with a grid component

Explanation

A record type defines the data structure, including its fields, relationships, and source. Fields are configured directly on the record type rather than in process models or interfaces.

Question 2Data Modeling and Data Management

Which Appian data type is best suited to store a true/false value?

  1. Integer
  2. Text
  3. Date
  4. Boolean Correct answer.

Explanation

The Boolean data type holds one of two values, true or false. Integer, Text, and Date cannot natively represent a two-state logical value.

Question 3Data Modeling and Data Management

What is the primary purpose of a data store entity in Appian?

  1. To map a record type to a relational database table Correct answer.
  2. To render a form to an end user
  3. To schedule a process model
  4. To define a user group hierarchy

Explanation

A data store entity links an Appian record type to a physical table in a configured data source. This mapping lets the record read and write relational data.

Question 4Data Modeling and Data Management

A developer wants the value of a record field to be calculated from other fields rather than stored in the database. Which field configuration achieves this?

  1. Mark the field as a computed field with an expression Correct answer.
  2. Enable the field as a foreign key
  3. Set the field as a primary key
  4. Assign the field a default value constant

Explanation

Computed fields derive their value at runtime from an expression instead of persisting a column value. Primary keys, foreign keys, and default values all relate to stored data.

Question 5Data Modeling and Data Management

Which relationship type allows many records of one record type to be associated with many records of another?

  1. Parent-to-child only
  2. Many-to-many Correct answer.
  3. One-to-one
  4. One-to-many

Explanation

A many-to-many relationship links multiple rows on each side, typically through an association or join table. One-to-one and one-to-many restrict cardinality on one side.

Question 6Data Modeling and Data Management

A record type is configured with a database-backed data store entity. Which action writes a new row to the underlying table?

  1. Viewing the record in a read-only grid
  2. Using a Write to Data Store Entity smart service or a record action that saves data Correct answer.
  3. Adding the record type to a process model variable
  4. Querying the record type with a!queryRecordType

Explanation

Persisting data requires a write operation, such as the Write to Data Store Entity smart service or a record action configured to save. Querying or viewing data only reads.

Question 7Data Modeling and Data Management

Which Appian function is used to retrieve data from a record type in an expression?

  1. a!writeToDataStoreEntity
  2. a!save
  3. a!startProcess
  4. a!queryRecordType Correct answer.

Explanation

a!queryRecordType executes a query against a record type and returns matching data. The other functions handle writing, process execution, and local variable assignment.

Question 8Data Modeling and Data Management

A developer needs to ensure each row in a record type is uniquely identifiable. Which field configuration is required?

  1. A computed field
  2. A primary key field Correct answer.
  3. A text field with a default value
  4. A field marked as searchable

Explanation

The primary key uniquely identifies each row and is required for database-backed record types. Computed fields, defaults, and searchability do not guarantee uniqueness.

Question 9Data Modeling and Data Management

Which data type should be used to store a monetary amount with decimal precision?

  1. Boolean
  2. Decimal Correct answer.
  3. Integer
  4. Time

Explanation

The Decimal data type holds fractional numeric values, which suits monetary amounts. Integer cannot store fractions, and Boolean and Time are unrelated.

Question 10Data Modeling and Data Management

A record type must display data from an external relational database without copying it into Appian's primary store. Which configuration supports this?

  1. A local variable in an interface
  2. A constant of type Integer
  3. A data store entity pointing to an external data source Correct answer.
  4. A process variable of type Text

Explanation

Data store entities can map to external data sources, letting record types read and write external tables directly. Local variables, process variables, and constants do not connect to external databases.

Question 11Data Modeling and Data Management

Which statement best describes a one-to-many relationship between a Customer record type and an Order record type?

  1. Each customer must have exactly one order
  2. One customer can be associated with many orders, but each order belongs to one customer Correct answer.
  3. Many customers can share the same order
  4. Orders and customers cannot be related

Explanation

In a one-to-many relationship, a single parent record links to multiple child records, while each child links back to one parent. This matches one customer with many orders.

Question 12Data Modeling and Data Management

What does a foreign key field represent in a record type?

  1. A field used only for display formatting
  2. A reference to the primary key of a related record Correct answer.
  3. A calculated value derived from other fields
  4. A field that must be unique across all rows

Explanation

A foreign key stores a value that references the primary key of another table, establishing the relationship between records. It is not inherently unique or computed.

Question 13Data Modeling and Data Management

A developer wants to filter a record query to return only active customers. Which query configuration is most appropriate?

  1. Select all fields in the record type
  2. Add a filter on the status field equal to "Active" Correct answer.
  3. Increase the batch size of the query
  4. Sort the results by creation date

Explanation

Filters restrict returned rows based on field criteria, so filtering on status returns only active customers. Sorting, batch size, and field selection do not restrict which rows match.

Question 14Data Modeling and Data Management

Which Appian object stores a reusable, named value that can be referenced across many objects?

  1. A rule input
  2. A process variable
  3. A constant Correct answer.
  4. A local variable

Explanation

Constants hold named values that can be referenced application-wide and are centrally managed. Local and process variables exist only within their runtime scope.

Question 15Data Modeling and Data Management

A record type's data source is a web service rather than a database. Which integration approach is used?

  1. A group with a membership rule
  2. An integrated record type backed by an integration object Correct answer.
  3. A data store entity mapped to a table
  4. A process model with an escalation

Explanation

Integrated record types source data through integration objects that call external services. Data store entities map to databases, while escalations and groups are unrelated to data sourcing.

Question 16Data Modeling and Data Management

Which practice best supports data integrity when deleting a parent record that has related child records?

  1. Delete the parent and ignore the children
  2. Define referential handling so child records are not orphaned Correct answer.
  3. Remove the primary key before deletion
  4. Disable all validation on the record type

Explanation

Referential integrity ensures child records remain consistent when a parent is removed, avoiding orphaned rows. Ignoring children, disabling validation, or dropping keys undermines integrity.

Question 17Data Modeling and Data Management

A developer needs a field value to default to the current date and time when a record is created. Which configuration applies?

  1. Set the field's default value to now() Correct answer.
  2. Enable the field as a foreign key
  3. Mark the field as a primary key
  4. Make the field a computed field using a constant

Explanation

A default value expression such as now() populates the field at creation time. Primary keys, foreign keys, and constant-based computed fields do not provide the current timestamp.

Question 18Data Modeling and Data Management

Which data type would correctly store a file attachment reference in a record field?

  1. Document Correct answer.
  2. Integer
  3. Time
  4. Boolean

Explanation

The Document data type references uploaded files and attachments in Appian. Integer, Boolean, and Time cannot represent file references.

Question 19Data Modeling and Data Management

What is the effect of marking a record field as searchable?

  1. The field becomes the primary key
  2. The field is hidden from all interfaces
  3. The field can be used in record search and filter criteria efficiently Correct answer.
  4. The field is converted to a computed value

Explanation

Searchable fields are indexed so users and queries can search and filter on them efficiently. It does not affect keys, visibility, or computation.

Question 20Data Modeling and Data Management

A developer must synchronize reference data from an external system on a recurring schedule. Which combination is most appropriate?

  1. A read-only interface and a grid
  2. A process model with a timer and a write to a data store entity Correct answer.
  3. A record action and a form
  4. A constant and a group

Explanation

A scheduled process model can run on a timer and persist the retrieved data via a write to a data store entity. Interfaces, constants, groups, and forms do not perform scheduled synchronization.

Question 21Data Modeling and Data Management

Which statement about record type field names is accurate?

  1. Field names should be unique within the record type and referenced consistently in expressions Correct answer.
  2. Field names are ignored by expressions
  3. Field names must always be numeric
  4. Field names may duplicate freely within one record type

Explanation

Each field needs a distinct name within its record type so expressions can reference it unambiguously. Duplicated or numeric-only names would break references.

Question 22Data Modeling and Data Management

A query returns more rows than needed for a dashboard summary. Which approach improves performance most directly?

  1. Select only the required fields and apply filters to limit rows Correct answer.
  2. Increase the number of record actions
  3. Sort by every field in the record
  4. Retrieve all fields and all rows then filter in the interface

Explanation

Limiting selected fields and filtering rows reduces the data transferred and processed. Fetching everything and filtering later wastes resources.

Question 23Data Modeling and Data Management

Which Appian feature lets a record type expose related records as a nested list on a parent record?

  1. A constant of type Text
  2. An escalation on a process model
  3. A process variable
  4. A one-to-many relationship configured on the record type Correct answer.

Explanation

A one-to-many relationship lets a parent record surface its related child records as a list. Constants, process variables, and escalations do not model relationships.

Question 24Data Modeling and Data Management

What is the purpose of a record action in Appian?

  1. To schedule a process model
  2. To render a static label
  3. To define an operation such as create, update, or delete on a record type Correct answer.
  4. To group users by role

Explanation

Record actions define the operations users can perform on records, including creating, updating, and deleting. Scheduling, labels, and groups serve different purposes.

Question 25Data Modeling and Data Management

A record type stores a status that can only be one of three defined values. Which mechanism best enforces this constraint?

  1. A foreign key to an unrelated table
  2. A validation that restricts the field to the allowed values Correct answer.
  3. A default value of null
  4. A computed field with no expression

Explanation

Validation enforces that only permitted values are accepted, protecting data quality. Computed fields, unrelated foreign keys, and null defaults do not restrict allowed values.

Question 26Data Modeling and Data Management

Which Appian data type is designed to store a whole number without fractional digits, such as a quantity ordered?

  1. Decimal
  2. Text
  3. Boolean
  4. Integer Correct answer.

Explanation

Integer stores whole numbers with no fractional component, which fits counts and quantities. Decimal is intended for values that require a fractional part.

Question 27Data Modeling and Data Management

A developer wants each record to capture a yes/no approval outcome. Which data type is the most direct fit?

  1. Date
  2. Integer
  3. Text
  4. Boolean Correct answer.

Explanation

Boolean is the native type for two-state true/false values and renders naturally as a checkbox. Other types would require convention-based encoding.

Question 28Data Modeling and Data Management

What is the primary purpose of a record type in Appian?

  1. To schedule process model execution at fixed intervals
  2. To model a business entity and its data so it can be queried, displayed, and acted upon Correct answer.
  3. To store static credentials for outbound integrations
  4. To define a reusable user interface layout

Explanation

A record type is the data modeling object that represents a business entity and centralizes its data source, fields, relationships, and actions. Interfaces, process scheduling, and credential storage are handled by other object types.

Question 29Data Modeling and Data Management

A developer needs a field to hold a reference to a user in the system so the value can drive task assignment. Which data type should the field use?

  1. Group
  2. Integer
  3. Text
  4. User Correct answer.

Explanation

The User type stores a reference to a single Appian user and integrates with assignment and identity functions. Group represents a collection of users rather than one person.

Question 30Data Modeling and Data Management

A record type must be populated by copying rows from an external system into Appian's own storage on a schedule. Which data source configuration supports this?

  1. A database-backed record type whose data store entity is refreshed by a data sync Correct answer.
  2. A service-backed record type that calls the external API at read time
  3. A process-backed record type that stores values only in memory
  4. A record type with no data source that relies on process variables

Explanation

A database-backed record type stores rows in Appian-managed tables, and a data sync populates or refreshes those rows from the external source. Service-backed types read live data instead of copying it.

Question 31Data Modeling and Data Management

A developer needs a query that returns only records whose region field equals a value supplied at runtime by the user. What should the query use?

  1. A field marked as searchable with no filter
  2. A sort configured on the region field
  3. A filter configured with a rule input or parameter comparison Correct answer.
  4. A constant that hard-codes the region value

Explanation

Filters compare a field against a value, and that value can be supplied dynamically through a rule input or query parameter. Hard-coding or sorting does not restrict the returned rows.

Question 32Data Modeling and Data Management

A developer wants a query to return a limited number of rows for a preview panel instead of the full result set. Which query setting accomplishes this?

  1. A sort on the creation timestamp
  2. A filter on a primary key field
  3. A paging configuration with a maximum number of results Correct answer.
  4. A searchable field configuration

Explanation

Paging settings control how many rows a query returns and how additional batches are fetched. Filters restrict which rows qualify but do not cap the count by themselves.

Question 33Data Modeling and Data Management

Which statement correctly describes how a record type relationship is expressed?

  1. A relationship is only possible between record types that share the same data store entity
  2. A relationship links a field on one record type to a field on another record type to express association Correct answer.
  3. A relationship replaces the need for a primary key on either record type
  4. A relationship copies all child rows into the parent record's table

Explanation

Relationships map a field on one record type to a matching field on another, letting queries traverse the association. They do not copy data or eliminate key requirements.

Question 34Data Modeling and Data Management

A record type must present a parent record together with its related child records on a single record view. Which configuration enables this?

  1. A searchable field on the child record type
  2. A related record list configured on the parent record type Correct answer.
  3. A constant holding the child identifiers
  4. A process model that writes child rows on save

Explanation

A related record list uses a relationship to surface child records within the parent's record view. The other options do not provide a nested display of related rows.

Question 35Data Modeling and Data Management

A developer needs the same maximum-retry value used consistently by several integrations. Which Appian object should hold this value?

  1. A constant referenced by each integration Correct answer.
  2. A record field on a user record type
  3. A process variable defined per instance
  4. A local variable inside each integration

Explanation

A constant stores a single named value that many objects can reference, so a change propagates everywhere. Local and process variables are scoped to a single execution context.

Question 36Data Modeling and Data Management

Which Appian function returns the value of a constant by its name within an expression?

  1. pv!
  2. rule!
  3. ri!
  4. cons! Correct answer.

Explanation

The cons! prefix references a constant by name in an expression. The other prefixes reference rule inputs, rules, and process variables respectively.

Question 37Data Modeling and Data Management

A record type's status field must accept only one of three defined values. Which approach enforces this at the data layer?

  1. A text field with a comment documenting the allowed values
  2. A picklist backed by a reference record type or lookup table Correct answer.
  3. A free-text field validated only in the interface
  4. An integer field with no constraints

Explanation

Backing the field with a controlled set of values constrains writes to the permitted options and keeps the list maintainable. Documentation, interface-only validation, and unconstrained integers do not enforce the restriction at the data layer.

Question 38Data Modeling and Data Management

A record type reads from a service-backed data source, and a developer needs to combine its results with a local reference table in one query. What is the most appropriate approach?

  1. Query each source separately and combine the results in an expression Correct answer.
  2. Assume the query joins both sources automatically
  3. Convert the reference table into a service-backed record type
  4. Copy the external rows into the reference table at design time

Explanation

Queries generally operate against a single data source, so combining sources requires querying each and merging the results in an expression. Automatic cross-source joins are not a standard capability.

Question 39Data Modeling and Data Management

A developer must remove a parent record whose children are still referenced elsewhere. Which design choice best preserves referential integrity?

  1. Disable the relationship before deleting the parent
  2. Delete the parent and rely on orphaned children being ignored
  3. Prevent deletion while active children exist, or cascade the deletion deliberately Correct answer.
  4. Delete the children first only if they are searchable

Explanation

Referential integrity is preserved either by blocking the parent deletion until children are resolved or by intentionally cascading the delete. Ignoring orphans or hiding relationships leaves inconsistent data.

Question 40Data Modeling and Data Management

A developer wants a record field to be usable in free-text search across the record type. Which field setting should be enabled?

  1. Read-only
  2. Searchable Correct answer.
  3. Hidden
  4. Required

Explanation

Marking a field searchable includes it in the record type's text search behavior. The other settings govern validation, visibility, and editability rather than search participation.

Question 41Process Modeling and Automation

In an Appian process model, which node type is used to pause execution and collect input from a human user through a form?

  1. Script Task
  2. Timer Event
  3. Service Task
  4. User Input Task Correct answer.

Explanation

A User Input Task assigns work to a user or group and presents a form, halting the automatic flow until a human submits it. Script and Service tasks execute automatically without human interaction. Timer events delay or trigger flows based on time rather than collecting input.

Question 42Process Modeling and Automation

Which process model object defines the sequence in which nodes execute from the start event to an end event?

  1. The process variable
  2. The process calendar
  3. The activity class
  4. The sequence flow Correct answer.

Explanation

Sequence flows are the connecting arrows that determine the order of execution between nodes. Process variables store data, activity classes group nodes for reporting, and calendars define working hours. Only sequence flows control execution order.

Question 43Process Modeling and Automation

A process model needs to run two branches of work simultaneously and then wait for both to finish before continuing. Which gateway should be used to split the flow?

  1. XOR gateway
  2. Event-based gateway
  3. Parallel gateway Correct answer.
  4. Exclusive gateway

Explanation

A parallel gateway splits execution into multiple concurrent paths and, when used to join, waits for all incoming branches before proceeding. Exclusive and XOR gateways choose exactly one path. An event-based gateway waits for one of several events rather than fanning out all paths.

Question 44Process Modeling and Automation

Which process property determines whether a process instance runs in the foreground or as a background job?

  1. The process variable type
  2. The process category
  3. The process display name
  4. The process execution mode Correct answer.

Explanation

The execution mode setting controls whether a process runs synchronously in the foreground or asynchronously as a background job. Display name and category are metadata for organization, and variable types describe data. Execution mode is the property that governs runtime behavior.

Question 45Process Modeling and Automation

Which type of process variable is best suited to store a reference to an Appian record so the process can read and update that record?

  1. A process variable of type Boolean
  2. A process variable of type Integer
  3. A process variable of type Text
  4. A process variable of type Record Correct answer.

Explanation

A Record-type process variable holds a reference to a record instance and lets the process read and update its fields. Text, Boolean, and Integer are primitive types that store simple values and cannot directly represent a record reference.

Question 46Process Modeling and Automation

What is the primary purpose of an Appian process model?

  1. To configure authentication and security groups
  2. To orchestrate a sequence of automated and human tasks that accomplish a business goal Correct answer.
  3. To define the data model and record relationships
  4. To render the user interface of a site

Explanation

A process model orchestrates the flow of work, combining automated steps and human tasks to complete a business process. Data modeling is handled by record types, interfaces render UI, and security groups manage access. The process model's role is coordination of tasks.

Question 47Process Modeling and Automation

Which node is used to represent a decision point in a process model where exactly one of several paths is taken based on a condition?

  1. Start event
  2. Exclusive gateway Correct answer.
  3. Parallel gateway
  4. Subprocess

Explanation

An exclusive gateway evaluates conditions on outgoing flows and routes execution down exactly one matching path. Parallel gateways fan out all paths, start events begin a process, and subprocesses encapsulate a nested flow.

Question 48Process Modeling and Automation

Which setting on a User Input Task controls who is able to complete the task?

  1. The data type of the form
  2. The node description
  3. The task assignment Correct answer.
  4. The process calendar

Explanation

Task assignment specifies the user or group responsible for completing a User Input Task. The description is documentation, calendars define working hours, and the form's data type is unrelated to assignment. Assignment is the property that determines who can act.

Question 49Process Modeling and Automation

A process model must call a reusable set of steps multiple times with different inputs. Which construct best supports this?

  1. A timer event
  2. A subprocess Correct answer.
  3. A record type
  4. A parallel gateway

Explanation

A subprocess encapsulates a reusable set of steps that can be invoked with parameters, promoting modularity. Gateways branch flow, timer events handle time, and record types model data. Subprocesses are the standard mechanism for reuse within process orchestration.

Question 50Process Modeling and Automation

An exclusive gateway has three outgoing flows whose conditions are all false at runtime. What is the recommended way to ensure the process does not stall?

  1. Add a timer event after the gateway
  2. Remove all conditions from the flows
  3. Convert the gateway to a parallel gateway
  4. Add a default flow on the gateway Correct answer.

Explanation

A default flow provides a fallback path taken when no other outgoing condition evaluates to true, preventing the process from stalling. A parallel gateway would activate all paths regardless of conditions. Removing conditions or adding a timer does not resolve the missing-path problem.