I85PREP
⌘ K
AEP study materials
AEP study resources

AEP practice questions

One question at a time. Build your AEP 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 1Appian Platform Fundamentals and Architecture

In Appian, which object type is used to define the structure of business data and generate the underlying database table?

  1. Record Type Correct answer.
  2. Interface
  3. Expression Rule
  4. Process Model

Explanation

A record type models a business entity and maps it to a data source, including database tables that Appian can generate and maintain. It defines fields, relationships, and the data source used for querying.

Question 2Appian Platform Fundamentals and Architecture

What is the primary purpose of a process model in the Appian platform?

  1. To automate a sequence of tasks and decisions Correct answer.
  2. To store reusable data records
  3. To define security groups for users
  4. To render the end-user interface

Explanation

A process model defines the flow of a business process, including user tasks, automated activities, gateways, and events. It drives the execution and routing of work through the process.

Question 3Appian Platform Fundamentals and Architecture

Which Appian object is primarily responsible for presenting information and capturing user input in a web form?

  1. Constant
  2. Interface Correct answer.
  3. Integration
  4. Data Store

Explanation

Interfaces define the layout, components, and behavior of screens users interact with, including forms and dashboards. They handle both display and input capture.

Question 4Appian Platform Fundamentals and Architecture

An Appian administrator needs a value that differs between the development and production environments without editing logic. Which object should be used?

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

Explanation

Constants can be defined per environment, allowing the same logic to reference different values in development versus production. They are the standard mechanism for environment-specific configuration.

Question 5Appian Platform Fundamentals and Architecture

Which statement accurately describes the relationship between a data store and record types in Appian?

  1. Record types cannot use database-backed data sources
  2. A data store can contain multiple tables that back multiple record types Correct answer.
  3. A data store replaces the need for record types entirely
  4. Each record type must have its own dedicated data store

Explanation

A data store groups related tables, and multiple record types can map to tables within the same data store. This allows related entities to be managed together.

Question 6Appian Platform Fundamentals and Architecture

What does a gateway in a process model control?

  1. The database connection pool size
  2. The version history of an interface
  3. The visual theme of user tasks
  4. The branching path the process takes Correct answer.

Explanation

Gateways evaluate conditions and determine which outgoing path a process follows, enabling decisions and parallel splits. They are the branching construct in process flow.

Question 7Appian Platform Fundamentals and Architecture

A developer wants to reuse a block of expression logic across several interfaces and process models. Which object is best suited?

  1. A process model
  2. A record type
  3. An expression rule Correct answer.
  4. A group

Explanation

Expression rules encapsulate reusable logic with defined inputs and outputs, and can be called from interfaces, process models, and other rules. This promotes consistency and maintainability.

Question 8Appian Platform Fundamentals and Architecture

Which component of an interface is used to arrange other components into rows and columns?

  1. A grid field
  2. A button
  3. A link
  4. A layout Correct answer.

Explanation

Layout components such as columns and sections organize other components spatially on the interface. They provide the structural containers for arranging content.

Question 9Appian Platform Fundamentals and Architecture

A process model needs to call an external REST service and use its response later in the process. Which type of node accomplishes this?

  1. A start event
  2. A user input task
  3. An integration node Correct answer.
  4. A timer event

Explanation

Integration nodes invoke external systems, including REST services, and expose the response for use by subsequent nodes. They are the standard mechanism for outbound service calls within a process.

Question 10Appian Platform Fundamentals and Architecture

Which security concept in Appian determines what a user is permitted to view or modify on an object?

  1. Rule inputs
  2. Object security roles Correct answer.
  3. Process variables
  4. Local variables

Explanation

Object security is governed by roles assigned to users and groups, which grant or deny permissions such as viewer or editor. These roles control access to each object.

Question 11Appian Platform Fundamentals and Architecture

In Appian, what is the role of a group?

  1. To define the data schema of a record
  2. To store environment configuration values
  3. To render dashboards for end users
  4. To organize users for permission and task assignment Correct answer.

Explanation

Groups aggregate users so that permissions and assignments can be managed collectively. They are referenced in security roles and task routing.

Question 12Appian Platform Fundamentals and Architecture

A developer needs to display a list of employees from a record type on an interface and allow filtering by department. Which approach is most appropriate?

  1. Store employees in a constant and display them
  2. Query the record type with a filter and bind results to a grid Correct answer.
  3. Create a new process model for each department
  4. Hard-code the employee list into the interface

Explanation

Querying the record type with a filter retrieves current data and lets the interface present and filter results dynamically. This avoids duplication and keeps data consistent with the source.

Question 13Appian Platform Fundamentals and Architecture

What is the purpose of a rule input on an expression rule?

  1. To schedule the rule to run on a timer
  2. To set the rule's security permissions
  3. To accept a value passed by the caller at evaluation time Correct answer.
  4. To define the rule's return type permanently

Explanation

Rule inputs are parameters that receive values from the caller when the rule is evaluated, enabling reuse with different data. They make the rule configurable rather than hard-coded.

Question 14Appian Platform Fundamentals and Architecture

A process must pause and wait for a specific calendar date before continuing automatically. Which construct should be used?

  1. A user input task assigned to a group
  2. An integration node
  3. A gateway with no conditions
  4. A timer event configured for that date Correct answer.

Explanation

A timer event can be configured to fire at a specific date or after a duration, resuming the process automatically. This is the standard way to introduce time-based waits.

Question 15Appian Platform Fundamentals and Architecture

Which statement best describes how Appian separates design-time objects from runtime execution?

  1. Interfaces execute independently of the platform engine
  2. Objects are defined as design artifacts and interpreted by the platform at runtime Correct answer.
  3. Runtime behavior is controlled only by database triggers
  4. Objects are compiled into a single executable at deployment

Explanation

Appian objects such as interfaces, process models, and rules are design-time artifacts that the platform engine interprets when users interact with them. This enables rapid changes without recompilation.

Question 16Appian Platform Fundamentals and Architecture

An interface calls an expression rule that queries a record type each time a component refreshes. Users report slow performance. What is the most appropriate optimization?

  1. Move the query into a process model start event
  2. Replace the record type with a text field
  3. Convert the record type into a constant
  4. Cache the query result in a local variable and reuse it Correct answer.

Explanation

Storing the query result in a local variable evaluates it once per interaction and lets multiple components reference the same data. This reduces redundant queries and improves responsiveness.

Question 17Appian Platform Fundamentals and Architecture

A process model must route a task to the manager of the submitting user. Which approach reflects correct Appian design?

  1. Use a dynamic group or expression that resolves the manager at runtime Correct answer.
  2. Assign the task to the process initiator only
  3. Create a separate process model for every employee
  4. Assign the task to a hard-coded administrator group

Explanation

Routing to a relationship such as a manager is achieved with a dynamic assignment that resolves the correct user or group at runtime. This keeps routing accurate as reporting lines change.

Question 18Appian Platform Fundamentals and Architecture

Which Appian feature enables a developer to view how data flows through a running process instance for troubleshooting?

  1. Process history and monitoring views Correct answer.
  2. The constant editor
  3. The group membership page
  4. The interface design preview

Explanation

Process monitoring and history views show the path taken, completed nodes, and variable values for a running or completed instance. This supports diagnosis of routing and data issues.

Question 19Appian Platform Fundamentals and Architecture

What distinguishes an Appian record type's data source configuration from its user-facing views?

  1. The data source controls permissions, while views control storage
  2. The data source defines how data is retrieved and stored, while views define how users see it Correct answer.
  3. Views define the database schema, while the data source renders the UI
  4. Both are configured identically and serve the same purpose

Explanation

The data source configuration specifies where and how records are queried, including the backing table or service. Views define the presentation and available fields for users interacting with the record.

Question 20Appian Platform Fundamentals and Architecture

Which object would an administrator use to connect Appian to an external database for reading and writing business data?

  1. A process variable
  2. A data store with a connected data source Correct answer.
  3. An expression rule
  4. An interface component

Explanation

A data store configured with a connected data source establishes the link to an external database, enabling record types to read and write data there. It is the standard integration point for external relational data.

Question 21Data Modeling and Records

In an entity-relationship model, what does a cardinality ratio of many-to-many between two entity types describe?

  1. Each entity of one type relates to exactly one entity of the other type
  2. Each entity of either type can be associated with many entities of the other type Correct answer.
  3. Only one entity of each type may exist in the relationship
  4. Every entity must relate to at least one entity of the other type

Explanation

A many-to-many cardinality means instances of either entity type may be linked to multiple instances of the other type. The ratio constrains how many associations an entity can participate in on each side.

Question 22Data Modeling and Records

A relationship in which every instance of the child entity must participate in the relationship is best described as having what property?

  1. Partial participation
  2. Optional cardinality
  3. Weak dependency
  4. Total participation Correct answer.

Explanation

Total participation (existence dependency) means every entity instance must take part in the relationship. Partial participation means some instances may not participate at all.

Question 23Data Modeling and Records

What is the defining characteristic of a weak entity type?

  1. It cannot participate in any relationship with other entities
  2. It must have a single-attribute primary key
  3. It has no key of its own and is identified by an owner entity Correct answer.
  4. It can only have one attribute in total

Explanation

A weak entity lacks a key attribute sufficient to identify its instances; it uses the owner's key plus a partial key. It is connected to its owner through an identifying relationship.

Question 24Data Modeling and Records

In relational modeling, what does a foreign key enforce?

  1. Uniqueness of every non-key attribute in a relation
  2. That no two tuples share the same primary key
  3. That all attributes are atomic values
  4. Referential integrity between a referencing relation and a referenced relation Correct answer.

Explanation

A foreign key references a candidate key of another (or the same) relation and enforces referential integrity. Values must match an existing referenced tuple or be null where allowed.

Question 25Data Modeling and Records

Which normal form eliminates partial dependencies of non-key attributes on part of a composite key?

  1. Fourth normal form
  2. Third normal form
  3. First normal form
  4. Second normal form Correct answer.

Explanation

Second normal form requires that every non-prime attribute be fully functionally dependent on the whole candidate key. This removes partial dependencies on part of a composite key.

Question 26Data Modeling and Records

What does an entity subtype represent in an enhanced entity-relationship model?

  1. A separate entity type with no relationship to the supertype
  2. A specialized grouping of entities within a supertype that shares its identity Correct answer.
  3. An attribute that can hold multiple values
  4. A relationship between two unrelated entity types

Explanation

A subtype is a specialization of a supertype; subtype instances are also supertype instances and share identity. Subtyping captures attributes and relationships specific to a subset.

Question 27Data Modeling and Records

What is the primary purpose of a data dictionary in a data modeling context?

  1. To hold the actual business transaction records
  2. To store metadata describing the meaning, structure, and constraints of data elements Correct answer.
  3. To back up the database on a schedule
  4. To physically index frequently queried columns

Explanation

A data dictionary is a repository of metadata: definitions, data types, constraints, and relationships for data elements. It does not store the operational data itself.

Question 28Data Modeling and Records

What distinguishes a conceptual data model from a physical data model?

  1. A conceptual model describes business entities and relationships independent of implementation Correct answer.
  2. A conceptual model specifies storage structures and access paths
  3. A conceptual model includes index and partition definitions
  4. A conceptual model is only used after the database is built

Explanation

A conceptual model captures business entities, relationships, and rules at a high level, free of platform details. Physical models add implementation specifics such as tables, indexes, and storage.

Question 29Data Modeling and Records

A relation has a composite primary key (StudentID, CourseID) and a non-key attribute InstructorName that depends only on CourseID. Which normalization problem does this illustrate?

  1. A partial dependency violating second normal form Correct answer.
  2. A transitive dependency violating third normal form
  3. A multivalued dependency violating fourth normal form
  4. A violation of first normal form

Explanation

A non-key attribute depending on only part of a composite key is a partial dependency, which second normal form removes. InstructorName should be stored with CourseID in a separate relation.

Question 30Data Modeling and Records

A table stores OrderID, CustomerID, and CustomerCity, where CustomerCity depends on CustomerID rather than on OrderID. Which normal form does this most directly violate?

  1. Third normal form Correct answer.
  2. Boyce-Codd normal form only
  3. First normal form
  4. Second normal form

Explanation

CustomerCity depends on CustomerID, a non-key attribute, creating a transitive dependency from the key OrderID. Third normal form removes transitive dependencies of non-key attributes.

Question 31Data Modeling and Records

In an ER diagram, a ternary relationship is one that associates how many entity types?

  1. Any number of entity types without limit
  2. One entity type recursively
  3. Three entity types simultaneously Correct answer.
  4. Exactly two entity types

Explanation

A ternary relationship links three entity types in a single association. It is distinct from three separate binary relationships, which cannot always capture the same constraint.

Question 32Data Modeling and Records

Which construct best models the fact that an employee may have several dependents, each with a name and birth date?

  1. A multivalued attribute with no relationship
  2. A one-to-one relationship between Employee and Dependent
  3. A weak entity Dependent identified by Employee Correct answer.
  4. An attribute of Employee holding a single dependent name

Explanation

Dependents have their own attributes and multiple instances per employee, so a weak entity identified by the owner Employee models this well. The owner's key plus a partial key identifies each dependent.

Question 33Data Modeling and Records

What does the degree of a relationship in an ER model refer to?

  1. The number of keys in a relation
  2. The number of attributes in an entity type
  3. The number of entity types participating in the relationship Correct answer.
  4. The number of instances in an entity set

Explanation

Relationship degree counts participating entity types: unary, binary, ternary, and so on. It should not be confused with cardinality, which constrains instance participation.

Question 34Data Modeling and Records

A supertype Person has subtypes Employee and Customer, and an instance can be both. Which constraint describes this situation?

  1. Overlapping specialization Correct answer.
  2. Complete specialization
  3. Disjoint specialization
  4. Total specialization

Explanation

Overlapping specialization allows a supertype instance to belong to more than one subtype. Disjoint specialization forbids membership in more than one subtype.

Question 35Data Modeling and Records

In relational mapping, how is a many-to-many relationship between two entity types typically implemented?

  1. As a separate associative relation holding foreign keys to both entity relations Correct answer.
  2. As a merged relation combining both entity types
  3. As a foreign key added to one of the two entity relations
  4. As a view over the two entity relations

Explanation

A many-to-many relationship maps to its own relation whose key combines foreign keys to both participating relations. This preserves all associations without redundancy.

Question 36Data Modeling and Records

What is the role of a surrogate key in a dimensional model?

  1. A natural key derived from source business identifiers
  2. A system-generated identifier with no business meaning used to join dimension and fact tables Correct answer.
  3. An attribute that stores descriptive dimension text
  4. A foreign key that references the fact table

Explanation

Surrogate keys are system-assigned, meaningless identifiers that insulate the warehouse from source key changes. They are used to join fact tables to dimension tables.

Question 37Data Modeling and Records

In a star schema, what does a fact table primarily contain?

  1. Foreign keys to dimension tables plus numeric measures Correct answer.
  2. Hierarchical rollup definitions
  3. Only surrogate keys with no measures
  4. Descriptive attributes describing each dimension

Explanation

A fact table holds foreign keys to dimensions and numeric, additive measures for events. Descriptive context lives in the dimension tables.

Question 38Data Modeling and Records

What distinguishes a snowflake schema from a star schema?

  1. Fact tables are removed entirely
  2. No surrogate keys are used
  3. Dimension tables are normalized into multiple related tables Correct answer.
  4. Measures are stored in dimension tables

Explanation

A snowflake schema normalizes dimensions into hierarchies of related tables, reducing redundancy at the cost of more joins. A star schema keeps dimensions denormalized.

Question 39Data Modeling and Records

A relation is in third normal form. Which additional condition makes it satisfy Boyce-Codd normal form?

  1. Every determinant is a candidate key Correct answer.
  2. Every non-key attribute is atomic
  3. Every foreign key references a primary key
  4. Every tuple has a unique identifier

Explanation

BCNF requires that every nontrivial functional dependency have a candidate key as its determinant. This is stricter than 3NF when multiple overlapping candidate keys exist.

Question 40Data Modeling and Records

Which situation best calls for a recursive relationship in an entity-relationship model?

  1. An employee who reports to another employee within the same entity type Correct answer.
  2. A customer who places many orders
  3. A department located in a building
  4. A product supplied by many suppliers

Explanation

A recursive (unary) relationship links instances of the same entity type, such as the manager-subordinate hierarchy among employees. The other cases involve distinct entity types.

Question 41Data Modeling and Records

What does the closed-world assumption imply when reasoning over a relational database?

  1. Constraints are enforced only at query time
  2. Any fact not present is assumed unknown
  3. Any fact not present in the database is assumed false Correct answer.
  4. All facts must be duplicated in every table

Explanation

Under the closed-world assumption, what is not recorded is taken to be false, which underlies negation in relational querying. Open-world reasoning instead treats missing facts as unknown.

Question 42Data Modeling and Records

In a logical data model, what is the effect of resolving a many-to-many relationship that carries its own attributes?

  1. It is removed because attributes cannot be stored
  2. It becomes a multivalued attribute on one entity
  3. It collapses into a single entity type with all attributes merged
  4. It becomes an associative entity holding the attributes and foreign keys to both sides Correct answer.

Explanation

When a many-to-many relationship has attributes, it is modeled as an associative entity. The associative entity carries those attributes and references both participating entities.

Question 43Data Modeling and Records

A relation R(A, B, C) has functional dependencies A→B and B→C, with A the only candidate key. Which statement is accurate?

  1. R violates 2NF because C depends on part of the key
  2. R is in BCNF because A determines all attributes
  3. R is in 2NF but violates 3NF because of the transitive dependency B→C Correct answer.
  4. R violates 1NF because C is not atomic

Explanation

A→B and B→C create a transitive dependency A→B→C with B not a candidate key, so R is in 2NF but not 3NF. Decomposing into R1(A,B) and R2(B,C) removes it.

Question 44Data Modeling and Records

Two relations are joined on a foreign key that permits nulls. What is the effect of an inner join versus a left outer join on rows whose foreign key is null?

  1. Both joins drop those rows
  2. The inner join drops those rows; the left outer join keeps them with nulls for the other side Correct answer.
  3. Both joins keep those rows with matching values
  4. The left outer join drops those rows; the inner join keeps them

Explanation

An inner join keeps only matching rows, so a null foreign key matches nothing and is excluded. A left outer join preserves all left-side rows, filling unmatched right-side columns with nulls.

Question 45Data Modeling and Records

A data model uses a single table with columns Attr1, Attr2, and Attr3 to store different kinds of phone numbers. Which modeling concern does this most directly raise?

  1. Transitive dependencies that violate third normal form
  2. Violation of domain-key normal form
  3. Loss of referential integrity
  4. Repeating groups that violate first normal form Correct answer.

Explanation

Storing multiple values of the same attribute in numbered columns creates a repeating group, which first normal form prohibits. The fix is a separate table with one row per phone number.

Question 46Data Modeling and Records

Which term describes an attribute or set of attributes whose values must uniquely identify each row of a relation?

  1. Multivalued attribute
  2. Foreign key
  3. Non-prime attribute
  4. Candidate key Correct answer.

Explanation

A candidate key is a minimal set of attributes that uniquely identifies each tuple, and one candidate key is chosen as the primary key. Foreign keys reference other relations, non-prime attributes are outside every candidate key, and multivalued attributes hold multiple values per instance.

Question 47Data Modeling and Records

In an entity-relationship model, what does a weak entity depend on to be uniquely identified?

  1. An owning entity through an identifying relationship Correct answer.
  2. A unique attribute of its own
  3. A many-to-many relationship to itself
  4. A generalization hierarchy above it

Explanation

A weak entity lacks a key of its own and is identified by combining a partial key with the key of its owner via an identifying relationship. This dependency is what makes the entity 'weak' relative to its owner.

Question 48Data Modeling and Records

Which cardinality notation states that each instance of entity A is associated with at most one instance of entity B, but an instance of B may be associated with many instances of A?

  1. One-to-many from A to B
  2. One-to-one between A and B
  3. Many-to-many between A and B
  4. Many-to-one from A to B Correct answer.

Explanation

Cardinality is read in the direction stated: many instances of A can point to at most one instance of B, which is a many-to-one association from A's perspective. The reverse reading (one B to many A) is the same relationship seen from B's side.

Question 49Data Modeling and Records

What is the main purpose of an identifying relationship in an ER model?

  1. To record the date on which an entity was created
  2. To enforce referential integrity between two strong entities
  3. To represent an attribute that holds several values
  4. To link a weak entity to the owner that supplies part of its key Correct answer.

Explanation

An identifying relationship connects a weak entity to its owner and contributes the owner's key to the weak entity's identifier. It is drawn distinctly from ordinary relationships precisely because of this key-supplying role.

Question 50Data Modeling and Records

A relation has attributes (A, B, C, D) with functional dependencies A→B and C→D, and the only candidate key is (A, C). Which normal form does this relation satisfy?

  1. Second normal form but not third normal form Correct answer.
  2. First normal form only
  3. Boyce-Codd normal form
  4. Third normal form but not second normal form

Explanation

Every non-prime attribute depends on the whole key (A, C) here only through partial dependencies? No: B depends on A alone and D on C alone, so partial dependencies exist and the relation fails 2NF. Wait-B and D are non-prime and depend on part of the key, so the relation is in 1NF only.