Prep and try our ACD300 valid and latest training questions & answers

Appian ACD300 Exam Overview:

Appian ACD300 Exam Syllabus Topics:

Appian Certified Lead Developer Sample Questions:

1. As part of your implementation workflow, users need to retrieve data stored in a third-party Oracle database on an interface. You need to design a way to query this information.
How should you set up this connection and query the data?

A) Configure a limed utility process that queries data from the thirdparty database daily, and stores It in the Applan business database, Then use alqueryEntity eating the Applan data source to retrieve the data.
B) Configure a Query DataBase node within the process model Then, type in the connection information, as well as a SQL query to execute and return the data in process variables.
C) Configure an expression-backed record type, calling an API to retrieve the data from the third-party database. Then, use allqueryRecordType to retrieve the data.
D) in the Administration Console configure the third-party database as a ''New Data Source,'' Then, use alqueryEntity to retrieve the data.

2. 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 COT to manage Vie locking
B) Use the database lo implement tow lewd pessimistic locking.
C) Design a process report and query to determine who opened the edit form first
D) Allow edits without locking the case GDI

3. You are reviewing the Engine Performance Logs in Production for a single application thathas been live for six months. This application experiences concurrent user activity and has a fairly sustained load during business hours. The client has reported performance issues with the application during business hours.
During your investigation, you notice a high Work Queue - Java Work Queue Size value in the logs You also notice unattended process activities, including timer events and sending notifications emails, are taking far longer to execute than normal.
The client Increased the number of CPU cores prior to the application going live What is the next recommendation?

A) Add more engine replicas.
B) Optimize slow-performing user interfaces.
C) Add more application servers.
D) Add execution and analytics shards

4. You are just starting with a new team that has been working together on an application for months. They ask you toreview some of their views thathave been degrading inperformance. The viewsare highly complex with hundreds of lines of SOL What is the first step in troubleshooting the degradation?

A) Go through all of the tables one by one to identify which of the grouped by. ordered by. or joined keys are currently indexed
B) Go through the entire database structure to obtain on overview, ensure you understand the business needs, andthen normalize the tables to optimizeperformance.
C) Run an explain statement on the views, identify criticalareas of improvement that can be remediated and without business knowledge
D) 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.

Solutions: