Modeling with Data Modules

What is the primary purpose of data modeling in Cognos Analytics?

a.) To create machine learning models

b.) To automate data entry processes

c.) To present a user-friendly representation of data and add business value

d.) To visualize complex data structures

c

How are numeric style data groups created?

a.) By default for text columns

b.) By ranges of numeric values

c.) By individual values

d.) By using pre-saved templates

b

How can a user add a selectable filter to a data module?

a.) By using the Actions menu

b.) By applying the filter automatically

c.) By using SQL scripting

d.) By saving it directly in the Properties pane

a

What is the default grouping style for text columns?

a.) Grouped by alphabetical order

b.) Grouped by individual values

c.) Grouped by hierarchy

d.) Grouped by ranges

b

What does the “Calculate after aggregation” checkbox enable?

a.) Saving the calculation as embedded

b.) Applying filters selectively

c.) Combining multiple filters

d.) Performing calculations post-aggregation

d

Which join type returns rows where the product code is the same on both tables?

a.) Right Outer Join

b.) Full Outer Join

c.) Inner Join

d.) Left Outer Join

c

What is required for two tables to use a Union in a custom table?

a.) Matching column names only

b.) Matching table names

c.) Identical data in all columns

d.) Same number of columns in the same order and compatible data types

d

What is a requirement for relinking a Data Module to a new source?

a.) The new source must match the original source type

b.) The new source must contain only tables

c.) The new source must be in the Team Content folder

d.) The new source must be an uploaded file

a

Which type of filter is applied automatically when the data module is used?

a.) Range Filter

b.) Manual Filter

c.) Embedded Filter

d.) Selectable Filter

c

What is the key benefit of including calculations in a data module?

a.) To ensure consistency and reuse

b.) To improve visualizations

c.) To enhance database security

d.) To reduce data loading time

a

What happens during source relinking in a Data Module?

a.) The filters are reset automatically

b.) The module is saved as a new version

c.) The data module validates and identifies issues

d.) The source type changes automatically

c

How do embedded calculations differ from stand-alone calculations?

a.) Embedded calculations reference only their table

b.) Stand-alone calculations are table-specific

c.) Embedded calculations are global

d.) Stand-alone calculations reside in a table

a

What does cardinality help with in relationships?

a.) Increasing the number of queries

b.) Renaming fields

c.) Avoiding double-counting fact data

d.) Automatically filtering unnecessary data

c

What is a Navigation Path in Cognos Analytics?

a.) A predefined filter applied to measures

b.) A collection of columns representing a hierarchy

c.) A collection of measures representing hierarchies

d.) A custom calculation combining two columns

b

Which panel displays the selected tables and relationships in a Data Module?

a.) Source Panel

b.) Properties Panel

c.) Data Module Panel

d.) Main Canvas

c

What is caching option available at the table level in Cognos Analytics?

a.) Cache all queries indefinitely

b.) Data cache settings in properties pane

c.) Cache to browser only

d.) Cache by default

b

What is a Data Module in Cognos Analytics designed for?

a.) Generating automated reports without manual input

b.) Allowing web-based, self-service data modeling capabilities

c.) Publishing metadata models to a local server

d.) Creating physical databases schemas

b

What is the purpose of hiding columns in a data module?

a.) To simplify the structure for users

b.) To create a duplicate table

c.) To improve dashboard loading speed

d.) To delete them permanently

a

Which of the following is a feature of Dynamic Cubes in Cognos Analytics?

a.) .csv

b.) .pdf

c.) .txt

d.) .xlsx

b

What is the first step to create a Data Module in Cognos Analytics?

a.) Navigate to the “Reports” section

b.) Use the “Create Module” wizard

c.) Open the “Admin Panel”

d.) Select “Prepare Data” on the landing page

d

Which step is NOT part of the data modeling workflow in Cognos Analytics?

a.) Testing the data module in Cognos Analytics Reporting

b.) Enhancing the module with calculations and filters

c.) Identifying the data sources

d.) Training machine learning algorithms

d

Where must a Data Module be placed to share it with others?

a.) A shared workspace

b.) My Content folder

c.) Team Content folder

d.) Any public folder

c

What does AI use to suggest related tables in Data Modules?

a.) Table Names

b.) Keywords

c.) Schema definitions

d.) Search history

b

What happens when you break links to tables in a Data Module?

a.) Changes in the source data are inherited

b.) The module becomes read-only

c.) Changes in the source data are not inherited

d.) The module is deleted

c

Which of the following is a feature of Dynamic Cubes in Cognos Analytics?

a.) Built-in browser support for dashboards

b.) Web-based self-service data modeling

c.) Real-time machine learning integration

d.) In-memory cube technology for OLAP structures

d

What is required for data grouping to be available in a column?

a.) Data type must be numeric or string

b.) Aggregate must be set to None

c.) The column must be calculated

d.) Both A and B

d

What must be ensured before applying a security filter to a Data Module?

a.) The data server is connected to the internet

b.) Schema is loaded and you have write permissions

c.) The module is saved to My content

d.) The data module is shared globally

b

How do you add fields to a Navigation Path?

a.) Apply a filter and set the path manually

b.) Drag fields into the Navigation Path window

c.) Group fields and select Save Navigation Path

d.) Right-click on the column and select Add

b

How can filters be added for multiple columns at one time?

a.) By applying filters sequentially

b.) By using the Expression Editor

c.) By overriding parent permissions

d.) By using the Actions menu

b

What is the primary purpose of relationships in Cognos Analytics?

a.) To create database indexes

b.) To add new columns to a table

c.) To delete unused data

d.) To define how tables are connected

d

Which property defines how fields are summarized in reports?

a.) Usage Property

b.) Expression

c.) Data Type

d.) Aggregate Property

d

What is a Data Module in Cognos Analytics designed for?

a.) Publishing metadata models to a local server

b.) Generating automated reports without manual input

c.) Allowing web-based, self-service data modeling capabilities

d.) Creating physical database schemas

c

Which SQL type is vendor-specific and must reference only one data source?

a.) Pass-through SQL

b.) Derived SQL

c.) Cognos SQL

d.) Native SQL

a

How can you review or edit a relationship in Cognos Analytics?

a.) Delete and recreate the relationship

b.) Use the Properties tab in the Data Module

c.) Export the data module for external editing

d.) Double-click on the relationship in the diagram

d

What does a Full Outer Join return?

a.) Rows only where the product code matches

b.) All rows from the right table

c.) All rows from the left table

d.) All rows from both tables

d