Friday, May 26, 2023

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

   

No comments:

Search Assignments and Papers Here...


Custom Search

An Appeal to SCDL students

Dear SCDL Student,

We at http://scdlpapers.blogspot.com tries to collect and spread the knowledge in terms of the solved papers and assignments which we are getting through SCDL Alumni.
Now we request you to help other students through mutual sharing. Please send your assignment questions/papers to "mindgrill@gmail.com" . We will publish them on this blog along with your name.
Your help can be boon for many students to clear their exams.

Best of Luck and waiting for your contributions.

Team @ MindGrill