Appian Certified Lead Developer 認定 ACD-301 試験問題:

1. You add an index on the searched field of a MySQL table with many rows (>100k). The field would benefit greatly from the index in which three scenarios?

A) The field contains a textual short business code.
B) The field contains long unstructured text such as a hash.
C) The field contains a structured JSON.
D) The field contains big integers, above and below 0.
E) The field contains many datetimes, covering a large range.

2. As part of an upcoming release of an application, a new nullable field is added to a table that contains customer dat a. The new field is used by a report in the upcoming release and is calculated using data from another table.
Which two actions should you consider when creating the script to add the new field?

A) Create a rollback script that clears the data from the field.
B) Create a rollback script that removes the field.
C) Add a view that joins the customer data to the data used in calculation.
D) Create a script that adds the field and leaves it null.
E) Create a script that adds the field and then populates it.

3. You are just starting with a new team that has been working together on an application for months. They ask you to review some of their views that have been degrading in performance. The views are highly complex with hundreds of lines of SQL. What is the first step in troubleshooting the degradation?

A) Browse through the tables, note any tables that contain a large volume of null values, and work with your team to plan for table restructure.
B) Go through all of the tables one by one to identify which of the grouped by, ordered by, or joined keys are currently indexed.
C) Go through the entire database structure to obtain an overview, ensure you understand the business needs, and then normalize the tables to optimize performance.
D) Run an explain statement on the views, identify critical areas of improvement that can be remediated without business knowledge.

4. A customer wants to integrate a CSV file once a day into their Appian application, sent every night at 1:00 AM. The file contains hundreds of thousands of items to be used daily by users as soon as their workday starts at 8:00 AM. Considering the high volume of data to manipulate and the nature of the operation, what is the best technical option to process the requirement?

A) Build a complex and optimized view (relevant indices, efficient joins, etc.), and use it every time a user needs to use the data.
B) Create a set of stored procedures to handle the volume and the complexity of the expectations, and call it after each integration.
C) Use an Appian Process Model, initiated after every integration, to loop on each item and update it to the business requirements.
D) Process what can be completed easily in a process model after each integration, and complete the most complex tasks using a set of stored procedures.

5. An Appian application contains an integration used to send a JSON, called at the end of a form submission, returning the created code of the user request as the response. To be able to efficiently follow their case, the user needs to be informed of that code at the end of the process. The JSON contains case fields (such as text, dates, and numeric fields) to a customer's API. What should be your two primary considerations when building this integration?

A) The size limit of the body needs to be carefully followed to avoid an error.
B) A dictionary that matches the expected request body must be manually constructed.
C) The request must be a multi-part POST.
D) A process must be built to retrieve the API response afterwards so that the user experience is not impacted.

質問と回答：