Appian Appian Certifications ACD200 Questions & Answers

• Question 31:

  Your organization is considering automating the running of expression rule test cases to provide unit tests for your Appian applications.

  Which three methods could be used to launch a test run when required? (Choose three.)

  A. Via the DevOps section of the Administration Console.

  B. A process model invoked via an API.

  C. A process model exposed to users as an action.

  D. A web hook from a content versioning system (CVS).

  E. A SAIL interface embedded in a report.

  Correct Answer: BCE

  Three methods that could be used to launch a test run for expression rule test cases when required are: A process model invoked via an API. A process model can be designed to run test cases for expression rules using the a!testRule() function or the Test Rule smart service. This process model can be exposed as a web API with an HTTP method such as POST or PUT, allowing external systems or applications to invoke it through an HTTP request. A process model exposed to users as an action. A process model can also be designed to run test cases for expression rules using the same function or smart service as above. This process model can be exposed to users as an action on an interface, such as a button or a link, allowing users to trigger it manually when needed. A SAIL interface embedded in a report. A SAIL interface can be created to run test cases for expression rules using the a!testRule() function. This interface can be embedded in a report, such as a grid or a chart, allowing users to view the test results interactively on an interface. References: Automated Testing for Expression Rules, a!testRule() Function, Test Rule Smart Service, Web APIs, SAIL Interfaces

• Question 32:

  You need to build a QC review process for a factory that allows a technician to review each production line on a regular basis.

  A QC technician has 30 minutes to complete their review, after which time the review will expire and be marked as a "missed review." If this, occurs, a supervisor should be notified via email and the review data should not be saved. Additional requirements are as follows:

  The user should be able to save a draft of their review before submission, and come back to work on it later.

  Once submitted, the review data should be saved to the database.

  Which option needs to be implemented to meet the requirements?

  A. An exception timer that skips the QC review task after 30 minutes, which flows to a Send Email node configured to notify a supervisor

  B. The task configured as a quick task

  C. A send message event which sends an email after 30 minutes to the supervisor

  D. An escalation that sends an email after 30 minutes to the supervisor

  Correct Answer: A

• Question 33:

  Your table contains several indexes.

  Which two statements regarding indexes are correct? (Choose two.)

  A. Indexes increase the performance of Read operations.

  B. Indexes increase the performance of Write operations.

  C. Indexes decrease the performance of Write operations.

  D. Indexes decrease he performance of Read operations.

  Correct Answer: AC

  An index is a data structure that allows for faster retrieval of data from a table based on one or more columns. Indexes increase the performance of read operations, such as select queries, by reducing the number of records that need to be scanned. However, indexes decrease the performance of write operations, such as insert, update, and delete queries, by requiring additional work to maintain the index structure and ensure its consistency with the table data. Therefore, indexes should be used judiciously and only on columns that are frequently used in queries and have high selectivity (i.e., low number of duplicate values).

• Question 34:

  Which two practices are strongly discouraged for activity chaining? (Choose two.)

  A. Less than or equal to 5 seconds between attended activities.

  B. More than 50 node instances

  C. More than 5 seconds between attended activities

  D. Less than or equal to 50 node instances

  Correct Answer: BC

  Activity chaining is a feature that allows users to complete multiple tasks in a row without returning to their task list. However, activity chaining can also have some drawbacks, such as increased memory consumption, longer transaction times,

  and reduced user feedback. Therefore, some practices are strongly discouraged for activity chaining, such as having more than 50 node instances or more than 5 seconds between attended activities. These practices can cause performance

  issues, user frustration, or process failures. Therefore, the correct answers are B and C.

  References:

  Activity Chaining

  Performance Best Practices

• Question 35:

  What should you use to create a virtual relation in a database to query the data?

  A. Procedure

  B. Index

  C. Function

  D. View

  Correct Answer: D

  The database object that should be used to create a virtual relation in a database to query the data is a view. A view is a searchable object that is defined by a query. It does not store any data but retrieves data from one or more tables at run

  time, creating a virtual table and returning the data in the defined format. It is created using joins, filters, aggregations, or other SQL operations. A view can be used to simplify complex queries, provide security, or enhance performance.

  Therefore, the correct answer is D.

  References:

  Relational Database Guidance

  Views

• Question 36:

  You need to display the profile picture of each employee inside an employee grid, alongside their names and phone numbers.

  According to Appian best practices, what is the preferred style and size for the images?

  A. style: "AVATAR" size: "LARGE"

  B. style: "STANDARD" size: "ICON"

  C. style: "STANDARD" size: "LARGE"

  D. style: "AVATAR" size: "SMALL"

  Correct Answer: D

  According to Appian best practices, the preferred style and size for the images to display the profile picture of each employee inside an employee grid are style: "AVATAR" and size: "SMALL". This is because the avatar style creates a circular image that is suitable for profile pictures, and the small size creates a 32x32 pixel image that fits well inside a grid cell. The standard style creates a rectangular image that may not look good for profile pictures, and the large size creates a 128x128 pixel image that may be too big for a grid cell. References: Image Component

• Question 37:

  You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result set after executing the Joins.

  The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority.

  What should you use? (Choose the best answer.)

  A. Table

  B. View

  C. Stored procedure

  D. Materialized view

  Correct Answer: D

  A materialized view is the best option to show joined data from 5 tables that contain a large number of rows and could generate a large result set after executing the joins. A materialized view is a physical table that holds the results of the SQL that a view would normally be constructed from and can be generated periodically. A materialized view can improve performance by reducing the execution time of complex queries that involve multiple joins, aggregations, or calculations. A materialized view can also reduce the load on the database server by storing the query results in advance. A materialized view can be refreshed at regular intervals or on demand to reflect the changes in the underlying tables. References: [Materialized Views], [View Performance]

• Question 38:

  You are investigating a slow-performing expression rule and want to analyze this rule's historical performance.

  Which performance log should you look at to see the mean evaluation time of this rule every hour?

  A. expressions_details.csv

  B. expressions_metrics.csv

  C. expressions_summary.csv

  D. expressions_trace.csv

  Correct Answer: A

  The performance log that should be used to see the mean evaluation time of a slow-performing expression rule every hour is expressions_details.csv. This log records information about how expression rules are performing in the system,

  such as the number of evaluations, the total time, the mean total time, and the standard deviation of the total time. The log is written to once every hour, and it provides fine-grain aggregation by type of expression rule. The mean total time

  column shows the average time it took to evaluate an expression rule in milliseconds. Therefore, the correct answer is A.

  References:

  Expression Performance Logs

  Performance Best Practices

• Question 39:

  When looking at the process model metrics for your application, you see that one of your process models has a low completion rate of 10%.

  What are two potential causes of this? (Choose two.)

  A. The process instances are long-lived compared to the configured days until archival or deletion.

  B. A large number of instances are encountering process errors, and they are not being addressed by the production support team.

  C. A large value is configured for days until archival or deletion compared to other process models in your application.

  D. A large number of smart service nodes are configured in the process model.

  Correct Answer: AB

  The question is about the potential causes of a low completion rate of 10% for a process model. The following are two possible causes of this:

  The process instances are long-lived compared to the configured days until archival or deletion. This means that the process instances take a long time to complete, and they are archived or deleted before they reach the end event. This

  reduces the completion rate, as only the instances that reach the end event are counted as completed.

  A large number of instances are encountering process errors, and they are not being addressed by the production support team. This means that the process instances are stuck in an error state, and they cannot proceed to the next step or

  the end event. This reduces the completion rate, as only the instances that reach the end event are counted as completed.

  The following are not likely causes of a low completion rate:

  A large value is configured for days until archival or deletion compared to other process models in your application. This means that the process instances have more time to complete before they are archived or deleted. This should increase

  the completion rate, as more instances can reach the end event before they are removed from the system.

  A large number of smart service nodes are configured in the process model. This means that the process model has a complex logic or functionality that requires multiple smart services. This does not directly affect the completion rate, as

  long as the smart services execute successfully and do not cause errors or delays.

  References:

  Process Model Metrics

  Archiving and Deleting Process Instances

• Question 40:

  You need to insert the deleted row of a table into a history table for audit purposes.

  What is the most efficient method to achieve this?

  A. Materialized view

  B. Process model

  C. View

  D. Trigger

  Correct Answer: D

  The most efficient method to insert the deleted row of a table into a history table for audit purposes is Trigger. This is because a trigger is a database object that automatically executes a specified SQL statement when a certain event occurs on a table or view. A trigger can be defined to run before or after a delete operation on a table, and can access the deleted row using a special table called deleted. A trigger can perform the insertion of the deleted row into the history table without any additional logic or overhead from Appian. References: Triggers