Chap 3 551

1. 1Which of the following data management technologies store data that are generated by business apps and operations?

   1. AData marts
   2. BData warehouses
   3. CDatabases
   4. DTransaction-processing systems (TPS).
2. 2________ tools and techniques process data and do statistical analysis for insight and discovery.

   1. AOperational intelligence
   2. BBusiness intelligence
   3. CInformation accessibility
   4. DInformation fluidity
3. 3Ad-hoc requests for specific data from a database or warehouse are called ___________.

   1. AUnplanned reports
   2. BRelational reports
   3. CVolatile
   4. DQueries
4. 4After data are extracted from a database and processed to standardize their format, they are then loaded into a ________ and ready for analysis.

   1. ASynchronized, low-latency system
   2. BDecision support system
   3. CData warehouse
   4. DDBMS
5. 5Users typically access data as needed from a database management system by using ________.

   1. ABI tools
   2. BSQL
   3. CTransaction processing
   4. DData filtering
6. 6Data in a ________ are volatile because record transactions.

   1. ADatabase
   2. BData warehouse
   3. CData mart
   4. DData silo
7. 7Organizations that cannot afford the cost of a data warehouse, but want the benefits of online analytic processing invest in___________.

   1. Aspreadsheets
   2. Bbig data
   3. Ctext mining
   4. Ddata marts
8. 8Data warehouses and data marts are optimized for all of the following except:

   1. ATransaction processing
   2. BData mining
   3. CBusiness intelligence
   4. DDecision support
9. 9An accurate and consistent view of data throughout the enterprise is needed so one can make informed, actionable decisions that support the business strategy. A function performed by a DBMS to integrate, match, or link data from disparate sources is data _____________.

   1. Afiltering
   2. Bprofiling
   3. Csynchronization
   4. Dmaintenance
10. 10NoSQL systems have increased in popularity because of the growing need for ________, which means the system can increase in size to handle data growth.

    1. Ascalability
    2. Bfault tolerance
    3. Chandling big data
    4. Dlarge Web apps

11. 11Which of the following is not a consequence of poor quality or dirty data?

    1. AThe company loses sales or customers
    2. BInformation workers are constrained in their jobs
    3. CDecision makers face too much uncertainty to make intelligent decisions
    4. DThe company faces data ownership problems
12. 12The primary benefits of centralized database configuration are better ___________ and ____________.

    1. AReports / Statistical Tools
    2. BQuality / Security
    3. CSpeed / Access
    4. DSoftware / Hardware
13. 13The primary disadvantage of centralized database systems is ________.

    1. AData security
    2. BData quality
    3. CAvailability of statistical analysis tools
    4. DTransmission delay when users are geo-dispersed
14. 14Distributed databases use ___________ architecture to process information requests.

    1. AClient/server
    2. BNoSQL
    3. CPrivate clouds
    4. DPublic clouds
15. 15In terms of the major functions performed by a DBMS, “data filtering and profiling” refers to which of the following?

    1. AInspecting the data for errors, inconsistencies, redundancies, and incomplete
       information.
    2. BCorrecting, standardizing, and verifying the integrity of the data.
    3. CIntegrating, matching, or linking data from disparate sources.
    4. DChecking and controlling data integrity over time.
16. 16Sometimes organizations place too much emphasis on the costs associated with acquiring high levels of data quality and ignore the costs of “dirty” or poor quality data. Which of the following sets of factors make up the total costs associated with poor quality data?

    1. ATechnology costs + Training costs + Marketing costs
    2. BValue of lost business + Cost to prevent errors + Cost to correct errors
    3. CCost of repeating analyses + Lost opportunity costs + Cost of unrealized threats
    4. DValue of lost business + Cost to correct errors + Cost of repeating analyses (on
       corrected data)
17. 17Despite the need for high-quality data, ____________ and technical issues often make it a difficult goal to achieve.

    1. AHigh costs
    2. BUntrained or undertrained IT personnel
    3. CUser errors
    4. DOrganizational politics
18. 18The principle of ________ explains why most organizations cannot operate at peak performance with blind spots (lack of data availability) of 30 days or longer. Global financial services institutions rely on near-real-time data for peak performance.

    1. Adata in context
    2. B90/90 data use
    3. Cdiminishing data value
    4. Ddata quality
19. 19According to the ________, a majority of data is seldom accessed after a 3 month period.

    1. APrinciple of data in context
    2. BPrinciple of 90/90 data use
    3. CPrinciple of diminishing data value
    4. DPrinciple of data quality
20. 20___________ is a set of processes that aid organizations in integrating data from various sources or enterprise applications to create and maintain a more unified view of a customer, product, or other core data entity that is shared across systems.

    1. AClient/server architecture
    2. BOLAP
    3. CMaster data management
    4. DData synchronization
21. 21MDM consolidates data from various data sources into a __________, which then feeds data back to the applications, thereby creating accurate and consistent data across the enterprise. This helps eliminate redundancies, inaccuracies and omissions that might otherwise hinder business processes.

    1. AData silo
    2. BMaster reference file
    3. CBackup file
    4. DCentral directory
22. 22________ enable managers to predict how customers would behave and use that knowledge to be prepared to respond quickly.

    1. ABig data analytics
    2. BData discovery
    3. CMaster data management
    4. DInformation optimization
23. 23In the past, data was transferred from OTLP databases to data warehouses periodically, say once a month or even once a week. Now, the trend is toward ___________, or real-time, data warehousing so that analysis and decision support apps use current data.

    1. AActive
    2. BAlways-on
    3. CDynamic
    4. DOperational
24. 24What is the key advantage of an active data warehouse compared to a traditional data warehouse?

    1. AThe ADW is less expensive to install and operate
    2. BData from an ADW can be used for DSS, report generation and Business
       Intelligence
    3. CData in an ADW is constantly updated, providing more current data than a
       traditional data warehouse
    4. DThe ADW is more widely available from a larger number of vendors
25. 25When customer X calls an organization’s customer service center, the service representative has access to a complete history of X’s previous calls, as a list of the services X has purchased, and customer profitability score. All of this information is up-to-date and is accessed from the company’s _________.

    1. AManagement information system
    2. BTransactional database system
    3. CActive data warehouse
    4. DOnline transaction processing system
26. 26The McKinsey Global Institute (MGI) estimates that retailers using big data analytics increase their operating margin by more than ________ percent.

    1. A10
    2. B20
    3. C40
    4. D60
27. 27________ processes move data from databases into data warehouses or data marts, where the data are available for access, reports, and analysis.

    1. ABig data analytics
    2. BData mining
    3. CExtract, transformation, load (ETL)
    4. DData de-duplication
28. 28Machine-generated sensor data from________ are becoming a much larger proportion of big data and analytics.

    1. Aphysical objects
    2. Bsatellites
    3. Csmartphones
    4. Dvehicles
29. 29Big data volumes that exceed the processing capacity of conventional infrastructures are processed using the ________ platform.

    1. AOracle
    2. BHadoop
    3. CADW
    4. DMySQL
30. 30____________ software enables users to analyze data from various dimensions or angles, categorize them, and find correlations or patterns among fields in the data warehouse.

    1. ANoSQL
    2. BData mining
    3. CHadoop
    4. DNexus
31. 31_____________ helps companies tap into the massive volume of customer opinions expressed online.

    1. AMedia metrics
    2. BUnstructured analytics
    3. CText mining
    4. DMedia mining
32. 32With text analytics, information is extracted out of large quantities of various types of textual information. Which of the following is not one of the steps involved in text analytics described in your text?

    1. AExploration of documents for preliminary categorization or identification of
       common topics
    2. BPreprocessing of documents to standardize content as much as possible
    3. CCategorization and modeling of document content using statistical models and
       business rules
    4. DVisualization – translating text data to graphic format (e.g. charts, graphs) for
       effective reporting
33. 33Which of the following is not a risk associated with cloud-based BI?

    1. ASlower response time
    2. BSecurity risk
    3. CBackup risk
    4. DIncreased costs
34. 34All of the following are factors contributing to the increased use of BI, except:

    1. ASmart devices and demand for 24/7 access to insights
    2. BProprietary information systems
    3. CCloud-enabled BI and analytics
    4. DIncreased amounts of data
35. 35________ are documentation of business events, actions, decisions, or transactions.

    1. Adata
    2. Breports
    3. Cinformation
    4. Drecords
36. 36______________ systems consist of hardware and software that manage and archive electronic documents and image paper documents; then index and store them according to company policy.

    1. AElectronic records management
    2. BBusiness management
    3. CCompliance
    4. DDigital Document
37. 37________ must ensure that their companies comply with legal and regulatory duties by managing electronic records.

    1. ASenior management
    2. BCIOs
    3. CCorporate lawyers
    4. DWorkers
38. 38Improperly managed or destroyed business records become ________.

    1. Aarchives
    2. Bliabilities
    3. Cbreach of contracts
    4. Dlawsuits
39. 39Companies have always faced the challenge of managing physical documents. Which of the following is the most significant challenge associated with managing physical documents?

    1. AThe volume of documents that must be reviewed to determine if they should be
       retained or destroyed
    2. BLoading documents onto company websites
    3. CSharing documents across geographic locations
    4. DTranslating documents into other languages
40. 40The supply of oranges used by Coca-Cola has a three-month growing season, but orange juice production is year-round. Therefore, producing orange juice with a consistent taste year-round is complex. How does Coca-Cola deal with this complexity and keep their orange juice taste consistent?

    1. AAn orange juice decision model was developed that combines detailed data on the 600+ flavors that make up an orange.
    2. BA decentralized data model was developed to respond to consumer preferences.
    3. CLegacy systems were replaced with data silos to manage big data.
    4. DA data governance program was implemented to ensure that juice preferences are achieved.

Descripción

Information Technology Test sobre Chap 3 551, creado por Huy Anh Vo el 06/06/2019.

Autor

Huy Anh Vo

Idioma

English

Visitas

1

Etiquetas

information technology

Valoración

Aún sin valoraciones

Valora este test

Valora este test

Más sobre Data Warehousing and Emerging Database Technologies