Appian ACD200 Exam Questions in PDF and Online

QUESTION: 6

Which review format is the most efficient way to coach team members and improve code quality? (Choose the best answer.)

Peer Dev Review
Automated Code Scanning
Retrospectives
User Acceptance Testing

Answer(s): A

A lead designer receives this requirement:
Every time a record is modified, the data changed must be stored for audit.
Which design is the most efficient and has the least impact on the Appian application? (Choose the best answer.)

Create a custom plugin that can write an audit trail to a log file.
Create a trigger on the database table to capture the audit trail to a table.
Create an Appian process to capture the change history and write the audit trail to the database.
Create a web API call to an audit history system and write the audit trail to file.

Answer(s): B

Reveal Solution Next Question

QUESTION: 8

You are creating an ERD that models the data for a college and includes a Many-to-Many relationship, Student-to-Class, where a student can be enrolled in multiple classes, and a class can enroll multiple students.
How can you handle this relationship so that it can be supported in Appian and remain in at least First Normal Form? (Choose the best answer.)

A joining table can be used to hold instances of Student/Class relationships.
The Student table should have a Class field to hold an array of Class IDs.
The Class table should have a Student field to hold an array of Student IDs.
It cannot be done, because Appian CDTs cannot handle Many-to Many relationships.

Answer(s): A

Reveal Solution Next Question

QUESTION: 9

You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result set after executing the Joins. The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority.
What should you use? (Choose the best answer.)

Table
View
Stored procedure
Materialized view

Answer(s): D

Explanation:

A materialised view is a physical table that holds the results of the SQL that a VIEW would normally be constructed from and can be generated periodically.

Reveal Solution Next Question

QUESTION: 10

You are creating a table to store book information for a library. The boot has a reference number (ISBN_ID), as well as a unique identifier (BOOK_ID). For the CDT to be created, which data type should you choose for the BOOK_ID? (Choose the best answer.)

Number (Integer)
Number (Decimal)
Date
Boolean

Answer(s): A

Reveal Solution Next Question

Appian Certified Senior Developer ACD200 Exam Questions in PDF

Free Appian ACD200 Dumps Questions (page: 2)

QUESTION: 6

QUESTION: 7

QUESTION: 8

QUESTION: 9

Explanation:

QUESTION: 10