You are developing a case management application to manage support cases for a large set of sites. One of the tabs in this application s site Is a record grid of cases, along with Information about the site corresponding to that case. Users must be able to filter cases by priority level and status.
You decide to create a view as the source of your entity-backed record, which joins the separate case/site tables (as depicted in the following Image).

Which three column should be indexed?

• A. status
• B. modified_date
• C. case_id
• D. priority
• E. name
• F. site_id

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. Design a process report and query to determine who opened the edit form first.
• B. Use the database to implement low-level pessimistic locking.
• C. Add an @Version annotation to the case CDT to manage the locking.
• D. Allow edits without locking the case CDI.

You are designing a process that is anticipated to be executed multiple times a day. This process retrieves data from an external system and then calls various utility processes as needed. The main process will not use the results of the utility processes, and there are no user forms anywhere.
Which design choice should be used to start the utility processes and minimize the load on the execution engines?

• A. Start the utility processes via a subprocess asynchronously.
• B. Use the Start Process Smart Service to start the utility processes.
• C. Use Process Messaging to start the utility process.
• D. Start the utility processes via a subprocess synchronously.

A customer wants to integrate a CSV file once a day into their Appian application, sent every night at 1:00 AM. The file contains hundreds of thousands of items to be used daily by users as soon as their workday starts at 8:00 AM. Considering the high volume of data to manipulate and the nature of the operation, what is the best technical option to process the requirement?

• A. Create a set of stored procedures to handle the volume and the complexity of the expectations, and call it after each integration.
• B. Process what can be completed easily in a process model after each integration, and complete the most complex tasks using a set of stored procedures.
• C. Use an Appian Process Model, initiated after every integration, to loop on each item and update it to the business requirements.
• D. Build a complex and optimized view (relevant indices, efficient joins, etc.), and use it every time a user needs to use the data.