C2020-635 - IBM Cognos 10 BI OLAP Developer Exam

Go back to IBM

Example Questions

What does unique mean when applied to a level in a dimension map? Which of the following can be done to improve performance when dealing with large volumes of data? 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? A group called Authors is used in a custom view. How is information updated if the Author group members change in the authentication provider? How can a developer define a specific view of the data and restrict access to it? How can the parent-child relationship for each category be established? For a cube that represents values in Euros, what should be done for American consumers to see the appropriate currency symbol in Euros? What does the developer specify when creating a test build that uses a subset of the source data? 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? 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? How can the cube build flexibility and performance be maximized? What can be done to apply member-based security if the model contains cube groups? When running simultaneous cube builds, how can cube build times be decreased? How does a developer associate a custom view with a 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? Where should fact queries against OLAP sources come from? Which option decreases cube size by removing data from the cube? How can a developer rebuild an incrementally updated cube? What can the developer specify for the cube build to use multiple directories to generate temporary work 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? 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? 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? Which of the following will help improve processing time when Transformer queries the data? 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? How can a cube be built with data volumes that result in a .mdc file larger than 2 GB? A developer notices that tildes (~) exist in the category codes. What can be done to avoid unstable MUN values? What objects can be created within the Cognos Namespace? 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? 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? What can be done in a manual level to keep new data separate until it can be connected to the appropriate parent 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? 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? A dimension organizes all the regions by Country and City. Disregarding the hierarchical organization, how can the five best performing regions be grouped? The time dimension contains levels for year, quarter, and month. How can the month levels in 2008 be retained while removing them from 2007? To add dimensional data to an existing model, how can metadata be leveraged from other published OLAP packages? When can Transformer category codes change? What should a developer do if some levels appear red after validating the model using Show Scope? What must be done to make the cube data available in Analysis Studio? Where are the log files accessed to troubleshoot issues? 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? 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?