Pegasystems Exam PEGAPCLSA80V1_2020 Topic 13 Question 1 Discussion

Actual exam question for Pegasystems's PEGAPCLSA80V1_2020 exam

Question #: 1
Topic #: 13

[All PEGAPCLSA80V1_2020 Questions]

Table A contains customer information, Table B contains complaints submitted by customers. Table C contains positive feedback submitted by customer.

You are tasked to write a report that lists all rows in Table a where customer, the number of rows in Table B related to Table A are greater than the number of rows in Table C related to Table A.

Which method creates the report that execute with the best performance?

AJOIN Table A to Tables B and C using Include all joined class. Count the Join column from both Table B and Table C. Only include rows where the first count is greater than the second.

BDefine two subreports, one where Table B uses ''Do not JOIN''. And one where table C uses ;Do not JOIN''. In the subreport is greater than the count from the Table C subreport.

CDefine two subreports: one that counts rows in Table B relative to table A, and one that counts the Table C relative to table A. Only include rows in the main report Table A where the Table B count is greater than table C count.

DJOIN Table A to Tables B and C using include all rows in this class. Count the JOIN column from both table B and Table C. Only include rows where the first count is greater than the second

Show Suggested Answer

Suggested Answer: D

by Heike at May 06, 2022, 08:53 PM

Limited Time Offer

25%

Off

Get Premium PEGAPCLSA80V1_2020 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!