Deck 5: Data and Knowledge Management

Question 1

Corporate databases are an example of a(n)_________ source of data.

A)Clickstream
B)External
C)Internal
D)Personal

Answer 1

C

Question 2

Which of the following is TRUE in regard to Big Data?

A)Big Data refers to large amounts of traditional data.
B)Big Data is about predictions.
C)Big Data systems work because people have taught those systems to think like humans; they just work faster than humans.
D)Big Data systems need human intervention to improve over time.

Answer 2

B

Question 3

There are 3 distinct characteristics of Big Data. The collection of social network data is an example of __________.

A)Variety
B)Velocity
C)Vintage
D)Volume

Answer 3

A

Question 4

Data ___________ means all applications are able to access the same data, which is ___________ by databases.

A)independence; maximized
B)independence; minimized
C)isolation; maximized
D)isolation; minimized

Question 5

Google's Knowledge Graph is a _______________.

A)Data mart
B)Data warehouse
C)Database
D)Repository

Question 6

Data are scattered throughout organizations. An example of this is ________________.

A)customers moving
B)data hoarding
C)human vs.computer languages
D)media changing (cassette to CD)

Question 7

Knowledge Graph has been integrated into ____________.

A)Amazon
B)Facebook
C)LinkedIn
D)YouTube

Question 8

The Emergency Department Information Exchange database was implemented in _________ to help reduce ___________.

A)New York; doctor fees
B)New York; Medicaid costs
C)Washington; doctor fees
D)Washington; Medicaid costs

Question 9

Which of the following is the correct order of the data hierarchy, from smallest to largest?

A)bit, byte, field, file, record, database
B)bit, byte, field, record, file, database
C)byte, bit, field, record, file, database
D)byte, bit, field, file, record, database

Question 10

Employee # is the _______ in the Employee file and the _________ in the Class File.

A)primary key; identifier
B)primary key; secondary key
C)secondary key; identifier
D)secondary key; primary key

Question 11

Your company decides to keep copies of your invoices on CDs. You decide the safest place to store them is in your company's basement since it is secure and people rarely go down there. When you get audited, you find the CDs got ruined during a recent rainstorm when the basement got flooded; you don't have access to the information for your audit. This is an example of _______.

A)Data degradation
B)Data integrity failure
C)Data rot
D)Low data quality

Question 12

The Emergency Department Information Exchange database was designed to address which of the following problems?

A)Ambulance drivers needed a way to communicate with the hospital when they were at a patient's location.
B)Communication between doctors and nurses is hindered by systems that don't display the correct data.
C)Emergency surgeries result in too many drugs being administered to the patient.
D)With the expansion of the Affordable Care Act, Medicaid patients visit hospital ERs too many times.

Question 13

Which of the following is FALSE?

A)Big Data can come from untrusted sources.
B)Big Data is often inaccurate, incomplete, incorrect, or erroneous.
C)Big Data changes, especially in data streams.
D)Big Data is valuable because it is structured.

Question 14

__________________________ is an approach to managing information across an entire organization.

A)Big Data
B)Data governance
C)Master data
D)Master data management

Question 15

Which of the following is NOT true of Knowledge Graph?

A)It adds useful context and detail to the list of links that Google provides by using past searches to determine what information is most relevant.
B)It is a vast database that enables Google software to connect facts on people, places, and things to one another.
C)It is an algorithm that looks for matches with the search teams, rather than the actual meaning of the information entered into the search box.
D)It was started by a startup company called Metaweb in 2010 with only 12 million entries.

Question 16

If your sales team shows a customer's name is "Johnny Smith" but your shipping department says it is "John
A)Inconsistency

A)Smith", this is a data __________ issue.
B)Isolation
C)Redundancy
D)Security

Question 17

Which of the following is a good example of a primary key in a student table?

A)Address
B)Birthdate
C)First and Last Name
D)Social security number

Question 18

Big Data primarily deals with ______________ data.

A)Semi-structured
B)Structured
C)Unstructured
D)All of the above

Question 19

The implementation of the Emergency Department Information Exchange database was originally met with __________ from hospitals.

A)Acceptance
B)Enthusiasm
C)Resistance
D)A neutral attitude

Question 20

The Sarbanes-Oxley Act of 2002 holds ______________ personally responsible for disclosing the effectiveness of their financial controls.

A)CFOs
B)CIOs
C)COOs
D)CSOs

Question 21

Which of the following is NOT a benefit of Nordea Bank's data warehouse?

A)Identity theft of Nordea Bank's customers is not quite as easy as in the past.
B)Nordea Bank was able to introduce a customer profitability application for customer relationship managers.
C)Reporting lead times decreased from eight to four days.
D)The data warehouse enabled Nordea Bank to meet relevant regulatory requirements more quickly and accurately.

Question 22

Data warehouses store _________ data, used primarily by _______ companies.

A)historical; large
B)historical; small
C)real-time; large
D)real-time; small

Question 23

Information ______________ utilize information created by others.

A)Consumers
B)Creators
C)Producers
D)Users

Question 24

Nonvolatile in the context of data storage means ________________.

A)The data can't be changed in a data warehouse.
B)The data can't be changed in the source system.
C)The data can only be changed by IT professionals.
D)The data can only be changed by users.

Question 25

Data warehouses and data marts are __________; this means users cannot change or update the data in data warehouses or data marts.

A)integrated
B)nonvolatile
C)organized by business dimension or subject
D)time variant

Question 26

_____________ is use to plan and control Business Intelligence activities.

A)A data dictionary
B)ETL
C)Governance
D)Metadata

Question 27

Which of the following is the correct order for the KMS cycle?

A)create, capture, store, refine, manage, disseminate
B)create, capture, refine, manage, store, disseminate
C)create, capture, refine, store, manage, disseminate
D)create, capture, store, manage, refine, disseminate

Question 28

Intellectual capital is also called __________.

A)Data
B)Knowledge
C)Information
D)Wisdom

Question 29

Knowledge and knowledge management processes usually have a(n)________ format.

A)Mini-structured
B)Semi-structured
C)Structured
D)Unstructured

Question 30

The MetLife Wall is a ____________.

A)database
B)expert system
C)social networking site
D)wiki

Question 31

Nordea Bank implemented a __________ to address regulations developed by various authorities around the globe.

A)Data dictionary
B)Data mart
C)Data warehouse
D)Database

Question 32

MetLife implemented a database system to address its problem with data __________.

A)inconsistency
B)isolation
C)redundancy
D)security

Question 33

_______________ is knowledge that has been codified or documented.

A)Data
B)Explicit knowledge
C)Information
D)Tacit knowledge

Question 34

___________ support local control, whereas ____________ support central control.

A)Data marts; data dictionaries
B)Data marts; data warehouses
C)Data warehouses; data dictionaries
D)Data warehouses; data marts

Question 35

Which of the following is NOT a stated benefit of MetLife's Wall?

A)Customer satisfaction
B)Efficiency
C)Security
D)Speed

Question 36

The most important principle for Nordea Bank's data warehouse was to ________.

A)comply with all relevant regulations
B)create a single version of the truth
C)improve customer service
D)reduce costs to improve financial performance

Question 37

____________ is one form of data integration.

A)EDI
B)ETL
C)SAP
D)SQL

Question 38

__________________ are/is the most effective and efficient way of doing things, readily available to a wide range of employees.

A)Best practices
B)Intellectual capital
C)Knowledge management
D)Knowledge management systems

Question 39

Big Data helps companies treat customers as individuals. This is called __________.

A)business model creation
B)data analyzation
C)experimentation
D)microsegmentation

Question 40

You've been working at ABC Corp for 20 years. Even though they say they are an Equal Opportunity Employer, you know they prefer to hire people who personally know someone at the company. This is _________.

A)Data
B)Explicit knowledge
C)Information
D)Tacit knowledge

Question 41

Flurry's main issues surround ______ concerns, particularly in _____.

A)privacy; Europe
B)privacy; the US
C)security; Europe
D)security; the US

Question 42

A __________________________ defines the required format for entering the data into the database

A)data dictionary
B)DBMS
C)entity
D)primary key

Question 43

____________ is a benefit of a data dictionary.

A)managing security and user access
B)recovering information if the system fails
C)reducing the chances that the same attribute will be used in multiple applications under different names
D)all of the above are benefits of a data dictionary

Question 44

The purpose of Flurry is to ___________.

A)allow users to block ads they don't want to see on their mobile device
B)guarantee an internet surfer will look at a particular ad
C)provide a high-speed auction system for targeting ads to individuals
D)send as many relevant ads as possible to a mobile device

Question 45

Mobile RTB allows advertisers to bid on __________.

A)Bundles of impressions
B)Each impression
C)PCs
D)Tablets

Question 46

SQL is the most popular query language because it ___________.

A)doesn't require training
B)has relatively simple statements
C)is so easy to point and click on the different icons
D)uses structured data

Question 47

An entity is the same thing as a field.

Question 48

A ___________ relationship exists when an association is maintained within a single entity.

A)Binary
B)Ternary
C)Quarterly
D)Unary

Question 49

Managing data is easier nowadays since there is so much of it.

Question 50

When data are normalized, attributes in the table depend only on the secondary key.

Question 51

Big Data predictions come from applying mathematics to huge quantities of data to infer probabilities.

Question 52

Flurry uses a ________ in its data collection efforts.

A)digital dossier policy
B)information privacy policy
C)opt-in model of informed consent
D)opt-out model of informed consent

Question 53

___________ is a challenge of KMS.

A)Being willing to invest resources
B)Getting employees to share information
C)Maintaining and updating the knowledge
D)Utilizing the knowledge

Question 54

Tacit knowledge is easier to document than explicit knowledge.

Question 55

Data warehouses maintain historical data while data marts are real-time.

Question 56

Secondary keys identify a file with complete accuracy.

Question 57

If your university has a policy that states you must take a minimum of 12 hours to be considered a full-time student and take no more than 21 hours without special permission, the 21 hours rule is referred to as ____________.

A)Cardinality
B)Connectivity
C)Mandatory
D)Optional

Question 58

Data governance is implemented through master data management.

Question 59

Databases maximize data independence.

Question 60

NoSQL databases only allow businesses to manipulate structured data.

Question 61

A(n)_________________ is a person, place, or thing that can be identified in the users' work environment.

Question 62

Intellectual capital is another term for _______________.

Question 63

From smallest to largest, what is the hierarchy of data for a computer-based file? Give an example for each one for a company like Walmart, building on the lower level where possible.

Question 64

_______________ are a set of core data that span the enterprise information systems.

Question 65

List and describe the six basic characteristics of data warehouses and data marts. How do each of these distinguish data warehouses and data marts from other enterprise systems?

Question 66

_____________ are low-cost, scaled-down versions of data warehouses.

Question 67

A(n)_________________ is a set of programs that provide users with tools to add, delete, access, modify, and analyze data stored in a single location.

Question 68

How could the movie industry put Big Data to use?

Question 69

Big Data _____________ the same thing as large amounts of traditional data.

Question 70

An instance is a specific, unique representation of a(n)_____________________.

Question 71

Draw a mandatory single, optional single, mandatory many, and optional many ER diagram for activities at your university.

Question 72

SQL is the most popular query language used for interacting with ________________.

Question 73

Thinking about your university, what kinds of issues make it so difficult for the administration to manage data?