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

What are three steps of data recovery when database goes in recovery mode.

  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 is the specific partitioning technique should be used for join stage?

  1. auto

  2. hash

  3. entire

  4. same


Correct Option: B

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
  1. sequential file stage

  2. File set stage

  3. Lookup file set stage

  4. Row generator stage


Correct Option: A,D

What is the order of execution of constraints,derivation.Stage variables in a transformer stage?

  1. Constraints,Derivations,Stage variables

  2. Derivations,Constraints,Stage variables

  3. Stage variables,Derivations,Constraints

  4. Any of the above


Correct Option: C

What are the join stages available in lookup stage?

  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

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

  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

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.


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

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

  1. BMTScriptPlayer.exe

  2. pcaccel.exe

  3. CubeSwap.bat

  4. RSUpgrade.bat


Correct Option: C

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.


Correct Option: C

The groups and roles defined in the Cognos namespace can be used to assign access rights to which of thefollowing Framework Manager objects?

  1. Query items.

  2. Data sources.

  3. Relationships.

  4. Parameter maps.


Correct Option: A

AI Explanation

To answer this question, you need to understand the concept of groups and roles in Cognos and how they can be used to assign access rights to different objects in Framework Manager.

Option A) Query items - This option is correct because groups and roles can be used to assign access rights to query items in Framework Manager. Query items are used to define the data items that can be included in queries and reports.

Option B) Data sources - This option is incorrect because groups and roles are not used to assign access rights to data sources in Framework Manager. Access to data sources is typically managed at the database or data connection level.

Option C) Relationships - This option is incorrect because groups and roles are not used to assign access rights to relationships in Framework Manager. Relationships define how different data items are related to each other and do not have individual access rights.

Option D) Parameter maps - This option is incorrect because groups and roles are not used to assign access rights to parameter maps in Framework Manager. Parameter maps are used to define mapping between query parameters and parameter values and do not have individual access rights.

The correct answer is A) Query items. This option is correct because groups and roles can be used to assign access rights to query items in Framework Manager, allowing or restricting users' ability to view or use specific query items in their reports or queries.

- Hide questions