Appian ACD100 Appian Certified Associate Developer Online Training
Appian ACD100 Online Training
The questions for ACD100 were last updated at Nov 22,2024.
- Exam Code: ACD100
- Exam Name: Appian Certified Associate Developer
- Certification Provider: Appian
- Latest update: Nov 22,2024
You need to update the table structure in the database, and then update the related CDT in Appian to publish the data store entity.
Column names in the database and the CDT are implemented using different naming conventions.
Which statement is appropriate in this scenario?
- A . You can update the CDT columns in Appian Designer, or update the CDT-related XSD and create a new version from that.
- B . You must update the CDT columns in Appian Designer.
- C . You don’t need to make any manual changes. Appian automatically updates the CDT according to database chances.
- D . You must update the CDT-related XSD and create a new version from that.
During User Acceptance Testing (UAT), a tester operating in the test environment asks you to change a data point in one of the tables.
In the development environment, you navigate to the database and adjust the data point that the tester described.
What is the issue with the steps taken?
- A . According to Appian best practices, changes should not be made directly in a database.
- B . The change to the database was made in the wrong environment.
- C . As an associate, you should not be communicating or coordinating directly with testers.
- D . The change was made without formally seeking approval from DevOps.
Review the following table.
Given the following options are in mySQL, which option correctly alters the last row on the table?
- A . INSERT price = 0.9 –
INTO product –
WHERE product_id = 3; - B . MODIFY product –
UPDATE price = 0.9 –
WHERE product_id = 3; - C . SET product –
(price) VALUES (0.9)
WHERE product_id = 3; - D . UPDATE product –
SET price = 0.9 –
WHERE product_id = 3;
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.
You need to edit data in a table. You ate currently using the following statement:
INSERT INTO product (productId, productName) VALUES (3, "App1e");
What is the issue?
- A . You should be using an UPDATE statement.
- B . You forgot the WHERE clause in your statement.
- C . You should be using a CREATE statement.
- D . You should be using an EDIT statement.
When using "a!pagingInfo()" within "a!queryEntity()", which batch size value will return all items?
- A . -1
- B . 0
- C . null
- D . 500
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;
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
What is a way to start a process from an interface?
- A . Start Process Smart Service
- B . Process Start Event
- C . Process Messaging
- D . Start Process Link
An end-user needs to trigger a process model and act on the user task assigned to them.
What is the minimum security permission needed?
- A . Viewer
- B . Initiator
- C . Editor
- D . Manager