• databases Online Quiz - 2
Back
0

databases Online Quiz - 2

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

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

technology databases

  1. Sp_find

  2. select * from Sys.sysobjects

  3. select * from sys.dm_exec_objects

  4. Sp_helpobjects

Show answer
Correct Option: B

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

technology databases

  1. Analysis ,redo,undo

  2. Redo.Analysis ,undo

  3. Undo,analysis,Redo

  4. Analysis,Redo,Recovery

Show answer
Correct Option: A

How will you see logical reads for a query when executing it.

technology databases

  1. SET XMLSTATS IO ON

  2. SET STATISTICS TIME ON

  3. SET STATISTICS I/O ON

  4. SET STATISTICS IO ON

Show answer
Correct Option: D

How many clusterd index you can create on a table

technology databases

  1. 3

  2. Depends on senario

  3. 2

  4. 1

Show answer
Correct Option: D

What is the specific partitioning technique should be used for join stage?

technology databases

  1. auto

  2. hash

  3. entire

  4. same

Show answer
Correct Option: B

what are the client components in data stage 8.0?

technology databases

  1. administrator

  2. manager

  3. designer

  4. directror

Show answer
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)?

technology databases

  1. ENV

  2. $UNSET

  3. $PROJDEF

  4. None of the above

Show answer
Correct Option: C

Stages which run in sequential mode by default?

technology databases

  1. sequential file stage

  2. File set stage

  3. Lookup file set stage

  4. Row generator stage

Show answer
Correct Option: A,D

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

technology databases

  1. Constraints,Derivations,Stage variables

  2. Derivations,Constraints,Stage variables

  3. Stage variables,Derivations,Constraints

  4. Any of the above

Show answer
Correct Option: C

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

AI Explanation

To answer this question, you need to understand the concept of OLAP-style queries and how to perform them directly against a relational database using Framework Manager modeling techniques.

Option A) Create regular and measure dimensions and set scope. This option is correct because when authors want to perform OLAP-style queries directly against a relational database, they can create regular and measure dimensions and set the scope. By doing so, they can organize the data in a multidimensional way and perform aggregations and calculations on the data.

Option B) Create shortcuts to regular dimensions and fact query subjects. This option is incorrect because creating shortcuts to regular dimensions and fact query subjects is not specifically related to performing OLAP-style queries directly against a relational database. Shortcuts are used to create reusable objects in Framework Manager.

Option C) Create star schema groupings for dimension and fact query subjects. This option is incorrect because creating star schema groupings for dimension and fact query subjects is not specifically related to performing OLAP-style queries directly against a relational database. Star schema groupings are used to organize the data in a star schema structure.

Option D) Create relationships between regular dimensions and measure dimensions. This option is incorrect because creating relationships between regular dimensions and measure dimensions is not specifically related to performing OLAP-style queries directly against a relational database. Relationships are used to define the connections between different query subjects in Framework Manager.

The correct answer is A) Create regular and measure dimensions and set scope. This option is correct because it specifically addresses the modeling technique required to perform OLAP-style queries directly against a relational database.

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

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

technology databases

  1. Query items.

  2. Data sources.

  3. Relationships.

  4. Parameter maps.

Show answer
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
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions