Deck 6: Data: Business Intelligence

Question 1

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

Answer 1

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

Question 2

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

Answer 2

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

Question 3

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

Answer 3

False
Explanation: Organizational information comes at different formats,levels,and granularities of information.

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

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

Question 18

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 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

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

Question 28

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 29

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

Question 30

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 31

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

Question 32

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 33

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

Question 34

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

Question 35

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 36

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

Question 37

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 38

Accurate information asks if there is an incorrect value in 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

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

Question 41

Relational database models store information in the form of logically related two-dimensional tables.

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

A foreign key provides details about data.

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

A record is a collection of related data elements.

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

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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 61

Information integrity is a measure of the quality of information.

Question 62

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

Question 63

A field is a collection of related data elements.

Question 64

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 65

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 66

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

Question 67

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 68

A DBMS provides details about data.

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

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

Entities are the data elements associated with an attribute.

Question 77

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

Question 78

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

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

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