Appian ACD200 Online Practice Questions and Exam Preparation

Appian ACD200 Online Questions & Answers

• Question 41:

  You are using pie charts.

  What is correct representation of Appian best practices? (Choose the best answer.)

  A. Use as many slices as possible.
  B. Pie charts should only be used to represent data that can be placed into identical categories.
  C. Use pie charts to show proportional data.
  D. Try to use multiple pie charts when comparing multiple sets of data.
  C. Use pie charts to show proportional data.

  ---

  Explanation/Reference:

  The correct representation of Appian best practices for using pie charts is to use pie charts to show proportional data. Pie charts are generally used to show how individual parts contribute to a whole, such as percentages or fractions. Pie charts should only be used to represent data that can be placed into distinct categories and should not consist of more than 6 slices. Pie charts should also include value and category labels for each slice, and sort the data values in ascending or descending order. References: Pie Chart Component, Charts UX Design Guide

• Question 42:

  You are investigating a slow-performing query entity which is mapped to a view and you decide to look in the data_store_details.csv log to gain more information. You see that the majority of the time is spent in the transform phase. Which two actions can you take to reduce the time spent in the transform phase? (Choose two.)

  A. Reduce the use of unnecessary columns in the GROUP BY clause in the database view.
  B. Reduce the number of columns returned from the query.
  C. Create a database index on the column being filtered against.
  D. Lower the batch size parameter of the query.
  B. Reduce the number of columns returned from the query.
  D. Lower the batch size parameter of the query.

  ---

  Explanation/Reference:

  The data_store_details.csv log provides information about the performance of query entities. The log shows the time spent in three phases: extract, transform, and load. The extract phase is the time it takes to execute the SQL query on the database. The transform phase is the time it takes to convert the SQL result set into Appian data types. The load phase is the time it takes to return the data to the expression that invoked the query entity. To reduce the time spent in the transform phase, two possible actions are to reduce the number of columns returned from the query and to lower the batch size parameter of the query. These actions can decrease the amount of data that needs to be converted and transferred, which can improve the performance of the query entity. Therefore, the correct answers are B and D. References: Query Entity Performance a!queryEntity() Function

• Question 43:

  When creating a Web API, which two items are configured in the Administration Console? (Choose two.)

  A. LDAP Authentication
  B. API Key
  C. Connected System
  D. Service Account
  B. API Key
  D. Service Account

  ---

  Explanation/Reference:

  When creating a Web API, you need to configure two items in the Administration Console: an API key and a service account. An API key is a unique identifier that is used to authenticate requests to your Web API. You can create and manage API keys in the Administration Console under Integration > API Keys. A service account is a user account that is used to execute the Web API expression rule. You can select a service account in the Administration Console under Integration > Web APIs when you create or edit a Web API. References: [Web APIs], [API Keys], [Service Accounts]

• Question 44:

  In Scrum, who is the right person responsible for prioritizing product backlog? (Choose the best answer.)

  A. Tester
  B. Product Owner
  C. Lead Developer
  D. Product Manager
  B. Product Owner

  ---

  Explanation/Reference:

  In Scrum, the product owner is the person who represents the voice of the customer and the stakeholders. The product owner is responsible for defining and prioritizing the product backlog, which is a list of features, requirements, enhancements, and fixes that need to be delivered by the team. The product owner collaborates with the team and the scrum master to ensure that the product backlog is clear, valuable, and aligned with the product vision and goals.

• Question 45:

  You are creating an ERD that models the data for a college and includes a Many-to-Many relationship, Student-to-Class, where a student can be enrolled in multiple classes, and a class can enroll multiple students.

  How can you handle this relationship so that it can be supported in Appian and remain in at least First Normal Form? (Choose the best answer.)

  A. A joining table can be used to hold instances of Student/Class relationships.
  B. The Student table should have a Class field to hold an array of Class IDs.
  C. The Class table should have a Student field to hold an array of Student IDs.
  D. It cannot be done, because Appian CDTs cannot handle Many-to Many relationships.
  A. A joining table can be used to hold instances of Student/Class relationships.

  ---

  Explanation/Reference:

  A joining table can be used to hold instances of Student/Class relationships, so that it can be supported in Appian and remain in at least First Normal Form. A joining table is a table that contains only foreign keys that reference the primary keys of other tables. A joining table can be used to model a Many-to-Many relationship between two entities, such as Student and Class. For example, a joining table called Enrollment could have two columns: Student_ID and Class_ID, which reference the primary keys of the Student and Class tables respectively. Each row in the Enrollment table represents an instance of a student enrolled in a class. References: [Joining Tables], [Many-to-Many Relationships], [First Normal Form]

• Question 46:

  Your organization is in the process of redesigning its user interfaces in order to use space efficiently.

  Which layout component is most appropriate for displaying the interface where the meaningful order of components is vertical?

  A. a!columnsLayout()
  B. a!columnOverlay()
  C. a!cardLayout()
  D. a!sideBySideLayout()
  A. a!columnsLayout()

  ---

  Explanation/Reference:

  The requirement is to use space efficiently in a user interface where the meaningful order of components is vertical. A columns layout is the most appropriate layout component for this requirement, as it allows you to arrange components into columns that stack vertically on smaller devices. A columns layout also provides options to control the width, alignment, and visibility of each column. The other options are not suitable for this requirement, as they either do not preserve the vertical order of components or do not use space efficiently. References: Columns Layout

• Question 47:

  You need to build a process model that transforms a large data set.

  Which two things should you ensure to include in your process model? (Choose two.)

  A. A subprocess is called using "Multiple Node Instances (MNI)" to perform the transformation on each item in the data set.
  B. An XOR gateway is added before the transformation node, to check for empty/null values.
  C. A loop is created within the process model that increments on each iteration, updating that particular row in the data set.
  D. The transformation is applied with an expression rule that takes the data set as an input, and loops through the dataset using a looping function, such as foreach.
  B. An XOR gateway is added before the transformation node, to check for empty/null values.
  D. The transformation is applied with an expression rule that takes the data set as an input, and loops through the dataset using a looping function, such as foreach.

  ---

  Explanation/Reference:

  When building a process model that transforms a large data set, two things that should be ensured to include in the process model are an XOR gateway before the transformation node, to check for empty/null values, and a transformation

  applied with an expression rule that takes the data set as an input, and loops through the dataset using a looping function, such as foreach. These things can help to improve the performance and reliability of the process model. The XOR

  gateway can prevent unnecessary processing of empty or null data sets, which can save time and resources. The expression rule can perform the transformation in one transaction, instead of using multiple nodes or subprocesses, which can

  reduce the memory footprint and the database load of the process model. Therefore, the correct answers are B and D.

  References:

  [XOR Gateway]

  [Expression Rules]

  [foreach() Function]

• Question 48:

  You need to update the archival settings for a process model. You modified the automatic process clean-up settings and selected the archive processes option with `n' days.

  Which instances of that process model will be affected? (Choose the best answer.)

  A. Future and past instances of the process model including subprocesses.
  B. Future instances of the process model only.
  C. Future and past instances of the process model.
  D. Future instances of the process model only including subprocesses.
  C. Future and past instances of the process model.

  ---

  Explanation/Reference:

  The instances of the process model that will be affected by modifying the automatic process clean-up settings are future and past instances of the process model. The automatic process clean-up settings allow you to specify how long completed or canceled processes should be kept before being archived or deleted. These settings apply to all instances of the process model, regardless of when they were started or completed. However, these settings do not affect any subprocesses that are part of the process model. Subprocesses have their own archival settings that can be configured separately. References: Automatic Process Clean-up Settings, Archiving Processes

• Question 49:

  Which two statements about the a!queryEntity() function are true? (Choose two.)

  A. The queries defined using the query parameter are not limited in how long they wait to return results.
  B. The queries defined using the query parameter return a constrained subset of matching data records by default.
  C. The entity value must be given as a constant of type Data Store Entity.
  D. Setting the fetchTotalCount parameter to False can improve the performance of the rule.
  C. The entity value must be given as a constant of type Data Store Entity.
  D. Setting the fetchTotalCount parameter to False can improve the performance of the rule.

  ---

  Explanation/Reference:

  The two statements about the a!queryEntity() function that are true are: The entity value must be given as a constant of type Data Store Entity. This is because the entity value specifies which data store entity (table or view) to query from. The value must be a constant that references an existing data store entity in Appian Designer. You cannot use a variable or an expression for this value. Setting the fetchTotalCount parameter to False can improve the performance of the rule. This is because setting this parameter to False tells Appian not to calculate the total number of records that match the query criteria, which can be an expensive operation for large data sets. By default, this parameter is set to True, which means Appian will return the total count along with the query results. References: a!queryEntity() Function

• Question 50:

  You are designing a case management application. The initiator creates a case, and the reviewer reviews it approximately 7 days later.

  You have already designed a process model for the initiators to create the case.

  Which process model design will result in the lowest memory impact? (Choose the best answer.)

  A. When all case details are entered, the case appears as a case record, and when the reviewer is ready to review the record, they can do so via a related action from the case record.
  B. When all case details are entered, the process flow will proceed and assign a task to the reviewer to review the record.
  C. When all case details are entered, the process flow will call a Start Process node to initialize a review process model for the reviewer.
  D. When all case details are entered, the process flow will call a Sub-Process node to initialize a review process model for the reviewer.
  A. When all case details are entered, the case appears as a case record, and when the reviewer is ready to review the record, they can do so via a related action from the case record.

  ---

  Explanation/Reference:

  The best process model design for a case management application is to use a case record and a related action. This way, the process flow does not have to wait for the reviewer to complete the task, which can take up to 7 days. This

  reduces the memory impact of the process, as well as the risk of process timeouts or errors. The case record also provides a better user experience, as the reviewer can access the case details and the related action from one place.

  Therefore, the best answer is A.

  References:

  Case Management

  Related Actions