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. 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.
• B. result totalCount is 1
• 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.

You're in the process of deploying a package to the client's TEST environment at the end of a sprint. This package is only relating to changes to a single application.
Which two statements best describes the practices you should follow for automated testing for expression rules either before or after deploying the package? (Choose two.)

• A. After deploying the package, you should perform regression testing by running the Start Rule Tests (Applications) smart service to automatically run the test cases. This indicates whether there are any impacts caused by changes to the application.
• B. Before using Compare and Deploy, individually evaluate the test cases in the expression rules you intend to deploy. For any failed test case, adjust the expression rule so that it passes.
• C. During Compare and Deploy, the Inspect Deployment tab automatically runs the test cases in each of the expression rules. Review these findings, and either adjust the expression rule or delete outdated test cases.
• D. After deploying the package, you should perform regression testing by running the Start Rule Tests (All) smart service to automatically run the test cases. This indicates whether there are any impacts caused by the changes across multiple applications.

You're developing a record view for a case management system that enables users to upload files to a specific location within an external records application.
Your requirements are:
In this record view, there should be a record action that allows the user to upload a file to the interface and configure the metadata (name, author, file size) before submitting.
If the file is larger than 250MB, the user will be notified that the file will be uploaded overnight.
Once the file has been successfully uploaded, the file will appear on the record view and the user can interact with the file.
Which two pieces of user-facing information must be captured from this business process so that you can develop this record view? (Choose two.)

• A. The location of where the file will be uploaded to in the external records application.
• B. How the user wishes to interact with these files in the record view - as a grid or a series of card layouts.
• C. The time of file upload if the file is less than 250MB.
• D. The email of the system administrator so that an email can be sent to them if the integration fails.

You're creating a synced record type which will store read-only data from an external web service. Data in the external system is updated nightly, and the latest information must be available to users in the morning. Currently there are approximately 150,000 entries in the external system, and this number is not expected to change significantly.
There is an existing integration object and associated expression rule, which when called returns the complete dataset from the external system.
What are two configurations that you must apply to ensure that the latest and complete record set is available? (Choose two.)

• A. Within the Source Filters settings on the record type, disable the row limit option so that all entries can be retrieved from the external system.
• B. Modify the integration object and associated expression rule to return batches of 1000 based on a batch number passed in from the record type.
• C. Set all record fields to evaluate in real-time so that the latest information is always retrieved from the web service.
• D. Within the record type, schedule a full sync to occur nightly after the data is refreshed in the external system.

You have a requirement to implement an audit trail for any modifications to a record.
You need to select the most efficient design option that has the least impact on your Appian application.
What should you do?

• A. Create a custom plug in that can write an audit trail to a log file.
• B. Create a trigger on the database table to capture the audit trail to a table
• C. Create an Appian process to capture the change history and write the audit trail to the database