SCDL PGDDS Sem 2 Exam Paper Big data with Data Warehousing and Data Mining - 1

 ------------------------------------ 

 Submitted By: Shaurya

 Thanks Shaurya for sharing and helping other fellow students. 

Hello,

Answers are not Known, these are just the Questions.

------------------------------------

1. Which of the following is NOT a characteristic of a data warehouse?

   a) Real-time data processing

   b) Historical data storage

   c) Subject-oriented data

   d) Integrated data

2. What is the main purpose of a data warehouse?

   a) To support operational systems

   b) To store raw data

   c) To provide real-time analytics

   d) To provide a consolidated view of data

3. What is metadata in the context of a data warehouse?

   a) Data that is stored in a warehouse

   b) Data about the data in a warehouse

   c) Data that is extracted from a warehouse

   d) Data that is transformed in a warehouse

4. Which of the following is a common data source for a data warehouse?

   a) Social media platforms

   b) Online transactional systems

   c) Cloud storage services

   d) All of the above

5. Which component is responsible for extracting data from various sources in a data warehouse architecture?

   a) ETL (Extract, Transform, Load) process

   b) Data marts

   c) OLAP (Online Analytical Processing) cubes

   d) Metadata repository

6. What is the role of a data mart in a data warehouse architecture?

   a) To store raw data

   b) To provide real-time analytics

   c) To provide a consolidated view of data

   d) To store a subset of data for a specific department or business area

7. Which of the following is NOT a layer in the architecture of a data warehouse?

   a) Data integration layer

   b) Data storage layer

   c) Data mining layer

   d) Data presentation layer

8. What is a dimension in dimensional modeling?

   a) A measure of a business process

   b) A category or attribute used to describe data

   c) A unique identifier of a record in a data warehouse

   d) A mathematical calculation performed on data

9. Which type of schema is commonly used in dimensional modeling?

   a) Star schema

   b) Snowflake schema

   c) Hierarchical schema

   d) Relational schema

10. What does ETL stand for in the context of data warehousing?

    a) Extract, Transform, Load

    b) Extract, Transfer, Load

    c) Extract, Translate, Load

    d) Extract, Transcribe, Load

11. Which process in ETL is responsible for cleaning and transforming data into a usable format?

    a) Extract

    b) Transform

    c) Load

    d) All of the above

12. What is data mining?

    a) A process of extracting data from a data warehouse

    b) A process of transforming data into a usable format

    c) A process of discovering patterns and insights from large datasets

    d) A process of loading data into a data warehouse

13. Which of the following is a data mining task?

    a) Data cleansing

    b) Data transformation

    c) Data loading

    d) Clustering

14. Which data mining technique is used to classify data into predefined categories or classes?

    a) Clustering

    b) Association rule mining

    c) Classification

    d) Regression

15. Which data mining technique is used to identify patterns or associations in data?

    a) Classification

    b) Regression

    c) Clustering

    d) Association