A multi-server installation of Cognos BI must be performed. Which of the following is a valid strategy for installing across multiple servers?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is a critical component in delivering Corporate Performance Management throughout an enterprise?
Exam C2090-180 - admin post to:2017-07-20 read more

A company has several operational data stores. They wish to compare data from the various data stores against one another. The data in the various stores must be manipulated to match. Eventual report performance is more important than development time. Which of the following Cognos 8 components would BEST address their requirements?
Exam C2090-180 - admin post to:2017-07-20 read more

Why should an application's performance be monitored on an ongoing basis after it goes into production?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes common methods for enriching an initial dimension map?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes a disadvantage of using the dimensionally modeled relational (DMR) technique to access a normalized data structure?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is a key difference between MDX and SQL?
Exam C2090-180 - admin post to:2017-07-20 read more

A table is in Third Normal Form if it is already in Second Normal Form, plus:
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following BEST describes the relationship or differences between Iterative Approach and Cognos SIM?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is a valid strategy for addressing failover for the content store?
Exam C2090-180 - admin post to:2017-07-20 read more

Using the diagram below to install and configure Cognos BI, which of the following components will NOT address automatic failover?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes the major steps in the deployment process for a Cognos BI application and their proper order?
Exam C2090-180 - admin post to:2017-07-20 read more

A company records when customers check into a service center. If there are too many customers waiting for the number of service representatives on hand, a manager wishes to be notified by an e-mail that contains a report showing the current condition. Which of the following Cognos 8 Components would BEST address their needs?
Exam C2090-180 - admin post to:2017-07-20 read more

When following the Information Focused approach, what should the users bring to the initial interview?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is a significant cause of failure when using the technology-focused approach to BI Application development?
Exam C2090-180 - admin post to:2017-07-20 read more

When considering the differences between Analysis, Reporting, and Querying, which of the following is NOT a user who needs Analysis?
Exam C2090-180 - admin post to:2017-07-20 read more

When comparing two differently grained facts directly against one another, the developer must:
Exam C2090-180 - admin post to:2017-07-20 read more

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." Based on the user's request, Actual Sales and Projected Sales have been identified as required measures. Which of the following other measures would be included in an initial dimension map?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following allows greatest flexibility in formatting but generally has the lowest interactivity with the users?
Exam C2090-180 - admin post to:2017-07-20 read more

Which combination of Cognos 8 components is considered the BEST fit for addressing the needs of company executives?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is the recommended method of implementing a regular backup plan for a BI Application?
Exam C2090-180 - admin post to:2017-07-20 read more

While Cognos BI will support any data warehouse design, which of the following designs does Cognos recommend for new warehouse development?
Exam C2090-180 - admin post to:2017-07-20 read more

A user makes the following request:"I need to see the number of flights throughout the year that arrived 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 or small carriers."Based on this request, the following metrics have been identified: Flight count, and minutes early or late. Large carriers operate signifigantly more flights than small carriers. Which of the following additional metrics or calculations would provide the MOST value to the user?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following issues is Iterative Development specifically designed to address?
Exam C2090-180 - admin post to:2017-07-20 read more

A company has a manufacturing database they wish to interrogate. They know there are issues that have affected production quality over the last year but they are unsure exactly what factors are contributing to the problem. They would like to be able to quickly examine manufactured batches from multiple perspectives and, if there are any anomalies or any unusual trends over time, they would then like to focus on specific batches to understand the details. Which of the following Cognos 8 Components would BEST address their needs?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is a common mistake made by designers when creating dimension models?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes the design goals of a reporting database?
Exam C2090-180 - admin post to:2017-07-20 read more

A consultant realizes after determining business requirements, that a complete solution will require several related but separate projects. The consultant must choose one project to deliver first. Which of the following describes the considerations that should govern that choice?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is correct regarding report execution requests?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes the benefits of Cognos Application Firewall (CAF)?
Exam C2090-180 - admin post to:2017-07-20 read more

The V-Model testing process specifies that developers should both verify and validate each test. Which of the following describes how developers would validate their tests in the design step of the V-model?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is NOT a critical feature or function of a scorecard?
Exam C2090-180 - admin post to:2017-07-20 read more

You are tasked with administering the Cognos BI system to perform batch reporting in a way that maximizes the use of available system resources. Given the following information, how many jobs 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
Exam C2090-180 - admin post to:2017-07-20 read more

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?
Exam C2090-180 - admin post to:2017-07-20 read more

Which service is required when a user views saved report output?
Exam C2090-180 - admin post to:2017-07-20 read more

A company wishes to coordinate the anticipated hiring activities of all of the departments in a given division of the organization. The CEO has mandated a limit of 50 total new hires for the coming fiscal year. The various departments must coordinate future hiring. The CEO would also like to see reports comparing the projected hiring vs. the actual number of new hires by department. Which set of Cognos 8 components BEST supports the company's needs?
Exam C2090-180 - admin post to:2017-07-20 read more

All of the following describe design intent of an operational database EXCEPT:
Exam C2090-180 - admin post to:2017-07-20 read more

After a BI application is placed into production, all of the following are considered part of the process to prepare for the next iteration of the application, EXCEPT:
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes the models contained in the '24 Ways' book referenced in the BI Professional Workshop course?
Exam C2090-180 - admin post to:2017-07-20 read more

In the Key Performance Indicator (KPI) process flow diagram shown below, which Cognos 8 components are normally associated with the 'Source Information' step?
Exam C2090-180 - admin post to:2017-07-20 read more

When deploying an application from a development environment to a production environment, which of the following is correct when each environment uses a separate LDAP instance?
Exam C2090-180 - admin post to:2017-07-20 read more

A company receives new orders each night. Those orders must be filled and packed for shipment before the end of each day. The users need to know which orders have arrived during the night and which still require filling throughout the day. Supervisors also need the flexibility to inquire against the database on a variety of items outside of the standard order filling process (e.g. customer outstanding balance or shipping rates). Which of the following Cognos 8 components BEST fills the company's needs?
Exam C2090-180 - admin post to:2017-07-20 read more

What is the recommended configuration size for Cognos 8 on a Windows 2003 Server environment, and why?
Exam C2090-180 - admin post to:2017-07-20 read more

When a user requests a certain piece of information, the interviewer may ask what the user would do with that information. From the techniques described in the BI Professional Workshop, why is the interviewer asking this particular question?
Exam C2090-180 - admin post to:2017-07-20 read more

How are Key Performance Indicators (KPIs) tracked?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes an advantage of using the dimensionally modeled relational (DMR) technique to access a normalized data structure?
Exam C2090-180 - admin post to:2017-07-20 read more

When examining an operational (transactional) database, which of the following is considered a good indicator as to which tables contain fact data?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following requires additional configuration for installing Cognos BI in a development and production environment?
Exam C2090-180 - admin post to:2017-07-20 read more

A developer has specified a maximum of two report processes for the application. While monitoring the application, the developer notices that only one report process is running. Which of the following would account for this?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following statements best describes the Iterative Approach of application development?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following statements describes the critical differences between a managed report and a query?
Exam C2090-180 - admin post to:2017-07-20 read more

If anonymous access is disabled, when a user accesses Cognos BI, what is the correct flow of the request?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following MOST clearly states the value of using a methodology?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes how Cognos 8 works with aggregate aware tables in relational data sources?
Exam C2090-180 - admin post to:2017-07-20 read more

The partial diagram below is an example of what type of database schema design?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is true regarding hierarchies and dimensions?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following describes Key Performance Indicators (KPI)?
Exam C2090-180 - admin post to:2017-07-20 read more

A user makes the following request:"I need to see the number of flights throughout the year that arrived 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 or small carriers."This request requires clarification to make the user's intention clear. Which of the following will NOT further clarify the user's request?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following must be moved manually instead of as part of a Cognos 8 deployment package?
Exam C2090-180 - admin post to:2017-07-20 read more

Companies often create a collection of summary tables as their first attempt at a data warehouse. While there are several drawbacks to this approach, there are also some advantages. Which of the following is an advantage of this approach over reporting from an operational database?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following is correct regarding the processing of a PageDown high affinity request?
Exam C2090-180 - admin post to:2017-07-20 read more

Which of the following statements is true about the Waterfall Approach?
Exam C2090-180 - admin post to:2017-07-20 read more

All of the following are considered part of the analyze phase of a BI development project EXCEPT:
Exam C2090-180 - admin post to:2017-07-20 read more

Which statement is true about the BI Bus?
Exam C2090-180 - admin post to:2017-07-20 read more