Data Modeling & Integration Flashcards
7 cards from real ACA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Modeling & Integration flashcards as text
An analyst needs a record type whose data can be filtered and related to other records with fast performance, sourced from a database table under 1 million rows. Which option should be recommended?
Answer: Enable data sync on the record type
Data sync caches source data in Appian, enabling record relationships, custom record fields, and faster queries.
A Customer can place many Orders. When configuring a relationship on the Customer record type, which relationship type should be selected?
Answer: One-to-many
From the Customer's perspective, one customer relates to many orders, so it is one-to-many.
Which Appian object stores the base URL and authentication details that multiple integrations can reuse?
Answer: Connected system
A connected system holds shared connection and authentication details used by one or more integrations.
An integration is configured as 'Modifies Data.' Where can it be called?
Answer: In a saveInto parameter, a Web API, or a process model
Integrations that modify data cannot run on evaluation; they must be triggered by user actions, Web APIs, or processes.
A business stakeholder wants external systems to push new case data into Appian over HTTP. What should the analyst propose?
Answer: A Web API with the POST method
A Web API exposes an Appian endpoint, and POST is the standard method for creating new data.
What is the role of a primary key field in a record type or CDT?
Answer: It uniquely identifies each row of data
A primary key uniquely identifies each record and is required for updates and relationships.
Which feature lets an analyst add a calculated field, such as 'Days Open,' to a synced record type without changing the source table?
Answer: Custom record field
Custom record fields calculate or group values on synced records without altering the source.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- prometric.com — Test delivery · verified Nov 2026
- academy.appian.com — Eligibility, fees, renewal, retake policy, score release, score validity, registration deadline, exam information · verified Nov 2026