Partial preview of the text
Download Appian Certified Associate Developer Exam 2025/2026 – Practice Test & Study Guide and more Exams Advanced Data Analysis in PDF only on Docsity!
Page 1 of 193 APPIAN CERTIFIED ASSOCIATE DEVELOPER EXAM + QUESTIONS WITH CORRECT ANSWERS | | COMPLETE A+ GUIDE Question 1 Scenario: You are creating a Customer Record. The customer has multiple addresses (billing, shipping). What is the best way to model this in Appian? A) Store addresses as multiple fields in a single CDT B) Create a separate Address CDT and link with a one-to- many relationship C) Store addresses as a text list D) Use process variables to store addresses Correct Answer: B Rationale: Normalization best practice: separate Address CDT Page 2 of 193 with foreign key to Customer allows scalability, querying, and record linking. Question 2 Scenario: You need a data store entity that holds user preferences per user ID, and you want to query it in a record. Which is required? A) Process variable B) Constant C) CDT with matching fields D) Integration object Correct Answer: C Rationale: A CDT defines the structure of data stored ina data store entity. Queries in records require a matching CDT. Question 3 Page 4 of 193 managerld field C) Use process variables D) Use a constant lookup Correct Answer: B Rationale: Self-referential relationships are modeled by adding a foreign key field (e.g., managerld) that references the primary key of the same CDT. Question 5 Scenario: Which of the following is NOT a valid data store type in Appian? A) MySQL B) MSSQL C) Oracle D) MongoDB Page 5 of 193 Correct Answer: D Rationale: Appian supports relational databases via JDBC. NoSQL like MongoDB is not directly supported. Question 6 Scenario: You need to create a record that aggregates data from two different tables (Customers and Orders). What must you configure? A) Record source as a process model B) Record source as a query rule with a join C) Two separate records D) Constant array Correct Answer: B Rationale: When data comes from multiple tables, use a query rule (or SQL) to join them and expose as a single record source. Page 7 of 193 B) Cascade delete in relationship C) Record event D) Validation rule Correct Answer: B Rationale: Cascade delete can be configured in the relationship between CDTs to maintain referential integrity. Question 9 Scenario: Which field type in a CDT cannot be a primary key? A) Integer B) Long C) Text D) Boolean Correct Answer: D Rationale: Primary keys must uniquely identify a row. Boolean only has two values. Page 8 of 193 Question 10 Scenario: You have a CDT with fields: id (Long), name (Text), active (Boolean). You write a query rule to fetch active records. Which function do you use? A) alqueryEntity() B) alqueryRecord() C) alqueryDataStoreEntity() D) querywith() Correct Answer: A Rationale: a!queryEntity() queries data store entities with filters, pagination, and sorting. Question 11 Scenario: You want to expose a CDT as a record. What must you create first? A) Process model B) Record type Page 10 of 193 Question 13 Scenario: You have a database view that joins three tables. Can you use it as a record source? A) Yes, if you create a CDT matching the view B) No, views are not supported C) Yes, but only for read-only records D) No, only tables are supported Correct Answer: A Rationale: Database views are supported as long as a matching CDT exists. The record will be read-only. Question 14 Scenario: What is the maximum number of primary key fields in an Appian CDT? A) 1 B) 2 Page 11 of 193 Cc) 3 D) No limit Correct Answer: A Rationale: Appian CDTs support only single-column primary keys. Composite keys are not supported. Question 15 Scenario: You need to store a list of phone numbers for a contact. Which field type should you use? A) Text B) Text Array C) Phone D) Multiple Text Correct Answer: B Rationale: Use an array type (e.g., Text Array) to store multiple values of the same type. Page 13 of 193 Correct Answer: B Rationale: The child CDT contains the foreign key referencing the parent's primary key. Question 18 Scenario: What happens when you delete a data store entity that is used in a record? A) The record becomes invalid B) Appian automatically recreates it C) Nothing, records are independent D) The record is deleted automatically Correct Answer: A Rationale: Records depend on data store entities. Deleting the DSE breaks the record. Question 19 Page 14 of 193 Scenario: You want to add a calculated field to a record (e.g., full name from first and last name). Where do you define this? A) In the CDT as a non-persisted field B) In the process model C) In the interface D) In a constant Correct Answer: A Rationale: Non-persisted fields in CDTs allow calculated values without database storage. Question 20 Scenario: Which data type is automatically indexed for fast searching in Appian records? A) Text B) Document C) Date D) All of the above Page 16 of 193 Scenario: What is the purpose of the al!save() function in record data? A) To save a process variable B) To write data to a data store entity C) To create a constant D) To log a message Correct Answer: B Rationale: al!save() is used in SAIL to write data back to a data store entity. Question 23 Scenario: You have a CDT with 50 fields. Only 10 are needed for a specific report. What is best practice? A) Use the entire CDT B) Create a separate smaller CDT for the report C) Use a process variable D) Ignore the extra fields Page 17 of 193 Correct Answer: B Rationale: Create purpose-specific CDTs or use query projections to reduce data transfer. Question 24 Scenario: Which of the following can be a record source? A) Process variable B) Integration object C) Expression rule returning a list of CDTs D) Constant list Correct Answer: C Rationale: Expression rules that return a list of CDTs from a data source can be record sources. Question 25 Page 19 of 193 Correct Answer: B Rationale: Default batch size is 1000; pagination is required for larger datasets. Question 27 Scenario: You need to display a record list grouped by category. Which record feature do you use? A) Record relationships B) Record group fields C) Record actions D) Record views Correct Answer: B Rationale: Record group fields allow grouping of records in the record list. Question 28 Page 20 of 193 Scenario: Which is true about CDTs and Data Store Entities? A) One CDT can map to multiple DSEs B) One DSE can have multiple CDTs C) CDTs and DSEs are the same D) DSEs are optional for CDTs Correct Answer: B Rationale: A single DSE (table) can have multiple CDTs representing different views of the same table. Question 29 Scenario: You want to cascade updates but not deletes. How do you configure the relationship? A) Cascade update only B) Cascade delete only C) Cascade all D) Restrict both 
