Pegasystems PEGACPLSA88V1 Exam (page: 7)
Pegasystems Certified Pega Lead System Architecture 8.8
Updated on: 15-Feb-2026

Viewing Page 7 of 49

XYZ Corporation would like a report that shows the number of employees who have been with the company more than 20 years, between 15 and 20 years, between 10 and 15 years, between 5 and 10 years, and less than 5 years.
How do you implement this report using Pega?

  1. Use a SQL Function.
  2. Use a listView with a custom getContent Activity.
  3. Use a correlated subreport.
  4. Use a Connect-SQL rule.

Answer(s): A

Explanation:

To create a report that shows the number of employees with varying years of service, the best approach is to use a SQL function:
SQL Function: Create a SQL function that categorizes the employees based on their years of service. This function can then be used in the report definition to generate the desired output. Implementation: Implement the function to return different categories such as more than 20 years, between 15 and 20 years, etc.


Reference:

Creating SQL functions in Pega



An application contains cases which transition though different statuses throughout their life cycle which typically lasts 3 months.
Design a reporting strategy to display the number of cases by status at the end of each month for a 12-month period.

  1. Configure an agent to record monthly case status in a separate table and report on that table.
  2. Configure an activity to generate the data in the clipboard and report using a custom section.
  3. Configure a summary report that leverages sub reports for each month.
  4. Configure a Declare index to record case data to a separate table.

Answer(s): A

Explanation:

To design a reporting strategy that displays the number of cases by status at the end of each month for a 12-month period, follow these steps:
Configure an Agent: Set up an agent to run at the end of each month to capture the status of all cases.
Record Data: The agent records the case statuses in a separate table specifically created for this purpose.
Reporting: Generate reports based on the data stored in this table to provide an accurate month-end snapshot of case statuses.


Reference:

Configuring agents in Pega



What two recommendations do you provide to the development team to ensure the performance of the Pega application does not degrade over tune? (Choose Two)

  1. Add indexes to all columns.
  2. Purge workparty UlU index tables periodically.
  3. Schedule scripts to maintain frequently fragmented tables.
  4. Purge and/or archive records based on the company's record retention policy.

Answer(s): C,D

Explanation:

To ensure the performance of a Pega application does not degrade over time, two key recommendations are:
Schedule scripts to maintain frequently fragmented tables (C): Table fragmentation can lead to inefficient database performance. Regular maintenance scripts can help defragment these tables, ensuring that data retrieval remains efficient.
Purge and/or archive records based on the company's record retention policy (D): Over time, the accumulation of records can slow down application performance. Implementing a purge or archive strategy based on the company's retention policy helps manage database size and performance.


Reference:

Pega Database Management: Best Practices for Database Maintenance Pega Performance: Improving Application Performance



Users in a cloud-based production application report a chronic performance issue that occurs every day between 2:0 P.M. and 4:00 P.M. All attempts to reproduce the problem in the Development, QA, and Staging environments have (ailed.
Which two techniques help you troubleshoot the problem? (Choose Two)

  1. Review Performance Alerts and Exceptions in PDC
  2. Review a Production Tracer Log using SMA-
  3. Review Alerts and Exceptions using PLA.
  4. Review Performance Alerts and Exceptions in AES.

Answer(s): A,D

Explanation:

To troubleshoot a chronic performance issue in a cloud-based production application:
Review Performance Alerts and Exceptions in PDC (A): Pega Predictive Diagnostic Cloud (PDC) monitors and reports on the health and performance of Pega applications in real-time. Reviewing alerts and exceptions here can provide insights into the root causes of performance issues. Review Performance Alerts and Exceptions in AES (D): Pega Autonomic Event Services (AES) also monitors system health and performance. It can help identify patterns and issues that occur during specific time frames.


Reference:

Pega PDC: Understanding Pega Predictive Diagnostic Cloud Pega AES: Pega Autonomic Event Services Overview



XYZ Corp users are experiencing delays in the application that you suspect is related to the database.
Which two options do you recommend to isolate the issue? (Choose Two)

  1. Write Pega logs to the database server.
  2. Investigate when the database is used most heavily.
  3. Lower query-time-related alert thresholds.
  4. Increase the threshold for blob-size alerts.

Answer(s): B,C

Explanation:

To isolate database-related performance issues:
Investigate when the database is used most heavily (B): Understanding peak usage times can help pinpoint when the database is under the most strain. This information is crucial for identifying potential bottlenecks and optimizing performance.
Lower query-time-related alert thresholds (C): By lowering the alert thresholds for query times, you can capture more detailed information about slow-running queries, helping to identify and address inefficient database operations.


Reference:

Pega Performance: Database Performance and Tuning
Pega Alerts: Configuring Alerts and Thresholds



Viewing Page 7 of 49



Share your comments for Pegasystems PEGACPLSA88V1 exam with other users:

VoiceofMidnight 12/17/2023 4:07:00 PM

Delayed the exam until December 29th.
UNITED STATES


Umar Ali 8/29/2023 2:59:00 PM

A and D are True
Anonymous


vel 8/28/2023 9:17:09 AM

good one with explanation
Anonymous


Gurdeep 1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.
CANADA