Appian ACD300 Online Practice Questions and Exam Preparation

Appian ACD300 Online Questions & Answers

• Question 1:

  As part of an upcoming release of an application, a new nullable field is added to a table that contains customer dataThe new field is used by a reportin the upcoming release, and is calculated using data from another table.

  Which two actions should you consider when creating the script to add the new field?

  A. Create a script thatadds the held and leaves it null.
  B. Create a rollback script that removes the field.
  C. Create a script that adds the field and then populate it
  D. Create a rollback script that clears the data from the field
  E. Add a view that joins the customer data to the data used in calculation
  B. Create a rollback script that removes the field.
  C. Create a script that adds the field and then populate it

  ---

  explanation:

  Explanation/Reference:

  When creating a script to add a new field to a table, you should consider two actions:

  Create a rollback script that removes the field. A rollback script is a script that can undo the changes made by the original script, in case something goes wrongor the changes need to be reverted. A rollback script is a good practice to have,

  as it can help to restore the previous state of the database and avoid any errors or inconsistencies. In this case, the rollback script should remove the new field from the table, and any other changes that were made by the original script.

  Create a script that adds the field and then populate it. A script that adds the field and then populate it is a script that can create the new field in the table, and then fill it with data from another table or source. This way, you can ensure that the

  new field has valid and consistent data, and that it can be used by the report in the upcoming release. In this case, the script should add the new field to the customer table, and then populate it with data from another table that contains the

  data used in the calculation.

• Question 2:

  You need to export data using an out-of-the-box Appian smart service. Which two formats are available (or data generation?

  A. CSV
  B. XML
  C. Excel
  D. JSDN
  A. CSV
  C. Excel

  ---

  explanation:

  Explanation/Reference:

  The two formats that are available for data generation using an out-of-the- box Appian smart service are:

  A. CSV. This is a comma-separated values format that can be used to export data in a tabular form, such as records, reports, or grids. CSV files can be easily opened and manipulated by spreadsheet applications such as Excel or Google Sheets.

  C. Excel. This is a format that can be used to export data in a spreadsheet form, with multiple worksheets, formatting, formulas, charts, and other features. Excel files can be opened by Excel or other compatible applications. The other options are incorrect for the following reasons:

  B. XML. This is a format that can be used to export data in a hierarchical form, using tags and attributes to define the structure and content of the data. XML files can be opened by text editors or XML parsers, but they are not supported by the out-of-the-box Appian smart service for data generation. D. JSON. This is a format that can be used to export data in a structured form, using objects and arrays to represent the data. JSON files can be opened by text editors or JSON parsers, but they are not supported by the out-of-the-box Appian smart service for data generation. Verified References: Appian Documentation, section "Write to Data Store Entity" and "Write to Multiple Data Store Entities".

• Question 3:

  You are presented with the following application requirement:

  Users must be able to navigate throughout the application while maintaining complete visibility in the

  application structure, and easily navigate to previous locations.''

  Which Appian Interface Pattern would you recommend?

  A. Use Bullous as Cards pattern on the home page lo prominently display application choices.
  B. Implement an Activity History pattern to track an organizations activity measures.
  C. implement a drilldown report pattern to show detailed information about report data.
  D. Include a breadcrumbs pattern on applicable inert aces to show the organizational hierarchy
  C. implement a drilldown report pattern to show detailed information about report data.

  ---

  explanation:

  Explanation/Reference:

  To meet the application requirement of allowing users to view summary and detailed information about report data, you should implement a drilldown report pattern to show detailed information about report data. A drilldown report pattern is a user interface component that displays data in a hierarchical structure, and allows users to expand or collapse different levels of data. For example, if the user is viewing a sales report by region, the drilldown report pattern could show something like "North America > USA > California > Los Angeles". The user can click on any level of data to see more or less details. This way, the user can see both summary and detailed information about report data, and explore different aspects of the data. The other options are not as effective. Option A, using Tiles as Cards pattern on the home page to prominently display application choices, would provide a way for users to access different parts of the application from the home page, but it would not show summary or detailed information about report data. Option B, implementing an Activity History pattern to track an organization's activity measures, would provide a way for users to see the recent actions performed by themselves or others in the application, but it would not show summary or detailed information about report data. Option D, including a breadcrumbs pattern on applicable interfaces to show the organizational hierarchy, would provide a way for users to see where they are in the application, and easily go back to any previous level by clicking on the corresponding link, but it would not show summary or detailed information about report data.

• Question 4:

  You are developing a case management application to manage support cases for a large set of sites. One of the tabs in this application s site Is a record grid of cases, along with Information about the site corresponding to that case. Users must be able to filter cases by priority level and status.

  You decide to create a view as the source of your entity-backed record, which joins the separate case/site tables (as depicted in the following Image).

  

  Which three column should be indexed?

  A. site_id
  B. status
  C. name
  D. modified_date
  E. priority
  F. case_id
  A. site_id
  B. status
  E. priority

  ---

  explanation:

  Explanation/Reference:

  Indexing columns can improve the performance of queries that use those columns in filters, joins, or order by clauses. In this case, the columns that should be indexed are site_id, status, and priority, because they are used for filtering or joining the tables. Site_id is used to join the case and site tables, so indexing it will speed up the join operation. Status and priority are used to filter the cases by the user's input, so indexing them will reduce the number of rows that need to be scanned. Name, modified_date, and case_id do not need to be indexed, because they are not used for filtering or joining. Name and modified_date are only used for displaying information in the record grid, and case_id is only used as a unique identifier for each record. Verified References: Appian Records Tutorial, Appian Best Practices

• Question 5:

  What are two advantages of having High Availability (HA) for Applan Cloud applications?

  A. An Applan Cloud HA instance is composed of multiple active nodes running in different availability zones in differentregions.
  B. Data andtransactions are continuouslyreplicated across the active nodes to achieve redundancy and avoid single points offailure.
  C. A typical Appian Cloud HA instance is composed of two active nodes.
  D. In the event of a system failure, your Appian instance will fie restored and available to your users in less than 15 minutes.having lost no more than the last 1minute worth of data.
  B. Data andtransactions are continuouslyreplicated across the active nodes to achieve redundancy and avoid single points offailure.
  D. In the event of a system failure, your Appian instance will fie restored and available to your users in less than 15 minutes.having lost no more than the last 1minute worth of data.

  ---

  explanation:

  Explanation/Reference:

  The two advantages of having High Availability (HA) for Appian Cloud applications are:

  B. Data and transactions are continuously replicated across the active nodes to achieve redundancy and avoid single points of failure. This is an advantage of having HA, as it ensures that there is always a backup copy of data and transactions in case one of the nodes fails or becomes unavailable. This also improves data integrity and consistency across the nodes, as any changes made to one node are automatically propagated to the other node. D. In the event of a system failure, your Appian instance will be restored and available to your users in less than 15 minutes, having lost no more than the last 1 minute worth of data. This is an advantage of having HA, as it guarantees a high level of service availability and reliability for your Appian instance. If one of the nodes fails or becomes unavailable, the other node will take over and continue to serve requests without any noticeable downtime or data loss for your users. The other options are incorrect for the following reasons:

  A. An Appian Cloud HA instance is composed of multiple active nodes running in different availability zones in different regions. This is not an advantage of having HA, but rather a description of how HA works in Appian Cloud. An Appian Cloud HA instanceconsists of two active nodes running in different availability zones within the same region, not different regions.

  C. A typical Appian Cloud HA instance is composed of two active nodes. This is not an advantage of having HA, but rather a description of how HA works in Appian Cloud. A typical Appian Cloud HA instance consists of two active nodes running in different availability zones within the same region, but this does not necessarily provide any benefit over having one active node. Verified References: Appian Documentation, section "High Availability".

• Question 6:

  You add an index on the searched field of a MySQL table with many rows (>100k).

  The field would benefit greatly from the Index in which three scenarios?

  A. The field contains a textual shot Business code.
  B. The field contains long unstructured text such as a hash
  C. The field contains many datetimes, covering a large range
  D. The Add contains Dig integers, above and below 0.
  E. The field contains a structured JSON.
  A. The field contains a textual shot Business code.
  C. The field contains many datetimes, covering a large range
  D. The Add contains Dig integers, above and below 0.

  ---

  explanation:

  Explanation/Reference:

  The field would benefit greatly from the index in the following scenarios:

  A. The field contains a textual short Business code. This is a scenario where an index can improve the performance of queries that search for exact matches or ranges of values in the field. A textual short Business code is likely to have high

  cardinality, meaning that it has many distinct values and low duplication. This makes the index more selective and efficient, as it can quickly narrow down the results based on the search criteria.

  C. The field contains many datetimes, covering a large range. This is a scenario where an index can improve the performance of queries that search for exact matches or ranges of values in the field. A datetime field is likely to have high

  cardinality, meaning that it has many distinct values and low duplication. This makes the index more selective and efficient, as it can quickly narrow down the results based on the search criteria.

  D. The field contains big integers, above and below 0. This is a scenario where an index can improve the performance of queries that search for exact matches or ranges of values in the field. A big integer field is likely to have high cardinality,

  meaning that it has many distinct values and low duplication. This makes the index more selective and efficient, as it can quickly narrow down the results based on the search criteria.

  The other options are incorrect for the following reasons:

  B. The field contains long unstructured text such as a hash. This is a scenario where an index might not improve the performance of queries that search for exact matches or ranges of values in the field. A long unstructured text field is likely to

  have low cardinality, meaning that it has few distinct values and high duplication. This makes the index less selective and efficient, as it cannot quickly narrow down the results based on the search criteria. Moreover, indexing a long

  unstructured text field could increase thestorage space and maintenance cost for the database, which could affect the overall performance.

  E. The field contains a structured JSON. This is a scenario where an index might not improve the performance of queries that search for exact matches or ranges of values in the field. A structured JSON field is not a native data type in

  MySQL, and it requires special functions or operators to access or manipulate its elements. Indexing a structured JSON field could increase the complexity and overhead for the database, which could affect the overall performance. Verified

  References: Appian Documentation, section "Query Optimization".

• Question 7:

  You are running an inspection as a part of the first deployment process from TEST to PROD. You receive a notice that one of your objects will not deploy because it is dependent on an object from an application owned by a separate team.

  What should be your next step?

  A. Create your own object with the same code base, replace (he dependent object in the application. and deploy to PROO.
  B. Halt the production deployment and contact the other team tor guidance on promoting the object to PROD
  C. Check the dependencies of the necessary object Deploy w PROO if there are few dependencies and it is low risk
  D. Push a functionally viable package to PROD without the dependencies, and plan the rest o! the deployment accordingly with the other team's constraints
  B. Halt the production deployment and contact the other team tor guidance on promoting the object to PROD

  ---

  explanation:

  Explanation/Reference:

  Deploying an object that is dependent on another object from a different application can cause errors and inconsistencies in the production environment. The best practice is to halt the production deployment and contact the other team for guidance on how to promote the object to PROD. The other team may have a different deployment schedule, or they may have some dependencies or customizations that need to be considered. By communicating with the other team, you can ensure that the object is deployed in a safe and coordinated manner, and avoid any potential conflicts or issues. Verified References: [Appian Deployment Guide], [Appian Best Practices]

• Question 8:

  Your Agile Scrum project requires you to manage two teams, with three developers per team. Both teams are to work on the same application In parallel.

  How should the work be divided between the teams, avoiding issues caused by cross- dependency?

  A. Group epics and stones by technical difficulty, and allocate one team the more challenging stories
  B. Group epics and stones by feature, and allocate work between each team by feature.
  C. Allocate stories to each team based on the cumulative years of experience of the team members.
  D. Have each team choose the stones they would like to work on based on personal preference
  B. Group epics and stones by feature, and allocate work between each team by feature.

  ---

  explanation:

  Explanation/Reference:

  The best way to divide the work between the teams, avoiding issues caused by cross-dependency, is to group epics and stories by feature, and allocate work between each team by feature. This way, each team can focus on a specific feature and minimize the need for coordination or integration with the other team. This also reduces the risk of conflicts or errors when merging the code from both teams. Verified References: Appian Documentation, section "Agile Development".

• Question 9:

  You are taskedto build a large scale acquisition application for a prominent customer. The acquisition process tracks the time it takes is fulfill a purchase request with an award.

  The customer has structured the contract so that there are multiple application dev teams.

  How should you design for multiple processes and forms, while minimizing repeated code?

  A. Create a Center of Excellence (CoE)
  B. Create a common objects application.
  C. Create a Scrum of Scrums sprint meeting for the team leads
  D. Create duplicate processes and forms as needed
  B. Create a common objects application.

  ---

  explanation:

  Explanation/Reference:

  To build a large scale acquisition application for a prominent customer, you should design for multiple processes and forms, while minimizing repeated code. One way to do this is to create a common objects application, which is a shared application that contains reusable components, such as rules, constants, interfaces, integrations, or data types, that can be used by multiple applications. This way, you can avoid duplication and inconsistency of code, and make it easier to maintain and update your applications. You can also use the common objects application to define common standards and best practices for your application development teams, such as naming conventions, coding styles, or documentation guidelines. Verified References: [Appian Best Practices], [Appian Design Guidance]

• Question 10:

  You are on a protect with an application that has been deployed to Production and is live with users. The client wishes to increase the number of active users.

  You need to conduct load testing to ensure Production can handle the increased usage

  Review the specs for four environments in the following image.

  

  Which environment should you use for load testing7

  A. acmeuat
  B. acmedev
  C. acme
  D. acmetest
  C. acme

  ---

  explanation:

  Explanation/Reference:

  The best environment to use for load testing is acme, which is the production environment. This is because load testing should be performed on an environment that is as close as possible to the actual production environment, in terms of hardware, software, configuration, data, and user behavior. This way, the results of the load testing will be more realistic and reliable, and can help to identify and resolve any performance issues or bottlenecks before increasing the number of active users. Verified References: Appian Documentation, section "Load Testing".