ACD-301 by Appian Actual Free Exam Q&As

Question 1

Review the following result of an explain statement:

Which two conclusions can you draw from this?

A. The worst join is the one between the table order_detail and order. B. The join between the tables order_detail, order and customer needs to be tine-tuned due to indices. C. The worst join is the one between the table order_detail and customer D. 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 E. The join between the tables 0rder_detail and product needs to be fine-tuned due to Indices

Discussion 0

Correct Answer: B,E Vote an answer

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

Question 2

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 timed utility process that queries data from the third-party database daily, and stores it in the Appian business database. Then use a!queryEntity using the Appian 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. In the Administration Console, configure the third-party database as a "New Data Source." Then, use a!queryEntity to retrieve the data. D. Configure an expression-backed record type, calling an API to retrieve the data from the third-party database. Then, use a!queryRecordType to retrieve the data.

Discussion 0

Correct Answer: C Vote an answer

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

Question 3

As part of an upcoming release of an application, a new nullable field is added to a table that contains customer dat a. The new field is used by a report in 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. 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 leaves it null. D. Create a rollback script that clears the data from the field. E. Create a script that adds the field and then populates it.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question 4

You are selling up a new cloud environment. The customer already has a system of record for Its employees and doesn't want to re-create them in Appian. so you are going to Implement LDAP authentication.
What are the next steps to configure LDAP authentication?
To answer, move the appropriate steps from the Option list to the Answer List area, and arrange them in the correct order. You may or may not use all the steps.

Discussion 0

Correct Answer:

Question 5

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. Allocate stories to each team based on the cumulative years of experience of the team members. B. Have each team choose the stories they would like to work on based on personal preference. C. Group epics and stories by technical difficulty, and allocate one team the more challenging stories. D. Group epics and stories by feature, and allocate work between each team by feature.

Discussion 0

Correct Answer: D Vote an answer

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

Appian Certified Lead Developer - ACD-301 Exam Practice Test