Deck 6: Data: Business Intelligence

Question 1

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

Answer 1

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

Question 2

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.

Answer 2

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

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

Answer 3

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

Question 4

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

Question 5

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 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

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

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 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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 23

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 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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 36

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 37

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

Question 38

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

Question 39

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 40

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 41

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

Question 42

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

Question 43

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 44

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

Question 45

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

Question 46

Record is a collection of related data elements

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

A foreign key provides details about data.

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

The core component of any system, regardless of size, is a database and a database management system.

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

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 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

A DBMS provides details about data.

Question 68

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

Question 69

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

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

Question 74

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

Question 75

A field is a collection of related data elements

Question 76

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

Question 77

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

Question 78

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 79

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

Question 80

Entities are the data elements associated with an attribute.