Deck 6: Valuing and Storing Organizational Informationdatabases

Question 1

Information integrity issues occur when the same data element has different values.

Answer 1

False

Question 2

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Answer 2

False

Question 3

Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Answer 3

True

Question 4

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Question 5

Information granularity means immediate, up-to-date information.

Question 6

There are only two main primary traits that help you determine the value of information: timeliness and quality.

Question 7

Reports for each sales person, product, and part are examples of information granularities.

Question 8

If a manager identifies numerous information integrity issues, he should consider the reports generated from that data as invalid and not use them when making decisions.

Question 9

The four primary traits of the value of information are levels, formats, granularities, and type.

Question 10

Real-time systems provide real-time information in response to requests.

Question 11

Data governance refers to the overall management of the availability, usability, integrity, and security of company data.

Question 12

Master data management (MDM) is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems. MDM is commonly included in data governance.

Question 13

Information has three characteristics: levels, formats, and granularities.

Question 14

Information has three characteristics: timeliness, quality, and governance.

Question 15

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

Question 16

Data governance is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Question 17

Information comes at the same level, formats, and granularities.

Question 18

Timeliness information must be up-to-the-second to be accurate.

Question 19

The four primary traits that help determine the value of information are type, timeliness, quality, and governance.

Question 20

Information integrity issues occur when a system produces incorrect, inconsistent, or duplicate data.

Question 21

Timely information asks if each transaction and event is represented only once in the information.

Question 22

In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.

Question 23

Unique information asks if the information is current with respect to the business needs.

Question 24

A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

Question 25

Unique information asks if each transaction and event is represented only once in the information.

Question 26

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Question 27

Complete information asks if there is an incorrect value in the information.

Question 28

Consistent information asks if the aggregate or summary information is in agreement with detailed information.

Question 29

Timely information asks if the information is current with respect to the business needs.

Question 30

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Question 31

Accurate information asks if there is an incorrect value in the information.

Question 32

Determining if all total columns equal the true total of the individual items is an example of a consistent characteristic of high-quality information.

Question 33

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Question 34

Complete information asks if there is a value missing from the information.

Question 35

Data latency includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

Question 36

Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Question 37

Identity management is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Question 38

Data validation includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

Question 39

Consistent information asks if there is a value missing from the information.

Question 40

Accurate information asks if the aggregate or summary information is in agreement with detailed information.

Question 41

Primary key is a field (or group of fields) that uniquely identifies a given record in a table.

Question 42

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Question 43

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Question 44

The core components of any system, regardless of size, are a database and a database management system.

Question 45

A primary key is the smallest or basic unit of information.

Question 46

There are three primary data models for organizing information including the hierarchical, network, and relational database models.

Question 47

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Question 48

Foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Question 49

A foreign key provides details about data.

Question 50

Record is a collection of related data elements.

Question 51

Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

Question 52

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

Question 53

Determining if information is updated weekly, daily, or hourly is an example of an accurate characteristic of high-quality information.

Question 54

Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

Question 55

Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Question 56

Data dictionary compiles all of the metadata about the data elements in the data model.

Question 57

Data element (or data field) is the smallest, or basic, unit of information.

Question 58

Relational database model stores information in the form of logically related two-dimensional tables.

Question 59

Attributes (also called columns or fields) are the data elements associated with an entity.

Question 60

Relational database management system allows users to create, read, update, and delete data in a relational database.

Question 61

A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Question 62

A foreign key uniquely identifies a given record in a table.

Question 63

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Question 64

A DBMS provides details about data.

Question 65

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Question 66

Information integrity is a measure of the quality of information.

Question 67

Integrity constraints are rules that help ensure the quality of information.

Question 68

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Question 69

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Question 70

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Question 71

The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Question 72

The physical view of information deals with the physical storage of information on a storage device.

Question 73

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Question 74

Structured query language compiles all of the metadata about the data elements in the data model.

Question 75

Hierarchal database model stores information in the form of logically related two-dimensional tables.

Question 76

Entities are the data elements associated with an attribute.

Question 77

The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

Question 78

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Question 79

A field is a collection of related data elements.

Question 80

The logical view of information deals with the physical storage of information on a storage device.