Quiz
Reporting
This quiz has question types that open in the usual player.
Questions in this quiz (40)
1Can a concrete class be mapped to a database table?
- ATrue
- BFalse
2Reports are most commonly generated with properties from which set of classes?
- AWork, Data, Rule
- B@baseclass, Assignment, Rule
- C@baseclass, Work, Assignment
- DWork, Assignment, and History
3An online retailer has received feedback about declining product quality. For each month, you want to display the number of orders and the number of one-star rated orders where quality issues are the primary complaint. How do you satisfy this use case?
- AConfigure appropriate report categories.
- BConfigure a report that uses an association rule.
- CConfigure a report that uses a class join.
- DConfigure a report that references a subreport.
4[blank_start]Class Join[blank_end]: Use [...] to create a class relationship in a report definition. You cannot use a [...] to configure unique filter conditions that apply separately to each class.
[blank_start]Association rules[blank_end]: Use [...] to create a class relationship in a report definition. You cannot use an [...] to configure unique filter conditions that apply separately to each class.
[blank_start]Report categories[blank_end]: Use [...] to organize reports.
[blank_start]Subreport[blank_end]: In a report for the order totals for each month, you use a join filter to join a [...] that fetches the number of one-star rated orders for each month. You use a filter condition to show the number of one-star rated orders with quality-related complaints.- AClass Join
- BAssociation rules
- CReport categories
- DSubreport
5[blank_start]Subreports[blank_end] are the only way to configure unique filter conditions that apply separately to each class
- ASubreports
6[blank_start]Subreports[blank_end] are the only way to aggregate data in another class in your report.
- ASubreports
7You create a report in a work class that displays the assigned operator and task name for each open case. Which two ways can you combine data in the Assign-Worklist class for your report? (Choose Two)
- AUse a class join to the Assign-Worklist class. Specify a join filter where the pxRefObjectKey in the join class is equal to an object identifier in the work class.
- BUse a class join to the Assign-Worklist class. Specify a join filter where the Worklist Assignment association rule is equal to an object identifier in the work class.
- CUse a Worklist Assignment association rule to join the Work class to the Assign-Worklist class.
- DUse a Worklist Assignment association rule to join to the Assign-Worklist class. Specify a join filter where the pxRefObjectKey in the join class is equal to an object identifier in the work class.
8Which report requires joining classes?
- AA list of all child cases showing the work urgency of their parent case
- BA list of flow actions and average turnaround time, categorized by Performer
- CA list of all worklist assignments grouped by the operator who is performing the action
- DA list of all cases created by the operator along with the work status of each case
9You create a report that uses data from two classes. Which of the following reporting requirements requires the use of a subreport?
- AColumns to display are: Operator Name, Operator Division, and Count of Purchase Requests created by the operator. Filter the results by unresolved status.
- BColumns to display are: Operator Name, Last updated Case ID, Last updated Case Status, and Update Date.
- CColumns to display are: Manager, Name, and Count of operators that report to each manager. Filter by Managers with more than five direct reports.
- DColumns to display are: Operator Name, Operator Division, Count of Purchase Requests created.
10[blank_start]Subreports[blank_end] can be defined in classes different from the main report.
[blank_start]Subreports[blank_end] can be used to filter results. This approach allows you to include or exclude data.
[blank_start]Subreports[blank_end] can be used to display aggregate calculations on specific rows in a list report.- ASubreports
- BSubreports
- CSubreports
11In the [blank_start]extract[blank_end] phase, data is extracted from various sources. In the [blank_start]transform[blank_end] phase, extracted data is compiled, converted, reformatted, and cleansed. The last step in the pipeline is [blank_start]load[blank_end]. Now that the data is ready, it must be stored in the target database (Data Warehouse).
- Aextract
- Btransform
- Cload
12Which two of the following actions do you perform when you begin developing your reporting strategy? (Choose Two)
- AInstall the BIX product
- BOptimize the properties in all the reports
- CInventory the reports the organization currently uses
- DCreate a matrix categorizing the user roles and reports each role uses to make business decisions
13Your organization uses a large number of business intelligence (BI) reports. Which two approaches would you consider to be good solutions? (Choose Two)
- AData archive
- BBIX
- CElasticsearch
- DData warehouse
14What two benefits do you gain by leveraging a data warehouse coupled with Pega reporting? (Choose Two)
- AYou can purge cases from your database along with the data warehousing process.
- BYou can use reporting tools suited for trending and data analysis.
- CYou can focus on using Pega Reporting for reporting on throughput data or cases in flight.
- DYou can use BIX to export cases to a database, a comma-separated file, or XML format.
15Selecting [blank_start]Include all rows[blank_end] on the [blank_start]Data Access[blank_end] tab of the report definition can be costly. This option causes the system to use an [blank_start]outer join[blank_end] for the report in which all instances of one of the classes are included in the report even if they have no matching instances in the other class. If possible, select [blank_start]Only include matching rows[blank_end].
- AInclude all rows
- BData Access
- Couter join
- DOnly include matching rows
16Pega automatically creates the tables in a reports database.
- ATrue
- BFalse
17The system does not sync between the reports database and the regular PegaDATA database.
- ATrue
- BFalse
18Data pulled out from a report using a reports database may not contain real-time data.
- ATrue
- BFalse
19Your application server is experiencing out-of-memory (OOM) errors. You suspect that the issue is related to a new report you recently put into production. Which of the following options is the likeliest reason that the report is causing these OOM issues?
- AHeavy network traffic
- BLarge result sets
- CComplex SQL requests
- DUnoptimized properties
20You have created a set of reports that use large numbers of embedded properties. Which of the following techniques do you use to help improve report performance?
- ARun reports against a reports database
- BInclude all rows when joining reports
- CEnable pagination
- DCreate declare indexes
21What database tuning technique do you use to determine if the database is taking the most efficient route to return results?
- ACreate table indexes
- BRun explain plans on your queries
- CPartition the database tables
- DPerform a load test
22When using the Reports database, system automatically sync the data between the reports database and the regular PegaDATA database. (Choose One)
- ATrue
- BFalse
23[blank_start]Joins[blank_end] and [blank_start]subreports[blank_end] are not available to business users on the end-user portal, only [blank_start]associations[blank_end].
- Ajoins
- Bsubreports
- Cassociations
24A class join contains three types of joins based on the type that is configured on the Data access tab:
Only include matching rows = [blank_start]INNER JOIN[blank_end]
Include all rows in this class = [blank_start]LEFT OUTER JOIN[blank_end]
Include all rows in joined class = [blank_start]RIGHT OUTER JOIN[blank_end]- AINNER JOIN
- BLEFT OUTER JOIN
- CRIGHT OUTER JOIN
25Compared with [blank_start]association rules[blank_end], [blank_start]joins[blank_end] are not reusable across multiple report definitions and apply only to the report you edit.
- Aassociation rules
- Bjoins
26[blank_start]Subreports[blank_end] join two different classes using [blank_start]specific join conditions[blank_end]. The results from the [blank_start]second report[blank_end] can then be used to filter the [blank_start]first report[blank_end] or be displayed as part of the [blank_start]first[blank_end] report. Subreports in Pega Platform are used as [blank_start]WHERE[blank_end] clause subqueries. There are also [blank_start]FROM[blank_end] clause subqueries (“table subqueries”) and [blank_start]SELECT[blank_end] clause subqueries.
- ASubreports
- Bspecific join conditions
- Csecond report
- Dfirst report
- Efirst
- FWHERE
- GFROM
- HSELECT
27What are two ways to define a trend report with a chart that shows the number of cases completed each day as well as the number of cases resolved each day? (Choose Two)
- AUse a series of sub-reports
- BUse a Complex SQL requests
- CDefine and reports against history table
- DDefine and report against a Timeline table
28Multiple case types within the Booking application’s case hierarchy can produce FSG-Data-Pricing records, BookEvent and VehicleParking, for example. To generate a customer’s invoice, the Booking team needs to collect every Pricing record related to a given BookEvent case. Which of the following approaches should be used as part of solution?
- ADefine an FSG-Booking-Data-CaseHierarchy class. Within each row of that class, both the pyID of the BookEvent case and the pyID of a BookEvent child case are persisted. That generated table is joined to FSG-Data-Pricing’s Reference property.
- BDefine an FSG-Booking-Work subreport that uses Do Not JOIN rows. The main FSG-Booking-Work-BookEvent Report Definition declares a ParentKey parameter which is passed to the subreport. The subreport filters on pxCoveredInsKey = param.ParentKey. Main report filters on pzInsKey = SUBRPT.pxCoveredInsKey which generates an IN clause. The main report OR’s that filter with pzInsKey = param.ParentKey
- CDefine an SQL Function named isInCaseHierachy() that takes two parameters, one being the passed-in pyID of the parent case, the other being the Reference property within the FSG-Data-Pricing record Pricing record.
- DDefine an FSG-Booking-Work-BookEvent Report Definition that defines a JOIN to FSG-Booking-Work-BookEvent aliased as “CHILD”. The JOIN compares pyOrigOrg values. The Query tab’s filter condition compares CHILD.pzInsKey to the pxCoveredInsKeys ValueList which generates an ((A = B) or (A = C) or…) clause.
29XYZ Corp. sends a survey to its customers with responses such as Poor, Fair, Good, Very Good, Exceptional. XYZ would like to see this information graphed numerically where Poor = 5, Fair = 4, Good = 3, Very Good = 2, and Excellent = 1, those values being summed, not counted. The resulting sum should then be averaged over the number of questions in the survey. XYZ’s goal is to lower the dissatisfied customer averaged score as low as possible. Which of the following approaches should be used as part of the solution?
- ADefine an SQL Function that returns a number 1-5. In subreport A, apply the “Sum” Summarize option to the output of that SQL Function. In a subreport B, use the “Count” Summarize option to obtain the number of rows queried by subreport A. In the main report, divide() subreport’s A’s sum by subreport B’s count.
- BDefine an Activity that uses Obj-Browse. Loop the result. In the loop adding to running total using When/Otherwise When/Otherwise conditions. Divide that total by param.pyForEachCount to obtain the average.
- CDefine an SQL Function that returns a number 1-5. Apply the “Average” Summarize option to the output of that SQL Function.
- DDefine SQL Functions such as Poor() or Fair(). Each Function returns a number 1-5 when matching the response otherwise 0. In subreport A, apply the “sum” Summarize option to each column then use the Add() Function to add those sums. In the main report, divide() subreport A’s total by the count of the rows queried by subreport A queried, that count obtained by subreport
30Which of the statements below are true related to Association and Class Joins? (Choose Two)
- AClass joins helps to joins the two classes only when these two classes are having common column.
- BAssociations helps to joins the two classes only when these two classes are having common column and are not reusable to include in other reports.
- CAssociations helps to join the two classes even if they do not have a common column and can be reused in other reports.
- DClass joins helps to joins the two classes even if they don't have a common column and can be reused in other reports.
31Which report definition data access method should be used to include Work Parties?
- AAssociation
- BSub Report
- CJoin
- DDeclare index
32Which JOIN condition is the most efficient in a report definition?
- AInclude all rows in joined class.
- BOnly include unmatched rows.
- COnly include matching rows.
- DInclude all rows.
33XYZ Corp orders office supplies through multiple suppliers. XYZ Corp wants to see detail about the least expensive line items purchased through each supplier. XYZ has Order cases that have LineItem subcases. LineItem detail is stored in a separate table. Which of the following approaches should be used as part of the solution?
- ADefine a subreport that obtains supplier ID and min(Price) from the line item table. Within the main report query the line item table joining to the subreport by product ID.
- BDefine a subreport that obtains supplier ID and max(Price) from the line item table. Within the main report query the line item table joining to the subreport by supplier ID.
- CDefine a subreport that obtains supplier ID and max(Price) from the line item table. Within the main report query the line item table joining to the subreport by product Id.
- DDefine a subreport that obtains supplier ID and min(Price) from the line item table. Within the main report query the line item table joining to the subreport by supplier ID.
34What are two issues that can result if large data sets are generated by a report and sent to another user? (Choose Two)
- ANetwork issues
- BOut-of-memory issues
- CHardware failure
- DTesting issues
35Which column can be removed from Declare Index tables to improve performance?
- ApwPvStream
- BpxPvStream
- CpyPvStream
- DpzPvStream
36Which of the following best describes the function of BIX?
- ATo extract Pega data for loading into a data warehouse.
- BTo transform data within the Pega database.
- CTo configure reports on both Pega and non-Pega data.
- DTo extract non-Pega data for loading into Pega.
37Which of the following statements is true about reports database in Pega?
- AReports database schema and Pega database schema must be on the same database server.
- BA table in a reports database must have the same structure (such as columns) as its counterpart table in the PegaRULES database.
- CPega automatically replicates data on to Reports database schema.
- DA table in a reports database need not have the same structure (columns, etc.) as its counterpart table in the PegaRULES database.
38What are the two phases to implement a agent activity through Purge and Archival Wizard? (Choose Two)
- ACommit the process on completion
- BConfiguration
- CProvide access to run the process
- DDelete the cases using SQL statement
- ESchedule process
39Which of the following is a benefit of table partitioning?
- AImprove the query performance.
- BImprove guardrail score.
- CCan create index automatically for better results.
- DTake less space for storage.
40Which of the following setups most likely requires the use of a subreport?
- AColumns-Operator Name, Operator Division, Count of Purchase Requests created, 1 row for every operator.
- BColumns-Operator Name, Operator Division, 1 row for every operator.
- CColumns-Operator Name, Operator Division, Count of Purchase Requests created, 1 row for every operator excluding Purchase Requests being audited.
- DColumns-Operator Name, Count of Purchase Requests created, 1 row for every operator.
Information
- Description
- User has deleted their subject information Quiz on Reporting, created by Deleted user on 14/09/2022.
- Author
- Deleted user
- Language
- English
- Views
- 13
- Tags