Cognos Interview Questions and Answers (Business Opportunities - Advertising Service)

USNetAds > Business Opportunities > Advertising Service

Item ID 130406600 in Category: Business Opportunities - Advertising Service

Cognos Interview Questions and Answers


Cognos Interview Questions and Answers

Q.What is a Data Warehouse?

Ans: Data Warehouse is a collection of data marts representing historical data from different operation data sources (OLTP). The data from these OLTP are structured and optimized for querying and analysis in a Data Warehouse.

Q.Define Cognos Report Net?

Ans: Cognos Report Net is the web-based, dynamic, business intelligence reporting solution from Cognos.

Q.What are the tiers of the ReportNet Architecture?

Ans: The ReportNet architecture can be separated into three tiers:

Web server
Applications
Data
Q.Define Business Intelligence

Ans: Business Intelligence is a broad category of application programs and technology used for query, Reporting and analyzing the business multi dimensionally.

Q.What is a Data Mart?

Ans: Data Mart is a subset of a data warehouse that can provide data for reporting and analysis.

Q.What is HPQS ?

Ans: Data Marts are sometimes also called as HPQS (Higher Performance Query Structure).

Q.What is multi dimension analysis?

Ans: It is a technique to modify the data so that the data can be view at the different levels of details.

Q.What are the responsibilities of Cognos Administrator?

Ans: Cognos Administrator is assigned with following responsibilities.

Installations and configurations in distributed network environment.
Creating the Repository (Content Store).
Perform back up and recovery of Meta Data.
Developing the user Administration.
Tuning the servers.
Deployment.
Q.Responsibility of Cognos Architect?

Ans: An Architect is responsible for designing the interface by fulfilling the user requirements.Once the interface has been designed it should be rigorously tested before distributing to the end user population.

Q.Roles of the Application Developer?

Ans: Design the Reports according to the Report requirement templates.

Testing the each report with the following types of tests.

Unit Testing
System Testing
Performance Testing
Q.What is OLAP?

Ans: OLAP stands for Online Analytical Processing. It uses database tables (Fact and Dimension tables) to enable multidimensional viewing, analysis and querying of large amount of data.

Q.What are the types of OLAPs?

Ans:

DOLAP:-The OLAP tool which works with desktop databases are called as DOLAP Ex:- FoxPro, Clipper, Dbase, Paradox.
ROLAP:-The OLAP tool, which works with Relational databases, are called as ROLAP. Ex:-Oracle, SQL Server, Tera Data, DB2.
MOLAP: – The OLAP tool, which works with Multidimensional databases, are called as
MOLAP.

Ex:- ESSBASE, Power Cube

HOLAP:- The OLAP tool which works with Relational databases and Multidimensional database, are called as MOLAP.
Ex:- Cognos, Business Objects.

Related Link: Click here to visit item owner's website (0 hit)

Target State: Washington DC
Target City : All Cities
Last Update : Aug 03, 2019
Number of Views: 41
Item  Owner  : best interview question
Contact Email:
Contact Phone: (None)

Friendly reminder: Click here to read some tips.
USNetAds > Business Opportunities > Advertising Service
 © 2019 USNetAds.com
2019-11-14 (0.072 sec)