Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-632

IBM C2090-632 Exam Practice Questions (P. 3)

  • Full Access (53 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
Which of the following is true applying object security in Framework Manager?
  1. A
    If beginning to apply security by specifying object security on an object with no children, all other objects remain accessible to all users.
  2. B
    If beginning to apply security by specifying object security on an object with no children, all other objects will not be accessible to all users.
  3. C
    Allows overrides Deny if specified in the properties of the object.
  4. D
    Child objects only inherit security from their parent if the Inherit property is set to YES.

Correct Answer:
B
References:
http://www.sis-elearning.com.mx/Descargables/Cursos_Invitacion/Cognos8/Metadata_Modeling/B2452_IG_Vol_2.pdf
Page: 14-28

Question #12
In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?
  1. A
    Create stand-alone filters.
  2. B
    Add performance indicators to functions.
  3. C
    Configure data sources in a project pointing to the same instance to use the same connection.
  4. D
    For a query item having an integer data type, set the Display Item Reference property to display an integer value.

Correct Answer:
C

Question #13
Which of the following components does a basic Cognos 10 stitch query consist of?
  1. A
    SC() function, full outer join, multiply queries that each query exclusive information.
  2. B
    SC() function, full outer join, multiple queries that query of the same information.
  3. C
    Coalesce function, full outer join, multiple queries that each query exclusive information.
  4. D
    Coalesce function, full outer join, multiple queries that query some of the same information.

Correct Answer:
D
References:
http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page605.html

Question #14
Which of the following data structures typically contain normalized data?
  1. A
    Cude
  2. B
    Relational
  3. C
    Operational
  4. D
    Data Warehouse

Correct Answer:
C
Operational = OLTP -
References:
http://www.ibm.com/support/knowledgecenter/SSTQPQ_7.5.0/com.ibm.swg.im.cognos.impdeploy.7.5.0.doc/impdeploy_id431ComparingOLTPSystemswith.html

Question #15
In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?
  1. A
    Import the stored procedure, add it as a model calculation, and when publish it as part of a package.
  2. B
    Import the stored procedure, provide values that satisfy the procedure’s arguments, retrieve a projection list then publish it as part of a package.
  3. C
    Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of package.
  4. D
    Import the stored procedure, set the type to Data Modification, provide values that satisfy the procedure’s arguments, retrieve a projection list and then publish

Correct Answer:
B

Previous Questions Next Questions

All Pages