Appian Appian Certifications ACD200 Questions & Answers

• Question 41:

  You create an interface, but it fails to load. When you open the design errors log, you see a memory circuit breaker error.

  What are two possible root causes of this error? (Choose two.)

  A. A database query is taking too long to evaluate.

  B. The interface contains some special characters.

  C. The interface is storing too much data in local variables.

  D. The interface component is looping over too many items.

  Correct Answer: CD

  A memory circuit breaker error occurs when an interface consumes too much memory on the server. This can happen when the interface is storing too much data in local variables or when the interface component is looping over too many items. Both of these scenarios can cause excessive memory allocation and garbage collection, which can degrade the performance of the interface and the server. Therefore, the possible root causes of this error are C and D. References: Memory Circuit Breaker Performance Best Practices

• Question 42:

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

  Correct Answer: A

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

  During the design review, you identified slow-operating expression rules querying a specific data store.

  Which metric from the data_store_details.csv file will help you understand the "number of operations against data store?" (Choose the best answer.)

  A. Transform Count

  B. Query Count

  C. Total Count

  D. Execute Count

  Correct Answer: C

  The metric from the data_store_details.csv file that will help you understand the number of operations against data store is Total Count. This metric represents the total number of queries, inserts, updates, deletes, and executes performed against the data store during the specified time period. You can use this metric to identify which data stores are heavily used and may need performance tuning or scaling. References: [Data Store Details Report], [Data Store Metrics]

• Question 44:

  Users are reporting that their application is slow to load customer records with many transactions.

  Using performance monitoring tools, you find that the following interface definition is responsible for the vast majority of page load time:

  

  You also notice that both queries (rule!APP_GetTransactionsWithFilters and rule!APP_GetTransactionTypeWithFilters) take about 25 milliseconds each to execute when you test them using expression editor.

  Which change would decrease the load time of this interface component the most? (Choose the best answer.)

  A. Don't fetch total count when getting transactions.

  B. On line 4, increase the paginginfo batch size to 50 so more data is prefetched.

  C. Use a synced record for Transactions to improve the query response time for the query performed on line 6.

  D. Prefetched transation types and use the displayvalue() function to display the Transaction Type for each transaction.

  Correct Answer: D

  The load time of this interface component can be improved by reducing the number of queries performed and the amount of data transferred. One way to achieve this is to prefetch the transaction types and use the displayvalue() function to display the Transaction Type for each transaction. This way, only one query is performed to get the transactions, and the transaction types are retrieved from a local variable instead of a separate query. This reduces the network latency and the database load, which can improve the performance of the interface. Therefore, the best answer is D. References: Prefetching Data displayvalue() Function

• Question 45:

  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?

  Correct Answer: ABC

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

  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

  Correct Answer: B

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

  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.

  Correct Answer: BD

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

  You are creating a table to store book information for a library. The boot has a reference number (ISBN_ID), as well as a unique identifier (BOOK_ID).

  For the CDT to be created, which data type should you choose for the BOOK_ID? (Choose the best answer.)

  A. Number (Integer)

  B. Number (Decimal)

  C. Date

  D. Boolean

  Correct Answer: A

  The Number (Integer) data type should be chosen for the BOOK_ID, because it is a unique identifier for each book record. The Number (Integer) data type is used to store whole numbers without decimals, such as IDs, counts, or ordinal values. The Number (Integer) data type can also be used as a primary key for a CDT or a foreign key for referencing another CDT. References: [Number (Integer) Data Type], [CDT Primary Keys]

• Question 49:

  Your organization is considering options for integrating with external systems from within Appian.

  Which Appian object is designed to allow you to share base URL and authentication details across multiple integrations? (Choose the best answer.)

  A. A web API

  B. An integration

  C. A connector function

  D. A connected system

  Correct Answer: D

  A connected system is an Appian object that is designed to allow you to share base URL and authentication details across multiple integrations4. A connected system represents an external system that is integrated with Appian. Connected systems allow you to easily connect to external integrations and data sources. They also allow you to deploy connection information across environments and use different connection information for each environment. You can choose from different types of connected systems, such as HTTP, SQL, or pre-built connected systems for common services like Google Drive or Salesforce5.

• Question 50:

  You are designing a repeating step in a process.

  What is the default limit for maximum number of node executions?

  A. 50

  B. 2000

  C. 1000

  D. 500

  Correct Answer: C

  The question is about the default limit for maximum number of node executions in a repeating step in a process. The default limit is 1000, as it is the value of the system property conf.bpm.maxNodeExecutionsPerInstance, which controls how many times a node can be executed in a single process instance. This limit is intended to prevent infinite loops or excessive node executions that could affect the performance or stability of Appian. The other options are not correct, as they are either too high or too low. References: Repeating Steps in Processes System Properties Reference