VendorsExamsEnterprise
Support
Request an ExamContact UsFAQ

IBM Cognos 10 BI Metadata Model Developer Free Sample Questions

20 free sample questions207 in the full practice test

Try simulator

C2090-632 Sample Questions

  1. Question 1

    A retail company's reporting performance is degrading due to a complex snowflake schema for its product dimension, which involves four separate tables (Product, Sub-Category, Category, Department). Report authors find it difficult to navigate and joins are inefficient. As the metadata modeler, what is the most effective approach in Framework Manager to resolve this for business users?

    Answer and explanation

    Correct answer: B

    Creating a model query subject to consolidate the snowflake schema into a single, denormalized dimension is the best practice. This simplifies the model for report authors, improves query performance by pre-defining the joins, and makes the business view more intuitive.

  2. Question 2

    A data modeler observes that a report showing Sales Revenue by Salesperson and Branch is producing inflated revenue figures. The model joins Salespersons to a Sales Fact table and also joins Salespersons to a Branch dimension. Each Branch has multiple salespersons, and each salesperson can have multiple sales. This structure represents a classic fan trap. Which is the most appropriate method to resolve this trap within Framework Manager?

    Answer and explanation

    Correct answer: C

    A fan trap occurs when a one-to-many join links to another one-to-many join from the central table. The correct way to resolve this is to create query subjects that isolate the join paths. Cognos can generate a stitched query to correctly bring the data together. Often, creating a shortcut to the relationship or creating separate query subjects for different contexts is the standard solution.

  3. Question 3

    Multiple answers

    A BI architect is designing a new Framework Manager project that will source data from two distinct systems: a corporate Oracle data warehouse for sales information and a departmental SQL Server database for marketing campaign data. To ensure model clarity, maintainability, and security, which of the following are considered best practices for organizing the project? (Select TWO)

    Answer and explanation

    Correct answers: B, C

    Isolating metadata from each data source into its own namespace is a fundamental best practice. It prevents naming conflicts, clarifies data lineage, and simplifies maintenance.

    A layered modeling approach involves creating a separate namespace for the business view. This abstraction layer uses shortcuts to the physical namespaces, providing a stable and user-friendly interface for report authors that is insulated from changes in the underlying sources.

  4. Question 4

    A healthcare provider needs to build a Framework Manager model for analyzing patient outcomes. The security requirements are stringent and complex, based on a user's role and their assigned medical facilities.

    Data Structure:

    • A PatientEncounters fact table contains sensitive patient data and a FacilityID.
    • A Doctors dimension table includes DoctorID and DoctorName.
    • A security table named DoctorFacilityAccess maps DoctorID to the multiple FacilityIDs they are authorized to access.

    Security Requirements:

    1. A logged-in user, who is a doctor, should only see patient data for the facilities they are assigned to in the DoctorFacilityAccess table.
    2. The user's DoctorID is available via a session parameter loggedInDoctorID populated from the authentication source.
    3. The solution must be scalable and avoid hard-coding values. It should be applied centrally to a security group named DoctorGroup.

    Which of the following represents the most robust and maintainable implementation of this row-level security requirement?

    Answer and explanation

    Correct answer: B

    This is the correct approach. By applying the filter to the security table DoctorFacilityAccess, you restrict its contents to only the facilities associated with the logged-in doctor. Because this table is joined to the fact table (likely through a facility dimension), the filter propagates through the model, correctly securing the PatientEncounters data. Applying the filter to the security mapping table itself is the most efficient and maintainable design.

    graph TD subgraph SecurityContext User[User Login] --> SessionParam["#loggedInDoctorID#"]; end subgraph Model subgraph SecurityFilter [Filter applied to DoctorGroup] SessionParam -->|Filters| DoctorFacilityAccess[DoctorFacilityAccess Table]; end DoctorFacilityAccess -->|Joins to| FacilityDim[Facility Dimension]; FacilityDim -->|Joins to| PatientEncounters[PatientEncounters Fact]; end PatientEncounters --> Report[Secured Report Data];

  5. Question 5

    True or False: In Framework Manager, changing a query item's 'Usage' property from 'Attribute' to 'Fact' will automatically change its 'Regular Aggregate' property to 'Sum'.

    Answer and explanation

    Correct answer: A

    This is true. Framework Manager provides this behavior as a convenience for modelers. When it detects that a numeric data item is being reclassified as a Fact, it assumes the most common aggregation function, Sum, should be applied. The modeler can then change it to another function like Average or Count if needed.

  6. Question 6

    A model contains a time dimension with keys for Day, Month, and Year. This dimension joins to a Sales fact table with a Day_Key and a Sales Forecast fact table with a Month_Key. Without proper configuration, queries combining sales and forecast data will cause the monthly forecast values to be repeated for every day of the month, leading to incorrect summaries. Which feature must be configured on the time dimension query subject to prevent this?

    Answer and explanation

    Correct answer: C

    Determinants are used to describe the levels of granularity within a dimension. By defining a determinant for the Month level (uniquely identified by Month_Key) and another for the Day level (uniquely identified by Day_Key), you inform the Cognos query engine about the data's structure. When a query involves the Month-level forecast fact, Cognos will aggregate correctly at the month level and will not incorrectly multiply the forecast values across all days.

  7. Question 7

    A report that joins the 'Customer' and 'Sales' query subjects is unexpectedly generating a cross-product (Cartesian join) instead of the expected inner join, causing extremely long query times and incorrect results. What is the most likely cause of this issue within the Framework Manager model?

    Answer and explanation

    Correct answer: B

    The Cognos query engine generates a cross-product when it cannot find a valid join path between the tables included in a query. This is most commonly caused by a missing or incorrectly defined relationship between the relevant query subjects. Without a defined join on a common key (e.g., Customer_ID), the engine has no choice but to join every row from the first table to every row in the second.

    graph LR subgraph "Problem State" Customer[Customer QS] -- "No Relationship" -- Sales[Sales QS] Customer --> CrossJoin((Cross Product)) Sales --> CrossJoin end subgraph "Correct State" Customer_Correct[Customer QS] -- "1..n on Customer_ID" --- Sales_Correct[Sales QS] Customer_Correct --> InnerJoin((Inner Join)) Sales_Correct --> InnerJoin end

  8. Question 8

    Multiple answers

    A BI team needs to implement dynamic filtering based on a user's region and also support multi-lingual report titles. For example, a filter should be [Region] = 'USA' for one user, and a report title should be 'Sales Report' for English users and 'Rapport des Ventes' for French users. Which Framework Manager features are best suited to manage these lists of values centrally? (Select TWO)

    Answer and explanation

    Correct answers: B, E

    Parameter maps are key-value pairs stored within the model. They are ideal for managing static lists of values, such as translations for report titles or mapping codes to descriptive names. The session parameter for language can be used as the key to look up the correct title.

    Session parameters hold values that are specific to a user's session, such as user name, account information, or preferred language. They are perfect for driving dynamic behavior like security filters, where the user's region can be passed from the authentication source and used in a macro.

  9. Question 9

    A logistics company is modeling shipment data. The model contains a Shipments fact table (at the package level) and dimension tables for Origin Port and Destination Port. Analysts need to report on the number of shipments between any two ports. However, the Origin Port and Destination Port dimensions are structurally identical, based on the same Ports database table. This is a classic role-playing dimension scenario. What is the recommended modeling technique in Framework Manager to handle this?

    Answer and explanation

    Correct answer: C

    This is the standard and most efficient method for handling role-playing dimensions. A single query subject for 'Ports' is maintained. Shortcuts (which act as aliases) are then created for each 'role' (Origin and Destination). This allows for unambiguous join paths to the fact table while maintaining a single point of definition for the port dimension, simplifying maintenance.

  10. Question 10

    What is the primary advantage of creating a stand-alone calculation in Framework Manager's business view, as opposed to embedding the calculation logic directly within a model query subject?

    Answer and explanation

    Correct answer: B

    Stand-alone calculations can reference query items from any query subject that has a relationship path to the others used in the expression. This allows for the creation of complex business logic (like profit margin, which needs revenue and cost from different subjects) that spans multiple tables. Embedded calculations are limited to items within the same query subject.

Register free to unlock 10 more sample questions

Lifetime One

Own this practice test forever.

$79.99
$75.99
one-time
  • Full access to 207 questions
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • Brainy AI Assistant
  • Lifetime updates

Two

Any 2 exams per month.

$20.00/exam
$39.99
/month
  • 2 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 1,000 Brainy AI Credits
  • Cancel anytime
Popular

Pro Four

Any 4 exams per month.

$17.50/exam
$69.99
/month
  • 4 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 5,000 Brainy AI Credits
  • Dedicated support

Premium Twelve

Any 12 exams over 3 months.

$15.00/exam
$179.99
/3 months
  • 4 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 15,000 Brainy AI Credits
  • Dedicated support
  • Friend seat included — full access

Trusted by professionals at

NvidiaSupabaseGitHubOpenAITursoClerkClaude AIAmazon