APPIAN LEAD CERTIFICATION EXAM ACTUAL
EXAM | ALL QUESTIONS AND CORRECT
ANSWERS | ALREADY GRADED A+ | LATEST
EXAM | VERIFIED ANSWERS
When should a stored procedure be used instead of an Appian datastore
feature? ---------CORRECT ANSWER-----------------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(). ----
-----CORRECT ANSWER-----------------True
What is the type column of an explain plan for? ---------CORRECT
ANSWER-----------------Describes how the data was accessed in a query
step.
What is the ref column of an explain plan for? ---------CORRECT ANSWER-
----------------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? ---------CORRECT ANSWER-----------------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? ---
------CORRECT ANSWER-----------------300
What are the three least performant join types in an explain plan? From
best to worst. ---------CORRECT ANSWER-----------------range, index, all
What join type would be for a query that compares a constant to a primary
key? ---------CORRECT ANSWER-----------------const
What database component should be used for Joining several tables via
common identifiers? ---------CORRECT ANSWER-----------------View
What database component should be used for inserting an audit row when
an update to a table occurs? ---------CORRECT ANSWER-----------------
Trigger
What database component should be used for analyzing and updating a
large number of records? ---------CORRECT ANSWER-----------------Stored
Procedure
I have an inventory record where 10 people could be updating occasionally.
What technical solution could be implemented? ---------CORRECT
ANSWER-----------------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? ---------CORRECT ANSWER-----------------
Stored Procedure
What does ETL stand for? ---------CORRECT ANSWER-----------------
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? ---------CORRECT ANSWER-----------------Appian
Processes and Rules
What should be used for ETL processes when the data is extreme in
volume and complexity? ---------CORRECT ANSWER-----------------Third-
Party Systems
True/False: I can set up Enhanced Data Pipeline on Appian Cloud
instances. ---------CORRECT ANSWER-----------------True
What is the purpose of a Web API within Appian? ---------CORRECT
ANSWER-----------------To expose Appian data to be consumed by outside
systems.
What are the four types of Web API authentication? ---------CORRECT
ANSWER-----------------1. API Key
2. Basic Authentication
3. OAuth 2.0 Client Credentials
, 4. Session Based
How does API Key authentication work in Appian? ---------CORRECT
ANSWER-----------------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. ---------CORRECT ANSWER-----------------True
What type of users (login authentication) cannot use their login information
to invoke a web API that uses Basic Authentication? ---------CORRECT
ANSWER-----------------SAML
What does CORS stand for? ---------CORRECT ANSWER-----------------
Cross-Origin Resource Sharing
When does a web browser automatically block HTTP requests? ---------
CORRECT ANSWER-----------------If the requestor website origin is different
than the response website origin.
How can you allow cross-origin requests to your APIs in Appian? ---------
CORRECT ANSWER-----------------Update the allowed origins list in the
Admin Console.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StudyWay. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $20.99. You're not tied to anything after your purchase.
