Appian Appian Certifications ACD300 Questions & Answers

• Question 11:

  As part of your implementation workflow, users need to retrieve data stored in a third-party Oracle database on an interface. You need to design a way to query this information.

  How should you set up this connection and query the data?

  A. Configure a Query DataBase node within the process model Then, type in the connection information, as well as a SQL query to execute and return the data in process variables.

  B. Configure a limed utility process that queries data from the thirdparty database daily, and stores It in the Applan business database, Then use alqueryEntity eating the Applan data source to retrieve the data.

  C. Configure an expression-backed record type, calling an API to retrieve the data from the third-party database. Then, use allqueryRecordType to retrieve the data.

  D. in the Administration Console configure the third-party database as a `'New Data Source,'' Then, use alqueryEntity to retrieve the data.

  Correct Answer: D

  To meet the application requirement of allowing users to navigate throughout the application while maintaining complete visibility in the application structure, and easily navigate to previous locations, you should include a breadcrumbs pattern on applicable interfaces to show the organizational hierarchy. A breadcrumbs pattern is a user interface component that displays the current location of the user within the application, and provides links to the previous levels of the hierarchy. For example, if the user is viewing a product details page, the breadcrumbs pattern could show something like "Home > Products > Product Details". This way, the user can see where they are in the application, and easily go back to any previous level by clicking on the corresponding link. 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 the organizational hierarchy or allow users to navigate to previous locations. 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 the organizational hierarchy or allow users to navigate to previous locations. Option C, implementing a drilldown report pattern to show detailed information about report data, would provide a way for users to explore different levels of data in a report, but it would not show the organizational hierarchy or allow users to navigate to previous locations.

• Question 12:

  You have created a Web API in Appian. with the following URL to call it: https://exampleappiancloud.com/suite/webapi/usef_managefnent/ users ?username=)=john.smith.

  Which is the connect syntax forreferring to the user name parameter'

  A. httpirequest.queryParameters users username

  B. httpirequest usees username

  C. httpirequest formData username

  D. httpirequest queryParameters.username

  Correct Answer: D

  The correct syntax for referring to the username parameter in the Web API URL is httpirequest.queryParameters.username. This syntax allows you to access the value of the username parameter that is passed in the query string of the URL after the question mark (?). For example, if the URL ishttps://exampleappiancloud.com/suite/webapi/user_management/users?username=john. smith, then httpirequest.queryParameters.username will return john.smith. Verified References: Appian Documentation, section "Web API".

• Question 13:

  You are planning a strategy around data volume testing for an Appian application that queries and writes to MySQL database.

  You have administrator access to the Appian application and to the database.

  What are two key considerations when designing a data volume testing strategy?

  A. Data from previous tests needs to remain in the testing environment prior to loading prepopulated data

  B. large datasets must be loaded via Applan processes

  C. The amount of data that needs to be populated should be determined by the project sponsor and the stakeholders based on their estimation

  D. Testing with the correct amount of data should be in the definition of done as part of each sprint.

  E. Data model changes must wait until towards the end of the protect.

  Correct Answer: DE

  When designing a data volume testing strategy for an Appian application that queries and writes to MySQL database, you should consider two key considerations: Testing with the correct amount of data should be in the definition of done as part of each sprint. Data volume testing is a type of testing that verifies how well an application performs when handling large amounts of data. Data volume testing is important to ensure that the application meets the performance and quality requirements of the users and stakeholders. By including data volume testing in the definition of done as part of each sprint, you can ensure that each feature or functionality of your application is tested with realistic data volumes before being delivered to production. This way, you can identify and resolve any potential issues or bottlenecks early in the development cycle, and avoid any surprises or delays later on. Data model changes must wait until towards the end of the project. Data model changes are changes that affect the structure or schema of your database, such as adding, modifying, or deleting tables, columns, indexes, or constraints. Data model changes are risky and costly to make, especially when dealing with large amounts of data. Data model changes can affect the performance, functionality, or integrity of your application and database. Therefore, data model changes must wait until towards the end of the project, when you have finalized your requirements and design decisions, and have minimized your data volume testing efforts. By waiting until towards the end of the project to make data model changes, you can reduce the impact and complexity of those changes, and avoid any unnecessary rework or regression. The other options are not as effective. Option A, data from previous tests needs to remain in the testing environment prior to loading prepopulated data, is not a key consideration for designing a data volume testing strategy, but rather a best practice for preparing your testing environment. Option B, large datasets must be loaded via Appian processes, is not a key consideration for designing a data volume testing strategy, but rather a technical implementation detail that may or may not be suitable for your application. Option C, the amount of data that needs to be populated should be determined by the project sponsor and the stakeholders based on their estimation, is not a key consideration for designing a data volume testing strategy, but rather an input or assumption that you need to validate before conducting your data volume testing.

• Question 14:

  Review the following resultof an explain statement: Which two conclusions can you draw from this?

  

  A. The request is good enough to support a high volume of data. but could demonstrate some limitations if the developer queries information related to the product

  B. The worst join isthe one between the table order_detail and order.

  C. The join between the tables order_detail, order and customerneeds to be tine-tuned due to indices.

  D. The join between the tables 0rder_detail and productneeds to be fine-tuned due to Indices

  E. The worst join is the one between the table order_detail and customer

  Correct Answer: DE

  D. The join between the tables order_detail and product needs to be fine-tuned due to Indices. This is correct because the result of the explain statement showsthat the join between these two tables has a high cost of 0.99, which indicates that it is inefficient and needs to be fine-tuned. One possible reason for the high cost is that there are no indices on the columns that are used for joining these two tables, which leads to a full table scan. Therefore, creating indices on these columns could improve the performance of this join. E. The worst join is the one between the table order_detail and customer. This is correct because the result of the explain statement shows that the join between these two tables has a very high cost of 1.00, which indicates that it is the worst join in terms of efficiency and needs to be fine-tuned. One possible reason for the high cost is that there are no indices on the columns that are used for joining these two tables, which leads to a full table scan. Therefore, creating indices on these columns could improve the performance of this join. The other options are incorrect for the following reasons:

  A. The request is good enough to support a high volume of data, but could demonstrate some limitations if the developer queries information related to the product. This is incorrect because the request is not good enough to support a high volume of data, as it has two joins with very high costs that need to be fine- tuned. Moreover, querying information related to the product would not necessarily cause any limitations, as long as the join between order_detail and product is optimized.

  B. The worst join is the one between the table order_detail and order. This is incorrect because the result of the explain statement shows that the join between these two tables has a low cost of 0.01, which indicates that it is efficient and does not need to be fine-tuned.

  C. The join between the tables order_detail, order and customer needs to be fine- tuned due to indices. This is incorrect because there is no such join between three tables in the result of the explain statement. There are only two joins: one between order_detail and order, and another between order_detail and customer. Each of these joins needs to be fine-tuned separately due to indices.

• Question 15:

  You are required to create an integration from your Appian cloud instance to an application hosted within a customers self-managed environment.

  The customers IT team has provided you with a REST API endpoint to test with; httpsV/lnternal networkVapi/api /ping

  Which recommendation should you make to progress this integration?

  A. Expose the API as a SOAP-basedweb service.

  B. Deploy the API / service into Appian Cloud

  C. Add Appian Cloud's IP address ranges lo the customer network's allowed IP listing

  D. Set up a VPN tunnel

  Correct Answer: D

  To create an integration from your Appian cloud instance to an application hosted within a customer's self-managed environment, you need to ensure that there is a secure and reliable connection between the two systems. One way to do this is to set up a VPN tunnel, which is a virtual private network that encrypts and transports data over the internet. A VPN tunnel allows you to access the customer's internal network and API endpoint from your Appian cloud instance, without exposing them to the public internet. This way, you can ensure the security and privacy of the data that is exchanged between the two systems. Verified References: [Appian Cloud VPN], [Appian Integration Guide]

• Question 16:

  You are required to configure a connection so that Jira can inform Appian when specific tickets change (using webhook).

  Which three required steps will allow you to connect both systems?

  A. Create a Web API object and set up the correct security.

  B. Configure the connection In Jira specifying the URE and credentials

  C. Create a new API Key and associate a service account

  D. Give the service account system administrator privileges

  E. Create an integration object from Applan to Jira to periodically check the ticket status

  Correct Answer: ABC

  The three required steps that will allow you to connect both systems are:

  A. Create a Web API object and set up the correct security. This will allow you to define an endpoint in Appian that can receive requests from Jira via webhook. You will also need to configure the security settings for the Web API object, such as authentication method, allowed origins, and access control. B. Configure the connection in Jira specifying the URL and credentials. This will allow you to set up a webhook in Jira that can send requests to Appian when specific tickets change. You will need to specify the URL of the Web API object in Appian, as well as any credentials required for authentication. C. Create a new API Key and associate a service account. This will allow you to generate a unique token that can be used for authentication between Jira and Appian. You will also need to create a service account in Appian that has permissions to access or update data related to Jira tickets. The other options are incorrect for the following reasons:

  D. Give the service account system administrator privileges. This is not required and could pose a security risk, as giving system administrator privileges to a service account could allow it to perform actions that are not related to Jira tickets, such as modifying system settings or accessing sensitive data. E. Create an integration object from Appian to Jira to periodically check the ticket status. This is not required and could cause unnecessary overhead, as creating an integration object from Appian to Jira would involve polling Jira for ticket status changes, which could consume more resources than using webhook notifications. Verified References: Appian Documentation, section "Web API" and "API Keys".

• Question 17:

  On the latest Health Check report from your Cloud TEST environment utilizing a ManaDB add-on. you note the following findings

  Category; User Experience Description; # of slow query rules Risk; High

  Category; User Experience

  Description: U of slow write to data store nodes

  Risk: High

  Which three things might you do to address this, without consulting the business?

  A. Reduce the batch size for database queues to 10.

  B. Optimize the database execution use standard database performance troubleshooting methods and tools (such as query execution plans)

  C. Reduce the size and complexity of the inputs. If you ore passing in a list, consider whether (he data model can be redesigned lo pass single values instead

  D. Optimize the database execution. Replace the new with a materialized view.

  E. Use smaller CDTs or limit the fields selected in alqueryEntity()

  Correct Answer: BCE

  The three things that might help to address the findings of the Health Check report are:

  B. Optimize the database execution using standard database performance troubleshooting methods and tools (such as query execution plans). This can help to identify and eliminate any bottlenecks or inefficiencies in the database queries that are causing slow query rules or slow write to data store nodes. C. Reduce the size and complexity of the inputs. If you are passing in a list, consider whether the data model can be redesigned to pass single values instead. This can help to reduce the amount of data that needs to be transferred or processed by the database, which can improve the performance and speed of the queries or writes.

  E. Use smaller CDTs or limit the fields selected in a!queryEntity(). This can help to reduce the amount of data that is returned by the queries, which can improve the performance and speed of the rules that use them. The other options are incorrect for the following reasons:

  A. Reduce the batch size for database queues to 10. This might not help to address the findings, as reducing the batch size could increase the number of transactions and overhead for the database, which could worsen the performance and speed of the queries or writes.

  D. Optimize the database execution. Replace the new with a materialized view. This might not help to address the findings, as replacing a view with a materialized view could increase the storage space and maintenance cost for the database, which could affect the performance and speed of the queries or writes. Verified References: Appian Documentation, section "Performance Tuning".

• Question 18:

  You are taking your package from the source environment and importing it into the target environment.

  Review the errors encountered during inspection:

  Whatis the first action you should take to Investigate the issue?

  

  A. Check whether the object(UUIDending in 18028821) is included in this package

  B. Check whether the object(UUD ending in 7t00000i4e7a)is included in this package

  C. Check whether the object (UUID ending in 25606) is included in this package

  D. Check whether the object (UUID ending in 18028931) is included in this package

  Correct Answer: B

  The error message indicates that the object with UUID ending in 18028821 has a dependency on another object with UUID ending in 7t00000i4e7a, which is missing from the target environment. Therefore, the first action to investigate the issue is to check whether the object with UUID ending in 7t00000i4e7a is included in this package or not. If not, then it should be added to the package or imported separately before importing the current package. Verified References: Appian Certified Lead Developer study guide, page 17, section "Importing and Exporting Applications".

• Question 19:

  You have 5 applications on your Appian platform in production. Users are now beginning to use multiple applications across the platform, and the client wants to ensure a consistent user experience across all applications You notice that some applications use rich text some use section layouts, and others use box layouts. The result is that each application has a different color and size for the header.

  What would you recommend to ensure consistency across the platform?

  A. Create constants for text size and color, and update each section lo reference these values.

  B. In the common application, create a rule that can be used across the platform for section headers, and update each application to reference this new rule

  C. In the common application, create one rule for each application, and update each application to reference its respective rule

  D. In each individual application, create a rule that can be used lot tot section headers, and update each application lo reference its respective rule

  Correct Answer: B

  The best way to ensure consistency across the platform is to create a rule that can be used across the platform for section headers. This rule can be created in the common application, and then each application can be updated to reference

  this rule. This will ensure that all of the applications use the same color and size for the header, which will provide a consistent user experience.

  The other options are not as effective. Option A, creating constants for text size and color, and updating each section to reference these values, would require updating each section in each application. This would be a lot of work, and it would

  be easy to make mistakes. Option C, creating one rule for each application, would also require updating each application. This would be less work than option A, but it would still be a lot of work, and it would be easy to make mistakes. Option

  D, creating a rule in each individual application, would not ensure consistency across the platform. Each application would have its own rule, and the rules could be different. This would not provide a consistent user experience.

  Best Practices:

  When designing a platform, it is important to consider the user experience. A consistent user experience will make it easier for users to learn and use the platform.

  When creating rules, it is important to use them consistently across the platform. This will ensure that the platform has a consistent look and feel. When updating the platform, it is important to test the changes to ensure that they do not break

  the user experience.

• Question 20:

  Your clients customer management application is finally released lo 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 lo 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. Provide guidance to the developer on how to address the issues so that they can proceed with their work

  B. Ask the developer to convert the original customer section into a shared object so it can be used by the new application

  C. Point the developer to the relevant areas in the documentation or Applan Community where they can find more Information on the issues they are running into.

  D. Create a duplicate version of that sect

  Correct Answer: B

  The best practice for reusing common UI components across multiple applications is to create shared objects, which are objects that can be referenced by other applications without being copied or duplicated. This way, any changes made to the shared object will be reflected in all applications that use it, ensuring consistency and maintainability. Therefore, instead of creating a duplicate version of the customer section for the new application, the developer should convert the original customer section into a shared object and reference it from both applications. Verified References: Appian Documentation, section "Shared Objects".