Quiz
Chapter 13 (MC)
Questions in this quiz (40)
11.Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.
- Aa.metadata
- Bb.facts
- Cc.information
- Dd.rules
22.Analyzing decision support data to generate information is part of ____.
- Aa.data warehousing
- Bb.very large database systems
- Cc.business intelligence
- Dd.distributed processing
33.Data mining is part of the “____” section of the business intelligence framework.
- Aa.Peopl
- Bb.Management
- Cc.Processes
- Dd.Governance
44.A data mart is part of the “____” section of the business intelligence framework.
- Aa.People
- Bb.Management
- Cc.Processes
- Dd.Governance
55.____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.
- Aa.DBMS
- Bb.OLAP
- Cc.Data warehousing
- Dd.MDM
66.The ____ contains business data extracted from the operational database and from external data sources.
- Aa.data store
- Bb.ETL tools
- Cc.data visualization tool
- Dd.data analysis tool
77.____ are in charge of presenting the data to the end user in a variety of ways.
- Aa.Data stores
- Bb.ETL tools
- Cc.Data visualization tools
- Dd.Data analysis tools
88.____provide a unified, single point of entry for information distribution.
- Aa.Decision support systems
- Bb.Portals
- Cc.Data warehouses
- Dd.Dashboards
99.Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
- Aa.decision support system
- Bb.portal
- Cc.data warehouse
- Dd.dashboard
1010.BusinessObjects is a(n) ____ tool
- Aa.OLAP
- Bb.data visualization
- Cc.data mining
- Dd.data warehouse
1111.Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.
- Aa.OLAP
- Bb.data mining
- Cc.governance
- Dd.networking
1212.____ systems provided no data extraction/integration process.
- Aa.Third-generation Mobile BI and cloud-based
- Bb.First-generation BI
- Cc.First-generation departmental decision support
- Dd.Traditional mainframe-based online transaction processing
1313.From the data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.
- Aa.usability
- Bb.dimensionality
- Cc.transaction processing
- Dd.sparsity
1414.A characteristic of decision support data is ____.
- Aa.high query activity
- Bb.high update volumes
- Cc.highly normalized
- Dd.low aggregation level
1515.A characteristic of operational data is ____.
- Aa.summarized data
- Bb.hundreds of gigabytes
- Cc.high normalization
- Dd.historic data
1616.In 2008, Wal-Mart, the world’s largest company, had over four ____ of data in its data warehouses.
- Aa.megabytes
- Bb.gigabytes
- Cc.terabytes
- Dd.petabytes
1717.Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
- Aa.volatility
- Bb.time-variation
- Cc.subject-orientation
- Dd.integration
1818.____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
- Aa.Data networks
- Bb.Data marts
- Cc.Data cubes
- Dd.OLAPs
1919.There are 12 rules that define a(n) ____.
- Aa.data warehouse
- Bb.multidimensional cube
- Cc.OLAP tool
- Dd.star schema
2020.The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.
- Aa.keys
- Bb.relationships
- Cc.cubes
- Dd.dimensions
2121.Computed or derived facts are sometimes called ____to differentiate them from stored facts.
- Aa.details
- Bb.attributes
- Cc.metrics
- Dd.fact tables
2222.In a star schema, dimensions are normally stored in ____.
- Aa.attributes
- Bb.indexes
- Cc.fact tables
- Dd.dimension tables
2323.In a star schema, attributes are often used to search, filter, or classify ____.
- Aa.tables
- Bb.stars
- Cc.fact
- Dd.dimensions
2424.The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly
predicted.- Aa.time
- Bb.cube
- Cc.third
- Dd.multi
2525.The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____and drilldown/roll up data analysis
- Aa.hierarchy
- Bb.de-normalization
- Cc.normalization
- Dd.aggregation
2626.Fact and dimension tables are related by ____ keys.
- Aa.shared
- Bb.primary
- Cc.foreign
- Dd.linked
2727.In a typical star schema, each dimension record is related to thousands of ____ records.
- Aa.attribute
- Bb.fact
- Cc.key
- Dd.star
2828.A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.
- Aa.snowflake
- Bb.starflake
- Cc.mesh
- Dd.matrix
2929.____splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time
- Aa.Normalization
- Bb.Meta modeling
- Cc.Replication
- Dd.Partitioning
3030.In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.
- Aa.GUI
- Bb.operational database
- Cc.multidimensional database
- Dd.data cube
3131.The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in
OLAP systems.- Aa.normalization
- Bb.denormalization
- Cc.star schema
- Dd.multidimensional schema
3232.Decision support data tend to be non-normalized, ____, and pre-aggregated.
- Aa.unique
- Bb.duplicated
- Cc.relational
- Dd.sorted
3333.The ____ schema is designed to optimize data query operations rather than data update operations.
- Aa.relational
- Bb.circle
- Cc.star
- Dd.matrix
3434.ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.
- Aa.SQL
- Bb.OLAP
- Cc.DDS
- Dd.BI
3535.A ____ index is based on 0 and 1 bits to represent a given condition.
- Aa.logical
- Bb.multidimensional
- Cc.star
- Dd.bitmapped
3636.Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a____.
- Aa.multi cube
- Bb.data matrix
- Cc.data cube
- Dd.hyper cube
3737.A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.
- Aa.table
- Bb.matrix
- Cc.network
- Dd.cube
3838.What is one of the main characteristics of OLAP systems?
- Aa.They use single-dimensional data analysis techniques.
- Bb.They provide complex command-line end-user interfaces.
- Cc.They provide minimal database support.
- Dd.They support client/server architecture.
3939.What is a characteristic of ROLAP?
- Aa.It uses the star schema
- Bb.It does not require high resources.
- Cc.It is limited to predefined dimensions.
- Dd.It has low flexibility.
4040.A(n) ____is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
- Aa.OLAP
- Bb.materialized view
- Cc.star schema
- Dd.data cube
Information
- Description
- asdf Quiz on Chapter 13 (MC), created by . . on 09/12/2016.
- Author
- . .
- Language
- English
- Views
- 255
- Tags
- Rating
- No ratings yet Rate this quiz