Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Appian ACD200

Appian ACD200 Exam Practice Questions (P. 2)

  • Full Access (87 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Which review format is the most efficient way to coach team members and improve code quality? (Choose the best answer.)
  1. A
    Peer Dev Review
  2. B
    Automated Code Scanning
  3. C
    Retrospectives
  4. D
    User Acceptance Testing

Correct Answer:
A

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. A
    Create a custom plugin that can write an audit trail to a log file.
  2. B
    Create a trigger on the database table to capture the audit trail to a table.
  3. C
    Create an Appian process to capture the change history and write the audit trail to the database.
  4. D
    Create a web API call to an audit history system and write the audit trail to file.

Correct Answer:
B

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
    A joining table can be used to hold instances of Student/Class relationships.
  2. B
    The Student table should have a Class field to hold an array of Class IDs.
  3. C
    The Class table should have a Student field to hold an array of Student IDs.
  4. D
    It cannot be done, because Appian CDTs cannot handle Many-to Many relationships.

Correct Answer:
A

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. A
    Table
  2. B
    View
  3. C
    Stored procedure
  4. D
    Materialized view

Correct Answer:
C

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. A
    Number (Integer)
  2. B
    Number (Decimal)
  3. C
    Date
  4. D
    Boolean

Correct Answer:
A

Previous Questions Next Questions

All Pages