Appian Appian Certifications ACD100 Questions & Answers

• Question 51:

  What is a Foreign Key?

  A. The key that cannot be used in any other table.

  B. The key that joins two tables together.

  C. The key that uniquely identifies a record.

  D. The key that uniquely identifies a record when joined with another column.

  Correct Answer: B

• Question 52:

  When using "a!pagingInfo()" within "a!queryEntity()", which batch size value will return all items?

  A. -1

  B. 0

  C. null

  D. 500

  Correct Answer: A

• Question 53:

  You need to configure the Write to Data Store Entity smart service. What is required to correctly configure this?

  A. On the data store entity, use a constant in the value field for the data store entity.

  B. Users must be granted access to database.

  C. On the Data tab, click New Input to save the data.

  D. Assign a namespace to the XML document.

  Correct Answer: B

  This includes granting users the necessary privileges and ensuring that the database connection information is correctly entered in the smart service configuration.

• Question 54:

  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

  Correct Answer: B

  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 55:

  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

  Correct Answer: AB

• Question 56:

  When setting the assignment of a User Input task, you need the task to be assigned to the person who started the process. Which option is appropriate to use to accomplish this goal?

  A. pp!name

  B. pm!creator

  C. pp!initiator

  D. pm!name

  Correct Answer: C

• Question 57:

  A feature is being deployed to the test environment.

  In which environment is unit testing performed for the feature?

  A. Upgrade

  B. Development

  C. Production

  D. Staging

  Correct Answer: D

• Question 58:

  A client asks you to store work location information for their employees. The client mentions that multiple employees may be assigned to multiple work locations. Which type of database relationship is the client describing?

  A. One-to-Many (1:N)

  B. Many-to-One (N:1)

  C. Many-to-Many (M:N)

  D. One-to-One (1:1)

  Correct Answer: C

  https://docs.appian.com/suite/help/23.2/CDT_Relationships.html#many-to-many- relationship Many-to-Many Relationship An example of this would be an application to manage Employees and Projects. Each Project has a team of multiple Employees, but a given Employee might currently be on more than one Project

• Question 59:

  By default, when is a local variable refreshed when using a!localVariables( )?

  A. After every user interaction

  B. After a record action event completes

  C. When any referenced variable changes

  D. It never refreshes

  Correct Answer: C

• Question 60:

  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

  Correct Answer: D

  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.