QUESTIONS AND ANSWERS GRADED A+
✔✔Record Centric Design - Steps - ✔✔- Start with key building blocks of data in a
relational database
- Use an entity-backed record type that allows users to list, search, filter, and drill down
into data in that entity
- Attach an action to allow users to create new records
- Use related actions to enable record update and status changes
- Repeat this process for each key resource that needs to be managed
✔✔Query Anti Patterns to Avoid - ✔✔1. Should not keep "batchSize" as -1 (this will try
to fetch all data
2. Unsorted query results (keep primary key as sort ID)
3. "ends with" filtering conditions
4. Using 50 or more operators using "in" operations, will result in very slow query
✔✔When Query will break with error - ✔✔Query breaks if data returned is >1MB or
takes >10 seconds
✔✔DB Design practices to follow - ✔✔1. Implement locking mechanism for DB updated
to avoid race conditions
2. Load test your applications with roughly three times anticipated first year's worth of
data
3. Avoid designing queries that are unbounded or slow
✔✔In addition to entity locks table to resist concurrent table update attempts, "optimistic
locking" can be used to prevent the writing of stale data. Using the following annotations
- ✔✔@version and @column
✔✔What process related information stored in memory - ✔✔1. Process variables
2. Task properties
3. Process properties
4. Process history
✔✔Process Data management best practices - ✔✔1. Processes with task data: 3 days
2. Processes that are automated/utility: delete after completion
✔✔Running the sub processes as "sub process" node will always run in the same
process execution engine - ✔✔true
✔✔Running the sub processes as "start process" node will always run in the same
process execution engine - ✔✔true
,✔✔Process Management Best Practices - ✔✔1. Build record-centric processes that are
short lived and set to archive after 3 days
2. Use sub-processes to break up larger workflows into segments that can be archived
or deleted, which use "start process" smart service where practical
3. Look to repeatable design patterns into multi purpose workflows
✔✔Plug-in guidelines - ✔✔1. Use OOTB if requirements are nearly met
2. Build off existing plug ins
3. Try to use an existing plugin before building your own
4. Thoroughly test every plug-in before each release
✔✔Plug-in risks - ✔✔1. Higher chance of support incidents
✔✔3rd party plug-ins must be watched for - ✔✔1. Thread safety
2. Performance at scale
3. Extra resource consumption
✔✔Which time scale refers to the term "short lived process" - ✔✔Milliseconds,
Seconds, Minutes
✔✔Valid reason to consider using a plug in (such as execute stored procedure) -
✔✔Your performance test a process that does not meet your response time
requirements
✔✔Benefits of using sub-process - ✔✔1. Collaborative Development
2. Reusability
3. Reduced process duration
4. Reduced memory usage
✔✔Appian Health Check purpose - ✔✔1. Examines an Appian Instance
2. Generates a report
3. Identifies the risks
✔✔Appian Health Check availability - ✔✔From 19.4 health included with Appian by
default, no need to deploy separately
✔✔Appian Health Check can be - ✔✔1. Configured
2. Run manually
3. Regularly scheduled
✔✔Appian Health Check run schedule - non production - ✔✔1. Run health check as
part of your sprints
2. Every 2 weeks
3. Should be part of pre-deployment checklist
, ✔✔Appian Health Check run schedule - production - ✔✔1. Run health check once per
month
2. Before deployment of applications
✔✔Appian Health Check - report sheets - ✔✔1. Summary
2. Details
3. Dashboard
4. Process Sizing
✔✔Appian Health Check - dashboard long running charts - ✔✔1. Slow Queries
2. Record summary views
3. Record lists
✔✔Appian Health Check - process sizing tab - ✔✔1. Record process instance memory
usage
2. Helps estimate future memory usage
3. Shows if process engine servers are properly sized
✔✔Appian Health Check - what is the maximum threshold of high risks allowed in
production environments? - ✔✔0
✔✔Appian Health Check - Application risk categories identified by health check report -
✔✔1. User Experience
2. Configuration
3. Design
4. Infrastructure
✔✔Appian Health Check - scheduling recommendation - ✔✔NOT recommended health
check be run during business hours in production environment or active environment as
it may increase system load and degrade performance
✔✔Appian Health Check - to configure health check - ✔✔must need "automatic upload
service account" credentials
✔✔Appian Health Check - for the first time a health check is performed, raw results
must be reviewed - ✔✔true
✔✔Appian Health Check - the name of the group will receive health check report
notifications - ✔✔1. Group name is "health check viewers"
2. can be "system administrators" excluded from the list
✔✔Appian Health Check - system account required to automatically receive the
analysis results of health. check report - ✔✔true