032524

Question 1

Minimum security level needed to evaluate an expression:

A. Administrator
B. Editor
C. Viewer
D. Deny

Answer 1

D. Deny

Question 2

You are creating a database table automatically from an existing CDT. How do you specify the foreign key column name in the database? (Choose 1 or more)

A. Database column names are the same as the CDT field names.
B. Foreign key fields are added as <CDT>_FK
C. The column name in the database cannot be controlled when tables are created automatically.
D. Under foreign key options, select "I know the name of the database column."</CDT>

Answer 2

D. Under foreign key options, select “I know the name of the database column.”

Question 3

You are creating a custom data type that is related to another custom data type. What sort of relationship should you create between them so that you can view related data using dot notation?

A. Mapped
B. Flat
C. Nested
D. Hierarchical

Answer 3

C. Nested

Question 4

You’re publishing the SS_Loan CDT to the Data Store. You notice that the data type is displayed as SS_Loan^4. What does this indicate?

A. There are other CDTs with the same name in different applications.
B. The CDT is being raised to the 4th power.
C. The Data Store is referencing an old version of the CDT.
D. The CDT is referenced by 4 objects in the application.

Answer 4

D. The CDT is referenced by 4 objects in the application.

Question 5

You are making changes to a CDT but first want to make sure it won’t affect any other objects. Where can you check to see what other objects rely on a CDT?

A. The CDT properties
B. Check in the Admin Console
C. Check each object manually
D. The dependents list

Answer 5

D. The dependents list

Question 6

You are creating a CDT in Appian that will hold an Invoice object. Each invoice can have one or more expenses added to it. Which of the following is the best practice for this use case?

A. Create two separate CDTs, Invoice and Expense. Invoice will have a foreign key field that will link to Expense’s primary key.
B. Create an expense field in the Invoice CDT and mark it as an array.
C. Create two separate CDTs, Invoice and Expense. Each will have foreign key fields that link to one another.
D. Create two separate CDTs, Invoice and Expense. Expense will have a foreign key field that will link to Invoice’s primary key.

Answer 6

D. Create two separate CDTs, Invoice and Expense. Expense will have a foreign key field that will link to Invoice’s primary key.

Question 7

What is the purpose of a data store?
(Select all that apply)

A. It specifies which Appian engine is used to retrieve data
B. To store Appian data in memory for rapid use
C. To define the structure of your application
D. To connect CDTs to database tables.

Answer 7

D. To connect CDTs to database tables.

Question 8

The primary purpose of CDTs is to structure and model data throughout the app.

A. True
B. False

Answer 8

B. False

Question 9

How would you cast a text value to a date value?

A. Appian does not support this functionality
B. date()
C. change(todate)
D. todate()

Answer 9

D. todate()

Question 10

If I wanted the substring “Chi” from the string “Chicago” which would I use?

A. text(“Chicago”, 3)
B. substr(“Chicago”, 3)
C. subString(“Chicago”, 3)
D. left(“Chicago”, 3)

Answer 10

D. left(“Chicago”, 3)

left(text: “Chicago”, num_chars: 3)

Question 11

You are developing an on boarding application for a tech company. In addition to the information that the applicant enters into the form, they would like to initialize the application status based on whether the applicant is internal or external. How would you design your interface to capture the status in the rule input?

A. Add an input field that displays a value calculated based on whether it is an internal or external hire.
B. Use an a!save() function in the submit button function.
C. Use a!refreshVariable on the input field for internal/external hire.
D. Use an a!save() function on the input field for internal/external hire.

Answer 11

B. Use an a!save() function in the submit button function.

Question 12

You finished building an interface for an online retailer for customers to select items from their catalogue. However, when the customer selects an item and hits the Check-Out button, the selected items are not being passed into the next interface. What should you troubleshoot first?

A. Interface Security
B. Local Variables
C. Activity Class Parameters
D. Rule Inputs

Answer 12

D. Rule Inputs

Question 13

Naming convention for interfaces?

A. Feedback Form AB
B. AB Feedback Form
C. AB_feedbackForm
D. AB_FeedbackForm

Answer 13

D. AB_FeedbackForm

Question 14

Interface security does not impact the ability to view the interface in a site.

A. True
B. False

Answer 14

A. True

Question 15

Best practice for labels:
(Select all that apply)

A. Justified
B. Above
C. Adjacent
D. Hidden

Answer 15

A. Justified
C. Adjacent

Question 16

You are creating a Record Type for an application where all user groups should have access to the record. However, only a single group should have the ability to perform an action on the record. How do you secure the action such that it’s only available to this specific group?

A. Visibility
B. Permissions
C. Filters
D. An Expression Rule

Answer 16

A. Visibility

Question 17

You have a query that returns all the columns from the Customers table. The interface you’re working on only needs 3 fields: the customer name, customer phone number and customer email. How do you limit the query to only bring in those specific fields?

A. a!querySelection
B. a!limitFields
C. a!selectedFields
D. a!fields

Answer 17

A. a!querySelection

Question 18

Ivan has a query that returns a list of product orders. He wants to sort the list by date with the oldest date appearing first in the list. What sort order should he use?

A. Oldest Order
B. Ascending Order
C. Newest Order
D. Descending Order

Answer 18

B. Ascending Order

Question 19

An Operations Managers would like to be able to view a live list of shipments actively being loaded. You have decided to create a new Shipment Record Type for the Operations Managers. What configurations should you make to the Record Type?
(Select all that apply)

A. Create a process model to keep the record up to date.
B. Set a short Refresh Interval for the list view.
C. Configure a short Data Sync interval.
D. Create a source filter to only sync shipments that are being actively loaded.

Answer 19

B. Set a short Refresh interval for the list view.
D. Create a source filter to only sync shipments that are being actively loaded.

Question 20

You are designing an expense report application. You have two record types: Expense Reports and Expenses. You would like to create a field in the Expense Report record that shows how many expenses are on the report. What is the optimal way to satisfy this requirement?

A. the number of related records is automatically saved by Appian.
B. Add a field to the Expense Report database that updates every time an expense is added.
C. Configure a Custom Record Field to aggregate related record fields
D. Query the expenses filtering by and aggregating the selected expense report.

Answer 20

C. Configure a Custom Record Field to aggregate related record fields

Question 21

You’ve created a Record Type with multiple custom fields that aren’t available in the corresponding CDT. Now you’re working on a report and need to incorporate those custom fields into a few charts. How can you retrieve the record data for the report?

A. Attach the report as a record action.
B. Custom record fields cannot be included in reports.
C. Use a!queryRecordType().
D. Create a “Record Report” in the Views and Headers tab.

Answer 21

C. Use a!queryRecordType().

Question 22

You are creating a new Loan Record Type that will be used by several different groups within the organization. Each role should only be able to access the data that is relevant to their role. Which of the following would be used to accomplish this?

A. Record-Level Security/Default Filter
B. User Filter
C. Source Filter
D. Create a separate Record Type for each role.

Answer 22

A. Record-Level Security/Default Filter

Question 23

You are working on an application for OSHA to streamline the reporting process for workplace safety violations. The organization connected their existing database to the Appian instance. However, they are missing several foreign key relationships between data types. Without deploying any changes to the database, how could you set up the proper relationships in the application?

A. Link the data types together with process variables.
B. Add a foreign key in the CDTs to relate the data types.
C. Make the appropriate changes to the database before creating the CDTs.
D. Configure a Record Type for each table and add Record Type Relationships.

Answer 23

D. Configure a Record Type for each table and add Record Type Relationships.

Question 24

Which of the following are top level interface components that cannot be nested inside other components?
(Choose all that apply)

A. a!sideBySideLayout()
B. a!formLayout()
C. a!sectionLayout()
D. a!headerContentLayout()

Answer 24

B. a!formLayout()
D. a!headerContentLayout()

Question 25

You have configured a dropdown field in your interface. After selecting an option from the dropdown list, it does not display your choice in the dropdown field, but it passes the selected value into the process model. Which parameter is most likely misconfigured?

A. choiceLables
B. choiceValues
C. value
D. saveInto

Answer 25

C. value

Question 26

Which of the following is not a common use case for local variables?

A. Store values for a custom filter.
B. Transfer data to a process model.
C. Add, remove, or update rows from a grid.
D. Store data from a query to display in a table.

Answer 26

B. Transfer data to a process model.

Question 27

When dealing with variables in an expression, you should create test cases for:
(Select all that apply)

A. Expected input values
B. Null values
C. Invalid values
D. All possible values
E. Only possible values
F. Number and Text values
G. Valid values

Answer 27

B. Null values
C. Invalid values
G. Valid values

Question 28

You are working on an application for Zip Airlines to allow customers to book flights online. The product owner wants an interface to display live prices for the different tickets. The prices are updated in the database once a minute. What refresh schema should be used for the local variable containing the prices?

A. refreshAlways
B. refreshOnReferencedVarChange
C. refreshInterval
D. refreshOnVarChange

Answer 28

C. refreshInterval

Question 29

Trident Corp has a development database with sample data so they can make sure everything runs smoothly before deploying. A senior developer has tasked you with removing all the data from one of the sample tables, without affecting the table’s structure. Which SQL command will accomplish this?

A. ALTER TABLE
B. DROP
C. DELETE
D. TRUNCATE

Answer 29

D. TRUNCATE

Question 30

You are working with sensitive banking data and your senior developer has instructed you to audit every time a database table is accessed or modified. What database feature should be used to accomplish this?

A. Behavior
B. View
C. Trigger
D. Stored Procedure

Answer 30

C. Trigger

Question 31

Which of the following is used to query and modify data in a database?

A. Trigger
B. DML
C. DDL
D. Relational Schema

Answer 31

B. DML

Question 32

Suzy is creating a query to return items currently in inventory in her warehouse. How does she make sure the query returns all results?

A. Enable “Fetch Total Count”
B. Set batchSize to -1
C. Set batchSize to 0
D. Set batchSize to “ALL”

Answer 32

B. Set batchSize to -1