Appian ACD100 Online Practice Questions and Exam Preparation

Appian ACD100 Online Questions & Answers

• Question 71:

  What is a correct representation of a dynamic process display name?

  A. "Create or Update Record; " and pv!recordName
  B. "Create or Update Record: " + pp!initiator
  C. "Create or Update Record " + ac!recordName
  D. "Create or Update Record and pv!recordName"
  A. "Create or Update Record; " and pv!recordName

• Question 72:

  You are configuring a record type and utilizing data sync.

  Appian does NOT have write access to the source database table, and will not make updates. Which data sync option is most appropriate for your situation?

  A. Hourly Sync
  B. Manual Sync
  C. Daily Sync
  D. Immediate Sync
  B. Manual Sync

  ---

  Explanation/Reference:

  The most appropriate data sync option in this situation would be B. Manual Sync, since Appian cannot write updates to the source database table and therefore, it would not make sense to schedule a regular automatic sync. Instead, the sync should be initiated manually by an authorized user when necessary.

• Question 73:

  DRAG DROP

  You need to create a table to store product IDs.

  What is the correct order for the SQL syntax? To answer, move everything from the Options list to the Answer List area and arrange them in the correct order.

  Select and Place:

  

  

  ---

  Explanation/Reference:

  create table product ( product_id int ) ;

• Question 74:

  You have data from two unrelated tables. Which Appian objects can easily relate data from these two tables?

  A. Process Models
  B. Expression Rules
  C. Custom Data Types
  D. Record Types
  D. Record Types

  ---

  Explanation/Reference:

  When creating a Record Type, you can define relationships to other Record Types, which enables you to link data from two or more unrelated tables. This is typically done by creating a foreign key field in the Record Type that references the primary key of another Record Type.

• Question 75:

  Which two statements are true about the Primary Key constraint in SQL? (Choose two.)

  A. A Primary Key must contain UNIQUE values.
  B. A Primary Key uniquely identifies each record in a SQL database table.
  C. A Primary Key must be mode of a single column only.
  D. A Primary Key must be on integer.ax
  A. A Primary Key must contain UNIQUE values.
  B. A Primary Key uniquely identifies each record in a SQL database table.

• Question 76:

  What is the lowest level of permissions required to delete a folder?

  A. Administrator
  B. Editor
  C. Manager
  D. Viewer
  A. Administrator

  ---

  Explanation/Reference:

  https://docs.appian.com/suite/help/23.2/folder-and-document-management.html#deleting- folders