Appian Certified Lead Developer - ACD300 Exam Practice Test

Question 1

For each scenario outlined, match the best tool to use to meet expectations. Each tool will be used once Note: To change your responses, you may deselected your response by clicking the blank space at the top of the selection list.

Correct Answer:

Question 2

You are reviewing log files that can be accessed in Appian to monitor and troubleshoot platform-based issues.
For each type of log file, match the corresponding Information that it provides. Each description will either be used once, or not at all.
Note: To change your responses, you may deselect your response by clicking the blank space at the top of the selection list.

Correct Answer:

Question 3

Review the following resultof an explain statement:

Which two conclusions can you draw from this?

A. The request is good enough to support a high volume of data. but could demonstrate some limitations if the developer queries information related to the product

B. The worst join isthe one between the table order_detail and order.

C. The join between the tables order_detail, order and customerneeds to be tine-tuned due to indices.

D. The join between the tables 0rder_detail and productneeds to be fine-tuned due to Indices

E. The worst join is the one between the table order_detail and customer

Correct Answer: D,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 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 the entire database structure to obtain on overview, ensure you understand the business needs, andthen normalize the tables to optimizeperformance.

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

C. Run an explain statement on the views, identify criticalareas of improvement that can be remediated and without business knowledge

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

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Appian Certified Lead Developer - ACD300 Exam Practice Test

Latest Update

Useful Links

Contact Us