Appian ACD201 Exam Practice Test Instant Access

Question 1

You need to relate two entities, Employee and Skill, in the data structure. You want to adhere to Appian best practices.

Employees can have multiple skills, and a single skill can relate to multiple employees.

What type of relationship do these entities represent, and what is the minimum number of tables required to implement the design?

AMany-to-many; 3 tables

BMany-to-many; 2 tables

COne-to-many; 2 tables

Answer : A

The relationship between Employee and Skill is many-to-many - an employee can have multiple skills, and each skill can belong to multiple employees.

To model this properly and according to Appian best practices, you need 3 tables:

Question 2

You're creating an interface to display all the employees of a company on a staff list.

You decide to use a!gridField() to create a user grid to display information from the company's AAA_Employee record, which has 42 fields relating to various employee information. To avoid cluttering the grid, you want to show six (6) fields on the grid.

How should you optimize the interface?

AQuery the AAA_Employee record using a!queryRecordType(), defining the six (6) fields you require to show in the 'fields'' parameterto be used in the data parameter of a!gridFieid().

BUsing a local variable, query the AAA_Employee record using a!queryRecordType(), without defining the six (6) fields you require to show in the 'fields' parameter to be used in the data parameter of a!gridFieid().

CCall the function a!forEach() in a local variable and query the AAA_Employee for each employee separately by using a!queryRecordType() to loop through all employees as defined by a constant to be used in the data parameter of a!gridFieid().

Answer : A

Querying the AAA_Employee record with a!queryRecordType(), specifying only the six fields needed in the fields parameter, optimizes data retrieval and improves grid performance by minimizing unnecessary data loading.

Question 3

You're conducting a design review.

You identify slow-performing expression rules querying a specific data store, and need to understand the "number of operations against data stores."

Which metric from the data_store_details.csv file is helpful to you?

AExecute Count

BQuery Count

CTCCCotal Count

Answer : B

The 'Query Count' metric in the data_store_details.csv file indicates the number of operations (queries) performed against data stores, helping you analyze data store usage.

Question 4

You need to create a read-only grid that displays support case information. Data for the support cases is mapped to the "Case" record type with data sync enabled.

Within the record, there are fields named "createdDateTime" and "resolvedDateTime". These two fields store the timestamps for when a case is created and resolved, respectively.

The grid includes a column indicating the number of hours between when the case was created and when it was resolved. This column must be sortable within the grid.

How should you calculate the hour value that will display in the column?

ACreate a custom record field that evaluates in real-time, and calculates the number of hours between when the case was created and when it was resolved.

BWithin the grid column, utilize an Appian function to calculate the number of hours between when the case was created and when it was resolved.

CCreate a custom record field that evaluates at sync-time, and calculates the number of hours between when the case was created and the current date and time.

Answer : A

A custom record field that evaluates in real-time and calculates the hours between 'createdDateTime' and 'resolvedDateTime' ensures the calculated value is available as a sortable field within the read-only grid.

Question 5

You're designing a file upload process that integrates with an external document management system.

Part of this process is to develop a start form with a file upload component, so that the user can upload multiple files.

The business has requested that the maximum file size that can be uploaded through this process is 1GB. Additionally, you're aware that the integration's API can accept files with a maximum file size of 3GB, but recommends no larger than 1GB.

Can the process be more performant without straining the application or integration?

AYes. Request the business allows for these files to be uploaded as an overnight process by storing large files in a staging table, so that adequate resources are available.

BNo. The file upload component is capable of accepting 1GB files and the integration can handle this.

CYes. Request the business reconsiders its requirements and find manual workarounds as it is not recommended to upload files of this size in both Appian and the integration.

Answer : A

While Appian and the integration technically support 1 GB file uploads, handling such large files during interactive sessions can negatively impact application performance, user experience, and resource utilization.

A better approach is to request that the business allow these files to be uploaded asynchronously (e.g., overnight batch process), by temporarily storing them (e.g., in a staging table or folder) and processing them when system load is lower. This makes the process more performant and reliable without straining Appian or the external system.

Question 6

You're designing an expression rule that needs to retrieve employees from a database for a given department and display their full name concatenated with their role in a list for a dropdown field.

Which design approach should you recommend?

AQuery the data to return all employees. Using a!forEach(), for each item in the list, if the employee belongs to the given department, return the employee name and role, otherwise, return a null value.

BQuery the data to return all employees. Use wherecontains() to return the employees for the given department and use a!forEach() to return the employee name and role for each item in the list.

CQuery the data with a filter applied to only return employees for the given department. Using a!forEach(), for each item in the list, return the employee name and role.

Answer : C

Querying the data with a filter to return only employees for the given department is the most efficient approach. Then, using a!forEach() to concatenate and return the employee name and role meets the dropdown display requirement without unnecessary processing.

Question 7

Which step should you perform to identify expression rules that have been causing or have caused performance issues in the past 30days?

AMonitor the runtime of all test cases.

BNavigate to the Admin Console > Rule Performance tab.

CExamine the application server log

Answer : B

The Admin Console > Rule Performance tab provides metrics and insights on expression rules that have caused performance issues in the past 30 days, allowing you to identify and address slow-running rules.

Appian Certified Senior Developer ACD201 Exam Practice Test