IDC 3931 Exam 1

Given the following range of numbers, what is the value of the 2nd Quartile? 10 11 11 13 14 15 15 16 17 19 20 22

15

What is the Mode of the following numbers: 1, 2, 2, 3, 4, 5, 5, 5

5

Statistical Data Variable Type: A variable that contains the values of either Yes or No would best be categorized as which of the following variable types?

Binary

Statistical Data Variable Type: A variable that contains a countable number of distinct values would best be categorized as which of the following variable types?

Discrete

T or F: Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.

False

T or F: OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

False

T or F: Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

False

The complexity of today's business environment creates many new challenges for organizations, such as global competition, but creates few new opportunities in return.

False

Statistical Data Variable Type: There is a web-based survey that asks you, "On a rating of 1(hated it) to 5(loved it), how much did you like the movie." This value is stored in your database and you need to categorize the statistical variable type. Which of the following variable types would be best?

Interval

Which of the following measures of central location would be best to use when the Skewness is approximately zero?

Mean

Which of the following measures of central location would be best to use when the Skewness is highly positive or negative?

Median

Statistical Data Variable Type: A variable that contains the one of the three values: "1st Place""2nd Place" or "3rd Place" would best be categorized as which of the following variable types?

Ordinal

Which of the following Visualization charts would you use to plot the relationship between TWO variables?

Scatterplot

Which of the following is NOT a qualitative data type?

Surveys with numerical answers

T or F: Actionable intelligence is the primary goal of modern-day Business Intelligence (BI) systems vs. historical reporting that characterized Management Information Systems (MIS).

True

The overwhelming majority of competitive actions taken by businesses today feature computerized information system support.

True

The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of predictive analytics.

True

Data mart is a subset of

a data warehouse, typically consisting of a single subject area.

An Operational Data Store (ODS) provides

a fairly recent form of customer information file (CIF).

Business intelligence (BI) can be characterized as a transformation of

data to information to decisions to actions.

In answering the question "Which customers are likely to be using fake credit cards?" you are most likely to use which of the following analytic applications?

fraud detection

DWA should be familiar with

high-performance software, hardware, and networking technologies.

OLTP databases are optimized for

input (getting new or updated data into the database).

If a company's strategy is properly aligned with DW and BI initiatives, and if the company's IS organization can be made capable of playing its role in such a project, and if the requisite user community is in place and has the proper motivation, then

it has the basics down and you can go to the next steps of starting BI and establishing a BI Competency Center (BICC) within the company.

Data warehouses are optimized for

output (querying/asking questions of the data)

Operational or transaction databases are

product oriented, handling transactions that update the database

In answering the question "Which customers are most likely to click on my online ads and purchase my goods?" you are most likely to use which of the following analytic applications?

propensity to buy

OLTP systems focus

routine, periodic, narrow reports

Subject oriented databases for data warehousing are organized by detailed subjects such as

sales, products, or customers, containing only information relevant for decision support.

Active data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is

speed of data transfer

The characteristics of data warehouses are

subject oriented, integrated, time variant and nonvolatile.

Big Data often involves a form of distributed storage and processing using Hadoop and MapReduce. One reason for this is

the processing power needed for the centralized model would overload a single computer.

Metadata describes

the structure of and some meaning about data, thereby contributing to their effective or ineffective use.

Big data is associated with almost any kind of large data that has the characteristics of:

volume, velocity, and variety