APPIAN LEAD DEVELOPER EXAM AND CERTIFICATION EXAM 2024, Exams of Physics

Download APPIAN LEAD DEVELOPER EXAM AND CERTIFICATION EXAM 2024 and more Exams Physics in PDF only on Docsity!

APPIAN LEAD DEVELOPER EXAM AND

CERTIFICATION EXAM 2024 WITH ACTUAL

CORRECT QUESTIONS AND VERIFIED

DETAILED ANSWERS |FREQUENTLY TESTED

QUESTIONS AND SOLUTIONS |ALREADY

GRADED A+|GUARANTEED PASS |LATEST

UPDATE

Once a Record Type with the data source of DB is created, what case format do your properties use? A. UPPERCASE B. lowercase C. PascalCase D. camelCase E. UPPER_CASE F. lower_case G. Pascal_Case H. camel_Case E. UPPER_CASE T or F: When creating a record type, the display name is always plural. True When adding a relationship to the record type, which is not a relationship type: A. Many to Many B. One to Many C. Many to One D. One to One A. Many to Many T or F: When adding a relationship to a record type, you can use any columns from either table. False. The one of the table's PK should be used to associate with one field from the other relationship.

T or F: When generating a Record Type summary view, the default naming convention is to use the word "Summary" before the description of the data. True T or F: When creating an interface that summarizes a record types data, you should NOT use the word "Summary" in the object's name. False. The Appian naming convention is APP(3 letter acronym)RecordTypeSummaryDescription. Exe. For ther Buy And Large (BNL) app, a summary object name could be, BNLPurchaseHistorySummaryCustomerReceipt When creating a table, which component do you use? A. a!gridField() B. a!table() C. a!gridColumn() D. fv!gridField() A. a!gridField() When creating a table, which component do you use to create the columns? A. a!dataField() B. a!gridData() C. a!tableColumn() D. a!gridColumn() D. a!gridColumn() When creating a table, what source types can be used for the data? A. Record Type B. SQL Query C. Report D. Process Report E. A and B F. All of the above F. All of the above When creating a table, which is the proper syntax for displaying a Record Type property? A. a!gridColumn(value: fv!row.property) B. a!gridColumn(value: fv!row[RecordType!Record.property]) C. a!gridColumn(value: fv!row[RecordType!property]) D. a!gridColumn(value: fv!item.property) B. a!gridColumn(value: fv!row[RecordType!Record.property]) When querying a record type, what is the appropriate query function? A. a!queryLogicalExpression() B. a!query()

C. a!queryEntity() D. a!queryRecordType() D. a!queryRecordType() a!queryRecordType() has all of these parameters EXCEPT for: A. recordType B. fields C. filters D. pagingInfo E. fetchTotalCount F. relatedRecordData G. aggregation G. aggregation is a parameter of a!query() a!query() has all of these parameters EXCEPT for: A. selection B. aggregation C. logicalExpression D. filter E. pagingInfo F. fields F. fields is a parameter of a!queryRecordType() a!queryEntity() has all of these parameters EXCEPT for: A. pagingInfo B. entity C. query D. fetchtotalCount A. pagingInfo is a parameter of a!query and a!queryRecordType() T or F: When querying a Record Type, you can sort and filter a related record type using a!relatedRecordData() as long as it is a one to many relationship. True What is the naming standard for a site? Start the name with the app prefix. The site name is internal and won't be seen. The Display Name will be seen so don't start with the app prefix. The web address identifier will auto populate in lower case from the display name and replace spaces with hyphens. When creating a site, what type of pages can be added? Report, Action, Interface, Record List T or F: When adding a page for a site, the title must be a static text.

False. This can also be an expression. What is the max number of pages a portal or site can have? 10 What is the benefit of creating a group page? This allows you to add pages under a drop down menu so you can condense your content. What navigation bar options are present on a site? Header bar and sidebar. What is the main difference between a portal and a site? A portal is a landing page for users not part of your organization. You need an Appian sign in to access the site. Where would you go to add security to a record action? Views and Actions Security tab on the Record Type. Where would you go if you want to add security to a record? Record-Level Security tab on the Record Type. What is Temp? Temp is a legacy End-User framework used to display reports, charts and grids based on an expression. What are Appian's folder security permission levels? No Access Editor Viewer Administrator What can a user with Viewer permission levels do? View the rule folder What can a user with Editor permission levels do? View the folder, create objects in the folder, view the security. What can a user with Deny permission levels do? Nothing. No Access. What can a user with Viewer Administrator levels do? View the folder, create objects in the folder, view the security, update the security and delete the folder. What is the difference between the security privilege's of rule folders and process model folders?

As an editor of a process model folder you can't view the security. As a viewer of a process model folder you can't create objects in the folder. What are the four critical capabilities of Appian?

1. Data fabric (Unify data across multiple systems)
2. Automation (Automate business processes)
3. Total Experience (Engage all users across web and mobile experiences)
4. Process mining (Mine your data to discover processes that can be optimized and automated) Appian's Data fabric consists of numerous design objects including: Record Types Custom Data Types Data Stores Connected Systems Integrations Web APIs Which one is the most common way to work with data? Record Types - This object allows you to connect to your enterprise data and unify it within a single data model. Appian's ability to automate is primarily displayed using what design object? Process Model - You'll see Appian's workflow through the process modeler that allows you to use complex logic to connect people, systems, robotic tasks, AI, business rules and data. T or F: Appian's process models allow you to automate repetitive and rule based tasks such as copying data or searching for data online. True What is the difference between a Site and a Portal? Sites are the user experience for the employees of your company who are logged into your app. Portals are the user experience for users without an Appian login. What are four use cases for a Portal?
5. Registering for an event
6. Reporting an incident
7. Requesting an account
8. Viewing a public record What Appian capability allows you to:

• Identify the root causes of bottle necks in user workload
• Compare to see if organizational workflow stand up to company standards and best practices
• Assess target performance of APIs Process Mining

What is the key benefit of Appian's data fabric? It connects and unifies your data within a single data model. What Appian feature allows you to automate complex business workflows? Process modeler What does "total experience" refer to? (Select 4) A. It engages all users B. It is responsive by default C. It allows you to sell goods and services D. It is secure by default E. It can be built using low-code tools A, B, D, E What are the benefits of Appian Process Mining? Select three options that apply. A. It allows you to analyze business processes B. It allows you to discover hidden inefficiencies C. It minimizes manual tasks D. It provides data to inform process improvements and automation A, B, D What Appian design object unifies and optimizes data? Record Type What three elements are found in a typical Appian app? Create: Action to add new records Read: Record lists and summary views Update: Related actions to update existing records CRUD minus the D T or F: Appian developers can create record types by connecting to existing data sources, and they can also create record types and tables from scratch. True How do you unify record types in Appian? Add relationships from within the record type. What two record type features can you use to extend existing data? Record Events (Who takes action on records and when. Then displays a history of events to users.) Custom record fields (You can create these to aggregate, extract, group or modify data to provide your business users with additional business insights. You can create a field for graphs such as sum of column.)

What type of security allows you to configure data visibility at the row level? Record-level security in the record type What kinds of automation can you implement with Appian? Select four options that apply. A. Build unified business workflows B. Integrate with external systems C. Industrial automation D. Enforce business rules E. Automate routine tasks and data classification and extraction A, B, D, E When automating a workflow, how do you add a specialized business activity to it? A. Drop the workflow node into your process B. Drop the gateway into your process C. Drop the smart service into your process D. Code your activity C. Drop the smart service into your process What design object is used to capture business rules in Appian? A. Process Model B. Decision Object C. Record Type D. Interface B. Decision Object T or F: Appian RPA is used to automate high-volume manual tasks, and often the only solution when you need to connect to legacy systems that lack APIs. True T or F: Appian AI Skill is used to automate common business tasks like document classification, email classification, and document extraction. A developer only needs to create and configure an AI Skill design object, and then add it to any Appian process using the corresponding smart service. True Complete this sentence. Process mining is a capability that ... Discovers patterns and bottlenecks in your processes What does the process discovery method generate? (Done by uploading an event log) A. The target model that shows how a process should run B. The discovered model that shows how a process runs in real life C. A chart of common deviations D. A reporting dashboard B. The discovered model that shows how a process runs in real life

What process mining method compares the discovered and target models and identifies the deviations between them? A. Process enhancement B. Conformance checking C. Process discovery D. Regulatory compliance B. Conformance checking What are the for purposes for Process Mining?

• Discover patterns in real life
• Check for conformance and deviations
• Identify root causes for deviations
• Create and monitor key metrics What is Conformance Checking? This is when Process Mining identifies deviations and uncovers root causes in a Discovered Model. These deviations include: Skipped events Additional events Event order switching Alternative paths Process Mining puts you in charge of the insight gained from process mining. Process discovery reveals what your processes are like in real life. Conformance checking identifies deviations and their root causes. Once you understand the issues you must do what two things?

1. Decide what must be automated
2. Implement a monitoring dashboard Define Persona A representation of a group of people with similar needs who will work in the application. Define Groups A security that enables users to view and interact with different application components. Such as records, reports and processes. What is used to primarily manage data in Appian? Record Types T or F: CDTs help you define the data model used in your app. False. Record Types help define the data model. Users can view and take action on data using records.

What three ways can record type data be sourced from?

• Relational Databases
• Appian Processes
• Web services What Appian component drives actions performed in the application? Process Models T or F: It's a good idea to create a planning document for the application. True. Do this by stating the application's purpose and goals. Add performance measures to define application success. After those are defined, you need to identify Groups and Personas; Data Design and Records; Process Models and Reports. In Appian, how is a record defined? A. A record represents a row in a database B. A record tracks user activity in an application C. Record types help you define the data model used in your app. Users can view and take action on data using records. D. A record documents a transaction that occurred using an application. C. Record types help you define the data model used in your app. Users can view and take action on data using records. What are the key components of application planning? A. Databases, web APIs, users, forms, process models, reports B. Personas, project budget, custom data types, records, reports C. Personas, records-based data design, custom data types, process models, reports D. Custom data types, records, forms, scheduling process models C. Personas, records-based data design, custom data types, process models, reports. Remember that this is planning. Planning drives development and should be half the work. What are the most basic security groups? All Users Administrators Within these groups, other groups can be made to further specify responsibilities. T or F: A security group can contain sub-groups but not individual user members. False Define Permissions Matrix A graph that defines who may access application functions and records. You can define which groups have or are denied access to application functions and records. Define Entity Relationship Diagram or ERD.

An ERD is a diagram that defines datastructures through records, their fields and field types. An ERD also defines the relationship between the records. T or F: Do not finalize data structures until you have finalized reporting requirement. True. Structures can change as requirements are identified. What's an example of a data entity? A. Relational B. Text C. Integer D. Vehicle D. Vehicle In the Acme Auto example, why does the Maintenance entity contain the Vehicle ID as a field? Select all that apply. A. To join the Vehicles and Maintenance data types B. To make Vehicle the parent of Maintenance C. So you can query the maintenance requests by Vehicle ID D. To nest Maintenance data under vehicle data A and B. Tables do not use "Parent" and "Child" relationships. You also do not "nest" data sets. They use "One to One", "One to Many" and "Many to One" relationships. T or F: Data used in an application can only originate from a relational database. False. Data does not only originate from relational databases. They can also come from Appian processes, web services and external systems. Appian record types can also create them from scratch. T or F: It is Appian best practice to design processes and then build records to fit the needs of those processes. False. Appian is data driven. The processes will always follow the needs of the data. Design the data first, then build the processes. T or F: A site consists of content organized into tabs and can target a specific group. True. You can create sites with a business-oriented navigation experience and terminology that users are familiar with. T or F: When designing for user mobile experience, a feed style may be better than the grid style because it doesn't require horizontal scrolling. True. A feed style mimics social media style data and is easy to navigate with a mobile device. What is the difference between an action and a related action? A related action is an action displayed on a record and pertains to the actions taken on that record. An action displayed when there is no specific record involved initially, such as a button that creates a new record. "Add Vehicle" action creates a new to the Vehicle table.

T or F: Data associated with key events that occur during your business operations can be captured, stored and accessed as record events in Appian. True. These make up the Event History. You can track activities, responsible parties and associated timestamps. How does a Summary view differ from a List view? Summary view provides more details about a record. What is the difference between Analyst view and Designer view? (Process modeler) The Analyst view can be used during planning to simply draw a process model. The Designer view is used to create a working model. You can reference the drawing from the Analyst view. What is the purpose of a swimlane? A swimlane gives a visual representation of what persona is responsible for the record and the actions they take. What type of gateway nodes are available? And Complex OR XOR When creating a process model, which of the following should you identify? Select all that apply. A. Data types B. Record types that will be linked through related actions C. Reporting requirements D. Interfaces used to enter data A, B, D. What can be used for a source for Report Data? Appian's Internal analytics engine Relational Databases Synced Records External Systems through web services or other integrations Which type of report focuses on key performance indicators, such as revenue or customer satisfaction? A. Business value B. Process metrics C. Gauges D. Pie chart A. Business value

Which type of report focuses on operational efficiency and bottlenecks? A. Business value B. Process metrics C. Gauges D. Pie chart B. Process metrics What is the most common description for the type of work Appian does? A. Business-to-Business and Business-to-Government B. Business-to-Government and Consumer-to-Consumer C. Business-to-Consumer and Consumer-to-Consumer D. Business-to-Business and Consumer-to-Consumer A. Business-to-Business and Business-to-Government How can application users launch a process? (Multi select) A. Add a gateway to the process B. Use a record type's related action C. Create a task D. Submit a form from a site B and D At what stage are you most likely to have a "Sprint 0"? A. Build B. Optimize C. Release D. Initiate D. Initiate Following Scrum best practices, what is the maximum number of product owner(s) a delivery team should have? A. It varies based on the size of the team and project B. 3 C. 1 D. Product owners are not always required C. 1 If your data lives in a relational database or a database table, how can the record type access your source data? (Multi Select) A. Through a cached copy of your database table (if data sync is enabled) B. Through a process model C. Through a web service D. Through a Data Store Entity (DSE) A and D

A user has Editor permissions to a record type. Which three actions can the user take? A. Update the record type definition. B. View the record type in Temp. C. View the record type definition and security. D. Update the record type security. E. Delete the record type. A, B, C. Changing Security and Deleting are Administrator level permissions. In which scenario should an Appian Site User Experience be used? A. When users need to make a decision over a broad scope of applications and information, as well as make use of the Tempo view. B. When a business is integrating with an existing intranet portal and wants to keep the interface employees are familiar with while introducing new capabilities. C. When an independent, customized User Experience is focused on a specific set of functionalities. D. When users need the ability to utilize tasks, actions, related actions, reports and record view with full control of custom CSS of all components. C. When an independent, customized User Experience is focused on a specific set of functionalities. You are configuring a script task and need to output to a target process variable. Which three operators are available in the Operator list for a custom output? A. is stored at index B. is stored as C. is added to D. is multiplied by E. is appended to list A, B and E A record for Employee has been created, with a related action to update an employee. This action should only be accessible to a certain user group. How can you manage access to the related action? A. In the Context setting of the Related Action B. In the Related Action Shortcuts setting of the Record View C. In the Interface Security within the Process Model D. In the Visibility setting of the Related Action D. In the Visibility setting of the Related Action You are creating an interface and want the user to have an interactive component that saves and submits a form. Which object should you use? A. a!buttonLink() B. a!buttonWidget() C. a!buttonField() D. a!save()

B. a!buttonWidget() What object permission level gives a user the ability to Create, Read, Update and Delete? A. Administrator B. Viewer C. Editor D. Deny A. Administrator T or F: For object security, the Editor can Rename the rule, view the security and can run test cases. But they can't delete the rule or update the security. True. Editor has all permissions besides deleting and changing the security. The editor is the second highest permission level. T or F: For object security, the Viewer can evaluate the rule, view the rule definition, run test cases and can even duplicate the rule. True. Viewers are the most basic permission level. They can use the rule and view everything but the security. They can't change or delete the rule object. This is the default permission level for all users. T or F: For object security, the Deny permission level has no permissions and can't evaluate the rule. False. The Deny permission level CAN evaluate the rule, but they can't do anything else. The only permission level that has no access is called "No Access". This is the default permission level for Default users. When creating a site, which is an appropriate display name? A. AA_SupervisorsSite B. Supervisors_Site C. Supervisor's Dashboard Site (Administrators Only) D. supervisorssite E. Supervisors Site E. Supervisors Site. The display name is visible to the users and should be concise, in title case (Pascal Case), and should not contain the application's abbreviation. How many phases are in the delivery of an application?

4. Initiate, Build, Release, Optimize. Build and Release are part of Agile where you build a small part of the application and release it when it's done. Each sprint has a build and release phase. What happens during the Initiate phase of the delevery methodology? Initiate phase is where sprint 0 occurs. You do a fair amount of planning. You don't need to plan the entire app in detail. What are the goals for the Initiate phase or sprint 0?

Define Success Explore Scope Plan Releases Agree on a way of working Define Definition of Ready (DoR) A list of criteria a unit of work (typically a story) must meet for development to start. Developers understand what needs to be done, external dependencies are identified, scope is clearly defined, etc. Define Definition of Done (DoD) A list of criteria that a unit of work (typically a story) must meet in order to be considered complete. Testing passes, documentation written, etc. Define Agile A series of values and principles that provide guidance for project management. This is a philosophy and not a methodology. Define Scrum An approach to software development where you complete units of work incrementally for an application as a team. What is the responsibility of the Product Owner? Responsible for defining and prioritizing all the user stories. They also address challenges developers face when there is conflicting or little direction for what needs to be built. What is the responsibility of the Scrum Master/Team Lead? Guards agile practices and removes impediments. Primary point of contact. What is the responsibility of the Developers? Deliver the application. making usable piece of software every sprint. How long does a typical sprint last? 2 weeks What are the 5 events that Scrum revolves around? Sprint (Agile Ceremony) Sprint Planning Daily Scrum Sprint Review Sprint Retrospective Define a User Story

Software feature descriptions written in non-technical language, written from the perspective of the end users and results in a working piece of functionality. What are the three stages of the Build phase? Planning, Disciplined Development, Inspect and Adapt What happens in a backlog refinement session? The team reviews user stories and asks questions until 2 weeks worth of stories meets the DoR. What are the three activities related to Agile planning? Backlog refinement Story Sizing Sprint Planning When reading through user stories, break down the story into what 2 sub tasks? Security Time When developing a story what are the steps you should take? Read through the story Break down the user story into sub tasks (Security, Time) Develop the story Test the story Peer Review the story Complete Product Owner Review Check DoD What is Sprint Review? A meeting to showcase the completed features from the Sprint to stakeholders. When defining a Record Type's Data Model, which data source is not an option? A. Database B. Process C. Salesforce D. Web Service E. All options are valid data sources E. All options are valid data sources What type case format do you use when creating a Record? A. APPUPPERCASE B. applowercase C. AppPascalCase D. appCamelCase E. APP_UPPER_CASE

F. app_lower_case G. App_Pascal_Case H. app_Camel_Case G. App_Pascal_Case What type case format do you use when creating a Record Type property? A. UPPERCASE B. lowercase C. PascalCase D. camelCase E. UPPER_CASE F. lower_case G. Pascal_Case H. camel_Case D. camelCase Once a Record Type with the data source of DB is created, what case format does the table use? A. UPPERCASE B. lowercase C. PascalCase D. camelCase E. UPPER_CASE F. lower_case G. Pascal_Case H. camel_Case E. UPPER_CASE What is a difference between the creation of an expression rule and a Web API? There are no rule inputs in a Web API. What does the term "OAuth" stand for? Owner Authentication What header contains a Bearer token for OAuth requests? Authorization When making an OAuth request, what HTTP status codes returned from the third-party system indicate that the access token is missing, revoked, or expired? 401, 403, and 404

What component can developers use to enable end-users to grant Appian access to third-party systems through OAuth Authorization Code Grant? a!authorizationLink() When setting up a OAuth Authorization Grant in the third party system, what should the Callback URI be to connect to Appian? http:///suite/oauth/callback What attributes are REQUIRED to setup an OAuth Authorization Code Grant Connected System? Authorization Endpoint | Client ID | Client Secret | Token Request Endpoint What is the Authorization Endpoint property of an OAuth Authorization Code Grant Connected System? The third-party system's authorization server endpoint that presents users with an authorization screen. What are the Client ID and Client Secret properties of an OAuth Connected System? Sensitive values from the third-party system that authorize the client (Appian) to use the OAuth of the third-party system. Similar to a username and password. What is the Token Request Endpoint property of an OAuth Connected System? The third-party system's resource server endpoint. Requires an access token to receive the desired resources. What attributes are REQUIRED to setup an OAuth Client Credentials Grant Connected System? Client ID | Client Secret | Token Request Endpoint For OAuth 2.0 Connected Systems, what is the difference between Authorization Code and Client Credentials? Authorization Code is for connecting to a resource server on behalf of a user. Client Credentials is for connecting to a resource server as an application. True / False: OAuth 2.0 Client Credentials Grant does not require an Authorization Endpoint. True True / False: OAuth 2.0 Client Credentials Grant requires a Callback URI in the third-party system. False What does SAML stand for? Security Assertion Markup Language What does IDP stand for? Identity Provider What is the purpose of SAML SSO?

User will sign in to an application one time and be connected to all applications that use the same IDP (SP-initiated login). Works the same with single logout. Does Appian support IDP-initiated login? Yes but not for embedded environments or mobile. What is required by Appian to setup SAML? SAML Identity Provider | PEM-formatted certificate | Identity Provider Metadata True/False: Appian can have multiple identity providers configured. True What types of SAML identity providers are allowed for Appian? SAML 2. True/False: Appian can accept signed or un-signed SAML assertions. False. Assertions must be signed with SHA-1 or SHA-256 signature method algorithms. What is the PEM-formatted certificate used for? Used to sign SAML assertions that come from Appian. Contains a private key that should be trusted by the target IDP. What is the Identity Provider Metadata file used for? Contains information about the IDP, especially the entity ID. What is the purpose of the Entity ID for SAML assertions? The Entity ID in the Appian metadata file must match the Issuer ID in all incoming SAML requests. Which SAML setting turns on SAML authentication? Enable SAML Which SAML setting enables Appian to use cookies to determine where users should be sent to sign-in? Remember IDP selection for non-SAML users Which SAML setting directs unauthenticated users to the default sign-in screen? Use a default sign-in page Which SAML setting directs unauthenticated users to the sign-in page selection screen? Have users choose their sign-in page Which SAML setting sets the header text sign-in page selection screen? Identity Provider choices prompt

Which SAML setting sets the identity providers that should appear on the sign-in page selection screen? Identity Provider Choices Which IDP setting sets the admin description for the IDP? Description Which IDP setting creates a URL identifier to route to a specific sign-in page? Web Address Identifier Which IDP setting allows Appian to use cookies to remember this IDP? Remember user's IDP selection Which IDP setting sets the Appian groups that should use this IDP? Authentication Group Which IDP setting enables users to sign-in once and stay signed in for a specified number of days? Remember Me Which IDP setting allows Appian to sync a user's group membership according to the SAML assertion? Group Member Synchronization Which IDP setting allows Appian to sync user data from a SAML assertion? Attribute Mapping If you want to ensure only certain users login with SAML, what should be configured? Add users to a specific SAML Authentication Group What do you configure to create a unique log-in URL for a SAML IDP? Web Address Identifier True/False: A user's username can be updated by IDP Attribute Mapping. False - A username change would result in a new Appian profile. What does LDAP stand for? Lightweight Directory Access Protocol What is required of the client when authenticating with LDAP? A username and password How does LDAP work with Microsoft's Active Directory? Using simple, string-based queries to extract user information. What protocols can be used to connect to an LDAP server?

ldap and ldaps If a user wants to use a service account to connect to their LDAP data, what authentication method should you use? Search for user then bind as user True/False: A single Appian user can authenticate with both LDAP and native Appian authentication. False True/False: LDAP authentication settings cannot be imported or exported from the Admin Console. True If an Appian user is a member of SAML and LDAP authentication groups, which authentication method should they use? SAML What user attributes are mapped in using LDAP authentication? Username | First/Last Name | Email What are the two types of authentication methods when authenticating via LDAP? Bind as user | Search for user then bind as user Where can you set the timeout length for LDAP Server Connection in Appian? Admin Console --> LDAP Server Connection Timeout What should you do if the usernames coming from the LDAP directory are uppercase and your Appian usernames are lowercase? Admin Console --> Use lowercase usernames for Appian user lookup What is the max length of CDT names and elements? 27 What is truncated first if a CDT name/element is over the character limit? Vowels True/False: Appian CDTs can use composite keys with no issues. False True/False: Database constraints are automatically enforced by Appian. False What does DDL stand for? Data Definition Language

What does Appian do if there is no primary key for a CDT? It will automatically create one, hidden from your view. What is optimistic data locking? A mechanism for avoiding race conditions by having a version number as a column on a row. That version number must be the same before and after the transaction is complete to prevent race conditions. What is pessimistic data locking? A mechanism that will shut down any access to a record while a user is completing a transaction. If another user tries to access it, they will be denied until the first transaction is complete. When should you implement data locking? When there is a chance of race conditions occouring. When should you implement pessimistic data locking over optimistic? If race conditions are to happen frequently within the application. What is an explain/execution plan? An outline of the set of steps that a database has to preform in order to return a result of a query. What is an index? An index is performance tuning method of allowing faster retrieval of records from the table. An index creates an entry for each value and it will be faster to retrieve data. How can you reduce the size of a database response in Appian? Use the selection and pagingInfo parameters. How many queries does it take to retrieve 5 company CDT values all with nested office location CDTs? 6 True/False: Appian should NOT handle all heavy data-centric tasks like sorting, aggregation, filtering, joining, and transforming data. True Where can you view the performance of data stores in Appian? Data Store Performance Logs What are the three steps to a database query through Appian? Prepare, Execute, Transform What does the Prepare step of an Appian database query do?

Generates the SQL query from SAIL code. What does the Execute step of an Appian database query do? Executes the generate SQL query in the database. What does the Transform step of an Appian database query do? Converts the results of a SQL query to an Appian dictionary or JSON. What causes slow query performance during peak usage? Server is under-resourced. What causes slow performance due to an increase in data? Missing suitable indexes. What causes slow transactional operations? Schema is not designed to handle operational activity. When should a stored procedure be used instead of an Appian datastore feature? Only if there is no OOTB datastore feature that supports the requirement. True/False: Indexes should be created on columns that are used in WHERE, JOIN, GROUP BY, ORDER BY, or are used in a!queryFilter(). True What is the type column of an explain plan for? Describes how the data was accessed in a query step. What is the ref column of an explain plan for? Shows which columns or constants are compared to the index in the key column. What does it mean when the possible_keys column of an explain plan is null? There are no relevant indexes on this table. For an explain plan, if the value in the row column is 1000 and the filtering column has a value of 30, how many rows are to be joined in the query? 300 What are the three least performant join types in an explain plan? From best to worst. range, index, all What join type would be for a query that compares a constant to a primary key? const

What database component should be used for Joining several tables via common identifiers? View What database component should be used for inserting an audit row when an update to a table occurs? Trigger What database component should be used for analyzing and updating a large number of records? Stored Procedure I have an inventory record where 10 people could be updating occasionally. What technical solution could be implemented? Add a @Version annotation to the CDT. I have a use case where I need to analyze and update 100,000 rows of data every night. What tools can I use to complete this activity without hurting memory utilization? Stored Procedure What does ETL stand for? Extract, Transform, Load I have a use case where I need to update a lookup table daily outside of business hours. The data is low in volume and complexity. What is the best ETL approach? Appian Processes and Rules What should be used for ETL processes when the data is extreme in volume and complexity? Third-Party Systems True/False: I can set up Enhanced Data Pipeline on Appian Cloud instances. True What is the purpose of a Web API within Appian? To expose Appian data to be consumed by outside systems. What are the four types of Web API authentication?

1. API Key
2. Basic Authentication
3. OAuth 2.0 Client Credentials
4. Session Based How does API Key authentication work in Appian? The API can only be invoked by a service account with a unique API Key associated with the account and appropriate permissions.

True/False: Service accounts for Web API authentication must be recreated in each environment with unique API Keys or OAuth client details. True What type of users (login authentication) cannot use their login information to invoke a web API that uses Basic Authentication? SAML What does CORS stand for? Cross-Origin Resource Sharing When does a web browser automatically block HTTP requests? If the requestor website origin is different than the response website origin. How can you allow cross-origin requests to your APIs in Appian? Update the allowed origins list in the Admin Console. What are the two REST HTTP methods Appian sends automatically for a Web API? OPTIONS and HEAD What is the maximum size of a document that can be downloaded or uploaded by Appian via a Web API? 75 MB What are the potential reasons a Web API would return a 404?

1. The endpoint is not found.
2. The user does not have permissions to invoke the API. What are the potential reasons a Web API would return a 500?
3. There was an error in the web API evaluation.
4. The result of the expression evaluation was not an HTTP Response object. Given this error message from an integration, what would be the next step to resolution? "Appian was not able to authenticate with the access token you provided. The request requires Bearer Authentication. HTTP/1.1 401 Unauthorized." Verify authentication of the request. If Appian needs to request data from an external system, what should be used to achieve this? Integration If an external system needs to request data from Appian, what should be used to achieve this? Web API