Discussion
4
Replies
823
Views
Posted: March 13, 2016
Last activity: May 24, 2016
Closed
Optimize reports questions - 100% fail!
I have done some mock exam questions regarding optimizing the correct columns for reports and I get them incorrect every time! I presumed they would be the values that change often that require them to be optimized. Are mock exam answers always correct? I presume this is part of CSA but it was only really skim covered in the videos.
Can somebody please point me in the right direction as I don't believe SAI and SAII videos as adequate?
Hi,
you want optimise properties for reporting. You want to optimise properties that are used often in reports.
When you create a report definition in order to query the DB, it is time consuming to retrieve the BLOB, parse it and get the value for the properties. Which is why you can optimise these properties, by doing so, a new column will be created in the table so you requests (reports) can point directly to columns to fetch data instead of using the BLOB.
To prepare the CSA exam there is only the videos, transcripts for each videos and the reference document (student guide) available in the first lesson of the first module.
Damien