Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

  1. Create relationships from date fields inone dimension to date fields in another dimension.

  2. Use parameter maps to map date values in one query subject to date values in another query subject.

  3. Use theTime Dimension wizard togenerate a time dimension and create the appropriate relationships.

  4. Identify a time dimension table source, import into the model and create relationships to fact query subjects.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

In Framework Manager, when using star schema groupings inthe business view, conformed dimensions can be identified bywhich one of the following?

  1. Using a different query subject icon for display inthe studios.

  2. Viewing the properties of the query subjects in Report Studio.

  3. Viewing the properties of the query subjects in Framework Manager.

  4. Using the same name for the dimension in each star schema grouping.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?

  1. Create regular and measure dimensions and set scope.

  2. Create shortcuts to regular dimensions and fact query subjects.

  3. Create star schema groupings for dimension and fact query subjects.

  4. Create relationships between regular dimensions andmeasure dimensions.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

Which of the following is correct regarding the Cognos 8 securityenvironment?

  1. Cognos 8 must be configured to use only one authentication provider at a time

  2. Toperform authentication of users, a connection to the Cognos namespace must be defined

  3. In Framework Manager, object security is implemented by defining access toobjects for users, groups and roles defined in theauthentication providers

  4. In Framework Manager, object security is implemented by defining access toobjects for groups and roles (of which users are members), not individual users
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

What is true of a Framework Manager model of an operational database lacking a time dimension?

  1. Virtual star schema models require a time dimension for multi-fact queries.

  2. Report authors cannot create multi-fact, time-based queries.

  3. Time-based rollups for multi-fact queries may be difficult to handle.

  4. Report authors cannot create multi-fact, time-based queries unless using a union.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

Which of the following statements is correct regarding the implementation of object security in Framework Manager?

  1. Groups and roles can be createdin the Cognos namespace when specifying access to objects.

  2. Even when object security is applied, if anonymous access is configured, every objectin a Framework Manager project is visible toeveryone.

  3. A user belongs to two groups. One of the groups isdenied access to an object. The other group is grantedaccess to the object.The result is that user has access to the object.

  4. Grantingaccess toan object for one user, group orrole(except theEveryone and All Authenticated Users groups), implicitlydenies access to that object for all other users, groups or roles.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation