You are just starting with a new team that has been working together on an application for months. They ask you to review some of their views that have been degrading in performance. The views are highly complex with hundreds of lines of SQL. What is the first step in troubleshooting the degradation?

• A. Go through the entire database structure to obtain an overview, ensure you understand the business needs, and then normalize the tables to optimize performance.
• 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 critical areas of improvement that can be remediated 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.

You need to export data using an out-of-the-box Appian smart service. Which two formats are available (or data generation?

• A. Excel
• B. CSV
• C. XML
• D. JSDN

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

What are two advantages of having High Availability (HA) for Appian Cloud applications?

• A. A typical Appian Cloud HA instance is composed of two active nodes.
• B. Data and transactions are continuously replicated across the active nodes to achieve redundancy and avoid single points of failure.
• C. In the event of a system failure, your Appian instance will be restored and available to your users in less than 15 minutes, having lost no more than the last 1 minute worth of data.
• D. An Appian Cloud HA instance is composed of multiple active nodes running in different availability zones in different regions.

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 Process Messaging to start the utility process.
• C. Use the Start Process Smart Service to start the utility processes.
• D. Start the utility processes via a subprocess synchronously.