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. Run an explain statement on the views, identify critical areas of improvement that can be remediated without business knowledge.
B. 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.
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. Go through all of the tables one by one to identify which of the grouped by, ordered by, or joined keys are currently indexed.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
You have created a Web API in Appian with the following URL to call it: https://exampleappiancloud.com/suite/webapi/user_management/users?username=john.smith. Which is the correct syntax for referring to the username parameter?
A. httpRequest.users.username
B. httpRequest.formData.username
C. httpRequest.queryParameters.users.username
D. httpRequest.queryParameters.username
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Users must be able to navigate throughout the application while maintaining complete visibility in the application structure and easily navigate to previous locations. Which Appian Interface Pattern would you recommend?
A. Use Billboards as Cards pattern on the homepage to prominently display application choices.
B. Include a Breadcrumbs pattern on applicable interfaces to show the organizational hierarchy.
C. Implement an Activity History pattern to track an organization's activity measures.
D. Implement a Drilldown Report pattern to show detailed information about report data.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
What are two advantages of having High Availability (HA) for Appian Cloud applications?
A. Data and transactions are continuously replicated across the active nodes to achieve redundancy and avoid single points of failure.
B. A typical Appian Cloud HA instance is composed of two active nodes.
C. In the event of a system failure, your Appian instance will be restored and available to your users in less than 15 minutes, having lost no more than the last 1 minute worth of data.
D. In the event of a system failure, your Appian instance will be restored and available to your users in less than 15 minutes, having lost no more than the last 1 minute worth of data. This is an advantage of having HA, as it guarantees a high level of service availability and reliability for your Appian instance. If one of the nodes fails or becomes unavailable, the other node will take over and continue to serve requests without any noticeable downtime or data loss for your users.
E. An Appian Cloud HA instance is composed of multiple active nodes running in different availability zones in different regions.
正解:A,C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
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 big integers, above and below 0.
B. The field contains long unstructured text such as a hash.
C. The field contains many datetimes, covering a large range.
D. The field contains a textual short business code.
E. The field contains a structured JSON.
正解:A,C,D
解説: (Pass4Test メンバーにのみ表示されます)
1255 お客様のコメント





大久** -
合格のカギが自分にはとても良かったですね〜。手に取りました。ACD301に関心のある方はおすすめの本です。