A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?

Question

Options

• AMake Aggregate Table 1 the first table in the list of Logical Table Sources.
• BDo not map the logical level in the Content tab.
• CSet the Priority Group to 0.
• DSet the Priority Croup to 5.

• A
  4% (1)
• B
  7% (2)
• C
  71% (20)
• D
  18% (5)

Explanation

You can set priority group numbers to determine which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of For example, you might have user queries that can be fulfilled by both a data warehouse and an OLTP source. Often, access to an operational system is "expensive," while access to a data warehouse is "cheap." In this situation, you can assign a higher priority to the data warehouse to ensure that all queries are fulfilled by the data warehouse if possible. Note that the priority group of a given logical table source does not always ensure that a particular query will be fulfilled by that source. Priority Group Designation 0 the highest-priority source (the default) 1 a lowest-priority source

No community discussion yet for this question.