nerdexam
Oracle

1Z0-591 · Question #96

If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?

The correct answer is B. By creating four new logical table sources and choosing each dimension's level of aggregation in. Aggregation Content You can define the aggregation (ie the group by) of: It helps you to define an aggregate navigation Note: logical table source Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one…

Creating Aggregate Tables

Question

If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?

Options

  • ABy creating four new logical tables sources
  • BBy creating four new logical table sources and choosing each dimension's level of aggregation in
  • CBy creating four new logical table sources and using the Fragmentation content to specify the
  • DBy creating four new logical table sources and using the "where" section of the Content tab to specify

How the community answered

(48 responses)
  • A
    6% (3)
  • B
    81% (39)
  • C
    10% (5)
  • D
    2% (1)

Explanation

Aggregation Content You can define the aggregation (ie the group by) of: It helps you to define an aggregate navigation Note: logical table source Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this element. The definition of the logical table source is used: The Content tab of the Logical Table Source is used to define :

Topics

#aggregate tables#logical table sources#dimension level aggregation#content tab

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice