Free Appian ACD301 Exam Questions

Question 1

Review the following result of 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 is the one between the table order_detail and order.

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

D : The join between the tables 0rder_detail and product needs to be fine-tuned due to Indices

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

Answer: C,D

Question 2

You are taking your package from the source environment and importing it into the target environment. Review the errors encountered during inspection: What is the first action you should take to Investigate the issue?

A : Check whether the object (UUID ending in 18028821) is included in this package

B : Check whether the object (UUD ending in 7t00000i4e7a) is included in this package

C : Check whether the object (UUID ending in 25606) is included in this package

D : Check whether the object (UUID ending in 18028931) is included in this package

Answer: B

Question 3

Review the following result of 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 is the one between the table order_detail and order.

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

D : The join between the tables 0rder_detail and product needs to be fine-tuned due to Indices

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

Answer: C,D

Question 4

You are taking your package from the source environment and importing it into the target environment. Review the errors encountered during inspection: What is the first action you should take to Investigate the issue?

A : Check whether the object (UUID ending in 18028821) is included in this package

B : Check whether the object (UUD ending in 7t00000i4e7a) is included in this package

C : Check whether the object (UUID ending in 25606) is included in this package

D : Check whether the object (UUID ending in 18028931) is included in this package

Answer: B

Question 5

You are taking your package from the source environment and importing it into the target environment. Review the errors encountered during inspection: What is the first action you should take to Investigate the issue?

A : Check whether the object (UUID ending in 18028821) is included in this package

B : Check whether the object (UUD ending in 7t00000i4e7a) is included in this package

C : Check whether the object (UUID ending in 25606) is included in this package

D : Check whether the object (UUID ending in 18028931) is included in this package

Answer: B