Explanation
The database object that should be used to create a virtual relation in a database to query the data is a view. A view is a searchable object that is defined by a query. It does not store any data but retrieves data from one or more tables at run time, creating a virtual table and returning the data in the defined format. It is created using joins, filters, aggregations, or other SQL operations. A view can be used to simplify complex queries, provide security, or enhance performance. Therefore, the correct answer is D.
References:
* Relational Database Guidance
* Views

Explanation
Activity chaining is a feature that allows users to complete multiple tasks in a row without returning to their task list. However, activity chaining can also have some drawbacks, such as increased memory consumption, longer transaction times, and reduced user feedback. Therefore, some practices are strongly discouraged for activity chaining, such as having more than 50 node instances or more than 5 seconds between attended activities. These practices can cause performance issues, user frustration, or process failures. Therefore, the correct answers are B and C.
References:
* Activity Chaining
* Performance Best Practices

Explanation
Two things that can be done to increase the performance of a poorly-performing process model that has a lot of nodes and is mainly used to do background updates are:
* Remove all activity chaining. Activity chaining is a feature that allows a process to move from one node to another without waiting for a commit point. This can improve the performance of some processes, but it can also cause memory issues and data inconsistency if used excessively or incorrectly. Removing activity chaining can reduce the memory consumption and ensure data integrity of the process model.
* Refactor some nodes into subprocesses when possible. Subprocesses are processes that are called from within another process model. Refactoring some nodes into subprocesses can simplify the main process model and improve its readability and maintainability. It can also reduce the memory usage and execution time of the main process model, as subprocesses are executed in parallel and have their own memory allocation. References: Activity Chaining, Subprocess Node, Process Model Best Practices

Explanation
The performance log that should be used to see the mean evaluation time of a slow-performing expression rule every hour is expressions_details.csv. This log records information about how expression rules are performing in the system, such as the number of evaluations, the total time, the mean total time, and the standard deviation of the total time. The log is written to once every hour, and it provides fine-grain aggregation by type of expression rule. The mean total time column shows the average time it took to evaluate an expression rule in milliseconds. Therefore, the correct answer is A.
References:
* Expression Performance Logs
* Performance Best Practices

Explanation
The question is about a sign that an application's performance is degrading and should be addressed with changes to the application design. The following is a sign of this:
* Three of the top five most executed process models have a low completion percentage. This means that a large proportion of the process instances are not reaching the end event, either because they are taking too long to complete, or because they are encountering errors or exceptions. This can affect the performance of the application, as it can consume more memory and resources, and reduce the availability and reliability of the application. You should review the process model design and identify the causes of the low completion rate, and make changes to improve the process efficiency and error handling.
The following are not signs of performance degradation that require changes to the application design:
* Integration calls to an external system are consistently returning an HTTP status code of 500. This means that the external system is experiencing an internal server error, which is not related to the application design. You should contact the external system provider and report the issue, or implement a fallback or retry mechanism in your integration logic.
* The number of tasks assigned to users has increased from 1 per day to 5 per day. This means that the workload or demand for the application has increased, which is not necessarily a sign of performance degradation. You should monitor the task completion rate and user feedback to see if the increase in tasks is affecting the user experience or satisfaction, and adjust the task assignment or prioritization logic if needed.
* The number of objects in the Application has increased from about 100 to about 500. This means that the application has grown in size and complexity, which is not necessarily a sign of performance degradation. You should follow the best practices for application design and maintenance, such as using folders, prefixes, dependencies, and documentation, to keep the application organized and manageable.
References:
* Process Model Metrics
* HTTP Status Codes
* Task Report
* Application Design