mdm9e_tif12
21 Pages

mdm9e_tif12

Course Number: IDS 410, Spring 2011

College/University: Ill. Chicago

Word Count: 4221

Rating:

Document Preview

Modern Database Management, Ninth Edition 9 Chapter 12 Data Quality and Integration MULTIPLE CHOICE: Choose the one alternative that best completes the statement or answers the question. 1. High quality data are data that are A) Accurate B) Consistent C) Available in a timely fashion D) All of the above Answer: D Level: Easy Page Ref: 524 Topic: Managing Quality Data AACSB Use of Information Technology,...

Unformatted Document Excerpt
Coursehero >> Illinois >> Ill. Chicago >> IDS 410

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Database Modern Management, Ninth Edition 9 Chapter 12 Data Quality and Integration MULTIPLE CHOICE: Choose the one alternative that best completes the statement or answers the question. 1. High quality data are data that are A) Accurate B) Consistent C) Available in a timely fashion D) All of the above Register to View AnswerLevel: Easy Page Ref: 524 Topic: Managing Quality Data AACSB Use of Information Technology, Analytic Skills 2. A) B) C) D) Data quality ROI stands for: Return on investment Risk of incarceration Rough outline inclusion None of the above Register to View AnswerLevel: Easy Page Ref: 524 Topic: Managing Quality Data AACSB Use of Information Technology, Analytic Skills 3. A) B) C) D) Data quality is important for all of the following reasons except: It minimizes project delay It aids in making timely business decisions It provides a stream of profit It helps to expand the customer base Register to View AnswerLevel: Moderate Page Ref: 524 Topic: Managing Quality Data AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 10 Data Quality and Integration 4. A) B) C) D) Chapter 12 Quality data can be defined as being: Unique Inaccurate Historical Precise Register to View AnswerLevel: Easy Page Ref: 524-525 Topic: Managing Quality Data AACSB Use of Information Technology 5. A) B) C) D) Conformance means that Data have been transformed Data are stored, exchanged or presented in a format that is specified by its metadata. Data are stored in a way to expedite retrieval. None of the above. Register to View AnswerLevel: Easy Page Ref: 525 Topic: Managing Quality Data AACSB Use of Information Technology 6. A) B) C) D) One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is: Currency Consistency Referential Integrity Timeliness Register to View AnswerLevel: Easy Page Ref: 525 Topic: Managing Quality Data AACSB Use of Information Technology 7. A) B) C) D) Experts estimate that ________________ data warehousing projects fail because users reject the data as unreliable. All Half of No Seventy percent of Register to View AnswerLevel: Easy Page Ref: 526 Topic: Managing Quality Data Sub-Topic: The State of Data Quality AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 8. A) B) C) D) External data sources present problems for data quality because: Data are not always available. There is a lack of control over data quality There are poor data capture controls. Data are unformatted. Register to View AnswerLevel: Easy Page Ref: 526 Topic: Managing Quality Data Sub-topic: The State of Data Quality AACSB Use of Information Technology 9. A) B) C) D) Data quality problems can cascade when Data are not deleted properly. Data are copied from legacy systems. There is redundant data storage and inconsistent metadata. There are data entry problems. Register to View AnswerLevel: Easy Page Ref: 527 Topic: Managing Quality Data Sub-Topic: Redundant data storage and inconsistent metadata. AACSB Use of Information Technology 10. The best place to improve data entry across all applications is: A) In the users B) In the level of organizational commitment C) In the database definitions D) In the data entry operators Register to View AnswerLevel: Easy Page Ref: 527 Topic: Managing Quality Data Sub-Topic: Data Entry AACSB Use of Information Technology 11. A) B) C) D) Which of the following are key steps in a data quality program? Conduct a data quality audit Apply TQM principles and practices Estimate return on investment All of the above. Register to View AnswerLevel: Moderate Page Ref: 528 Topic: Managing Quality Data Sub-Topic: Data Quality Improvement AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 11 12 Data Quality and Integration 12. A) B) C) D) Chapter 12 One simple task of a data quality audit is to: Interview all users Statistically profile all files Load all data into a data warehouse Establish quality metrics. Register to View AnswerLevel: Moderate Page Ref: 527 Topic: Managing Quality Data Sub-Topic: Data Quality Improvement AACSB Use of Information Technology 13. A) B) C) D) One way to improve the data capture process is to: Allow all data to be entered manually Provide little or no training to data entry operators Check entered data immediately for quality against data in the database Not use any automatic data entry routines Register to View AnswerLevel: Easy Page Ref: 529 Topic: Managing Quality Data Sub-Topic: Data Quality Improvement AACSB Use of Information Technology 14. A person assigned the responsibility of ensuring data quality in the organization is called a(n): A) Data steward B) Data manager C) Database administrator D) Business analyst Register to View AnswerLevel: Easy Page Ref: 530 Topic: Managing Quality Data Sub-Topic: Data Quality Improvement AACSB Use of Information Technology 15. A) B) C) D) Data governance can be defined as: A means to slow down the speed of data. High-level organizational groups and processes that oversee data stewardship. A government task force for defining data quality. None of the above. Register to View AnswerLevel: Easy Page Ref: 530 Topic: Managing Quality Data Sub-Topic: Data Quality Improvement AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 16. A) B) C) D) TQM stands for: Thomas Quinn Mann, a famous data quality innovator Total Quality Manipulation Transforming Quality Management Total Quality Management Register to View AnswerLevel: Easy Page Ref: 531 Topic: Managing Quality Data Sub-Topic: Data Quality Improvement AACSB Use of Information Technology 17. A) B) C) D) When creating a sound data model, entity types should represent and be named after: The role that the entity plays in a context The underlying object Random events Actors Register to View AnswerLevel: Easy Page Ref: 532 Topic: Managing Quality Data Sub-Topic: Data Quality Improvement AACSB Use of Information Technology 18. A) B) C) D) All of the following are ways to consolidate data except: Application integration Data rollup and integration Business process integration User interaction integration Register to View AnswerLevel: Easy Page Ref: 533-534 Topic: Data Integration: An Overview Sub-Topic: General Approaches to Data Integration AACSB Use of Information Technology 19. A) B) C) Data federation is a technique which: Creates an integrated database from several separate databases. Creates a distributed database Provides a virtual view of integrated data without actually creating one centralized database. D) Provides a real-time update of shared data. Register to View AnswerLevel: Easy Page Ref: 534 Topic: Data Integration: An Overview Sub-Topic: Data Federation AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 13 14 20. A) B) C) D) Data Quality and Integration Chapter 12 _________________ duplicates data across databases. Data propagation Data duplication Redundant replication A replication server Register to View AnswerLevel: Easy Page Ref: 534 Topic: Data Integration: An Overview Sub-Topic: Data Propagation AACSB Use of Information Technology 21. A) B) C) D) Event-drive propagation Provides a means to duplicate data for events Pushes data to duplicate sites as an event occurs Pulls duplicate data from redundant sites None of the above. Register to View AnswerLevel: Easy Page Ref: 534 Topic: Data Integration: An Overview Sub-Topic: Data Propagation AACSB Use of Information Technology 22. A) B) C) D) The major advantage of data propagation is: Real-time cascading of data changes throughout the organization. Duplication of non-redundant data The ability to have trickle-feeds None of the above Register to View AnswerLevel: Easy Page Ref: 534 Topic: Data Integration: An Overview Sub-Topic: Data Propagation AACSB Use of Information Technology 23. A) B) C) D) The methods to ensure the quality of data across various subject areas are called: Variable Data Management Master Data Management Joint Data Management Managed Data Management Register to View AnswerLevel: Easy Page Ref: 535 Topic: Data Integration: An Overview Sub-Topic: Master Data Management AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 24. A) B) C) D) 15 All of the following are popular architectures for Master Data Management except:: Identity Registry Integration Hub Persistent Object Normalization Register to View AnswerLevel: Moderate Page Ref: 536 Topic: Data Integration: An Overview Sub-Topic: Master Data Management AACSB Use of Information Technology 25. In the ________________ approach, one consolidated record is maintained and all applications draw on that one actual "golden" record. A) Persistent B) Identity Registry C) Federated D) Integration Hub Register to View AnswerLevel: Moderate Page Ref: 536 Topic: Data Integration: An Overview Sub-Topic: Master Data Management AACSB Use of Information Technology 26. A) B) C) D) A characteristic of reconciled data that means the data reflect an enterprisewide view is: detailed. historical. normalized. comprehensive. Register to View AnswerLevel: Moderate Page Ref: 538 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: Characteristics of Data after ETL AACSB Use of Information Technology 27. Informational and operational data differ in all of the following ways EXCEPT: A) level of detail. B) normalization level. C) scope of data. D) data quality. Register to View AnswerLevel: Moderate Page Ref: 58 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: Characteristics of Data after ETL AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 16 Data Quality and Integration Chapter 12 28. A method of capturing only the changes that have occurred in the source data since the last capture is called _____ extract. A) static B) incremental C) partial D) update-driven Register to View AnswerLevel: Easy Page Ref: 540 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 29. A method of capturing only the changes that have occurred in the source data since the last capture is called _____ extract. A) static B) incremental C) partial D) update-driven Register to View AnswerLevel: Easy Page Ref: 540 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 30. A) B) C) D) A technique using artificial intelligence to upgrade the quality of raw data is called: dumping. data reconciliation. completion backwards updates. data scrubbing. Register to View AnswerLevel: Easy Page Ref: 542 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 31. A) B) C) D) All of the following are tasks of data cleansing EXCEPT: decoding data to make them understandable for data warehousing applications. adding time stamps to distinguish values for the same attribute over time. generating primary keys for each row of a table. creating foreign keys. Register to View AnswerLevel: Moderate Page Ref:542 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 32. An approach to filling a data warehouse that employs bulk rewriting of the target data periodically is called: A) dump mode. B) overwrite mode. C) refresh mode. D) update mode. Register to View AnswerLevel: Easy Page Ref: 543 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 33. A) B) C) D) Which type of index is commonly used in data warehousing environments? Join index Bit-mapped index Secondary index Both A and B Register to View AnswerLevel: Moderate Page Ref: 543 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 34. A) B) C) D) Loading data into a data warehouse involves: appending new rows to the tables in the warehouse. updating existing rows with new data. purging data that have become obsolete or were incorrectly loaded. all of the above. Register to View AnswerLevel: Moderate Page Ref: 543-544 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 17 18 Data Quality and Integration Chapter 12 35. A) B) C) D) Data may be loaded from the staging area into the warehouse by following: SQL Commands (Insert/Update) Special load utilities Custom-written routines All of the above 36. A) B) C) D) Register to View AnswerLevel: Moderate Page Ref: 544 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology The process of combining data from various sources into a single table or view is called: extracting. updating. selecting. joining. 37. A) B) C) D) Register to View AnswerLevel: Easy Page Ref: 545 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology The process of transforming data from a detailed to a summary level is called: extracting. updating. joining. aggregating. Register to View AnswerLevel: Easy Page Ref: 546 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology 38. A) B) C) D) Which of the following is a basic method for single field transformation? Table lookup Cross-linking entities Cross-linking attributes Field-to-field communication Register to View AnswerLevel: Moderate Page Ref: 546 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition TRUE/FALSE: Write T if the statement is true and F if the statement is false. 39. Quality data are not essential for well-run organizations. Register to View AnswerLevel: Easy Page Ref: 522 Topic: Introduction AACSB Use of Information Technology 40. ETL is short for Extract, Tranform, Load. Register to View AnswerLevel: Easy Page Ref: 523 Topic: Introduction AACSB Use of Information Technology 41. There are six major steps to ETL. Register to View AnswerLevel: Easy Page Ref: 523 Topic: Introduction AACSB Use of Information Technology 42. Dirty data saves work for information systems projects. Register to View AnswerLevel: Easy Page Ref: 524 Topic: Managing Data Quality AACSB Use of Information Technology 43. Data quality is essential for SOX and Basel II compliance. Register to View AnswerLevel: Easy Page Ref: 524 Topic: Managing Quality AACSB Data Use of Information Technology 44. Quality data does not have to be unique. Register to View AnswerLevel: Easy Page Ref: 524 Topic: Managing Data Quality AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 19 20 Data Quality and Integration Chapter 12 45. Completeness means that all data that are needed are present. Register to View AnswerLevel: Easy Page Ref: 525 Topic: Managing Data Quality AACSB Use of Information Technology 46. Retention refers to the amount of data that is not purges periodically from tables. Register to View AnswerLevel: Easy Page Ref: 525 Topic: Managing Data Quality AACSB Use of Information Technology 47. Bad data can cost a business between 10 and 20 percent of its revenue. Register to View AnswerLevel: Moderate Page Ref: 526 Topic: Managing Data Quality Sub-topic: The State of Quality data AACSB Use of Information Technology 48. Generally, records in a customer file never become obsolete. Register to View AnswerLevel: Moderate Page Ref: 526 Topic: Managing Data Quality Sub-topic: The State of Quality data AACSB Use of Information Technology 49. Data which arrive via XML and B2B channels is always guaranteed to be accurate. Register to View AnswerLevel: Moderate Page Ref: 527 Topic: Managing Data Quality Sub-topic: External Data Sources AACSB Use of Information Technology 50. The uncontrolled proliferation of spreadsheets, databases and repositories leads to data quality problems. Register to View AnswerLevel: Moderate Page Ref: 527 Topic: Managing Data Quality Sub-topic: External Data Sources AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 21 51. A data quality audit helps an organization understand the extent and nature of data quality problems. Register to View AnswerLevel: Easy Page Ref: 528 Topic: Managing Data Quality Sub-topic: Data Quality Improvement AACSB Use of Information Technology 52. A data stewardship program does not help to involve the organization in data quality. Register to View AnswerLevel: Easy Page Ref: 528 Topic: Managing Data Quality Sub-topic: Data Quality Improvement AACSB Use of Information Technology 53. Improving the data capture process overcomes the garbage in, garbage out phenomenon. Register to View AnswerLevel: Easy Page Ref: 528 Topic: Managing Data Quality Sub-topic: Data Quality Improvement AACSB Use of Information Technology 54. A data steward is a person assigned the responsibility of ensuring the organizational applications properly support the organization's enterprise goals for data quality. Register to View AnswerLevel: Easy Page Ref: 530 Topic: Managing Data Quality Sub-topic: Data Quality Improvement AACSB Use of Information Technology 55. A data governance committee is always made up of high-ranking government officials. Register to View AnswerLevel: Easy Page Ref: 530 Topic: Managing Data Quality Sub-topic: Data Quality Improvement AACSB Use of Information Technology 56. User interaction integration is achieved by creating fewer user interfaces. Register to View AnswerLevel: Easy Page Ref: 534 Topic: Data Integration: An Overview Sub-topic: General Approaches to Data Integration AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 22 57. Data Quality and Integration Chapter 12 Data federation consolidates all data into one database. Register to View AnswerLevel: Easy Page Ref: 534 Topic: Data Integration: An Overview Sub-topic: Data Federation AACSB Use of Information Technology 58. The major advantage of the data propagation approach to data integration is the near realtime cascading of data changes throughout the organization. Register to View AnswerLevel: Easy Page Ref: 534 Topic: Data Integration: An Overview Sub-topic: Data Propagation AACSB Use of Information Technology 59. Master data management is the disciplines, technologies and methods to ensure the currency, meaning and quality of data within one subject area. Register to View AnswerLevel: Easy Page Ref: 535 Topic: Data Integration: An Overview Sub-topic: Master Data Management AACSB Use of Information Technology 60. The data reconciliation process is responsible for transforming operational data to reconciled data. Register to View AnswerLevel: Easy Page Ref:537 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: Characteristics of Data after ETL AACSB Use of Information Technology 61. After the extract, transform, and load is done on data, the data warehouse is never fully normalized. Register to View AnswerLevel: Easy Page Ref: 537 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: Characteristics of Data after ETL AACSB Use of Information Technology 62. Data reconciliation occurs in two stages, an initial load and subsequent updates. Register to View AnswerLevel: Moderate Page Ref: 538 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: Characteristics of Data after ETL AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 23 63. Static extract is a method of capturing only the changes that have occurred in the source data since the last capture. Register to View AnswerLevel: Easy Page Ref: 540 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 64. One of the biggest challenges of the extraction process is managing changes in the source system. Register to View AnswerLevel: Difficult Page Ref: 540 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 65. Data are moved to the staging area before extraction takes place. Register to View AnswerLevel: Moderate Page Ref: 540 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 66. Data scrubbing is a technique using pattern recognition and other artificial intelligence techniques to upgrade the quality of raw data before transforming and moving the data to the data warehouse. Register to View AnswerLevel: Easy Page Ref: 542 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 67. Total quality management (TQM) focuses on defect correction rather than defect prevention. Register to View AnswerLevel: Difficult Page Ref: 542 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 24 Data Quality and Integration Chapter 12 68. Refresh mode is an approach to filling the data warehouse that employs bulk rewriting of the target data at periodic intervals. Register to View AnswerLevel: Easy Page Ref: 543 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 69. Update mode is used to create a data warehouse. Register to View AnswerLevel: Easy Page Ref: 543 Topic: The Reconciled Data Layer Subtopic: The ETL Process Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 70. Bit-mapped indexing is often used in a data warehouse environment. Register to View AnswerLevel: Easy Page Ref: 543 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 71. Loading data into the warehouse typically means appending new rows to tables in the warehouse as well as updating existing rows with new data. Register to View AnswerLevel: Easy Page Ref: 543 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 72. Data transformation is not an important part of the data reconciliation process. Register to View AnswerLevel: Easy Page Ref: 544 Topic: Data Transformation AACSB Use of Information Technology 73. Joining is often complicated by problems such as errors in source data. Register to View AnswerLevel: Moderate Page Ref:545 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 25 74. The process of transforming data from detailed to summary levels is called normalization. Register to View AnswerLevel: Easy Page Ref: 546 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology 75. Data quality tools are used to assess the quality of existing systems and compare them to the requirements of the data warehouse. Register to View AnswerLevel: Moderate Page Ref: 547 Topic: Data Transformation Subtopic: Tools to Support Data Reconciliation x AACSB Use of Information Technology 76. Data conversion tools can support data transformation in a data warehousing environment. Register to View AnswerLevel: Moderate Page Ref: 549 Topic: Data Transformation Subtopic: Tools to Support Data Reconciliation x AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 26 Data Quality and Integration Chapter 12 SHORT ANSWER: Write the word or phrase that best completes each statement or answers the question. ___________ ______________ can cause delays and extra work on information systems projects. Answer: dirty data Level: Easy Page Ref: 524 Topic: Managing Data Quality AACSB Use of Information Technology 77. 78. Completeness means that all data that must have a ______________ does have a ____________. Answer: value Level: Easy Page Ref: 525 Topic: Managing Data Quality AACSB Use of Information Technology 79. Conformance refers to whether the data is stored, exchanged or presented in a format that is as specified by its ___________________. Answer: metadata Level: Easy Page Ref: 525 Topic: Managing Data Quality AACSB Use of Information Technology 80. Experts estimate that up to seventy percent of data warehousing projects fail because users reject the data as _____________. Answer: unreliable Level: Easy Page Ref: 526 Topic: Managing Data Quality Subtopic: The State of Quality Data AACSB Use of Information Technology 81. A(n) _______________ will thoroughly review all process controls on data entry and maintenance. Answer: audit Level: Easy Page Ref: 528 Topic: Managing Data Quality Subtopic: The State of Quality Data AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 27 82. Improving _____________ ____________________ ______________ is a fundamental step in data quality improvement. Answer: data capture processes Level: Easy Page Ref: 529 Topic: Managing Data Quality Subtopic: The State of Quality Data AACSB Use of Information Technology 83. A _____________ _______________ is a person assigned the responsibility of ensuring that organizational applications properly support the organization's enterprise goals of data quality. Answer: data steward Level: Easy Page Ref: 530 Topic: Managing Data Quality Subtopic: The State of Quality Data AACSB Use of Information Technology 84. Sound data ___________________ is a central ingredient of a data quality program. Answer: modeling Level: Easy Page Ref: 531 Topic: Managing Data Quality Subtopic: The State of Quality Data AACSB Use of Information Technology ________________ _____________________ is achieved by coordinating the flow of event information between business applications. Answer: application integration Level: Easy Page Ref: 533 Topic: Data Integration: An Overview AACSB Use of Information Technology 85. 86. User interaction integration is achieved by creating fewer ______________ _____________ that feed different systems. Answer: user interfaces Level: Easy Page Ref: 534 Topic: Data Integration: An Overview AACSB Use of Information Technology 87. ______________________ _______________________ provides a virtual view of integrated data without actually bringing the data into one physical database. Answer: data federation Level: Easy Page Ref: 534 Topic: Data Integration: An Overview AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall 28 88. Data Quality and Integration Chapter 12 Data propagation duplicates data across databases, usually with no _________ delay. Answer: real-time Level: Easy Page Ref: 534 Topic: Data Integration: An Overview AACSB Use of Information Technology 89. In the _______________ approach, one consolidated record is maintained from which all applications draw data. Answer: persistent Level: Easy Page Ref: 536 Topic: Data Integration: An Overview AACSB Use of Information Technology 90. A method of capturing data in a snapshot at a point in time is called _____ extract. Answer: static Level: Easy Page Ref: 540 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 91. A technique using pattern recognition to upgrade the quality of raw data is called _____. Answer: data scrubbing Level: Easy Page Ref: 542 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 92. An approach in which only changes in the source data are written to the data warehouse is called _____. Answer: update mode Level: Easy Page Ref: 543 Topic: Data Integration for Data Warehousing: The Reconciled Data Layer Subtopic: The ETL Process AACSB Use of Information Technology 93. Converting data from the format of its source to the format of its destination is called _________ _________. Answer: data transformation Level: Easy Page Ref: 544 Topic: Data Transformation AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall Modern Database Management, Ninth Edition 94. 29 The process of partitioning data according to predefined criteria is called _____. Answer: selection Level: Easy Page Ref: 545 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology 95. The process of transforming data from a detailed to a summary level is called __________. Answer: aggregation Level: Easy Page Ref: 546 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology 96. A(n) _________ ___________ function converts data from a given format in a source record to a different format in a target record. Answer: field-level Level: Moderate Page Ref: 546 Topic: Data Transformation Subtopic: Data Transformation Functions AACSB Use of Information Technology Copyright 2009 Pearson Education, Inc. Publishing as Prentice Hall

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Ill. Chicago - IDS - 410
Modern Database Management, Ninth Edition243Chapter 11 Data WarehousingMULTIPLE CHOICE: Choose the one alternative that best completes the statementor answers the question.1.The analysis of summarized data to support decision making is called:A)op
Ill. Chicago - IDS - 521
Step-By-Step Instructions on How toInstallSQL Server 2008 R2 Express,SQL Server 2008 Management Studio,andVisual Web Developer 2010 Express1. DownloadSQLEXPRWT_x86_ENU.exe fromhttp:/www.microsoft.com/express/DatabaseBe sure to download the corre
Ill. Chicago - IDS - 521
-One potential solution for Deliverable 3.-NOTE 1: Make sure that you use the appropriate database (i.e., ASPNETDB.MDF)-NOTE 2: The following tables are already created in ASPNETDB.MDF:-aspnet_Users, aspnet_Roles, aspnet_UsersInRoles-Therefore, we do
Ill. Chicago - IDS - 572
IDS 572 Fall 2011Data Mining Project10/13/2011The Data Mining Project 60% of gradeReports should be around 25 pages, include a title page, table of contents, page numbers, captions and numbers for graphsand tables.Sections for the following:Busines
Ill. Chicago - IDS - 572
September 8, 2011 IDS572 Assignment 1 due 9/15/11Review the article below and the information in the table that follows then answer the questions on page 7.NIU president unveils grand visionFacing dwindling state help, university plans to raise profile
Ill. Chicago - IDS - 572
IDS 572 Data Mining for Business4 Credit HoursFall 2011Thursdays 6:00-8:30pmL270Instructor:Kenneth Stehlik-Barry,PhDPrincipal AnalyticsConsultantIBM312 451.3540(m)kensb@uic.eduOffice Hours:Thursday 5:00-5:50pmOther times byappointment.COU
Ill. Chicago - IDS - 572
IDS 572Neural NetworksSeptember 15, 20111Pattern Recognition2Example using the letters T and HExact pattern match3Partial matches4Indeterminate pattern fits either T or H imperfectly5Neural Networks:Sample NetworkX1X2X3y1y2X4 Neurons
Ill. Chicago - IDS - 572
IDS572ClusteringSeptember 22, 20111Unsupervised Learning Method514232Distance measures3Distance measures4Environment measures from GSS935Environment measures from GSS936Environment measures from GSS937Clustering MethodsHierarchicalK
Ill. Chicago - IDS - 552
IDS 552 Fall 2008 Supply Chain ManagementProf. James K. Ho http:/www.uic.edu/~jimho e-mail: jimho @ uic.eduSection # 27838 T 1800 2030 LC C6Office: UH 2407Blackboard Site: IDS552F08Hours: T 4:00 5:00 R 1:00 2:00 (other hours by appointment)Scope:Wi
Ill. Chicago - MBA - 590
University of Illinois at ChicagoMBA 590 Professional Topics SeminarLEADERSHIP & IMPROVISATIONCOURSE SYLLABUSFall Semester 2011INSTRUCTORName:Office:Phone:Fax:E-mail:Office Hours:Mr. Michael Popowits2304 University Hall(312) 413-0998(312) 9
Ill. Chicago - MBA - 590
MBA 590 Leadership & ImprovisationStudent ProfileNAME:1) Give me a thumbnail sketch of your background, school and work history, and careergoals.2) Why the heck are you taking Leadership & Improvisation? What are your goals forthe class?3) What com
Ill. Chicago - MBA - 590
The Structure of Spontaneity from Blink, by Malcolm GladwellOne Saturday evening not long ago, an improvisation comedy group called Mother tookthe stage in a small theater in the basement of a supermarket on Manhattans West Side.It was a snowy evening
Ill. Chicago - IDS - 410
Modern Database Management, Ninth Edition236Chapter 15 Object-Oriented Data ModelingChapter OverviewPlease note that the material for this chapter is based upon the Web version of Chapter 15, notthe abbreviated version of Chapter 15 in the text.The
Ill. Chicago - IDS - 410
Modern Database Management, Ninth Edition14Chapter 16 Using Relational Databases to Provide Object PersistenceChapter OverviewPlease note that the material for this chapter is based upon the Web version of Chapter 16, notthe abbreviated version of Ch
Ill. Chicago - IDS - 410
Modern Database Management, Ninth Edition220Chapter 14 Distributed DatabasesChapter OverviewPlease note that the material for this chapter is based upon the Web version of Chapter 14,not the abbreviated version of Chapter 14 in the text. The purpose
Ill. Chicago - IDS - 410
Chapter 11143Chapter 11 Data WarehousingChapter OverviewThe purpose of this chapter is to introduce students to the rationale and basic concepts ofdata warehousing from a database management point of view. We contrast operationaland informational pr
Ill. Chicago - IDS - 410
Chapter 13199Chapter 13 Data and Database AdministrationChapter OverviewThe purpose of this chapter is to introduce students to the principles and tools for theadministration of data. Data and database administration assume even greater importance as
Ill. Chicago - IDS - 410
Modern Database Management, Ninth Edition180Chapter 12 Data Quality and IntegrationChapter OverviewThis chapter reviews the importance of data quality and integration in todays modernorganizations. The chapter begins with an in-depth discussion of da
Ill. Chicago - IDS - 410
Chapter 869Chapter 8 Advanced SQLChapter OverviewChapter 8 follows from Chapter 7, from single table queries to multi-table joins,subqueries (both non-correlated and correlated), establishing referential integrity, andderived tables. Triggers, store
Ill. Chicago - IDS - 410
38Modern Database Management, Ninth EditionChapter 7 Introduction to SQLChapter OverviewThis chapter describes in detail what has become the standard query language forrelational database management systems, SQL. Although SQL is illustrated in thisc
Ill. Chicago - IDS - 410
30Data and Database AdministrationChapter 13Chapter 13 Data and Database AdministrationMULTIPLE CHOICE: Choose the one alternative that best completes the statementor answers the question.1.Which of the following is true of poor data and/or databas
Rutgers - GEN CHEM - 162
CHAPTER 14NON ACID/BASE CHEMICAL EQUILIBRIUM1NON ACID-BASE EQUILIBRIUM CONCEPTS4 Chem 162-2007 Final exam + answersChapter 14 Non Acid-Base Chemical EquilibriumNon Acid-Base equilibrium conceptsFor which of the following reactions is Kc > Kp?A. H2
Rutgers - GEN CHEM - 162
CHAPTER 16EQUILIBRIAProblems to prepare students for Chem 162 hourly exam.SOLUBILITY PRODUCTCOMPLEX ION EQUILIBRIAE. Tavss 3/11Chapter 15B practice problems1SOLUBILITY PRODUCTCHEM 162-2007 EXAM II + ANSWERSCHAPTER 16A EQUILIBRIASOLUBILITY PRODU
Rutgers - GEN CHEM - 162
CHAPTERS 22CHEM 162-2011 Some PRACTICE PROBLEMSCHAPTER 22- TRANSITION METALS AND COORDINATION CHEMISTRY COORDINATION COMPOUNDSE. Tavss, PhD1CHAPTER 21 - TRANSITION METALS AND COORDINATION CHEMISTRY1 Chem 162-2007 Final exam + answersChapter 22 Tr
Rutgers - GEN CHEM - 162
CHAPTER 17THERMODYNAMICSProblems to prepare students for Chem 162 hourly exam III.THERMODYNAMICS covers Zumdahl chapter 16.ENTROPY CONCEPTSENTROPY CALCULATIONSFREE ENERGY CONCEPTSFREE ENERGY CALCULATIONSFREE ENERGY AND EQUILIBRIA CONCEPTSFREE ENE
Rutgers - GEN CHEM - 162
Hill & Petrucci Chapter 12 Homework ProblemsChem 162-2010 Homework 1st & 2nd Week21. Describe how you would prepare 2.30 kg of an aqueous solution that is 4.85% NaNO3 by mass.4.85 g NaNO3/100g solution gNaNO3/2300g solutionNumerator conversion: Done.
Rutgers - GEN CHEM - 162
Hill & Petrucci Chapter 13 Homework ProblemsRate of Reaction and Reaction Order23. The initial concentration of H2O2 is 0.2546 M, and the initial rate of reaction is 9.32 x 10-4Ms-1. Whatwill be [H2O2] at t = 35s?Reaction rate = -(C2-C1)/(t2-t1)9.32
Rutgers - GEN CHEM - 162
Chem 162-2010 Homework 4th WeekCHAPTER 1351. Chemical reactions occur as a result of molecular collisions, and the frequency of molecularcollisions can be calculated with the kinetic-molecular theory. Calculations of the rates of chemicalreactions, ho
Rutgers - GEN CHEM - 162
Hill & Petrucci Chapter 14 Homework Problems 5th WeekCHAPTER 14Equilibrium Constant Relationships19. Determine the values of Kc that correspond to the following values of Kp.(a) SO2Cl2(g) SO2(g) + Cl2(g)Kp = 2.9 x 10-2 at 303K(b) 2NO2(g) 2NO(g) + O2
Rutgers - GEN CHEM - 162
Chem 162-2010 Homework 8th WeekHill & Petrucci Chapter 16 Homework ProblemsThe Solubility Product Constant, Ksp19. Write a chemical equation representing solubility equilibrium for (a) Hg 2(CN)2, Ksp = 5 x 10-40; and(b) Ag3AsO4, Ksp = 1.0 x 10-22.(a)
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Chapters 16 & 22 9th Week HomeworkChapter 16:Complex Ion Formation69. A complex ion has Cr3+ as its central ion and four NH3 molecules and two Cl- ions as ligands. Writethe formula of this complex ion.[Cr(NH3)4(Cl)2]+Th
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Homework Chapter 17 10th WeekChapter 22.73. A tetrahedral complex with Br-, Cl-, I-, and CO32- ligands can exist as optical isomers but not asgeometric isomers. Explain.These can exist as optical isomers because a non-sup
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Homework Chapter 17 11th WeekStandard Free Energy Change39. Use data from Appendix C to determine Go values for the following reactions at 25oC.(a) FeO(s) + H2(g) Fe(s) + H2O(g)(b) CdO(s) + 2HCl(g) CdCl2(s) + H2O(l)FeO(s
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Homework Chapter 18AChem 162-2009 Hill & Petrucci Homework Chapter 18Oxidation-Reduction Reactions25. Complete and balance the following half-equations, and indicate whether oxidation or reduction isinvolved.(a) HNO2(aq)
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Homework Chapter 18AChem 162-2009 Hill & Petrucci Homework Chapter 18Oxidation-Reduction Reactions25. Complete and balance the following half-equations, and indicate whether oxidation or reduction isinvolved.(a) HNO2(aq)
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Homework Chapter 18Eocell and the Spontaneity of Redox ReactionsUse data from Table 18.1 and Appendix C, as necessary.43. Predict whether a spontaneous reaction will occur in the forward direction in each of the following.
Rutgers - GEN CHEM - 162
Chem 162-2010 14th & 15th Week HomeworkChem 162-2010 Hill & Petrucci Homework Chapter 19Radioactive Decay Processes21. Each of the following equations represents a radioactive decay process. Supply the missing items.(a) 219?Rn ? + 42He(b) 16769? + 0-
Rutgers - GEN CHEM - 162
PRACTICE PROBLEMSCHEM 162-2010 EXAM ICHAPTER 12 - PROPERTIES OF SOLUTIONSSOLUTION CONCENTRATIONS CONCEPTS (Molarity, mole fraction, etc.)SOLUTION CONCENTRATIONS CALCULATIONS (Molarity, mole fraction, etc.)ENERGETICS OF SOLUTIONS AND SOLUBILITY CONCEP
Rutgers - GEN CHEM - 162
PRACTICE PROBLEMSCHEM 162-2010 EXAM ICHAPTER 13A - KINETICSRATES, RATE CONSTANTS, REACTION ORDERS, HALF-LIVES CONCEPTSRATES,RATE CONSTANTS, REACTION ORDERS, HALF-LIVES CALCULATIONSE. Tavss, PhD1RATES, RATE CONSTANTS, REACTION ORDERS, HALFLIVES CONC
Rutgers - GEN CHEM - 162
PRACTICE PROBLEMSCHEM 162-2009 EXAM ICHAPTER 13B - KINETICSREACTION MECHANISMS, ACTIVATION ENERGY & CATALYSTS CONCEPTSREACTION MECH., ACTIVATION ENERGY & CATALYSTS CALCULATIONSE. Tavss, PhDREACTION MECHANISMS, ACTIVATIONENERGY & CATALYSTS CONCEPTS
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Homework Chapter 15.1-15.7(Note that my algebra-solving calculator requires my setting up equations involving ,X and lots ofparentheses. Ignore these equations.)Brnsted-Lowry Acids and Bases*21. For each of the following
Rutgers - GEN CHEM - 162
Chem 162-2010 Hill & Petrucci Homework Chapter 15(Note that my algebra-solving calculator requires my setting up equations involving ,X and lots ofparentheses. Ignore these equations. Also, in reviewing the homework, it seems that some of theproblems m
Rutgers - GEN CHEM - 162
ACID AND BASE CONCEPTSCHEM 162-2007 EXAM II + ANSWERSCHAPTER 15A ACID & BASE EQUILIBRIAACID AND BASE CONCEPTS22. Solution A contains 50.0 mL of 0.10 M HClSolution B contains 50.0 mL of 0.10 M CH3COOHWhich statements are correct?X. Solution A has a
Rutgers - GEN CHEM - 162
CHAPTER 15 2nd HALFAPPLIC. OF ACID & BASE EQUILIBRIA(BUFFERS & TITRATIONS)BUFFER CONCEPTS110 Chem 162-2007 Final exam + answersChapter 15B Applications of Acid & Base EquilibriaBuffer conceptsWhich of the following solutions would be a buffer solu
Rutgers - GEN CHEM - 162
CHAPTER 18ELECTROCHEMISTRYProblems to prepare students for Chem 162 hourly exam III.ELECTROCHEMISTRY covers Zumdahl chapter 17.OXIDATION-REDUCTION REACTION CONCEPTSOXIDATION-REDUCTION REACTION CALCULATIONSGALVANIC CELLS & REDUCTION-POTENTIALCONCEPT
Rutgers - GEN CHEM - 162
CHEM 162-2011 EXAM III + SOLUTIONSChem 162-2011 Exam III + AnswersChapter 22 - Transition Metals and Coordination ChemistryCoordination Compounds1. Which of the following is called a chelating ligand?A. NO2B. CNC. CH3CH2CH2NH2D. -OOCCOOE. NH3A chel
Rutgers - GEN CHEM - 162
CHEM 162-2011 EXAM I + SOLUTIONS1Chem 162-2011 Exam IHill & Petrucci et al. 4th editionChapter 13B KineticsReaction mech., activation energy & catalysts calculationsThe reaction 2A + B C has the following mechanism.A + B D fast equilibriumD + B E
Rutgers - GEN CHEM - 162
2011 REVIEWChemistry 162C162s08e1v1Exam IFebruary 20, 200812CHEM 162-2008 EXAM ICHAPTER 13 - KINETICS10RATES, RATE CONSTANTS, REACTION ORDERS, HALF-LIVES CONCEPTSWhich units of k are consistent with a fifth order rate law?A. M-5 s-1B. M4 s-1C.
Rutgers - GEN CHEM - 162
Chemistry 162Exam IIMarch 23, 2011Chem 162-2011 Hourly Exam II + AnswersChapter 15A - Acid & Base EquilibriaAcid and base equilibria calculations1.At 5 oC, the pH of 0.10 M NaOH = 13.74. What is the value of Kw at 5oC?A. 1.0 x 10-15B.1.8 x 10-15
Rutgers - GEN CHEM - 162
Chemistry 162-2011Exam III Review Sessionfrom Exam III (4/14/10) Working Copy1SOLVING EQUILIBRIA PROBLEMSStep 1: Write balanced equilibrium equationStep 2: Fill in and solve ICE tableStep 3: Write equilibrium expressionStep 4: Solve equilibrium ex
Rutgers - GEN CHEM - 162
Chemistry 162/162SGFinal Exam May 9, 2011Student Name (Print): _TAVSS_Recitation Section Number:Recitation Instructor: _TAVSS_The exam booklet has 50 questions for credit and one additional question to check the color of yourexam booklet. Each quest
Rutgers - GEN CHEM - 162
Chem 162-2011 4/29 Review for Final Exam Review of 2010 final examDr. Ed TavssCHAPTER 15pH14H2O + H2OBasic[H+]1x10-147 Neutral (e.g. H2O) 1x10-7-14+ H3O + OH Kw = 1x10+-Kw = [H ][OH ] = 1 x 10-14pH + pOH = 14Kw = Ka x Kcb = Kca x Kb = 1 x
Rutgers - GEN CHEM - 162
January 18th, 2011CHEMISTRY 162 LECTURE 1WELCOME!PLAN FOR 1ST LECTURE:I. YouII. Course detailsIII. MeChem 162-2011 Lecture 11WHO ARE YOU? Freshmen? Leaning towards being a chemistry major? Why this lecture?Chem 162-2011 Lecture 12Dr. Ed Tav
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011Lecture 3: 12.8-12.10; 13.1-13.3ANNOUNCEMENTSE-MAILATTENDANCE Sign inQUIZRecitation quiz this weekChapter 12.1 13.3MISCELLANEOUSChem 162-2011 Lecture 31PLAN FOR TODAY:DO LECTURE 2LECTURE 3PHYSICAL PROPERTIES OF SOLUTIONS
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011LECTURE 4ANNOUNCEMENTSE-MAILATTENDANCE Sign inQUIZRecitation quiz this weekMISCELLANEOUSChem 162-2011 Lecture 31PLAN FOR TODAY:BALANCE OF LECTURE 3 Electrolytes ColloidsLECTURE 4 - CHEMICAL KINETICS (13.3 13.6) Reaction r
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011LECTURE 5ANNOUNCEMENTSE-MAILATTENDANCE SigninEXAMSQUIZChem 162-2011 Lecture 51PLAN FOR TODAY:COMPLETE LECTURE 4CHAPTER 13 (cont.) - CHEMICAL KINETICSH&P 13.7-13.8Collision theoryEffect of temperature on reaction ratesChem
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011LECTURE 6H&P Chapter 13.9-13.11ANNOUNCEMENTSE-MAILATTENDANCE SigninEXAMSQUIZChem 162-2011 Lecture 61PLAN FOR TODAY:CHAPTER 13 (cont.) - CHEMICAL KINETICSReaction mechanismsCatalysisEnzyme catalysisChem 162-2011 Lecture 6
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011LECTURE 7ANNOUNCEMENTSE-MAILATTENDANCE SigninEXAMWednesday,Feb.16th,9:4011:00PMChapters12.1?QUIZChem 162-2011 Lecture 71PLAN FOR TODAY:CHAPTER 14.1 14.3CHEMICAL EQUILIBRIUMThe dynamic nature of equilibriumThe equilibrium
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011LECTURE 8ANNOUNCEMENTSE-MAILATTENDANCE Sign inEXAM Wednesday, Feb. 16th, 2011, 9:40-11:00 PMSEC (Science and Engineering Center?), Frelinghuysen Road, BuschCoverage: H&P, Chapters 12.1 to 13.11.QUIZChem 162-2011 Lecture 81PL
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011LECTURE 9(H&P 15.1-15.3)ANNOUNCEMENTSE-MAILATTENDANCE SigninQUIZEXAMSChem 162-2011 Lecture 91PLAN FOR TODAY:CHAPTER 15ACIDS AND BASES EQUILIBRIUMThe Brnsted-Lowry Theory of Acids and BasesMolecular Structure and Strengths
Rutgers - GEN CHEM - 162
CHEMISTRY 162-2011LECTURE 10(H&P 15.4-15.5)ANNOUNCEMENTSE-MAILATTENDANCE SigninQUIZ RecitationquizthisweekTue:H&P14.515.3Fri:H&P14.515.4EXAMS Howdidwedo?:>)Chem 162-2011 Lecture 101PLAN FOR TODAY:CHAPTER 15 (15.4-15.5)ACIDS AND BASES EQUI