Pegasystems PEGACPLSA88V1 Exam (page: 7)
Pegasystems Certified Pega Lead System Architecture 8.8
Updated on: 31-Mar-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:

DMZ 6/25/2023 11:56:00 PM

this exam dumps just did the job. i donot want to ruffle your feathers but your exam dumps and mock test engine is amazing.
UNITED KINGDOM


Jose 8/30/2023 6:14:00 AM

nice questions
PORTUGAL


Tar01 7/24/2023 7:07:00 PM

the explanation are really helpful
Anonymous


DaveG 12/15/2023 4:50:00 PM

just passed my exam yesterday on my first attempt. these dumps were extremely helpful in passing first time. the questions were very, very similar to these questions!
Anonymous


A.K. 6/30/2023 6:34:00 AM

cosmos db is paas not saas
Anonymous


S Roychowdhury 6/26/2023 5:27:00 PM

what is the percentage of common questions in gcp exam compared to 197 dump questions? are they 100% matching with real gcp exam?
Anonymous


Bella 7/22/2023 2:05:00 AM

not able to see questions
Anonymous


Scott 9/8/2023 7:19:00 AM

by far one of the best sites for free questions. i have pass 2 exams with the help of this website.
CANADA


donald 8/19/2023 11:05:00 AM

excellent question bank.
Anonymous


Ashwini 8/22/2023 5:13:00 AM

it really helped
Anonymous


sk 5/13/2023 2:07:00 AM

excelent material
INDIA


Christopher 9/5/2022 10:54:00 PM

the new versoin of this exam which i downloaded has all the latest questions from the exam. i only saw 3 new questions in the exam which was not in this dump.
CANADA


Sam 9/7/2023 6:51:00 AM

question 8 - can cloudtrail be used for storing jobs? based on aws - aws cloudtrail is used for governance, compliance and investigating api usage across all of our aws accounts. every action that is taken by a user or script is an api call so this is logged to [aws] cloudtrail. something seems incorrect here.
UNITED STATES


Tanvi Rajput 8/14/2023 10:55:00 AM

question 13 tda - c01 answer : quick table calculation -> percentage of total , compute using table down
UNITED KINGDOM


PMSAGAR 9/19/2023 2:48:00 AM

pls share teh dump
UNITED STATES


zazza 6/16/2023 10:47:00 AM

question 44 answer is user risk
ITALY


Prasana 6/23/2023 1:59:00 AM

please post the questions for preparation
Anonymous


test user 9/24/2023 3:15:00 AM

thanks for the questions
AUSTRALIA


Draco 7/19/2023 5:34:00 AM

please reopen it now ..its really urgent
UNITED STATES


Megan 4/14/2023 5:08:00 PM

these practice exam questions were exactly what i needed. the variety of questions and the realistic exam-like environment they created helped me assess my strengths and weaknesses. i felt more confident and well-prepared on exam day, and i owe it to this exam dumps!
UNITED KINGDOM


abdo casa 8/9/2023 6:10:00 PM

thank u it very instructuf
Anonymous


Danny 1/15/2024 9:10:00 AM

its helpful?
INDIA


hanaa 10/3/2023 6:57:00 PM

is this dump still valid???
Anonymous


Georgio 1/19/2024 8:15:00 AM

question 205 answer is b
Anonymous


Matthew Dievendorf 5/30/2023 9:37:00 PM

question 39, should be answer b, directions stated is being sudneted from /21 to a /23. a /23 has 512 ips so 510 hosts. and can make 4 subnets out of the /21
Anonymous


Adhithya 8/11/2022 12:27:00 AM

beautiful test engine software and very helpful. questions are same as in the real exam. i passed my paper.
UNITED ARAB EMIRATES


SuckerPumch88 4/25/2022 10:24:00 AM

the questions are exactly the same in real exam. just make sure not to answer all them correct or else they suspect you are cheating.
UNITED STATES


soheib 7/24/2023 7:05:00 PM

question: 78 the right answer i think is d not a
Anonymous


srija 8/14/2023 8:53:00 AM

very helpful
EUROPEAN UNION


Thembelani 5/30/2023 2:17:00 AM

i am writing this exam tomorrow and have dumps
Anonymous


Anita 10/1/2023 4:11:00 PM

can i have the icdl excel exam
Anonymous


Ben 9/9/2023 7:35:00 AM

please upload it
Anonymous


anonymous 9/20/2023 11:27:00 PM

hye when will post again the past year question for this h13-311_v3 part since i have to for my test tommorow…thank you very much
Anonymous


Randall 9/28/2023 8:25:00 PM

on question 22, option b-once per session is also valid.
Anonymous