Course: B.Tech (Semester V) Subject Code: KDS-051
Subject Name: Business Intelligence and Analytics Time: 3 Hours
Total Marks: 100
Section A – Short Answer Questions (2 × 10 = 20 Marks)
Attempt all questions briefly:
Limitations of mathematical modeling Factors that influence rational choice in decision-making
Define evolution and deviation analysis Meaning of OLTP and OLAP
Purpose of data validation Is PCS used for data reduction?
Four types of business analytics Types of variables in a dataset
What is a data repository? When should root cause analysis be conducted?
Section B – Descriptive Questions (10 × 3 = 30 Marks)
Attempt any three:
Draw and explain business intelligence architecture.
Explain types of Data Marts, define Fact Table and Mapplet.
Explain tools and important steps for Data Validation.
Describe Monte Carlo and Regression Analysis.
Compare Complex Event Processing (CEP) and Business Activity Monitoring (BAM) — when to use each.
Section C – Long Answer Questions (10 × 5 = 50 Marks)
Question 3
(a) How does BI architecture influence business intelligence purpose?
or
(b) Factors responsible for successful Business Intelligence (BI) projects.
Question 4
(a) Differentiate between Star Schema and Snowflake Schema with examples.
or
(b) Explain steps in the ETL process and its role in data warehousing.
Question 5
(a) Write the function to find the day of the week for a given date.
or
(b) Define Data Validation, its working, and importance.
Question 6
(a) How to determine accuracy in an Iris Dataset?
or
(b) Explain data mining techniques and their business applications.
Question 7
(a) Relationship between Business Glossary and Metadata Management.
or
(b) Explain how Complex Event Processing (CEP) and Business Activity Monitoring (BAM) benefit companies.
