ACD200 Online Practice Questions and Answers

Correct Answer: BCD

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 actions can be taken to make the process model more efficient, such as:

Shorten long process chains by combining transactions into the smallest number of nodes. This can reduce the memory footprint and the database load of the process model.

Avoid chaining system nodes like Integrations. These nodes can have unpredictable execution times and can cause timeouts or errors if chained. It is better to use asynchronous integrations or message events to decouple the process flow

from external systems.

Move transactions that can be done asynchronously outside of the chain. This can improve the responsiveness of the process model and allow parallel processing of independent tasks.

Therefore, the correct answers are B, C, and D.

References:

Activity Chaining

Performance Best Practices

Correct Answer: A

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

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

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

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

Correct Answer: BCE

The question is about improving the memory usage of a process model. The following are three things you can do for this purpose: Reduce the number of process variables. This means using fewer or smaller process variables to store data in the process model, as each process variable consumes memory and resources. You should only use process variables that are necessary for the process logic or data flow, and avoid storing redundant or temporary data in process variables. Avoid storing large blocks of text in process variables. This means using other methods to store or handle large blocks of text, such as documents, constants, or expression rules, rather than process variables. This can reduce the memory usage of the process model, as large blocks of text can consume a lot of memory and resources, and affect the performance or stability of Appian. Pass data directly to activity nodes and smart services. This means using parameters or inputs to pass data to activity nodes and smart services, rather than process variables. This can reduce the memory usage of the process model, as parameters or inputs are only evaluated when needed, and do not persist in memory. The following are not things you can do to improve the memory usage of a process model: Configure process variables to be parameters. This is not possible, as process variables and parameters are different types of data elements in a process model. Process variables are used to store data throughout the process model, while parameters are used to pass data to or from a subprocess or an expression rule. Split large nodes into many smaller nodes. This is not advisable, as it can increase the complexity and maintenance overhead of the process model, and may not reduce the memory usage significantly. You should only split nodes when it makes sense for the process logic or functionality, and not for the sake of reducing node size. References: Process Variables Documents Constants Expression Rules Parameters

Correct Answer: C

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

Correct Answer: AD

A sprint retrospective is a meeting that takes place at the end of each sprint, where the team reflects on what went well and what can be improved in their work process. The purpose of the retrospective is to identify and implement actions that can enhance the team's performance and satisfaction in future sprints. Two basic questions that can help facilitate the retrospective are: What went well? and What didn't go well and can be improved? These questions allow the team to celebrate their achievements, acknowledge their challenges, and generate ideas for improvement.

Correct Answer: A

The most likely root cause of the error is that the view contains a large number of rows, requiring more time to fetch the data. This can result in a timeout or an out-of-memory error. To avoid this, you can use pagination or filters to limit the number of rows returned by the view. You can also optimize the view performance by using indexes, avoiding unnecessary joins, and reducing the number of columns. References: [Views], [View Performance]