C2020-635 - IBM Cognos 10 BI OLAP Developer Exam
Go back to IBM
What does unique mean when applied to a level in a dimension map?
No two categories in the level can be derived from the same source value.
Which of the following can be done to improve performance when dealing with large volumes of data?
Include multiple data sources.
The Region dimension is organized by Territory, Country, and City. Which option can be applied to only show data for the United States and its descendants?
When measures are calculated after rollup, when are the calculations performed?
After allocated measures are calculated.
A group called Authors is used in a custom view. How is information updated if the Author group members change in the authentication provider?
The changes are automatically updated at run time.
How can a developer define a specific view of the data and restrict access to it?
Set member-based security.
How can the parent-child relationship for each category be established?
Generate the categories.
For a cube that represents values in Euros, what should be done for American consumers to see the appropriate currency symbol in Euros?
Build Cubes using a system locale that matches the measure locale.
What does the developer specify when creating a test build that uses a subset of the source data?
The number of records.
Where can a developer change relationships to create a structure different from what the data suggests?
A Cognos 10 report with prompts is used as a data source. What must be done to create a second query that is based on the same report but provides different values for mandatory prompts?
Add the same report as another Transformer report data source.
To control access to content for users that have similar responsibilities and privileges,where should security be applied?
As a good practice, what can a developer do to be prepared in case a model develops conflicts or becomes corrupt?
Keep a backup .mdl file.
How can the cube build flexibility and performance be maximized?
Preprocess the data.
What can be done to apply member-based security if the model contains cube groups?
Define the security for each member cube.
When running simultaneous cube builds, how can cube build times be decreased?
Assign each Transformer process one CPU.
How does a developer associate a custom view with a PowerCube?
Drag the custom view to the appropriate Powercube.
The dimensions in the model include Product, Customer, and Order. If the Powercube should focus on the sales orders, how can the developer remove customer data?
Omit the dimension from the PowerCube.
Where should fact queries against OLAP sources come from?
A flat file
Which option decreases cube size by removing data from the cube?
How can a developer rebuild an incrementally updated cube?
Delete the old .mdc file and recreate the entire cube.
What can the developer specify for the cube build to use multiple directories to generate temporary work files?
Data temporary files
A developer created a cube for each regional Sales Manager. Each cube should contain only the transactional details for each Sales Manager's region, as well as the summarized values for other regions. What should be created?
When the model contains two data sources that provide date values, how can the developer avoid ambiguity when Transformer sets the current time period?
Disable the data source's ability to set the current time period.
At the beginning of the fiscal year, the Camping Equipment product line reduced the number of products that are being sold. What can be done to remove the inactive categories that are no longer needed in the model?
Set the level inclusion to suppress categories that are not needed.
What can a developer set up to analyze actual, planned, and forecasted budget information that do not rollup into a single root category?
How is the PowerCube updated once changes are made to a custom view?
The cube must be rebuilt.
Which of the following will help improve processing time when Transformer queries the data?
Separate structural and transactional information in multiple data sources.
What improves performance in the reporting application by combining records with identical non- measure values?
What could be done if the report does not run after the category codes change?
Modify the report to point to the updated member.
How can a cube be built with data volumes that result in a .mdc file larger than 2 GB?
Enable the creation of multiple local PowerCube files.
A developer notices that tildes (~) exist in the category codes. What can be done to avoid unstable MUN values?
Resolve the non-unique keys within a dimension in the data source.
What objects can be created within the Cognos Namespace?
Groups and roles
Transformer is unable to locate one of the source files for a data source in the model, and the model update fails. Which type of files can be used to restart the processing at the point of failure?
Senior Managers need to see total and regional sales figures, but Regional Managers should see relevant figures for only their regions. Where can the developer specify the degree of detail to be included?
In a cube group
What can be applied to a category if only the parent and child categories are required?
What does a unique move ensure when applied to a level in a dimension map?
The category moved within the level has its data history moved with it.
What can be done in a manual level to keep new data separate until it can be connected to the appropriate parent category?
Create an orphanage category.
A developer added a manual level in the time dimension. During category generation, the developer gets a warning that Transformer is not able to relate the categories to the parent levels. What must be done to ensure Transformer relates the categories correctly?
Specify a date function for each level.
If a cube group based on a level in a dimension is created, how can the developer prevent another cube from being added to the cube group?
Prevent the automatic creation of categories.
A dimension organizes all the regions by Country and City. Disregarding the hierarchical organization, how can the five best performing regions be grouped?
Add a special category.
The time dimension contains levels for year, quarter, and month. How can the month levels in 2008 be retained while removing them from 2007?
Create a subdimension.
To add dimensional data to an existing model, how can metadata be leveraged from other published OLAP packages?
Add dimensions from an OLAP package in the dimension map.
When can Transformer category codes change?
When a Clean House is performed before a cube is rebuilt.
What should a developer do if some levels appear red after validating the model using Show Scope?
Specify a valid relationship between the level and the data source.
What must be done to make the cube data available in Analysis Studio?
Publish the PowerCube as a data source and a package.
Where are the log files accessed to troubleshoot issues?
In the path set in Transformer preferences.
The model contains a measure named Quantity, and the OLAP reports need to show the Minimum monthly quantity sold to each store. How would a developer get the correct result?
Use a Regular rollup function.
Columns have been renamed in the data source. Which command must the developer run to update the model?
What modeling factor affects the auto-partitioning strategy and causes poor consolidation for partitioned categories?
Wide, flat dimensions