0

databases Online Quiz - 2

Description: databases Online Quiz - 2
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

How to find out no. of objects in a database.

  1. Sp_find

  2. select * from Sys.sysobjects

  3. select * from sys.dm_exec_objects

  4. Sp_helpobjects


Correct Option: B
  1. Analysis ,redo,undo

  2. Redo.Analysis ,undo

  3. Undo,analysis,Redo

  4. Analysis,Redo,Recovery


Correct Option: A
  1. SET XMLSTATS IO ON

  2. SET STATISTICS TIME ON

  3. SET STATISTICS I/O ON

  4. SET STATISTICS IO ON


Correct Option: D

How many clusterd index you can create on a table

  1. 3

  2. Depends on senario

  3. 2

  4. 1


Correct Option: D

what are the client components in data stage 8.0?

  1. administrator

  2. manager

  3. designer

  4. directror


Correct Option: A,C,D

what is to be entered to ensure that env variables need not be edited in the jobs when code moves from one env to other(dev to test)?

  1. ENV

  2. $UNSET

  3. $PROJDEF

  4. None of the above


Correct Option: C

Stages which run in sequential mode by default?

  1. sequential file stage

  2. File set stage

  3. Lookup file set stage

  4. Row generator stage


Correct Option: A,D
  1. Constraints,Derivations,Stage variables

  2. Derivations,Constraints,Stage variables

  3. Stage variables,Derivations,Constraints

  4. Any of the above


Correct Option: C
  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


Correct Option: C

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

  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


Correct Option: B
  1. Derivations,Stage variables,Constraints

  2. Stage variables,Constraints,Derivations

  3. Constraints,Stage variables,Derivations

  4. Constraints,Derivations,Stage variables


Correct Option: B
  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


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.

  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.


Correct Option: D
  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.


Correct Option: D
  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.


Correct Option: A

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


Correct Option: C
  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.


Correct Option: C
- Hide questions