EBTM FINAL || VERY FLAWLESS.
levels of data correct answers individual, department, enterprise
formats of data correct answers Document, presentation, spreadsheet, database
granularities of data correct answers detail (fine), summary, aggregate (coarse)
four primary traits of the value of data correct answers data type, data timeliness, data quality,
data governance
Data Timeliness- Real-time data correct answers Immediate, up-to-date data.
data timeliness- real-time system correct answers Provides real-time data in response to requests
high quality data is correct answers accurate, complete, consistent, unique, timely
low quality data correct answers Wrong, Misleading
Missing, partial
Inconsistent, unpredictable
Late
Duplicated, Redundant
Irrelevant
Confusing, ambiguous
Can't find, spread around
four primary sources of low quality data correct answers 1. Customers intentionally enter
inaccurate data to protect their privacy
2. Different entry standards and formats
3. Operators enter abbreviated or erroneous data by accident or to save time
4. Third party and external data contains inconsistencies, inaccuracies, and errors
potential business effects resulting from low quality data include correct answers Inability to
accurately track customers
Difficulty identifying valuable customers
Inability to identify selling opportunities
Marketing to nonexistent customers
Difficulty tracking revenue
Inability to build strong customer relationships
data governance correct answers refers to the overall management of the availability, usability,
integrity, and security of company data
master data management (MDM) correct answers 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
data validation correct answers includes the tests and evaluations used to determine compliance
with data governance policies to ensure correctness of data
database correct answers maintains data about various types of objects (inventory), events
(transactions), people (employees), and places (warehouses)
database management systems (DBMS) correct answers allows users to create, read, update, and
delete data in a relational database
data element correct answers The smallest or basic unit of data
data model correct answers logical data structures that detail the relationships among data
elements using graphics or pictures
metadata correct answers details about data
data dictionary correct answers compiles all of the metadata about the data elements in the data
model
entity correct answers A person, place, thing, transaction, or event about which information is
stored
attribute (field, coumn) correct answers the data elements associated with an entity
record correct answers a collection of related data elements
primary key correct answers A field (or group of fields) that uniquely identifies a given entity in
a table
foreign key correct answers A primary key of one table that appears an attribute in another table
and acts to provide a logical relationship among the two tables
database advantages from a business perspective correct answers 1. increased flexibility
2. increased scalability and performance
3. reduced information redundance
4. increased information integrity
5. increased information security
a well designed database should correct answers Handle changes quickly and easily
Provide users with different views
Have only one physical view
Have multiple logical views
levels of data correct answers individual, department, enterprise
formats of data correct answers Document, presentation, spreadsheet, database
granularities of data correct answers detail (fine), summary, aggregate (coarse)
four primary traits of the value of data correct answers data type, data timeliness, data quality,
data governance
Data Timeliness- Real-time data correct answers Immediate, up-to-date data.
data timeliness- real-time system correct answers Provides real-time data in response to requests
high quality data is correct answers accurate, complete, consistent, unique, timely
low quality data correct answers Wrong, Misleading
Missing, partial
Inconsistent, unpredictable
Late
Duplicated, Redundant
Irrelevant
Confusing, ambiguous
Can't find, spread around
four primary sources of low quality data correct answers 1. Customers intentionally enter
inaccurate data to protect their privacy
2. Different entry standards and formats
3. Operators enter abbreviated or erroneous data by accident or to save time
4. Third party and external data contains inconsistencies, inaccuracies, and errors
potential business effects resulting from low quality data include correct answers Inability to
accurately track customers
Difficulty identifying valuable customers
Inability to identify selling opportunities
Marketing to nonexistent customers
Difficulty tracking revenue
Inability to build strong customer relationships
data governance correct answers refers to the overall management of the availability, usability,
integrity, and security of company data
master data management (MDM) correct answers 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
data validation correct answers includes the tests and evaluations used to determine compliance
with data governance policies to ensure correctness of data
database correct answers maintains data about various types of objects (inventory), events
(transactions), people (employees), and places (warehouses)
database management systems (DBMS) correct answers allows users to create, read, update, and
delete data in a relational database
data element correct answers The smallest or basic unit of data
data model correct answers logical data structures that detail the relationships among data
elements using graphics or pictures
metadata correct answers details about data
data dictionary correct answers compiles all of the metadata about the data elements in the data
model
entity correct answers A person, place, thing, transaction, or event about which information is
stored
attribute (field, coumn) correct answers the data elements associated with an entity
record correct answers a collection of related data elements
primary key correct answers A field (or group of fields) that uniquely identifies a given entity in
a table
foreign key correct answers A primary key of one table that appears an attribute in another table
and acts to provide a logical relationship among the two tables
database advantages from a business perspective correct answers 1. increased flexibility
2. increased scalability and performance
3. reduced information redundance
4. increased information integrity
5. increased information security
a well designed database should correct answers Handle changes quickly and easily
Provide users with different views
Have only one physical view
Have multiple logical views
