Which of the following is a common mistake made by designers when creating dimensionmodels?
A. Including alternatehierarchies.
B. Including multiple date/timehierarchies.
C. Splitting a single dimension into multiple dimensions.
D. Adding dimensions and measures from other subject areas.
A consultant realizes after determining business requirements, that a complete solution willrequire several related but separate projects. The consultant must choose one project to deliverfirst. Which of the following describes the considerations that should govern that choice?
A. Priority of IT, ease of development, resource availability, and data availability
B. Business impact, ease of development, resource availability, and number of target users
C. Data availability, ease of development, resource availability, and position of project sponsor inthe organization
D. Business impact, data availability, ease of development, and resource availability
Which of the following describes common methods for enriching an initial dimension map?
A. Add exception and range band dimensions and include additional metrics and calculations.
B. Merge dimensions and include additional metrics and calculations.
C. Include additional metrics and calculations and core metrics and dimensions from relatedbusiness areas.
D. Include additional metrics, calculations, and hierarchy levels, and dimensions from relatedsubject areas.
A user makes the following request:"I need to see the number of flights throughout the year thatarrived or departed more than 15 minutes early or late by origin and destination airport, by carrier,and by time of day. I want to see if the number of flights delayed is greater for large carriers orsmall carriers."This request requires clarification to make the user's intention clear.
Which of thefollowing will NOT further clarify the user's request?
A. Determine if origin and destination airports should be considered joined pairs (for example,from DFW to ORD) or as separate dimensions.
B. Determine if 15 minutes is the only significant grouping of late or early departures or arrivals.
C. Determine the definition of a large and small carrier.
D. Determine if Date and Time of Day should be split into separate dimensions.
Which of the following statements best describes the Iterative Approach of applicationdevelopment?
A. A prototype solution is developed after the initial user interviews. This prototype is then usedas a basis for refining specific design requirements.
B. The design step is repeated multiple times before proceeding to the development step. Eachpass through the design step further refines the eventual solution.
C. The solution is developed and delivered to the users. After approximately 2 weeks, the usersare interviewed for any missing requirements and any new requirements form the basis for thenext iteration.
D. A prototype is created that addresses 80 to 90% of the business requirements. This isdemonstrated to the users and their feedback is used to refine the prototype in subsequentiterations.
All of the following are considered part of the analyze phase of a BI development project EXCEPT:
A. Conduct a readiness assessment
B. Analyze solution scope
C. Determine detailed requirements
D. Create a logical data model
When a user requests a certain piece of information, the interviewer may ask what the user woulddo with that information. From the techniques described in the BI Professional Workshop, why isthe interviewer asking this particular question?
A. To determine if the user is allowed access to that particular information and therefore shouldnot be included in his subject area.
B. To determine if the user understands how the information is functionally used within theorganization.
C. To determine if the information is a security concern and should therefore be made unavailableto other users.
D. To determine if the information is an actionable item for the user and therefore part of abusiness requirement.
A user makes the following request:"I need to see actual sales compared with projected sales,and margin range for branches within each division, by product line, sales rep by sales manager,and cost center over time."
Which of the following is a dimension identified by the request?
A. Cost
B. Margin Range
C. Actual / Projected
D. Sales Range
You are tasked with administering theCognos BIsystem to perform batch reporting in a waythat maximizes the use of available system resources. Given the following information, how manyjobs should be created to perform this task?
480 reports must run
6 report processes are available
Each process is configured to use 4 low affinity connections
A. 20
B. 24
C. 48
D. 12
Which service is required when a user views saved report output?
A. presentation service
B. report data service
C. report service
D. batch report service
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.