New Click here to Enroll for SIDBI MSME Expert Class by ex-GM, SBI on Nov 24

    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. 

    OLAP and OLTP differs in

    A Application Correct Answer Incorrect Answer
    B Normalization Correct Answer Incorrect Answer
    C Data source Correct Answer Incorrect Answer
    D Both 1 and 3 Correct Answer Incorrect Answer
    E All three Correct Answer Incorrect Answer

    Solution

         

    Practice Next