Data Warehousing

  1. Question: Which of the following are the modes of OLAP?

    A
    MOLAP

    B
    ROLAP

    C
    KOLAP

    Note: Not available
    1. Report

  2. Question: OLAP queries can be characterised as on-line transactions that do not:

    A
    Access small amounts of data

    B
    Analyse the relationships between many types of business elements e.g. sales, products, regions, and channels

    C
    Compare aggregated data over hierarchical time periods e.g. monthly, quarterly, yearly

    D
    Present data in different perspectives e.g. sales by region vs. sales by channels by product within each region

    E
    Respond quickly to user requests, so that users can pursue an analytical thought process without being stymied by the system

    Note: Not available
    1. Report

  3. Question: Normalisation is:

    A
    The process of organising data in accordance with the rules of a relational database

    B
    The process of cleansing the data

    C
    The process of integrating the data into the datawarehouse from legacy systems

    D
    The process of compressing the data

    E
    The process of eliminating invalid data before it is introduced into the data warehouse

    Note: Not available
    1. Report

  4. Question: Which of the following would not be considered as a variable affecting the design of an OLAP system?

    A
    Query demand

    B
    Source of data

    C
    Number of dimensions

    D
    Atomic data volume

    E
    Data volatility

    Note: Not available
    1. Report

  5. Question: A slice is:

    A
    A subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions not in the subset

    B
    A subset of a multi-dimensional array corresponding to multiple values for one or more members of the dimensions not in the subset

    C
    A subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions in the subset

    D
    A subset of a multi-dimensional array corresponding to multiple values for one or more members of the dimensions in the subset

    E
    A subset of a multi-dimensional array not corresponding to a single value for one member of the dimensions not in the subset

    Note: Not available
    1. Report

  6. Question: Which of the following techniques can be used to improve query performance?

    A
    Denormalization

    B
    Partitioning

    C
    Summarization

    D
    Denormalization and Partitioning

    E
    Denormalization, Partitioning and Summarization

    Note: Not available
    1. Report

  7. Question: The term OLAP was coined by:

    A
    Date

    B
    Codd

    C
    IBM

    D
    Oracle

    E
    Microsoft

    Note: Not available
    1. Report

  8. Question: The main objects used by OLAP programs are:

    A
    Multidimensional cubes

    B
    Metadata

    C
    RDBMS tables

    D
    Fact tables

    E
    Pivot tables

    Note: Not available
    1. Report

  9. Question: Granularity refers to the:

    A
    Validity of the data stored in a data warehouse

    B
    The level of detail of the facts stored in a data warehouse

    C
    The timeliness of the data stored in a data warehouse

    D
    The redundancy of the data stored in a data warehouse

    E
    Compactness of the data stored in a data warehouse

    Note: Not available
    1. Report

  10. Question: Which of the following queries would be correlated with a Data warehouse?

    A
    What is the current account balance of this customer?

    B
    How many customers have not paid their balances on time?

    C
    What is the total number of customers in the middle region?

    D
    Which product line sells best in middle region and how does this correlate to demographic data?

    E
    Which customer makes the maximum purchases?

    Note: Not available
    1. Report
First123Last
/7
Copyright © 2024. Powered by Intellect Software Ltd