ACD100 Online Practice Questions and Answers

What is the most appropriate interface component to display tabular data?

A. Rich Text

B. Column Layout

C. Editable Grid

D. Read-only Grid

In addition to initiating the process model, what other permission is required to execute the Write to Data Store Entity smart service?

A. Viewer permission to the data store

B. Viewer permission to a constant that points to the data store entity

C. Admin permission to the CDT

D. Editor permission to the record

What type of variable can only be used within the context of a particular expression, and can only be accessed within the function that defines them?

A. Local Variable

B. Process Variable

C. Rule Input Variable

D. CDT Variable

Which two filter types should you apply to limit the record list by default? (Choose two.)

A. Default filters

B. Source filters

C. User filters

D. Filter by search field

What is the most accurate reason to use a related record type?

A. Related record types automatically update when dependent table structures are changed

B. Related record types allow you to easily write to a data source

C. Related record types allow you to easily query data from multiple unrelated tables

D. Related record types perform better than tables with a large scale of data

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.

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 user has a direct URL to access a record view.

Which configuration(s) would allow the user this access?

A. A combination of user filters, source security, and record type security are required.

B. Source security is all that is required.

C. A combination of data source security, record type security, and default filler configuration (if it is set) are required.

D. Record Type security is all that is required.

A client requested a feature that is exceptionally specific and uncommon.

You begin by gathering research to help determine how such a feature could be implemented, but no documentation is available.

What should you do next?

A. Create a Support Case.

B. Check The Appian Academy.

C. Review the Appian Playbook.

D. Ask the Appian Community.

Review the following table.

Which option correctly deletes the last row from the table?

A. REMOVE product_id = 3 IN product;

B. DELETE FROM product WHERE product_id = 3;

C. DELETE product_i = 3 FROM product;

D. REMOVE FROM product WHERE product_id = 3;