ABC Retail Inc. wants a report that illustrates the distribution of customer loyalty based on their shopping history. ABC wants to see the number of customers who have beenshopping with the company for more than
10 years, between five and 10 years, between two and five years, and less than two years. Suggest the most optimistic way of separating and displaying the shopping history using a report.

• A. Use a correlated subreport.
• B. Use a function alias.
• C. Use a Connect-SQL rule.
• D. Use a Rule-Obj-ListView with a custom getContent activity.

You are a Lead System Architect working on a booking application for a travel agency. You want to send email notifications to different participants (such as customers or sales coordinators) with custom messages based on their roles. You also want to ensure that the email-sending process does not affect the performance or responsiveness of the application. Which design option would you choose to implement this requirement?

• A. Standard queue processor
• B. Job scheduler
• C. Standard agent
• D. Advanced agent

An online streaming service faces performance issues because of a high volume of user data stored in the database. As a Lead System Architect, what are the two best corrective actions that you suggest for enhancing application performance? (Choose Two)

• A. Conduct database indexing on critical tables and optimize columns to improve query performance.
• B. Schedule regular database defragmentation sessions in collaboration with the Database Administrator.
• C. Implement archival of cases, case history, and associated media files, and then purge the data based on usage patterns and business criteria.
• D. Implement horizontal and vertical database partitioning strategies and replication to distribute the load effectively.

In the HRApp application, there are sensitive reports related to hiring and compensation. These reports must only be accessible to senior executives. What is the best possible way to achieve this requirement?

• A. Use the Access Control Check feature in Pega Platform to identify any potential security risks in the custom code.
• B. Assign the HRApp:SeniorExec role to the relevant users and ensure that this role has the necessary permissions for the reports.
• C. Implement a data masking strategy to protect sensitive data in the reports.
• D. Implement a role-based access control system that restricts access to the reports based on the role of the user.

In a hospital's patient management Pega application, patient details are gathered during the initial consultation process. This information must be accessible and current for all subsequent appointments and treatments.
Keeping patient information updated is crucial to effective planning and implementation of treatment. Which one of the following options would you select as a solution?

• A. A portal to collect patient data. Pre-load the patient's information into the system for each subsequent appointment and treatment, based on the outcomes of the initial consultation.
• B. A portal to collect patient data and store the data with Consultation cases. Use data propagation features to transfer patient information to each subsequent appointment or treatment as they are scheduled.
• C. A portal for updating patient data, utilizing the System of Record (SOR) data access pattern to access patient information for appointments and treatment processes.
• D. A portal for updating patient data, using the snapshot data access pattern to access patient information for appointments and treatment processes.