Which of the following must be moved manually instead of as part of a Cognos 8 deploymentpackage?
A. report output versions
B. run history
C. schedules
D. system.xml
A developer has specified a maximum of two report processes for the application. Whilemonitoring the application, the developer notices that only one report process is running.
Which ofthe following would account for this?
A. The number of affinity connections per BI Bus is set too high.
B. The configuration size for the application is set too low.
C. The number of low affinity connections has been exceeded.
D. The number of report requests is too high.
What is the recommended configuration size for Cognos 8 on a Windows 2003 Serverenvironment, and why?
A. Small or medium because Cognos 8 can only allocate 2 GB of memory per process.
B. Small because Java consumes half of the 2GB of RAM that can be allocated per process.
C. Small or medium because Cognos 8 can take advantage of the switch that allows 3GB of RAMper process.
D. Medium or large because Windows 2003 can allocate up to 4 GB of RAM per process.
In the Key Performance Indicator (KPI) process flow diagram shown below, which Cognos 8components are normally associated with the 'Source Information' step?
A. Enterprise Planning and Data Manager
B. Enterprise Planning and Report Studio
C. Analysis Studio and Metric Studio
D. Analysis Studio and Data Manager
When comparing two differently grained facts directly against one another, the developer must:
A. either write a union query or two reports that roll both facts up to a common level
B. either roll up the lower grained fact to the higher level or allocate the higher grained fact to thelower level
C. declare determinants at multiple levels in the dimensions of a DMR Framework Managermodel
D. ensure that all conformed dimensions shared by the facts have the same number of levels
Which of the following is true regarding hierarchies and dimensions?
A. Hierarchies help users understand the data through rollup levels within dimensions.
B. All dimensions must have hierarchies.
C. All hierarchies are defined by the inherent nature of their dimensional data.
D. It is considered poor design to split a hierarchy across multiple dimensions.
When examining an operational (transactional) database, which of the following is considered agood indicator as to which tables contain fact data?
A. Tables with the fewest number of columns
B. Tables with the greatest number of rows
C. Tables with the greatest number of foreign keys
D. Tables with the fewest number of foreign keys
Which of the following describes the models contained in the '24 Ways' book referenced in the BIProfessional Workshop course?
A. Framework Manager models that map over an example normalized database, which one mightfind in a manufacturing enterprise.
B. Physical, star schema data models for constructing data marts for the various departments in ageneric business enterprise.
C. Logical models that contain dimensions and key tactical metrics for the various departments ina generic business enterprise.
D. Cognos 8 OLAP Modeler (Transformer) models that describe how to map data from amanufacturing database into a PowerCube.
How are Key Performance Indicators (KPIs) tracked?
A. By aligning them to strategic and tactical goals and the business objectives of the enterprise.
B. By comparing them against other KPIs in a balanced scorecard.
C. By examining anomalies that appear in BI reporting and analysis.
D. By comparing their values to acceptable minimum and maximum levels of performanceagainst a target.
Which of the following is a key difference between MDX and SQL?
A. MDX is used for dimensional style reporting while SQL is incapable of dimensional stylereporting.
B. MDX has built in functions to support relative date calculations while SQL cannot performrelative date calculations.
C. Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL.
D. MDX can reference metadata that SQL cannot.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-180 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.