QUESTION: 13

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.

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

Answer(s): B

Reveal Solution Next Question

QUESTION: 14

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)

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

Answer(s): A,D

Reveal Solution Next Question

QUESTION: 15

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?

association
subreport
class join
declare index

Answer(s): B

Reveal Solution Next Question

QUESTION: 16

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?

both the order class and product class
the product class
the order class
the data class for the product

Answer(s): D

Reveal Solution Next Question

Free PEGACLSA74V1-R Exam Braindumps (page: 4)

QUESTION: 13

QUESTION: 14

QUESTION: 15

QUESTION: 16