Appian ACD200 Online Practice Questions and Exam Preparation

Appian ACD200 Online Questions & Answers

• Question 1:

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

  A. Procedure
  B. Index
  C. Function
  D. View
  D. View

  ---

  Explanation/Reference:

  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 2:

  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
  B. More than 50 node instances
  C. More than 5 seconds between attended activities

  ---

  Explanation/Reference:

  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 3:

  As a developer, you have created a Web API.

  To execute the API, what is the minimum privilege the end user should have? (Choose the best answer.)

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

  ---

  Explanation/Reference:

  The minimum privilege the end user should have to execute a web API is Viewer. A web API is an Appian object that exposes data and services to outside systems through an HTTP endpoint. A web API can be configured with different security role maps that control which users can see or modify it and its properties. A user must have at least Viewer permissions to a web API in order to execute it. Viewer permissions allow the user to view and run the web API, but not to edit or delete it. References: Web APIs, Web API Security

• Question 4:

  A user is uploading a document in the Appian environment and wants to restrict the uploading of documents without extensions.

  How can this be done at the environment level?

  A. Enable File Upload > Block files without an extension, under Administration Console.
  B. Document can be uploaded but cannot be restricted.
  C. Configure Validation rules wherever required.
  D. No actions are required from the developer; Appian auto-validates these documents.
  A. Enable File Upload > Block files without an extension, under Administration Console.

  ---

  Explanation/Reference:

  The best way to restrict the uploading of documents without extensions at the environment level is to enable the File Upload > Block files without an extension option under the Administration Console. This option will prevent users from

  uploading files that do not have a valid file extension, such as .docx, .pdf, or .png. This can help to avoid security risks and compatibility issues with unsupported file types. Therefore, the correct answer is A.

  References:

  [File Upload Settings]

  [File Extensions]

• Question 5:

  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.
  A. Indexes increase the performance of Read operations.
  C. Indexes decrease the performance of Write operations.

  ---

  Explanation/Reference:

  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 6:

  You are reviewing a recent Health Check report and notice that a process model has high memory consumption.

  What are three possible reasons for this? (Choose three.)

  A. Too many process variables
  B. Misconfigured error alerts
  C. Nested CDTs with large numbers of fields
  D. Too many nodes
  E. Gateway nodes with multiple incoming flows
  A. Too many process variables
  C. Nested CDTs with large numbers of fields
  D. Too many nodes

  ---

  Explanation/Reference:

  Three possible reasons for high memory consumption of a process model are: Too many process variables. Process variables are used to store data that is needed throughout the process execution. However, having too many process variables can increase the memory usage of the process engine, especially if the variables store large or complex data types, such as documents or CDTs. It is recommended to use local variables whenever possible, and to delete or nullify process variables that are no longer needed. Nested CDTs with large numbers of fields. CDTs are custom data types that define the structure and validation of business data in Appian. CDTs can be nested within other CDTs to create complex data models. However, nesting CDTs with large numbers of fields can result in high memory consumption and performance degradation, as each field requires additional memory allocation and processing. It is recommended to limit the number of fields and nesting levels of CDTs, and to use references instead of embedding whenever possible. Too many nodes. Nodes are the graphical elements that represent the activities and events in a process model. Having too many nodes in a process model can increase the memory usage and complexity of the process execution. It can also make the process model harder to read and maintain. It is recommended to simplify the process model by using subprocesses, smart services, or expression rules to encapsulate common or reusable logic. References: Process Variables, Custom Data Types, Process Model Best Practices

• Question 7:

  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
  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

• Question 8:

  You have a requirement that can only be achieved by using a plug-in, where more than one plug-in does a similar job.

  What are three primary considerations in choosing the right plugin? (Choose three.)

  A. What are the compatible Appian versions?
  B. Is the plug-in Cloud-approved?
  C. What are the limitations of the plug-in?
  D. What is the size of the plug-in?
  E. Who is the plug-in author?
  A. What are the compatible Appian versions?
  B. Is the plug-in Cloud-approved?
  C. What are the limitations of the plug-in?

  ---

  Explanation/Reference:

  The question is about choosing the right plug-in for a requirement that can only be achieved by using a plug-in. The following are three primary considerations in choosing the right plug-in: What are the compatible Appian versions? This is important because some plug- ins may not work with older or newer versions of Appian due to changes in APIs or features. You should check the plug-in documentation or release notes to see which Appian versions are supported by the plug-in. Is the plug-in Cloud-approved? This is important because some plug-ins may not be allowed in Appian Cloud environments due to security or performance reasons. You should check the Appian Cloud Approved Plug-ins list to see which plug-ins are approved for use in Appian Cloud. What are the limitations of the plug-in? This is important because some plug-ins may have known issues or limitations that could affect your requirement or use case. You should check the plug-in documentation or forums to see if there are any reported bugs or limitations for the plug-in. The following are not primary considerations in choosing the right plug-in: What is the size of the plug-in? This is not a major factor, as plug-ins are usually small in size and do not affect the performance or storage of Appian significantly. However, you should still follow the best practices for managing plug-ins and avoid installing unnecessary or unused plug-ins. Who is the plug-in author? This is not a decisive factor, as plug-ins can be authored by Appian, third-party vendors, or community members. However, you should still consider the reputation and reliability of the plug-in author and check their support and update policies. References: Plug-ins Appian Cloud Approved Plug-ins

• Question 9:

  HOTSPOT

  You are presenting data through data visualization.

  Match the chart types to the data they are best suited to represent. Each answer will be used once.

  Note: To change your responses, you may deselect your response by clicking the blank space at the top of the selection list.

  Hot Area:

  

  

  ---

  Explanation/Reference:

  

  The question is about presenting data through data visualization and matching the chart types to the data they are best suited to represent. The following are the correct matches: A pie chart is best suited to represent proportional data in one category and can help us understand the contribution of parts to a whole. A pie chart shows the relative size of each part as a slice of a circular pie, and can display percentages or absolute values. For example, a pie chart can show the market share of different smartphone brands in one country. A line chart is best suited to represent direct comparison of data with multiple categories with a relatively small set of positive and negative values. A line chart shows the change or trend of data over time or another variable, and can display multiple lines for different categories. For example, a line chart can show the temperature change of different cities over a year. A bar chart is best suited to represent values across a relatively large number of categories that are not sequential or time-based. A bar chart shows the magnitude or frequency of data using horizontal or vertical bars, and can display multiple bars for different categories. For example, a bar chart can show the number of students enrolled in different courses in a university. References: Pie Chart Line Chart Bar Chart

• Question 10:

  While deploying a package to a target environment, object security warnings were detected.

  In which two places can object security settings be changed in bulk? (Choose two.)

  A. Application security summary
  B. Administration Console
  C. Compare and Deploy tool
  D. Process model folder
  A. Application security summary
  C. Compare and Deploy tool

  ---

  Explanation/Reference:

  Object security settings can be changed in bulk in the application security summary and the compare and deploy tool. The application security summary provides a centralized view of the security role maps for all objects in an application. You can filter, sort, and edit the role maps from this view. The compare and deploy tool allows you to compare objects between two environments and deploy changes from one environment to another. You can also edit the role maps of the objects before deploying them. References: Application Security Summary, Compare and Deploy Tool