Download Appian Senior Developer Ultimate Exam and more Exams Technology in PDF only on Docsity!
Exam
Question 1. Which Appian console setting controls the default time-zone for all new users in a Cloud tenant? A) System Locale B) Default User Preferences C) Global Settings → Regional Settings D) Environment Variables Answer: C Explanation: Global Settings → Regional Settings defines the default time-zone and locale applied to newly created users; other options affect individual preferences or system messages.
Question 2. When reviewing a Health Check report, a red “High-Risk Design Pattern” flag for “Heavy Use of a!queryEntity() in a grid” most likely indicates what? A) Missing database indexes B) Inefficient pagination causing N+1 queries C) Insufficient memory allocation for the server D) Incorrect SAIL syntax Answer: B Explanation: Heavy use of a!queryEntity() without proper pagination can generate an N+1 query pattern, leading to performance degradation, which the Health Check flags as high-risk.
Exam
Question 3. Which log file would you examine to troubleshoot a failure occurring during a process model’s “Call Subprocess” node execution? A) design.log B) engine.log C) tomcat.log D) audit.log Answer: B Explanation: engine.log captures runtime execution details of process models, including subprocess calls, making it the primary source for such errors.
Question 4. In the Performance Dashboard, the “Avg. UI Rendering Time” metric is most directly impacted by which of the following? A) Number of concurrent engine threads B) Size of the database indexes C) Complexity of SAIL expressions on the form D) Frequency of background smart service executions Answer: C Explanation: UI rendering time measures how long the client waits for the interface to be built; complex SAIL expressions increase server-side processing before the UI is sent.
Exam
Question 7. When designing a relational schema to support a many-to-many relationship between “Projects” and “Tags”, which database object is essential? A) A view combining both tables B) A junction (link) table with foreign keys to each entity C) A stored procedure that inserts rows into both tables simultaneously D) A trigger that enforces uniqueness on the “Tag” column Answer: B Explanation: A junction table (also called a link table) holds pairs of foreign keys, enabling many-to-many associations in a relational model.
Question 8. In Appian Data Fabric, what does the “Source Filter” option do when configuring a Record Type Sync? A) Limits the number of records fetched per sync batch B) Applies a WHERE clause to the source query to restrict synced rows C) Determines which fields are encrypted at rest D) Sets the frequency of automatic sync jobs Answer: B Explanation: Source Filter translates to a WHERE clause on the external data source, allowing only rows that meet the criteria to be synchronized.
Exam
Question 9. Which of the following is a best practice for creating a calculated field at the Record Type level? A) Use a!recordField() inside the UI layout only B) Define the calculation in a database view for performance C) Write the expression in the “Calculated Field” editor, referencing only record fields D) Store the result in a separate custom data type for later use Answer: C Explanation: The Calculated Field editor lets you define an expression that runs whenever the record is loaded, using only the record’s fields; this is the intended method.
Question 10. When writing a complex SQL view to be consumed by a! queryEntity(), which indexing strategy most improves query performance? A) Index every column used in the SELECT clause B) Create a composite index on columns used in WHERE and JOIN predicates C) Use a full-text index on all textual columns D) Rely on the default primary key index only Answer: B Explanation: Composite indexes on the columns participating in WHERE and JOIN conditions allow the database optimizer to efficiently locate rows, reducing scan time.
Exam
Question 13. A record-level security rule is defined as “owner = loggedInUser()”. Which of the following statements is true? A) The rule is evaluated once per application load B) It restricts access to only the record’s owner, regardless of group membership C) It can be overridden by a higher-level site security rule D) It applies only to write operations, not reads Answer: B Explanation: The rule evaluates at runtime for each record read, allowing only the record’s owner (matching the current user) to view or edit the record.
Question 14. In an ABAC (Attribute-Based Access Control) implementation, which Appian construct typically stores the user attributes used for decision making? A) Security Groups B) User Roles C) User-Defined Data Types (UDDT) attached to the user record D) Application Settings Answer: C Explanation: ABAC relies on user attributes (e.g., department, clearance level) stored in a custom data type or record linked to the user, rather than static group membership.
Exam
Question 15. When translating a user story that requires “bulk approval of expense reports”, which Appian design pattern is most appropriate? A) A single Process Model with a “Parallel Gateway” for each report B) A Record Action with a!gridField() supporting bulk selection and a!save() on each selected row C) A Site page with a “Submit” button that launches a separate process per report D) An Interface with a!buttonArray() that triggers individual smart services Answer: B Explanation: Record Actions can be configured for bulk operations; a! gridField() with multi-select enables users to approve many records in one transaction, matching the story.
Question 16. Which authentication protocol is NOT natively supported by Appian Connected Systems? A) OAuth 2.0 (Authorization Code) B) SAML 2. C) API Key D) Basic Authentication Answer: B Explanation: Appian Connected Systems support OAuth, API Key, and Basic Authentication out-of-the-box; SAML is used for single sign-on, not for Connected System authentication.
Exam
Explanation: Chunked Transfer streams the file in pieces, preventing the entire payload from being held in memory at once, thus reducing the risk of OOM errors.
Question 19. Which scenario most justifies creating a custom plug-in rather than using an out-of-the-box Smart Service? A) Sending an email notification to a static list B) Performing a complex transformation on a CSV file that requires a third-party Java library C) Updating a single row in a data store entity D) Creating a user-assigned task Answer: B Explanation: When functionality requires external libraries or logic not provided by Smart Services, a custom plug-in is appropriate; the other tasks are covered by built-in services.
Question 20. In an event-driven architecture, which Appian element can be used to start a process automatically when a message arrives on an external queue? A) Message Start Event configured with a Connected System B) Timer Start Event with a 5-second interval C) User Input Task with “Receive Message” option D) Script Task that polls the queue
Exam
Answer: A Explanation: Message Start Events can be linked to external messaging systems (via Connected Systems) to trigger a process as soon as a message is received.
Question 21. Which memory-management technique reduces the execution engine’s footprint for long-running processes? A) Using a!save() to persist all intermediate variables to the database B) Declaring all process variables as “Global” C) Designing “short-lived” subprocesses that complete quickly and release memory D) Increasing the engine’s maximum heap size Answer: C Explanation: Short-lived subprocesses finish quickly, allowing the engine to reclaim memory; persisting variables or increasing heap does not directly reduce footprint.
Question 22. What is the primary purpose of the “Process Model Planner” in Appian? A) To schedule batch jobs on a nightly basis B) To visualize and identify performance bottlenecks in a process model C) To generate documentation for a process model automatically
Exam
D) Convert the loop into a series of “User Input Tasks” Answer: B Explanation: A Data Subprocess can handle batch processing efficiently and prevents the engine from creating a massive number of loop iterations in a single process instance.
Question 25. When configuring asynchronous processing for a non-critical task, which Appian feature should you use? A) Synchronous Smart Service with “Run in Background” flag B) Queue-Based Integration with “Execute Asynchronously” option C) Timer Start Event set to fire after 1 minute D) “Run as a Service” toggle on the Process Model Answer: B Explanation: Queue-Based Integrations can be marked to execute asynchronously, allowing the engine to continue without waiting for the external call to complete.
Question 26. A developer wants to expose a set of Appian records as a GraphQL endpoint. Which built-in capability supports this requirement? A) Appian GraphQL Connector (beta) B) Web API with “Expose as GraphQL” toggle C) Data Store Entity with “GraphQL Export” option
Exam
D) There is no native GraphQL support; a custom plug-in is required Answer: D Explanation: As of the latest release, Appian does not provide native GraphQL endpoints; developers must build a custom plug-in or use an external gateway.
Question 27. Which of the following is the most secure way to store a large binary file (e.g., video) that must be accessed by an external public portal? A) Appian Files with public URL enabled B) An external object storage (e.g., AWS S3) referenced via a Connected System with signed URLs C) Embedding the file as a Base64 string in a record field D) Storing the binary in a database BLOB column Answer: B Explanation: External object storage with signed URLs provides controlled, temporary access without exposing Appian’s internal file system.
Question 28. When using a!queryRecordType(), which parameter controls the maximum number of rows returned before pagination is applied? A) pagingInfo.startIndex B) queryInfo.pagingInfo.maxRowsPerPage C) queryInfo.pagination.totalRows
Exam
Answer: B Explanation: The “Enable Tenant Isolation” toggle forces the platform to segregate data store objects per tenant at the database level.
Question 31. Which SAIL component is specifically designed to meet WCAG 2.1 AA contrast requirements out of the box? A) a!richTextField() B) a!iconField() C) a!buttonLayout() with “style: ‘PRIMARY’” D) a!textField() with “label” property Answer: B Explanation: a!iconField() automatically applies sufficient contrast for icons; other components rely on developer styling to meet contrast ratios.
Question 32. A developer needs to calculate a running total across a list of transactions within a single interface without storing intermediate results in the database. Which expression pattern should be used? A) a!forEach() with an accumulator stored in a!localVariables() B) a!reduce() with a lambda that adds the current value to the accumulator C) a!save() inside a!forEach() to persist each step D) a!queryEntity() with a GROUP BY clause Answer: B
Exam
Explanation: a!reduce() is designed for aggregations like running totals, allowing the calculation to stay entirely in memory.
Question 33. When configuring a Connected System to use OAuth 2. Authorization Code flow, which of the following fields is NOT required? A) Authorization URL B) Token URL C) Client Secret D) Refresh Token TTL Answer: D Explanation: Refresh Token TTL is optional; the core OAuth 2.0 Authorization Code flow needs Authorization URL, Token URL, Client ID, and Client Secret.
Question 34. Which Appian feature allows you to automatically generate a PDF document from a report layout and send it via email? A) Document Generation Smart Service B) a!exportPdf() function C) Record Action “Generate PDF” D) Integration with a third-party PDF API Answer: A
Exam
Answer: C Explanation: Smart Services are versioned alongside the application, ensuring that changes to a service are tracked with the app’s release.
Question 37. When a Web API is called with an invalid JSON payload, which HTTP status code does Appian return by default? A) 200 OK B) 400 Bad Request C) 401 Unauthorized D) 500 Internal Server Error Answer: B Explanation: Invalid request bodies trigger a 400 Bad Request response, indicating client-side formatting errors.
Question 38. Which database object is best suited for enforcing business rules that must execute before any INSERT on a “Customer” table? A) AFTER INSERT trigger B) BEFORE INSERT trigger C) CHECK constraint on the table D) Stored procedure that performs the INSERT Answer: B
Exam
Explanation: A BEFORE INSERT trigger runs prior to the row being written, allowing validation or modification of the incoming data.
Question 39. What is the effect of enabling “Snapshot” on a Data Store Entity? A) It creates a read-only copy of the table for reporting purposes B) It forces the engine to cache all rows in memory at startup C) It enables versioning of records for audit trails D) It disables all write operations to the entity Answer: A Explanation: Snapshot creates a static, read-only replica of the table that can be used for high-performance reporting without affecting the live source.
Question 40. Which of the following is a recommended technique for avoiding “N+1” query problems when displaying a grid of related records? A) Use a!queryRecordType() with a “join” on the related record type in the queryInfo B) Load the related data in a separate a!forEach() loop after the main grid renders C) Disable lazy loading on the grid component D) Increase the database connection pool size Answer: A
