Oracle Siebel 7.7 Server Architect Professional Core

You want to compare this year's sales figure with that of last year. Why would you use time series modeling?

Which of the following contains values in memory that are used by the Siebel Analytics Server during its
processing?

ABC's tables have different columns and store different information but some column data may be duplicated
between them. Which of the following partition techniques is ABC using in this example?

ABC's database administrator has divided one huge Sales Rep table into two smaller tables so that one table
contains actual sales figures and the other contains the quota. What kind of partitioning is used?

Which of the following is NOT true of the non-dimensional data source used for prototypes?

Which of the following is NOT necessary when implementing Type II slowly changing dimensions as is done in
the Siebel Relationship Management Warehouse?

You want to compare the % increase/decrease in sales figure for each of your real estate agents in each district
from a year ago. Which of the following would best suit your need?

Which of the following NEVER uses Initialization Blocks to initialize its values?

ABC's database administrator has divided its region table into several tables so that the west region is in one
table and all the other regions are stored in another table. What kind of partitioning is used?

You have imported the Sales aggregate table that is aggregated by Period with the lowest granularity of Month.
After saving the repository and then restarting the appropriate servers, you ran the queries in Siebel Answers to
see the total sales figure for each product line by month. Then you saw that the query was run against the
Sales aggregate table and not the Sales detail table. Then you ran the queries to see the total sales figure for
each product line by day. What would you see in the log for the latest query?