Appian ACD200 Online Practice Questions and Exam Preparation

Appian ACD200 Online Questions & Answers

• Question 51:

  What is the lowest permission required on the data store in order to query, write, and delete data?

  A. Manager
  B. Administrator
  C. Viewer
  D. Editor
  C. Viewer

  ---

  Explanation/Reference:

  The lowest permission required on the data store in order to query, write, and delete data is Viewer. This is because the data store permissions only control the ability to view and modify the data store object in Appian Designer, not the actual data in the database. To query, write, and delete data, the user needs to have the appropriate SQL permissions on the database tables or views that are mapped to the data store entities. References: Data Store Permissions

• Question 52:

  You are tasked with configuring a process model to store the result of an expression rule for every item in a list.

  Which process model design has the lowest memory footprint?

  A. Run MNI over a script task for each item in the list.
  B. Call a sub-process for each item in the list.
  C. Configure a script task to use a!foreach to iterate over each item in the list.
  D. Create a loop of smart service nodes in the process model and execute it for each item in the list.
  C. Configure a script task to use a!foreach to iterate over each item in the list.

  ---

  Explanation/Reference:

  The question is about designing a process model to store the result of an expression rule for every item in a list with the lowest memory footprint. The best design for this purpose is to configure a script task to use a!foreach to iterate over each item in the list, as it allows you to execute an expression rule for each element of an array without creating multiple nodes or subprocesses in the process model. A script task is a node that executes an expression without user interaction, and a!foreach is a function that applies an expression to each element of an array and returns an array of results. The other options are not optimal for this purpose, as they either create more nodes or subprocesses in the process model, which consume more memory and resources. References: Script Task a!foreach()

• Question 53:

  You create an Integration that modifies the data.

  In which three locations can it be called? (Choose three.)

  A. Web API (GET)
  B. Expression or Rule
  C. Web API (POST, PUT, DELETE)
  D. Process model
  E. SAIL save into parameter
  C. Web API (POST, PUT, DELETE)
  D. Process model
  E. SAIL save into parameter

  ---

  Explanation/Reference:

  An integration that modifies data can be called from three locations: web API (POST, PUT, DELETE), process model, and SAIL saveInto parameter. These locations allow for sending data to an external system or service and receiving a

  response. Web API (POST, PUT, DELETE) are HTTP methods that are typically used to create, update, or delete data on a server. An integration that modifies data can be exposed as a web API with one of these methods, allowing external

  applications or systems to invoke it through an HTTP request1.

  Process model is a graphical representation of a business workflow that consists of nodes and flows. An integration that modifies data can be called from a process model using either an integration node or a Call Integration smart service2.

  This allows for orchestrating complex workflows that involve data manipulation across different systems or sources.

  SAIL saveInto parameter is a property of a SAIL component that specifies an expression to be evaluated when the component is modified by the user3. An integration that modifies data can be called from an interface using the saveInto

  parameter of a SAIL component. This allows for triggering data changes based on user actions or events on the interface.

• Question 54:

  You are reviewing process model metrics and looking at AMUs to evaluate a process's memory usage.

  Which statement is correct regarding this metric?

  A. Memory usage is considered low when it is below 10,000 AMUs.
  B. Memory usage is considered low when it is below 1,000 AMUs.
  C. Memory usage is considered low when it is below 100,000 AMUs.
  D. AMUs is not a good measurement for process memory usage.
  C. Memory usage is considered low when it is below 100,000 AMUs.

  ---

  Explanation/Reference:

  The question is about AMUs (Appian Memory Units), which is a metric that measures the memory usage of a process model. The following statement is correct regarding this metric:

  Memory usage is considered low when it is below 100,000 AMUs. This is based on the Appian recommendation that each process model should use less than 100,000 AMUs on average, as higher memory usage can affect the performance

  or stability of Appian.

  The following statements are not correct regarding this metric:

  Memory usage is considered low when it is below 10,000 AMUs. This is too low, as most process models will use more than 10,000 AMUs on average, depending on their complexity and data size.

  Memory usage is considered low when it is below 1,000 AMUs. This is too low, as even simple process models will use more than 1,000 AMUs on average, depending on their configuration and parameters. AMUs is not a good measurement

  for process memory usage. This is not true, as AMUs is a standardized and consistent measurement that reflects the relative memory usage of different process models in Appian.

  References:

  AMUs (Appian Memory Units)

• Question 55:

  You are analyzing a poorly-performing process model.

  You find that the process model in question has a lot of nodes and is mainly used to do background updates.

  Which two things can be done to increase its performance? (Choose two.)

  A. Define the correct alerts for the process model.
  B. Remove all activity chaining.
  C. Use swim lanes in the process model.
  D. Refactor some nodes into subprocesses when possible.
  B. Remove all activity chaining.
  D. Refactor some nodes into subprocesses when possible.

  ---

  Explanation/Reference:

  Two things that can be done to increase the performance of a poorly- performing process model that has a lot of nodes and is mainly used to do background updates are: Remove all activity chaining. Activity chaining is a feature that allows a process to move from one node to another without waiting for a commit point. This can improve the performance of some processes, but it can also cause memory issues and data inconsistency if used excessively or incorrectly. Removing activity chaining can reduce the memory consumption and ensure data integrity of the process model. Refactor some nodes into subprocesses when possible. Subprocesses are processes that are called from within another process model. Refactoring some nodes into subprocesses can simplify the main process model and improve its readability and maintainability. It can also reduce the memory usage and execution time of the main process model, as subprocesses are executed in parallel and have their own memory allocation. References: Activity Chaining, Subprocess Node, Process Model Best Practices

• Question 56:

  Using a View, you pull a report on different employee transactions. You receive the following error: "a!queryEntity: An error occurred while retrieving the data."

  What is the most likely root cause? (Choose the best answer.)

  A. The view contains a large number of rows, requiring more time to fetch the data.
  B. The view doesn't have a column mapped as a Primary Key in its corresponding CDT.
  C. The required inputs were not provided.
  D. The rule contains a missing syntax.
  A. The view contains a large number of rows, requiring more time to fetch the data.

  ---

  Explanation/Reference:

  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]

• Question 57:

  In the next year, you expect the number of concurrent active users of your application to increase from approximately 50 to 500.

  Which two recommendations for your Appian environment would address the performance risk of this large increase in users? (Choose two.)

  A. Add more design engines.
  B. Add more process execution engines.
  C. Add more application server memory.
  D. Switch from a records-centric to a process-centric design.
  B. Add more process execution engines.
  C. Add more application server memory.

  ---

  Explanation/Reference:

  The question is about the recommendations for Appian environment to address the performance risk of a large increase in users. The following are two recommendations for this purpose: Add more process execution engines. This means adding more servers or nodes that can execute process instances in parallel, which can improve the scalability and availability of Appian. This can help handle the increased workload and demand from more users without affecting the response time or reliability of Appian. Add more application server memory. This means increasing the amount of memory allocated to each server or node that runs Appian components, such as web servers, engines, or analytics servers. This can help improve the performance and stability of Appian by reducing memory pressure and garbage collection. The following are not recommendations for Appian environment to address the performance risk of a large increase in users: Add more design engines. This means adding more servers or nodes that can execute expression rules or interface components in parallel, which can improve the performance and scalability of Appian. However, this is not directly related to the number of users, but rather to the complexity and frequency of expression rules or interface components in the application. Switch from a records-centric to a process-centric design. This means changing the application design to focus more on process models and tasks, rather than records and reports. This does not affect the Appian environment, but rather the application logic and functionality. This may or may not improve the performance of the application, depending on the requirements and use cases. References: Process Execution Engines Memory Recommendations Design Engines Records-Centric vs Process-Centric Design

• Question 58:

  You are about to deploy a package to another environment.

  Which two statements are true? (Choose two.)

  A. It is not possible to undo changes from an import to all types of objects.
  B. It is possible to undo changes from an import to all types of objects.
  C. It is possible to import the same package multiple times.
  D. It is not possible to import the same package multiple times.
  A. It is not possible to undo changes from an import to all types of objects.
  C. It is possible to import the same package multiple times.

  ---

  Explanation/Reference:

  Two true statements are: It is not possible to undo changes from an import to all types of objects. Once a package is imported to an environment, it applies changes to the existing objects or creates new objects based on the package contents. There is no built-in mechanism to revert these changes or delete these objects automatically. Therefore, it is important to test the package in a non-production environment before importing it to production, and to backup any objects that may be overwritten by the import. It is possible to import the same package multiple times. A package can be imported to an environment more than once, as long as it does not contain any conflicts or errors that would prevent the import. However, importing the same package multiple times may not have any effect if there are no changes in the package contents or in the target environment since the last import. References: Prepare Deployment Packages, Application Deployment Guidelines

• Question 59:

  You are facing issues when attempting to establish a SAML connection to an identity provider. You determine you need to increase the authentication-specific logging levels so that you can view trace level statements about the connection attempt in the application server log.

  Which property file should you update to modify the log output level? (Choose the best answer.)

  A. commons-logging.Properties
  B. appian_log4j.properties
  C. logging.properties
  D. custom.properties
  B. appian_log4j.properties

  ---

  Explanation/Reference:

  The appian_log4j.properties file is used to configure the logging levels for Appian components, including authentication. You can modify this file to increase or decrease the verbosity of the log output for different categories. For example, to enable trace-level logging for SAML authentication, you can add this line to the file: log4j.logger.com.appiancorp.suite.authentication.saml=TRACE References: [Appian Logging Configuration], [SAML Troubleshooting]

• Question 60:

  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
  D. Trigger

  ---

  Explanation/Reference:

  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