Week 7

Question 1

A ______ is an organized collection of data, generally stored and accessed electronically

Answer 1

database

Question 2

A ______ is a software package designed to define, manipulate,
retrieve and manage data in a database.

Answer 2

database management system

Question 3

_______is the discovery, interpretation, and communication of meaningful patterns in data;
and the process of applying those patterns towards effective decision making.

Answer 3

Analytics

Question 4

______ is a domain-specific language used in programming and designed for managing data held
in a relational database management system, or for stream processing in a relational data stream management system.

Answer 4

Structured Query Language (SQL)

Question 5

________is an approach to manage a company’s interaction with
current and potential customers. It uses data analysis about customers’ history with a company
to improve business relationships with customers, specifically focusing on customer retention
and ultimately driving sales growth.

Answer 5

customer-relationship management

Question 6

In commerce, _______ , the management of the flow of goods and services,
involves the movement and storage of raw materials, of work-in-process inventory, and of finished goods from point of origin to point of consumption.

Answer 6

supply-chain management

Question 7

_______ is the integrated management of core business processes,

Answer 7

enterprise resource planning

Question 8

In computing, a _______ , also known as an enterprise data warehouse, is a system used for reporting and data analysis, and is considered a core component of business intelligence.

Answer 8

data warehouse

Question 9

________ is a structure / access pattern specific to data warehouse environments, used to
retrieve client-facing data.

Answer 9

data mining

Question 10

Programs that infect other software or files. They require an executable (a running program) to spread, attaching to other executables.

Answer 10

viruses

Question 11

Data relevance pertains to which of the following questions?

Answer 11

What data is needed to compete on analytics and to meet our current and future goals?

Question 12

What are some key things to watch out for while building a model?

Answer 12

• black swan events,
• Basing a decision or action purely on the results of a model, without taking the business context into account, -Looking at a random but meaningless statistical fluke (because you did not set aside a portion of data to verify the results),
• Over-engineering the model (building it with so many variables that the solution arrived at might only work on the subset of data used to create it)

Question 13

Which of the following tasks can be performed using online analytical processing (OLAP)?

Answer 13

Drill down to uncover new insights, Slice and dice data to uncover new insights

Question 14

Data governance pertains to which of the following questions?

Answer 14

What rules and processes are needed to manage data from its creation through its retirement?

Question 15

Anyone can acquire _________, but ____________ is oftentimes considered a defensible source of competitive advantage.

Answer 15

technology; data

Question 16

Data quality pertains to which of the following questions?

Answer 16

Can our data be trusted as accurate? Is it clean, complete, and reasonably free of errors?

Question 17

The use of frameworks and being compliant is not equal to security. Security is about trade-offs, both economic and intangible. Firms need to understand their assets and risks in order to best allocate resources and address needs.

Answer 17

true