ACD300 Online Practice Questions and Answers

Correct Answer: B

The first step in troubleshooting the degradation of the views is to run an explain statement on the views, identify critical areas of improvement that can be remediated without business knowledge. An explain statement is a tool that shows how a database executes a query or a view, and provides information about the cost, plan, and steps involved in the execution. By running an explain statement on the views, you can identify any inefficiencies or bottlenecks that are causing the degradation, such as missing indices, full table scans, nested loops, or hash joins. You can then apply some basic optimization techniques that do not require business knowledge, such as creating indices, limiting the number of columns or rows returned, using joins instead of subqueries, or using materialized views. Verified References: Appian Documentation, section "Query Optimization".

Correct Answer: A

This is the best risk mitigation effort that both teams can employ to ensure that Team A's capital project is only minorly interrupted, and Team B's critical fix can be completed and deployed quickly to end users. By communicating with Team A, Team B can identify which component is causing the critical error in PROD, and check if there is any overlap of changes with Team A's enhancements. If there is an overlap, Team B can version the component to its PROD state, which is the last stable version, before making any changes to fix the error. Then, Team B can deploy the fixed component to PROD, and version it back to its latest development state, which includes Team A's enhancements. This way, Team B can avoid overwriting or losing any of Team A's work, and ensure that the component is consistent across all environments. If there is no overlap, Team B can simply make the changes to the component and deploy it to PROD, without affecting Team A's work. The other options are not as effective. Option B, having Team A analyze their current codebase in DEV to merge the hotfix changes into their latest enhancements, would delay the deployment of the critical fix, as Team B would have to wait for Team A to finish their analysis and merge. Option C, having Team B address the changes in TEST, would interrupt Team A's UAT process, and could cause conflicts or errors in TEST or PROD. Option D, having Team B address the changes directly in PROD, would be risky and not recommended, as it could introduce new errors or inconsistencies in PROD. Verified References: [Appian Deployment Guide], [Appian Best Practices]

Correct Answer: C

The best environment to use for load testing is acme, which is the production environment. This is because load testing should be performed on an environment that is as close as possible to the actual production environment, in terms of hardware, software, configuration, data, and user behavior. This way, the results of the load testing will be more realistic and reliable, and can help to identify and resolve any performance issues or bottlenecks before increasing the number of active users. Verified References: Appian Documentation, section "Load Testing".

Correct Answer: B

To build a large scale acquisition application for a prominent customer, you should design for multiple processes and forms, while minimizing repeated code. One way to do this is to create a common objects application, which is a shared application that contains reusable components, such as rules, constants, interfaces, integrations, or data types, that can be used by multiple applications. This way, you can avoid duplication and inconsistency of code, and make it easier to maintain and update your applications. You can also use the common objects application to define common standards and best practices for your application development teams, such as naming conventions, coding styles, or documentation guidelines. Verified References: [Appian Best Practices], [Appian Design Guidance]

Correct Answer: B

Deploying an object that is dependent on another object from a different application can cause errors and inconsistencies in the production environment. The best practice is to halt the production deployment and contact the other team for guidance on how to promote the object to PROD. The other team may have a different deployment schedule, or they may have some dependencies or customizations that need to be considered. By communicating with the other team, you can ensure that the object is deployed in a safe and coordinated manner, and avoid any potential conflicts or issues. Verified References: [Appian Deployment Guide], [Appian Best Practices]

Correct Answer: C

To meet the application requirement of allowing users to view summary and detailed information about report data, you should implement a drilldown report pattern to show detailed information about report data. A drilldown report pattern is a user interface component that displays data in a hierarchical structure, and allows users to expand or collapse different levels of data. For example, if the user is viewing a sales report by region, the drilldown report pattern could show something like "North America > USA > California > Los Angeles". The user can click on any level of data to see more or less details. This way, the user can see both summary and detailed information about report data, and explore different aspects of the data. The other options are not as effective. Option A, using Tiles as Cards pattern on the home page to prominently display application choices, would provide a way for users to access different parts of the application from the home page, but it would not show summary or detailed information about report data. Option B, implementing an Activity History pattern to track an organization's activity measures, would provide a way for users to see the recent actions performed by themselves or others in the application, but it would not show summary or detailed information about report data. Option D, including a breadcrumbs pattern on applicable interfaces to show the organizational hierarchy, would provide a way for users to see where they are in the application, and easily go back to any previous level by clicking on the corresponding link, but it would not show summary or detailed information about report data.

Correct Answer:

Correct Answer: