(TCO 4) Data warehouses are designed differently from operational databases because 0 operational data represent transactions in real time, whereas decision support data are historic decision support data represent transactions in real time, whereas operational data are historic operational data are mostly read-only, whereas decision support data are subject to frequent updates decision support data are stored in many tables, whereas operational data are stored in few tables Question 3 3 pts (TCO 4) A defining characteristic of a data warehouse is that it is fragmented 0 volatile time-variant time-invariant Question 4 3 pts (TCO 4) Some organizations implement data marts because of their compared to a data warehouse. longer implementation time broader scope lower cost O E m/courses/60130/quizzes/197031/take (TCO 4) A data model that maps multidimensional decision support data into a relational database is the star schema circular schema flat schema O pyramid schema Question 6 3 pts (TCO 4) Starting with a broad overview of data, such as sales for all months in 2013, and then focusing on increasing levels of detail, such as a single month showing a sales decline, is called drill-down analysis roll-up analysis aggregation data mining D Question 7 3 pts (TCO 4) In a star schema, the primary key of a fact table is formed by combining Top the primary keys of all other fact tables metros calculated from the stored facts the foreign keys pointing to the dimension tables (TCO 4) In a star schema, the primary key of a fact table is formed by combining the primary keys of all other fact tables metrics calculated from the stored facts the foreign keys pointing to the dimension tables the attributes at all levels of a single attribute hierarchy Question 8 3 pts (TCO 4) analytics focuses on discovering and understanding characteristics and relationships of existing data Dynamic Static , Explanatory Predictive Question 9 3 pts (TCO 4) The phase of data mining that involves classification analysis, clustering and sequence analysis, link analysis, and trend and deviation analysis is the phase data preparation knowledge acquisition O Question 9 3 pts (TCO 4) The phase of data mining that involves classification analysis, clustering and sequence analysis, link analysis, and trend and deviation analysis is the phase. Odata preparation knowledge acquisition O prognosis data analysis and classification Question 10 3 pts (TCO 4) Which of the following is a main characteristic of online analytical processing (OLAP)? Difficult to-use end-user interfaces Basic database support Single-dimensional data analysis Multidimensional data analysis No new data to save. Last checked at 2:22am Submit Q O