Deck 6: Valuing and Storing Organizational Information Databases

Question 1

Organizational information has three characteristics: levels, formats, and granularities.

Answer 1

True

Question 2

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

Answer 2

False

Question 3

Organizational information comes at the same level, formats, and granularities.

Answer 3

False

Question 4

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 5

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 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

Organizational information has three characteristics: timeliness, quality, and governance.

Question 20

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

Question 21

Data validation helps to ensure that every data value is correct and accurate.In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.

Question 22

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 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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 28

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 29

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 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

A DBMS provides details about data.

Question 42

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

Question 43

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

Question 44

A foreign key provides details about data.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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 53

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

Question 54

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

Question 55

Record is a collection of related data elements.

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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 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

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 67

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

Question 68

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

Question 69

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 70

Information integrity is a measure of the quality of information.

Question 71

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

Question 72

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

Question 73

Entities are the data elements associated with an attribute.

Question 74

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

Question 75

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

Question 76

Information integrity comprises rules that help ensure the quality of information.

Question 77

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

Question 78

A field is a collection of related data elements.

Question 79

Information constraints are measures of the quality of information.

Question 80

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