Data mining and warehousing mcq unit 2

data mining and warehousing mcq, data mining and warehousing mcq sppu, data mining and warehousing mcq questions, data mining and data warehousing mcq, data mining and warehouse mcq, high performance computing quiz, dmw mcq, data mining and warehousing multiple choice questions, data mining and warehousing mcq pdf, data warehouse mcq questions and answers, data mining quiz
data mining and warehousing mcq sppu

Data mining and warehousing mcq

1. What is the type of relationship in star schema?

  1. many-to-many.
  2. one-to-one
  3. many-to-one
  4. one-to-many
Advertisement

one-to-many

2. Fact tables are _______.

  1. completely demoralized.
  2. partially demoralized.
  3. completely normalized.
  4. partially normalized.
Advertisement

completely normalized.

3. Data warehouse is volatile, because obsolete data are discarded

  1. TRUE
  2. FALSE
Advertisement

FALSE

4. Which is NOT a basic conceptual schema in Data Modeling of Data Warehouses?

  1. Star schema
  2. Tree schema
  3. Snowflake schema
  4. Fact constellations b
Advertisement

Tree schema

5. Which is NOT a valid OLAP Rule by E.F.Codd?

  1. Accessibility
  2. Transparency
  3. Flexible reporting
  4. Reliability
Advertisement

Reliability

6. Which is NOT a valid layer in Three-layer Data Warehouse Architecture in Conceptual View?

  1. Processed data layer
  2. Real-time data layer
  3. Derived data layer
  4. Reconciled data layer
Advertisement

Processed data layer

7. Among the types of fact tables which is not a correct type ?

  1. Fact-less fact table
  2. Transaction fact tables
  3. Integration fact tables
  4. Aggregate fact tables

Integration fact tables

8. Among the followings which is not a characteristic of Data Warehouse?

  1. Integrated
  2. Volatile
  3. Time-variant
  4. Subject oriented
Advertisement

Volatile

Machine Learning mcq with answers

9.  what is not considered as isssues in data warehousing?

  1. optimization
  2. data transformation
  3. extraction
  4. inter mediation

inter mediation

10. which one is NOT considering as a standard  query technique?

  1. Drill-up
  2. Drill-across
  3. DSS
  4. Pivoting
Advertisement

DSS

Data mining and warehousing mcq sppu

11. Among the following which is not a type of business data ?

  1. Real time data
  2. Application data 
  3. Reconciled data
  4. Derived data

Application data

12. A data warehouse is which of the following?

  1. Can be updated by end users.
  2. Contains numerous naming conventions and formats.
  3. Organized around important subject areas.
  4. Contains only current data.
Advertisement

Organized around important subject areas.

13. A snowflake schema is which of the following types of tables?

  1. Fact
  2. Dimension
  3. Helper
  4. All of the above

All of the above

14. The extract process is which of the following?

  1. Capturing all of the data contained in various operational systems
  2. Capturing a subset of the data contained in various operational systems
  3. Capturing all of the data contained in various decision support systems .
  4. Capturing a subset of the data contained in various decision support systems

Capturing a subset of the data contained in various operational systems

Data mining and Warehousing mcq

15. The generic two-level data warehouse architecture includes which of the following?

  1. At least one data mart
  2. Data that can extracted from numerous internal and external sources
  3. Near real-time updates
  4. All of the above.
Advertisement

Data that can extracted from numerous internal and external sources

16. Which one is  correct regarding MOLAP ?

  1. Data is stored and fetched from the main data warehouse.
  2. Use complex SQL queries to fetch data from the main warehouse
  3. Large volume of data is used.
  4. All are incorrect
  5. A and B is correct.

Data is stored and fetched from the main data warehouse.

17.In terms of data warehouse,metadata can be define as,

  1. Metadata is a road-map to data warehouse
  2. Metadata in data warehouse defines the warehouse objects.
  3. Metadata acts as a directory.
  4. All are incorrect

All are incorrect

18. In terms of RLOP model, choose the most suitable answer

  1. The warehouse stores atomic data.
  2. The application layer generates SQL for the two dimensional view
  3. The presentation layer provides the multidimensional view.
  4. All are incorrect
Advertisement

All are incorrect

19. In the OLAP model, the _ provides the multidimensional view.

  1. Data layer
  2. Data link layer
  3. Presentation layer
  4. Application layer

Data layer

data mining and warehousing mcq sppu

20. Which of the following is not true regarding characteristics of warehoused data?

  1. Changed data will be added as new data
  2. Data warehouse can contains historical data
  3. Obsolete data are discarded
  4. Users can change data once entered into the data warehouse 

Users can change data once entered into the data warehouse

21. ETL is an abbreviation for Elevation, Transformation and Loading

  1. TRUE
  2. FALSE
Advertisement

FALSE

22. which is the core of the multidimensional model that consists of a large set of facts and a number of dimensions?

  1. Multidimensional cube
  2. Data model
  3. Data cube
  4. None of the above

Data cube

23. Which of the following statements is incorrect

  1. ROLAPs have large data volumes
  2. Data form of ROLAP is large multidimentional array made of cubes 
  3. MOLAP uses sparse matrix technology to manage data sparcity
  4. Access for MOLAP is faster than ROLAP
Advertisement

Data form of ROLAP is large multidimentional array made of cubes

24. Which of the following standard query techniques increase the granularity

  1. roll-up
  2. dril-down
  3. slicing
  4. dicing

dril-down

25. The full form of OLAP is

  1. Online Analytical Processing
  2. Online Advanced Processing
  3. Online Analytical Performance
  4. Online Advanced Preparation

Online Analytical Processing

26. Which of the following statements is/are incorrect about ROLAP

  1. ROLAP fetched data from data warehouse.
  2. ROLAP data store as data cubes.
  3. ROLAP use sparse matrix to manage data sparsity.
Advertisement

B and C

27. __ is a standard query technique that can be used within OLAP to zoom in to more detailed data by changing dimensions.

  1. Drill-up
  2. Drill-down
  3. Pivoting
  4. Drill-across

Drill-down

28. Which of the following statements is/are correct about Fact constellation

  1. Fact constellation schema can be seen as a combination of many star schemas.
  2. It is possible to create fact constellation schema, for each star schema or snowflake schema.
  3. Can be identified as a flexible schema for implementation.
Advertisement

All are correct

29. How to describe the data contained in the data warehouse?.

  1. Relational data
  2. Operational data
  3. Meta data
  4. Informational data

Meta data

30. The output of an OLAP query is displayed as a

  1. Pivot
  2. Matrix
  3. Excel
  4. both B and C

both B and C : Matrix and Excel

data mining and warehousing mcq questions

31. One can perform Query operations in the data present in Data Warahouse

  1. TRUE
  2. FALSE

TRUE

32. A __ combines facts from multiple processes into a single fact table and eases the analytic burden on BI applications.

  1. Aggregate fact table
  2. Consolidated fact table
  3. Transaction fact table
  4. Accumulating snapshot fact table
Advertisement

Consolidated fact table

33. In OLAP operations, Slicing is the technique of ____

  1. Selecting one particular dimension from a given cube and providing a new sub-cube
  2. Selecting two or more dimensions from a given cube and providing a new sub-cube
  3. Rotating the data axes in order to provide an alternative presentation of data
  4. Performing aggregation on a data cube

Selecting one particular dimension from a given cube and providing a new sub-cube

34. Standalone data marts built by drawing data directly from operational or external sources of data or both are known as independent data marts

  1. TRUE
  2. FALSE

TRUE

35. Focusing on the modeling and analysis of data for decision makers, not on daily operations or transaction processing is known

  1. Integrated
  2. Time-variant
  3. Subject oriented
  4. Non-volatile
Advertisement

Subject oriented

36. Most of the time data warehouse is

  1. Read
  2. Write
  3. Both

Read

37. Data granularity is ——————- of details of data ?

  1. summarization
  2. transformation
  3. level

level

38. Which one is not a type of fact?

  1. Fully Addictive
  2. Cumulative addictive
  3. Semi Addictive
  4. Non Addictive
Advertisement

Semi Addictive

39. When the level of details of data is reducing the data granularity goes higher

  1. True
  2. False

False

40. Data Warehouses are having summarized and reconciled data which can be used by decision makers

  1. True
  2. False
Advertisement

True

41. _____ refers to the currency and lineage of data in a data warehouse

  1. Operational metadata 
  2. Business metadata
  3. Technical metadata
  4. End-User meatdata
Advertisement

Operational metadata

MORE DATA MINING AND WAREHOUSING MCQ :

Data mining mcq questions | dmw mcqs sppu

Data mining and warehousing mcq questions

Data mining and warehousing mcq unit 1

Data mining and warehousing mcq unit 2

Data Mining and Warehousing mcq sppu unit 4

Data Analytics sppu mcq

data mining and warehousing mcq, data mining and warehousing mcq sppu, data mining and warehousing mcq questions, data mining and data warehousing mcq, data mining and warehouse mcq, dmw mcq, data mining and warehousing multiple choice questions, data mining and warehousing mcq pdf, data warehouse mcq questions and answers, data mining quiz

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top