Scribd
Upload
2K views2 pages

CCS341 Set1

This document outlines the practical end semester examinations for the fifth semester CCS341 - Data Warehousing course (Regulations 2021). It lists 20 potential exam questions students could answer related to data warehousing and preprocessing tasks using tools like WEKA, creating data models for applications like banking and healthcare, data warehousing architecture design, and OLAP operations. Students will have 3 hours to answer one of the questions, and will be evaluated on various components including the aim/principle/procedure, program/drawing, calculations and results, viva voce, and record, for a total of 100 marks.

Uploaded by

Anonymous SwS8ipxbd
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2K views2 pages

CCS341 Set1

This document outlines the practical end semester examinations for the fifth semester CCS341 - Data Warehousing course (Regulations 2021). It lists 20 potential exam questions students could answer related to data warehousing and preprocessing tasks using tools like WEKA, creating data models for applications like banking and healthcare, data warehousing architecture design, and OLAP operations. Students will have 3 hours to answer one of the questions, and will be evaluated on various components including the aim/principle/procedure, program/drawing, calculations and results, viva voce, and record, for a total of 100 marks.

Uploaded by

Anonymous SwS8ipxbd
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

B.E / B.Tech.

PRACTICAL END SEMESTER EXAMINATIONS, NOVEMBER/DECEMBER 2023


Fifth Semester

CCS341 - DATA WAREHOUSING

(Regulations 2021)

Time: 3 Hours Answer any one Question Max. Marks 100

Aim/Principle/Apparatus Tabulation/Circuit/ Calculation Viva-Voce Record Total


required/Procedure Program/Drawing & Results

20 30 30 10 10 100

1. Perform data preprocessing tasks using labor data set in WEKA.

2. Create scatterplots and histograms using visualize option to detect outliers in WEKA.

3. Demonstrate how to identify and address conflicting data when merging multiple datasets.

4. Implement data preprocessing using ARFF format, CSV format and C4.5 format in WEKA
tool.

5. Perform data preprocessing tasks using weather database in WEKA. Demonstrate how to
remove attributes in the given data base.

6. Demonstrate the usage of filters in WEKA.

7. Create noise monitoring data set using Apriori algorithm.

8. Design multi-dimensional data models such as Star, Snowflake and Fact Constellation
schemas for Banking application.

9. Design multi-dimensional data models such as Star, Snowflake and Fact Constellation
schemas for Health care application.

10. Implement classification of data using K-nearest neighbor approach in WEKA

11. Design a three-tier data ware house architecture of banking.

Page 1 of 2
12. Design a three-tier data ware house architecture of your own example.

13. Build data warehouse system for storing and analyzing data about all loans issued by
bank.

14. Analyze the results of its students and the quality of its courses over time for a university.

15. Perform a OLAP case study for sales analysis of a retail chain.

16. Design and investigate role of accountants in information systems and the benefits of
using OLAP to accountants in generating complex management reports

17. Perform Various OLAP operations such slice, dice, roll up, drill up and
pivot.

18. Perform a case study on online retail order processing

19. Performa banking transaction processing system.

20. Implement warehouse testing.

Page 2 of 2

You might also like