nerdexam
SAP

C_BOWI_40 · Question #145

Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?

The correct answer is B. It will refresh up to three times slower. Data tracking in Web Intelligence compares old and new data values on each refresh, adding significant overhead to the process even when row count and volume remain constant.

Working with Data

Question

Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?

Options

  • AIt will refresh up to three times faster.
  • BIt will refresh up to three times slower.
  • CIt will refresh faster each time the report is refreshed.
  • DIt will refresh slower each time the report is refreshed.

How the community answered

(47 responses)
  • A
    6% (3)
  • B
    74% (35)
  • C
    4% (2)
  • D
    15% (7)

Why each option

Data tracking in Web Intelligence compares old and new data values on each refresh, adding significant overhead to the process even when row count and volume remain constant.

AIt will refresh up to three times faster.

Data tracking adds processing overhead rather than reducing it, so a speed increase of three times is technically impossible.

BIt will refresh up to three times slower.Correct

When data tracking is enabled, Web Intelligence must compare each retrieved value against the previously stored snapshot to identify changes, additions, and deletions. This comparison work is performed in addition to the normal data retrieval, causing refresh times to be up to three times slower than without tracking enabled.

CIt will refresh faster each time the report is refreshed.

Refresh time does not improve progressively with each refresh - the comparison overhead is incurred on every refresh cycle.

DIt will refresh slower each time the report is refreshed.

While refresh does become slower, 'slower each time' implies cumulative degradation per refresh, which is incorrect - the slowdown is consistent, not increasing.

Concept tested: Data tracking performance impact on report refresh

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1c0a6a3d2b6f4e76a87e49f1b22b5b5a/46d2a56a6e041014910sce01.html

Topics

#data tracking#report refresh performance#refresh time impact

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice