Your team has deployed an application to Production with an underperforming view. Unexpectedly, the production data is ten times that of what was tested, and you must remediate the issue. What is the best option you can take to mitigate their performance concerns?

• A. Introduce a data management policy to reduce the volume of data.
• B. Bypass Appian's query rule by calling the database directly with a SQL statement.
• C. Create a materialized view or table.
• D. Create a table which is loaded every hour with the latest data.

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.

Your client's customer management application is finally released to Production. After a few weeks of small enhancements and patches, the client is ready to build their next application. The new application will leverage customer information from the first application to allow the client to launch targeted campaigns for select customers in order to increase sales. As part of the first application, your team had built a section to display key customer information such as their name, address, phone number, how long they have been a customer, etc. A similar section will be needed on the campaign record you are building. One of your developers shows you the new object they are working on for the new application and asks you to review it as they are running into a few issues. What feedback should you give?

• A. Point the developer to the relevant areas in the documentation or Appian Community where they can find more information on the issues they are running into.
• B. Create a duplicate version of that section designed for the campaign record.
• C. Ask the developer to convert the original customer section into a shared object so it can be used by the new application.
• D. Provide guidance to the developer on how to address the issues so that they can proceed with their work.

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

• A. 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.
• B. A typical Appian Cloud HA instance is composed of two active nodes.
• C. An Appian Cloud HA instance is composed of multiple active nodes running in different availability zones in different regions.
• D. Data and transactions are continuously replicated across the active nodes to achieve redundancy and avoid single points of failure.

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. Allow edits without locking the case CDI.
• D. Design a process report and query to determine who opened the edit form first.