Help shape GoConqr. What should we add next?

Flashcards

CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES

Miguel Lucero CIS 3365 English 49 cards

Cards in this deck (49)

  1. 11. Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom. a. True b. FalseANSWER: True
  2. 22. Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components. a. True b. FalseANSWER: True
  3. 33. A data store is used by data analysts to create queries that access the database. a. True b. FalseANSWER: False
  4. 44. Master data management’s main goal is to provide a partial and segmented definition of all data within an organization. a. True b. FalseANSWER: False
  5. 55. Operational data and decision support data serve the same purpose. a. True b. FalseANSWER: False
  6. 66. Decision support data are a snapshot of the operational data at a given point in time. a. True b. FalseANSWER: True
  7. 77. Queries against operational data typically are broad in scope and high in complexity. a. True b. FalseANSWER: False
  8. 88. Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS. a. True b. FalseANSWER: False
  9. 99. Relational data warehouses use multidimensional data schema support to handle multidimensional data. a. True b. FalseANSWER: False
  10. 1010. The data warehouse development life cycle differs from classical systems development. a. True b. FalseANSWER: True
  11. 1111. A data warehouse designer must define common business dimensions that will be used by a data analyst to narrow a search, group information, or describe attributes. a. True b. FalseANSWER: False
  12. 1212. By default, the fact table’s primary key is always formed by combining the superkeys pointing to the Dimension tables to which they are related. a. True b. FalseANSWER: False
  13. 1313. Normalizing fact tables improves data access performance and saves data storage space. a. True b. FalseANSWER: False
  14. 1414. Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in a table. a. True b. FalseANSWER: True
  15. 1515. Multidimensional data analysis techniques include advanced computational functions. a. True b. FalseANSWER: True
  16. 1616. Advanced OLAP feature become more useful when access to them is kept simple. a. True b. FalseANSWER: True
  17. 1717. To provide better performance, some OLAP systems merge data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations. a. True b. FalseANSWER: True
  18. 1818. A star schema is designed to optimize data query operations rather than data update operations. a. True b. FalseANSWER: True
  19. 1919. ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework. a. True b. FalseANSWER: True
  20. 2020. The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one. a. True b. FalseANSWER: False
  21. 2121. The CUBE extension enable you to get a grand total for each column listed in the expression a. True b. FalseANSWER: False
  22. 2222. A is optimized for decision support and is generally represented by a data warehouse or a data mart. a. data store b. ETL tool c. data visualization d. data analysis toola. data store
  23. 2323. are in charge of presenting data to the end user in a variety of ways. a. Data stores b. ETL tools c. Data visualization tools d. Data analysis toolsc. Data visualization tools
  24. 2424. _____ provide a unified, single point of entry for information Distribution. a. Decision support systems b. Portals c. Data warehouses d. Dashboardsb. Portals
  25. 2525. In business intelligence framework, data are captured from a production system and placed in the____ on a near real- time basis. a. decision support system b. portal c. data warehouse d. dashboardc. data warehouse
  26. 2626. Tools focus on the strategic and tactical use of information. a. Business b. Relational database management c. Business intelligence d. Networkingc. Business intelligence
  27. 2727. Which of the following is a personal analytics vendor for BI applications? a. IBM b. Kognitio c. Netezza d. MicroStrategyd. MicroStrategy
  28. 2828. From a data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and . a. usability b. dimensionality c. transaction processing d. sparsityb. dimensionality
  29. 2929. Operational data are commonly stored in many tables, and the stored data represent information about a given only. a. transaction b. database c. table d. concepta. transaction
  30. 3030. The schema must support complex (non-normalized) data representations. a. snowflake b. online analytical processing c. decision support database d. multidimensional databasec. decision support database
  31. 3131. Data implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise. a. visualization b. analytics c. mining d. integrationd. integration
  32. 3232. can serve as a test vehicle for companies exploring the potential benefits of data warehouses. a. Data networks b. Data marts c. Data cubes d. OLAPsb. Data marts
  33. 3333. Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) . a. data warehouse b. multidimensional cube c. OLAP tool d. star schemaa. data warehouse
  34. 3434. The basic star schema has four components: facts, , attributes, and attribute hierarchies. a. keys b. relationships c. cubes d. dimensionsd. dimensions
  35. 3535. Computed or derived facts, at run time, are sometimes called to differentiate them from stored facts. a. schemas b. attributes c. metrics d. dimensionsc. metrics
  36. 3636. In a star schema, attributes are often used to search, filter, or classify . a. tables b. sales c. facts d. dimensionsc. facts
  37. 3737. The attribute hierarchy provides a top-down data organization that is used for two main purposes:_____ and drill-down/roll-up data analysis. a. decomposition b. de-normalization c. normalization d. aggregationd. aggregation
  38. 3838. In star schema representation, a fact table is related to each dimension table in a relationship. a. many-to-one (M:1) b. many-to-many (M:M) c. one-to many (1:M) d. one-to-one (1:1)a. many-to-one (M:1)
  39. 3939. Fact and dimension tables are related by keys. a. shared b. primary c. foreign d. linkedc. foreign
  40. 4040. In a typical star schema, each dimension record is related to thousands of records. a. attribute b. fact c. key d. primaryb. fact
  41. 4141. A schema is a type of star schema in which dimension tables can have their own dimension tables. a. snowflake b. starflake c. dimension d. matrixa. snowflake
  42. 4242. _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time. a. Normalization b. Meta modeling c. Replication d. Partitioningd. Partitioning
  43. 4343. The reliance on as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems. a. normalization b. denormalization c. star schema d. multidimensional schemaa. normalization
  44. 4444. Decision support data tend to be non-normalized, , and pre-aggregated. a. unique b. duplicated c. optimized d. sortedb. duplicated
  45. 4545. extends SQL so that it can differentiate between access requirements for data warehouse data and operational data. a. ROLAP b. OLAP c. DBMS d. BIa. ROLAP
  46. 4646. A index is based on 0 and 1 bits to represent a given condition. a. logical b. multidimensional c. normal d. bitmappedd. bitmapped
  47. 4747. Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a . a. multi-cube b. database cube c. data cube d. hyper cubec. data cube
  48. 4848. A multidimensional database management systems (MDBMS) uses proprietary techniques to store data in n-dimensional arrays. a. table-like b. matrix-like c. network-like d. cube-likeb. matrix-like
  49. 4949. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows. a. SQL view b. materialized view c. star schema d. data cubeb. materialized view

Information

Description
CIS 3365 Flashcards on CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES, created by Miguel Lucero on 21/03/2017.
Created by
Miguel Lucero
Views
42
Rating

More on Data Warehousing

Feedback

What is it about?

What should we add next?