Quiz  /  Data Warehousing Gate & PSU MCQ Questions With Answers

  • 1. 
    What is CORRECT about dimensional modeling?

  • It is designed to support query
  • It is designed to support storage
  • It is entity-relationship modeling
  • It does not need normalization

  • 2. 
    In SQL the cross-tabs are created using

  • Slice
  • Dice
  • Pivot
  • All of the mentioned

  • 3. 
    Data warehouse is?

  • The actual discovery phase of a knowledge discovery process
  • The stage of selecting the right data for a KDD process
  • A subject-oriented integrated time variant non-volatile collection of data in support of management
  • None of these

  • 4. 
    A null value indicates:

  • A numeric value with value 0
  • The absence of a value
  • A very small value
  • An erroneous value

  • 5. 
    Discharge date must be sorted in order to calculate the length-of-stay

  • True
  • False

  • 6. 
    Data that can be modeled as dimension attributes and measure attributes are called _______ data.

  • Multidimensional
  • Singledimensional
  • Measured
  • Dimensional

  • 7. 
    { (item name, color, clothes size), (item name, color), (item name, clothes size), (color, clothes size), (item name), (color), (clothes size), () }This can be achieved by using which of the following ?

  • group by rollup
  • group by cube
  • group by
  • none of the mentioned

  • 8. 
    The full form of OLAP is?

  • Online Analytical Processing
  • Online Advanced Processing
  • Online Advanced Preparation
  • Online Analytical Performance

  • 9. 
    Classification is

  • A subdivision of a set of examples into a number of classes
  • A measure of the accuracy, of the classification of a concept that is given by a certain theory
  • The task of assigning a classification to a set of examples
  • None of these

  • 10. 
    There are 13 boys and 14 girls in fifth period.

  • Qualitative Data
  • Quantitative Data

  • 11. 
    Which one come first to build data warehouse

  • Data Cleansing
  • Business questions
  • Data Acquisition
  • Data Profiling

  • 12. 
    Data warehousing used in_______________

  • transaction system
  • decision support system

  • 13. 
    What is data to describe data in data warehouse?

  • Relational data
  • Operational data
  • Informational data
  • Metadata

  • 14. 
    A data warehouse can include

  • flat-files
  • database table
  • online data
  • all

  • 15. 
    Why aggregate is used in dimensional model of data warehouse?

  • To store data in one operational system
  • To retrieve data from an operational system
  • To combine data from heterogeneous sources
  • To take the dimension and change its granularity

  • 16. 
    The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________

  • Rollup
  • Drill down
  • Dicing
  • Pivoting

  • 17. 
    Which of the following features usually applies to data in a data warehouse?

  • Data are often deleted
  • B.Most applications consist of transactions
  • C.Data are rarely deleted
  • D.Relatively few records are processed by applications

  • 18. 
    Choose which data mining task is suitable for the following scenario: first buy digital camera, then buy large SD memory cards

  • Classification
  • Sequential pattern analysis
  • Association rule
  • Prediction

  • 19. 
    The candy was sour.

  • Qualitative Data
  • Quantitative Data

  • 20. 
    Data mining is the exploration and analyzing large data set to discover patterns and correlations to predict outcomes.

  • True
  • False

  • 21. 
    What is true of the multidimensional model?

  • It typically requires less disk storage
  • It typically requires more disk storage
  • Typical business queries requiring aggregate functions take more time
  • Increasing the size of a dimension is difficult

  • 22. 
    The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is

  • Slicing
  • Dicing
  • Pivoting
  • Both Slicing and Dicing

  • 23. 
    Data warehouse is based on_____________

  • two dimensional model
  • three dimensional model
  • multidimensional model
  • unidirectional model

  • 24. 
    What is WRONG about surrogate key?

  • It is a list of running numbers
  • It is a primary key of fact table
  • It is designed for handling slowly change dimension problem
  • It is the join key between fact and dimension table
Report Question
warning
access_time
  Time