Q&A Hero

Q: ______________are in charge of presenting data to the end user in a variety of ways.a. Data storesb. ETL toolsc. Data visualization toolsd. Data analysis tools

Q: 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 tool

Q: The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one. a. True b. False

Q: ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework. a. True b. False

Q: A star schema is designed to optimize data query operations rather than data update operations. a. True b. False

Q: 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. False

Q: Multidimensional data analysis techniques include advanced computational functions. a. True b. False

Q: Explanatory analytics employs mathematical and statistical algorithms, neural networks, artificial intelligence, and other advanced modeling tools to create actionable predictive models based on available data. a. True b. False

Q: In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes. a. True b. False

Q: Business intelligence tools use the data warehouse data as the raw materials for data analytics to generate business knowledge. a. True b. False

Q: 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. Trueb. False

Q: 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. False

Q: Normalizing fact tables improves data access performance and saves data storage space. a. True b. False

Q: 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. False

Q: The data warehouse development life cycle differs from classical systems development. a. True b. False

Q: Relational data warehouses use multidimensional data schema support to handle multidimensional data. a. True b. False

Q: Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS. a. True b. False

Q: Queries against operational data typically are broad in scope and high in complexity. a. True b. False

Q: Decision support data are a snapshot of the operational data at a given point in time. a. True b. False

Q: Operational data and decision support data serve the same purpose. a. True b. False

Q: Master data management's main goal is to provide a partial and segmented definition of all data within an organization. a. True b. False

Q: A data store is used by data analysts to create queries that access the database. a. True b. False

Q: Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components. a. True b. False

Q: Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom. a. True b. False

Q: ___________________management ensures that data move from one consistent state to another.

Q: In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a______________ .

Q: One of the advantages of a distributed database management system (DDBMS) is processor____________ .

Q: One of the advantages of a distributed database management system (DDBMS) is less danger of a single-________ failure.

Q: A user-friendly ___________is one advantage of a distributed database management system (DDBMS) .

Q: One of the advantages of a distributed database management system (DDBMS) is ___________operating cost.

Q: A(n)_____________ database stores each database fragment at a single site.a. partially replicatedb. unreplicatedc. fully replicatedd. partitioned

Q: The___________ rule requires that all copies of data fragments be identical.a. shared fragmentb. mutual consistencyc. horizontal fragmentationd. replication

Q: ___________fragmentation refers to the division of a relation into attribute subsets.a. Datab. Horizontalc. Verticald. Mixed

Q: _______________fragmentation refers to the division of a relation into subsets of tuples.a. Verticalb. Horizontalc. Datad. Mixed

Q: _____________fragmentation allows a user to break a single object into two or more segments, or fragments.a. Horizontalb. Verticalc. Datad. Request

Q: _____________is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.a. Data distributionb. Replica transparencyc. Network latencyd. Network partitioning

Q: The objective of_____________ optimization is to minimize the total cost associated with the execution of a request.a. datab. remotec. transactiond. query

Q: A _____________lets a single SQL statement access the data that are to be processed by a single remote database processor.a. remote requestb. remote transactionc. distributed requestd. distributed transaction

Q: The_____________ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.a. DO-UNDO-REDO protocolb. two-phase commit protocol (2PC)c. coordinator protocold. write-ahead protocol

Q: A___________ request lets a single SQL statement reference data located at several different local or remote DP sites.a. distributedb. transactionc. fragmentedd. remote

Q: A distributed ___________can reference several different local or remote data processing sites.a. requestb. sitec. data locationd. transaction

Q: A__________ contains the description of the entire database as seen by the database administrator.a. distributed global dictionaryb. distributed data dictionaryc. distributed global schemad. distributed data schema

Q: _______________transparency exists when the end user or programmer must specify both the fragment names and their locations.a. Local mappingb. Locationc. Performanced. Fragmentation

Q: _____________transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.a. Transactionb. Locationc. Local mappingd. Fragmentation

Q: ___________transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.a. Performanceb. Fragmentationc. Locationd. Local mapping

Q: ________________transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema.a. Transactionb. Performancec. Distributiond. Heterogeneity

Q: _________________transparency allows the system to operate as if it were a centralized database management system.a. Heterogeneityb. Distributionc. Performanced. Failure

Q: ____________transparency ensures that the system will continue to operate in the event of a node or network malfunction.a. Transactionb. Distributionc. Failured. Performance

Q: _____________transparency allows data to be updated simultaneously at several network sites.a. Transactionb. Distributionc. Failured. Performance

Q: __________________transparency allows a physically dispersed database to be managed as though it were centralized.a. Distributionb. Transactionc. Failured. Performance

Q: A____________ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.a. fully heterogeneousb. fully homogeneousc. homogeneousd. heterogeneous

Q: ____________distributed database systems integrate different types of centralized database management systems (DBMS) over a network.a. Homogeneousb. Heterogeneousc. Fully homogeneousd. Combination

Q: _____ distributed database management system (DDBMS) integrate multiple instances of the same DBMS over a network.a. Homogeneousb. Heterogeneousc. Fully heterogeneousd. Combination

Q: A DDBMS is subject to which of the following restrictions?a. Multiple instances of the same database should be integrated over a network.b. All database processing must be done at a single site.c. Rapid ad hoc data access is not possible.d. Remote data access is provided on a read-only basis.

Q: Under___________ the scenario, all record- and file-locking activities are performed at the end-user location.a. single-site processing, single-site datab. multiple-site processing, single-site datac. single-site processing, multiple-site datad. multiple-site processing, multiple-site data

Q: The_______________ processor is the software component residing on each computer that stores and retrieves data located at the site.a. transactionb. networkc. datad. management

Q: In theory, a(n)___________ can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.a. transaction processorb. application processorc. transaction managerd. data processor

Q: The______________ processor is the software component found in each computer that requests data. It receives and processes the application's data requests.a. databaseb. transactionc. datad. network

Q: A database management system needs_____________ to prepare the data for presentation to the end user or to an application program.a. securityb. concurrency controlc. formattingd. I/O interface

Q: Distributed processing does not require: a. database processing functions to be distributed to all data storage sites. b. an existing distributed database. c. a network of interconnected components. d. multiple sites to share processing chores.

Q: A distributed database is composed of several parts known as database_______________ .a. sectionsb. fragmentsc. partitionsd. parts

Q: Which of the following is an advantage associated with a distributed database management system (DDBMS)?a. Reduced operating costsb. Simplicity of management and controlc. Decreased storage requirementsd. Decreased training costs

Q: _______________is a disadvantage of a distributed database management system (DDBMS).a. Processor dependenceb. Lack of graphical user interfacec. Security lapsed. Increased danger of a single-point failure

Q: A disadvantage of a distributed database management system (DDBMS) is that: a. it is slower in terms of data access. b. adding new sites affects other sites' operations. c. it is processor dependent. d. there are lack of standards.

Q: A centralized database management is subject to a problem such as_______________________ .a. a growing number of remote locationsb. maintaining and operating small database systemsc. dependence on multiple sitesd. organizational flexibility of the database

Q: A remote transaction, composed of several requests, may access data at multiple sites. a. True b. False

Q: Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.a. Trueb. False

Q: The level of transparency supported by the distributed database management system remains the same for all systems.a. Trueb. False

Q: Distribution transparency is supported by a distributed data dictionary.a. Trueb. False

Q: Performance transparency ensures that the system finds the most cost-effective path to access remote data. a. True b. False

Q: In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.a. Trueb. False

Q: A transaction processor (TP) is the software component residing on each computer that stores and retrieves data located at the site.a. Trueb. False

Q: A distributed database management system (DDBMS) must be communications-media-dependent.a. Trueb. False

Q: The transaction processor (TP) is the software component found in each computer that requests data.a. Trueb. False

Q: A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.a. Trueb. False

Q: A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.a. Trueb. False

Q: Both distributed processing and distributed databases require a network of interconnected components. a. True b. False

Q: In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites. a. True b. False

Q: Distributed processing does not require a distributed database, and a distributed database does not require distributed processing. a. True b. False

Q: Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network. a. True b. False