ACD200

ACD200 practice questions, page 2 of 4, with answer review and explanations.

Question 6

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

  1. Peer Dev Review
  2. Automated Code Scanning
  3. Retrospectives
  4. User Acceptance Testing

Question 7

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.)

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

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.)

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

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.)

  1. Table
  2. View
  3. Stored procedure
  4. Materialized view

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.)

  1. Number (Integer)
  2. Number (Decimal)
  3. Date
  4. Boolean