New Click here to enroll in UIICL SO Finance and Investment Course

    Register

    Question

    Read the below passage and answer the questions OLAP stands for Online Analytical Processing. OLAP systems have the capability to analyze database information of multiple systems at the current time. The primary goal of OLAP Service is data analysis and not data processing.  OLTP stands for Online Transaction Processing. OLTP has the work to administer day-to-day transactions in any organization. The main goal of OLTP is data processing not data analysis. During the Extract, Transform, and Load (ETL) process, a ______(14)   also known as a  landing zone , is an interim storage region used for Data Processing. The Data Staging Area is located in between the Data Source(s) and the Data Target(s), which are typically Data Warehouses,  Data Marts , or other Data Repositories. 

    Data warehouse has historical data

    A Always Correct Answer Incorrect Answer
    B Sometimes Correct Answer Incorrect Answer
    C Many a times Correct Answer Incorrect Answer
    D Depends on application Correct Answer Incorrect Answer
    E None of these Correct Answer Incorrect Answer

    Solution

    The correct answer is A

    Practice Next