← All ACA Flashcard Decks

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
  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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 , 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

  1. prometric.com — Test delivery · verified Nov 2026
  2. academy.appian.com — Eligibility, fees, renewal, retake policy, score release, score validity, registration deadline, exam information · verified Nov 2026