📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    âš¡ Month End Offer - Flat 52% Off On All Courses! Enroll Now âš¡
    00:00:00 AM Left

    Question

    Data warehouse has historical

    data 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. 
    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
    More IT Operating System Questions
    ask-question