Free Appian Certified Lead Developer Exam ACD301 Exam Practice Test

While working on an application, you have identified oddities and breaks in some of your components. How can you guarantee that this mistake does not happen again in the future?

• Design and communicate a best practice that dictates designers only work within the confines of their own application.
• Ensure that the application administrator group only has designers from that application’s team.
• Create a best practice that enforces a peer review of the deletion of any components within the application.
• Provide Appian developers with the “Designer” permissions role within Appian. Ensure that they have only basic user rights and assign them the permissions to administer their application.

As part of an upcoming release of an application, a new nullable field is added to a table that contains customer data. The new field is used by a report in the upcoming release and is calculated using data from another table.Which two actions should you consider when creating the script to add the new field?

• Create a script that adds the field and leaves it null.
• Create a rollback script that removes the field.
• Create a script that adds the field and then populates it.
• Create a rollback script that clears the data from the field.
• Add a view that joins the customer data to the data used in calculation.

You have created a Web API in Appian with the following URL to call it: https://exampleappiancloud.com/suite/webapi/user_management/users?username=john.smith. Which is the correct syntax for referring to the username parameter?

• httpRequest.queryParameters.users.username
• httpRequest.users.username
• httpRequest.formData.username
• httpRequest.queryParameters.username

You are the project lead for an Appian project with a supportive product owner and complex business requirements involving a customer management system. Each week, you notice the product owner becoming more irritated and not devoting as much time to the project, resulting in tickets becoming delayed due to a lack of involvement. Which two types of meetings should you schedule to address this issue?

• An additional daily stand-up meeting to ensure you have more of the product owner’s time.
• A risk management meeting with your program manager to escalate the delayed tickets.
• A sprint retrospective with the product owner and development team to discuss team performance.
• A meeting with the sponsor to discuss the product owner’s performance and request a replacement.

Your application contains a process model that is scheduled to run daily at a certain time, which kicks off a user input task to a specified user on the 1st time zone for morning data collection. The time zone is set to the (default) pm!timezone. In this situation, what does the pm!timezone reflect?

• The time zone of the server where Appian is installed.
• The time zone of the user who most recently published the process model.
• The default time zone for the environment as specified in the Administration Console.
• The time zone of the user who is completing the input task.

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?

• Use an Appian Process Model, initiated after every integration, to loop on each item and update it to the business requirements.
• Build a complex and optimized view (relevant indices, efficient joins, etc.), and use it every time a user needs to use the data.
• Create a set of stored procedures to handle the volume and the complexity of the expectations, and call it after each integration.
• 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.

You are in a backlog refinement meeting with the development team and the product owner. You review a story for an integration involving a third-party system. A payload will be sent from the Appian system through the integration to the third-party system. The story is 21 points on a Fibonacci scale and requires development from your Appian team as well as technical resources from the third- party system. This item is crucial to your project’s success. What are the two recommended steps to ensure this story can be developed effectively?

• Acquire testing steps from QA resources.
• Identify subject matter experts (SMEs) to perform user acceptance testing (UAT).
• Maintain a communication schedule with the third-party resources.
• Break down the item into smaller stories.

You are just starting with a new team that has been working together on an application for months. They ask you to review some of their views that have been degrading in performance. The views are highly complex with hundreds of lines of SQL. What is the first step in troubleshooting the degradation?

• Go through the entire database structure to obtain an overview, ensure you understand the business needs, and then normalize the tables to optimize performance.
• Run an explain statement on the views, identify critical areas of improvement that can be remediated without business knowledge.
• Go through all of the tables one by one to identify which of the grouped by, ordered by, or joined keys are currently indexed.
• Browse through the tables, note any tables that contain a large volume of null values, and work with your team to plan for table restructure.

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?

• 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.
• Configure a timed utility process that queries data from the third-party database daily, and stores it in the Appian business database. Then use a!queryEntity using the Appian data source to retrieve the data.
• Configure an expression-backed record type, calling an API to retrieve the data from the third- party database. Then, use a!queryRecordType to retrieve the data.
• In the Administration Console, configure the third-party database as a “New Data Source.” Then, use a!queryEntity to retrieve the data.

An Appian application contains an integration used to send a JSON, called at the end of a form submission, returning the created code of the user request as the response. To be able to efficiently follow their case, the user needs to be informed of that code at the end of the process. The JSON contains case fields (such as text, dates, and numeric fields) to a customer’s API. What should be your two primary considerations when building this integration?

• A process must be built to retrieve the API response afterwards so that the user experience is not impacted.
• The request must be a multi-part POST.
• The size limit of the body needs to be carefully followed to avoid an error.
• A dictionary that matches the expected request body must be manually constructed.