Tag: databases

Questions Related to databases

What are the join stages available in lookup stage?
technology databases

  1. LeftOuter Join,Right Outer Join,Inner join

  2. Outer Join,Inner Join

  3. Left Outer Join,Inner Join

  4. Left Outer Join,Right Outer Join

Show answer
Correct Option: C

How do you ensure re start ability of jobs within a sequencer.What options need to be checked for this?

technology databases

  1. Automatically handle activities that fail

  2. Add checkpoints so sequence is restartable on failure

  3. Log warnings after activities that finish with status other than ok

  4. Log report messages after each job run

Show answer
Correct Option: B

What is the order of execution of constraints,derivation and stage variables in a transformer stage?
technology databases

  1. Derivations,Stage variables,Constraints

  2. Stage variables,Constraints,Derivations

  3. Constraints,Stage variables,Derivations

  4. Constraints,Derivations,Stage variables

Show answer
Correct Option: B

Which of the following techniques can be usedto improve performance of PowerCubes in Cognos 8 BI?

technology databases

  1. Run the cube through the pcoptimizer utility that is shipped with Cognos 8 BI.

  2. Enable the Allow dynamic usage of dimension information governor in Framework Manager.

  3. Edit the EnablePCOptimizer entry in the Cognos.ini file so that its value=1, and then rebuild the cube.

  4. Ensure that the Pass-through SQL setting is enabled onall regular dimensions in the Framework

Show answer
Correct Option: A
Explanation:

To answer this question, the user needs to have knowledge about Cognos 8 BI and the techniques that can be used to improve the performance of PowerCubes.

Option A: Run the cube through the pcoptimizer utility that is shipped with Cognos 8 BI. This option is correct. The pcoptimizer utility is used to optimize the performance of PowerCubes. It can be run on the cube to improve query response times and reduce the cube size.

Option B: Enable the Allow dynamic usage of dimension information governor in Framework Manager. This option is incorrect. The Allow dynamic usage of dimension information governor controls how much of the dimension information is loaded into memory. It does not directly improve the performance of PowerCubes.

Option C: Edit the EnablePCOptimizer entry in the Cognos.ini file so that its value=1, and then rebuild the cube. This option is incorrect. The EnablePCOptimizer entry in the Cognos.ini file is used to enable or disable the PowerCube optimizer. Enabling it alone will not improve the performance of PowerCubes. The cube needs to be rebuilt after making the change to the Cognos.ini file.

Option D: Ensure that the Pass-through SQL setting is enabled on all regular dimensions in the Framework. This option is incorrect. The Pass-through SQL setting is used to pass SQL statements directly to the database. It is not directly related to improving the performance of PowerCubes.

Therefore, the correct answer is:

The Answer is: A. Run the cube through the pcoptimizer utility that is shipped with Cognos 8 BI.

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

  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.

Show answer
Correct Option: D

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

technology databases

  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.

Show answer
Correct Option: D

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

  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.

Show answer
Correct Option: A

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

  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

Show answer
Correct Option: C

Which of the following utilities can be used to update PowerCubes withoutaffecting users?
technology databases

  1. BMTScriptPlayer.exe

  2. pcaccel.exe

  3. CubeSwap.bat

  4. RSUpgrade.bat

Show answer
Correct Option: C

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

  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.

Show answer
Correct Option: C