PEGACPLSA23V1 practice question 2 of 15
[Reporting Design] In a retail inventory management application, the system captures and stores product sales data in the backend database to manage…
Full set: 60 questionsThis solution represents the most robust and scalable architectural pattern for handling large-scale historical reporting in Pega. Storing all application-related data, including product master data and transactional sales data, within the standard PegaDATA schema is the correct approach. For complex, long-term trend analysis spanning five years, using Business Intelligence Exchange (BIX) to extract data to a dedicated data warehouse is the Pega-recommended best practice. This strategy offloads resource-intensive analytical queries from the live transactional database, preventing performance degradation of the core application while enabling powerful analysis with specialized BI tools.
A: Incorrectly suggests segmenting product data into the CustomerData schema. Product data is core application data and belongs in the PegaDATA schema alongside the related sales workflow data. B: Proposing direct queries by BI tools on the live transactional database is a significant anti-pattern that would severely impact the application's performance, especially with five years of data. D: Incorrectly centralizes all data in the CustomerData schema and recommends direct database querying by BI tools, which is both an incorrect data model and a poor performance strategy.
1. Pega Academy (Lead System Architect 8.7 Module): "BIX and data extraction". This module explicitly details the use of Business Intelligence Exchange (BIX) for extracting large volumes of data from the Pega database to a separate reporting database or data warehouse. It emphasizes this approach to avoid performance impacts on the transactional system when running complex, long-running reports. The scenario in the question is a classic use case for BIX.
2. Pega Documentation: "Business Intelligence Exchange (BIX)". The official documentation describes BIX as the tool for extracting transactional data from the Pega Platform database into formats suitable for use in external reporting, analytics, and data warehousing systems. It highlights that BIX is designed for high-performance extraction without impacting OLTP users.
3. Pega Documentation: "Understanding the Pega Platform schemas". This documentation clarifies the purpose of the different schemas. The PegaDATA schema is the primary schema for all case data, assignments, and application-specific data tables. The CustomerData schema is designated for customer-centric data, typically used by Pega Marketing and Customer Service applications, not for general application or product master data. Storing both product and sales data in PegaDATA is the standard practice.
Keep practicing
Take the free PEGACPLSA23V1 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PEGACPLSA23V1 practice questions
- Question 1[Security Design] An application has a web page where users can upload and view images. T…
- Question 3[Data Modeling] As an LSA developing a Pega application for an online grocery store, you …
- Question 4[Data Modeling] In a hospital's patient management Pega application, patient details are …
- Question 5[Deployment and Testing] You are a Pega developer working on a large project. You must im…
- Question 6[Work Delegation and Asynchronous Processing] Hospital XYZ wants to analyze patient data …
- Question 7[Application Design] As a Lead System Architect, one of your principal duties involves ad…
