A view is created with the primary table PERSON and is joined using a left join with the APPOINTMENT table on the column "PERSON_ID". There is a one-to-many relationship between the PERSON and APPOINTMENT tables.
A Custom Data Type (CDT) and a data store entity have been created based on this view, with the primary key being "PERSON_ID".
Review the data presented in the PERSON and APPOINTMENT tables:

Which two statements are true when the following query entity is executed? (Choose two.)

• A. result totalCount is 1
• B. Appian makes one more query to the database(other than the actual query to fetch the data) to get the totalCount based on the applied filters.
• C. result totalCount is 3
• D. Appian makes one more query to the database(other than the actual query to fetch the data) to get the totalCount based on the applied filters and paging info.

A process was recently pushed to the Prod environment. However, users are reporting that a task on this process is experiencing slow response times when they try to input data.
What is the most likely reason for this issue?

• A. The process uses too many hidden variables.
• B. There are too many SAIL components on the task.
• C. The task is assigned to too many users.
• D. Exception timers on tasks are set to values that are too low.

You need to create a process workflow for employee background investigations. This workflow takes an average of six months from start to completion. There are multiple phases to the background investigation which must be completed by people in different departments. Each department is responsible for inputting a large amount of data as part of the workflow.
There is an emphasis on process memory management since thousands of these investigations will happen concurrently.
What are two best practices that you should employ when designing this process workflow? (Choose two.)

• A. Divide the workflow into multiple process models so that each process can be short-lived and consume less memory.
• B. Ensure that the data management policy is set to archive the process instances after a minimum of six months, so that data is available throughout the workflow.
• C. Combine all stages of the workflow into a single process model, so that data can be efficiently shared between nodes using process variables.
• D. Utilize a record-backed design throughout the workflow where data entered by users is saved to and queried from the database.

You need to assign a user input task to three different groups of users: Group A, Group B, and Group C.
Each task form shares some common components with the following key differences:
Group B will receive a task that includes an additional section.
Group C will only view and enter data for one section.
What should you do?

• A. Within the process model, utilize an XOR gateway to conditionally select between the three different user input tasks.
• B. Utilize conditional logic on the form along with the showWhen parameter for interface components.
• C. Configure the version setting on the user input task node to conditionally display the correct form.

A local variable is reevaluated every time a form loads and you notice subsequent slow performance of the form.
Which two steps could you perform to optimize this? (Choose two.)

• A. Avoid executing queries every time a form reevaluates.
• B. Ensure the local variable is refreshed after a specified interval, and nor refreshed when referenced variable are changed.
• C. Ensure the local variable only updates when a referenced variable is modified or when it's being updated in the saveInto parameter of a component.
• D. Create a local variable inside with () for faster reevaluation.