Free Appian ACD-301 Exam Dumps Questions & Answers

You are asked to design a case management system for a client. In addition to storing some basic metadata about a case, one of the client's requirements is the ability for users to update a case. The client would like any user in their organization of 500 people to be able to make these updates. The users are all based in the company's headquarters, and there will be frequent cases where users are attempting to edit the same case. The client wants to ensure no information is lost when these edits occur and does not want the solution to burden their process administrators with any additional effort. Which data locking approach should you recommend?

• A.Add an @Version annotation to the case CDT to manage the locking.
• B.Allow edits without locking the case CDI.
• C.Design a process report and query to determine who opened the edit form first.
• D.Use the database to implement low-level pessimistic locking.

You are just starting with a new team that has been working together on an application for months. They ask you to review some of their views that have been degrading in performance. The views are highly complex with hundreds of lines of SQL. What is the first step in troubleshooting the degradation?

• A.Browse through the tables, note any tables that contain a large volume of null values, and work with your team to plan for table restructure.
• B.Run an explain statement on the views, identify critical areas of improvement that can be remediated without business knowledge.
• C.Go through the entire database structure to obtain an overview, ensure you understand the business needs, and then normalize the tables to optimize performance.
• D.Go through all of the tables one by one to identify which of the grouped by, ordered by, or joined keys are currently indexed.

You are tasked to build a large-scale acquisition application for a prominent customer. The acquisition process tracks the time it takes to fulfill a purchase request with an award.
The customer has structured the contract so that there are multiple application development teams.
How should you design for multiple processes and forms, while minimizing repeated code?

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

On the latest Health Check report from your Cloud TEST environment utilizing a MongoDB add-on, you note the following findings:
Category: User Experience, Description: # of slow query rules, Risk: High Category: User Experience, Description: # of slow write to data store nodes, Risk: High Which three things might you do to address this, without consulting the business?

• A.Use smaller CDTs or limit the fields selected in a!queryEntity().
• B.Reduce the size and complexity of the inputs. If you are passing in a list, consider whether the data model can be redesigned to pass single values instead.
• C.Optimize the database execution using standard database performance troubleshooting methods and tools (such as query execution plans).
• D.Reduce the batch size for database queues to 10.
• E.Optimize the database execution. Replace the view with a materialized view.

Your team has deployed an application to Production with an underperforming view. Unexpectedly, the production data is ten times that of what was tested, and you must remediate the issue. What is the best option you can take to mitigate their performance concerns?

• A.Introduce a data management policy to reduce the volume of data.
• B.Create a materialized view or table.
• C.Create a table which is loaded every hour with the latest data.
• D.Bypass Appian's query rule by calling the database directly with a SQL statement.