Jawaharlal Nehru Technological University Hyderabad
Jawaharlal Nehru Technological University Hyderabad B.Tech III DATA WAREHOUSING AND BUSINESS INTELLIGENCE Previous Question Paper (January/February - 2023 - R18)
Question paper consists of Part A, Part B. Part A is compulsory, which carries 25 marks. Answer all questions in Part A. In Part B, Answer any one question from each unit. Each question carries 10 marks.
Part A
Define metadata repository.
Answer
A metadata repository is a centralized database that stores information about the data warehouse, including data definitions, source systems, transformation rules, business rules, and access privileges, serving as the directory for the entire data warehouse environment.
Explain about a three-tier data warehouse architecture.
Answer
A three-tier data warehouse architecture consists of: (1) The Bottom Tier, which is the data warehouse database server that extracts and cleans data from operational sources; (2) The Middle Tier, which is an OLAP server that transforms data into multidimensional structures for analysis; and (3) The Top Tier, which is the front-end client layer providing tools for reporting, querying, and data visualization.
What is business analytics?
Answer
Sign in to view the complete answer paper.
Write a brief history of BI.
Answer
Sign in to view the complete answer paper.
What are key drivers of BI?
Answer
Sign in to view the complete answer paper.
Draw architecture of BI.
Answer
Sign in to view the complete answer paper.
What are BI tools?
Answer
Sign in to view the complete answer paper.
Explain about Pentaho tool.
Answer
Sign in to view the complete answer paper.
Define physical integration.
Answer
Sign in to view the complete answer paper.
What are limitations of on-demand BI?
Answer
Sign in to view the complete answer paper.
Part B
Describe OLAP operations in the multidimensional data model.
Answer
Sign in to view the complete answer paper.
Explain about multiway array aggregation for full cube computation.
Answer
Sign in to view the complete answer paper.
Discuss about computing iceberg cubes using a dynamic star-tree structure.
Answer
Sign in to view the complete answer paper.
Explain in detail about indexing OLAP data.
Answer
Sign in to view the complete answer paper.
What is Business Intelligence? Explain about leveraging knowledge and data for BI.
Answer
Sign in to view the complete answer paper.
What are BI dimensions? Explain about BI life cycle in detail.
Answer
Sign in to view the complete answer paper.
What are key performance indicators? Explain.
Answer
Sign in to view the complete answer paper.
Explain about the value of business intelligence.
Answer
Sign in to view the complete answer paper.
Describe best practices of Business Intelligence.
Answer
Sign in to view the complete answer paper.
Discuss about a cyclic process of intelligence creation.
Answer
Sign in to view the complete answer paper.
Explain about social networks importance in BI. Also explain about emerging trends in BI.
Answer
Sign in to view the complete answer paper.
What is KNIME? What are features of KNIME? Explain in detail.
Answer
Sign in to view the complete answer paper.
Explain the following:
Mobile social networking
Answer
Sign in to view the complete answer paper.
Implications of business and enterprise social networks.
Answer
Sign in to view the complete answer paper.
Explain the following:
Social networks
Answer
Sign in to view the complete answer paper.
Connecting BI systems to databases and other enterprise systems.
Answer
Sign in to view the complete answer paper.