Questões para certificação IBM Cognos COG-125
08/06/2010 2 Comentários
Consegui algumas provas antigas da Cognos, provas que não são aplicadas mais e irei postar aqui algumas questões para ajudar o pessoal a se preparar para a prova.
Para ver as respostas,clique na opção “Read more of this post”:
1- Please select three rules that apply to pivoting.
A: Pivoting increases the number of output fact rows.
B: You cannot pivot more than one set of columns within a datastream.
C: No limits exist on the number of pivot values.
D: A measure element is declared to hold the pivot value.
E: A dimension element is declared to hold the pivot values.
2- A static member can act as a foster parent for any member that does not have a parent associated with it.
3- The template for a particular dimension indicates three attributes with “Business Key” as its Behavior and “Primary Key” as its Property. How do you determine which is the ‘real’ business key for this dimension?
A: Make sure you have a model diagram to refer to.
B: You must select the check box beside the attribute you wish to be the dimensional business key.
C: The dimensional business key is indicated as “True” under the Value column in the template.
4 – Ralph Kimball maintains that there are three typical ways to handle changing dimensional data. By far the most commonly accepted methods are: Type 1 – where no historical record is required Type 2 – where an accurate historical record is required at any stage Which one of the following choices applies to a slowly changing dimension?
A: Type 1
B: Type 2
C: Type 1 and Type 2
D: none of the above
5 – Which CLI program would you use to export one or more components from one catalog to another?
Respostas: 1 – (A,C,D) ; 2 – A; 3- C ; 4 -B ; 5 – A