Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
Scrum
All Vendors
  2. Home
  3. Exams
  4. Pegasystems
  5. PEGACLSA74V1-R

Free PEGACLSA74V1-R Exam Braindumps (page: 5)

Page 4 of 39
PDF with 151 Questions

a performance analysis for an equals-comparisons-only query against a table shows that it always performas a full table scan. the table has grown steadily over time. nothing has been done in the database concerning this table other than it being generated by pega.

  1. limit the number of rows fetched from this table,
  2. add one or more column indexes to this table.
  3. Expose one or more columns within this table.
  4. alter one or more column types in the table.

Answer(s): B



you are writing a report that needs to compute the sum of multipul columns and display the result. The number of columns to sum varies from report to report but does not exceed five. which two options can you use to implement this requirement? (choose two)

  1. Develop a SQL function that sums two columns. Recursively apply this function as needed.
  2. implement a declare expression to sum the values and store the result as an additional property.
  3. construct the report to group by the columns to be summed followed by a column that uses SUM.
  4. Develop separate SQL functions for summing two through five columns. use the appropriate function.

Answer(s): A,D



an application to onboard new bank customers create child cases for each account that the customer opens.
You need to configure a report definition that lists new customer cases created in a given day and the average opening balance for all account child cases for each customer.
which reporting feature do you use?

  1. association
  2. subreport
  3. class join
  4. declare index

Answer(s): B



XYZ corp sells products that can be researched and ordered within a single screen. After the user submits the order, only the ID for each ordered product is propagated to a product child case. An additional property within the product child case reference a data page that displays product detail. XYZ wants you to define a report that shows detail about each product associated within a given order case.
In which class do you optimize the detail properties for the product?

  1. both the order class and product class
  2. the product class
  3. the order class
  4. the data class for the product

Answer(s): D






Post your Comments and Discuss Pegasystems PEGACLSA74V1-R exam with other Community members: