Deck 6: Data: Business Intelligence

Question 1

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

Answer 1

False
Explanation: Information inconsistency occurs when the same data element has different values.

Question 2

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

Answer 2

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

Question 3

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

Answer 3

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

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

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

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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 24

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

Question 25

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

Question 26

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

Question 27

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 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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 33

A DBMS uses three primary data models for organizing information-the hierarchical, network, and the relational database.

Question 34

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

Question 35

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

Question 36

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

Question 37

A foreign key provides details about data.

Question 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

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 43

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

Question 44

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

Question 45

A record is a collection of related data elements.

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

Entities are the data elements associated with an attribute.

Question 51

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

Question 52

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

Question 53

A field is a collection of related data elements.

Question 54

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

Question 55

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

Question 56

A DBMS provides details about data.

Question 57

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

Question 58

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

Question 59

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

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

Question 61

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 62

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

Question 63

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 64

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 65

Information constraints is a measure of the quality of information.

Question 66

One of the advantages found in a relational database is increased information redundancy.

Question 67

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

Question 68

Information integrity is a measure of the quality of information.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Question 79

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

Question 80

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.