Appian ACD100 Online Practice Questions and Exam Preparation

Appian ACD100 Online Questions & Answers

• Question 1:

  Given a Text type input of ri!text, which function will return that text without any spaces in the text?

  A. trim(ri!text)
  B. remove(ri!text, " ")
  C. stripwith(ri!text, " ")
  D. flatten(ri!text)
  C. stripwith(ri!text, " ")

• Question 2:

  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;
  B. DELETE FROM product WHERE product_id = 3;

• Question 3:

  A form has 5 rule inputs, as follows: 1 CDT variable 3 Text variables 1 Integer variable According to best practices, how many process variables are required in the process model's user input task?

  A. 1
  B. 3
  C. 5
  D. 6
  C. 5

• Question 4:

  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.
  A. Create a Support Case.

• Question 5:

  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
  D. Start Process Link

• Question 6:

  During CDT creation, when should you select the option to "Create New Version from XSD"?

  A. When the data type (CDT) contains more than 12 fields
  B. When the data type (CDT) is created through a Web Service
  C. When the Data Type (CDT) Designer docs nor allow you to identify your Primary Key field
  D. When the data type (CDT) configurations are not accessible through the Data Type (CDT) Designer
  B. When the data type (CDT) is created through a Web Service

  ---

  explanation:

  Explanation/Reference:

  In general, the option to "Create New Version from XSD" is most commonly used when creating a CDT that is used to consume or provide data through a Web Service. This is because the XSD file provides a standard way of describing the data structure used by the Web Service, which can be used to generate the CDT and ensure that it is consistent with the Web Service interface.

• Question 7:

  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.
  C. A combination of data source security, record type security, and default filler configuration (if it is set) are required.

• Question 8:

  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;
  D. UPDATE product SET price = 0.9 WHERE product_id = 3;

  ---

  explanation:

  Explanation/Reference:

• Question 9:

  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.
  A. You should be using an UPDATE statement.

  ---

  explanation:

  Explanation/Reference:

  CREATE TABLE table_name (

  column1 datatype,

  column2 datatype,

  );

• Question 10:

  What table relationship is illustrated in the following data structure (if the relationship is evaluated from left to right)?

  

  A. Many to Many (M:M)
  B. Many-to-One (M:1)
  C. One-to-Many (1:M)
  D. One-to-One (1:1)
  C. One-to-Many (1:M)

  ---

  explanation:

  Explanation/Reference:

  This relationship is a "one-to-many" relationship because one supplier can supply many different products, but each product can only be supplied by one supplier.