Lydia Kesatie Flashcards

1
Q

Today, many vendors offer diversified tools, some of which are completely preprogrammed (called shells). How are these shells utilized?

A

All a user needs to do is insert the number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the following developments is not contributing to facilitating the growth of decision support analytics

A

Locally concentrated workforces

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Software monitors referred to as ___ can be placed on a separate server in the network and use event- and process based approaches to measure and monitor operational processes

A

Intelligent Agents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

____ cycle times are now extremely compressed, faster, and more informed across industries

A

Business

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

This plot is a graphical illustration of several descriptive statistics about a given data set.

A

Box-and-whiskers plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

This measure of dispersion is calculated by simply taking the square root of the variations

A

Standard Deviation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which characteristic of data requires that the variables and data values be defined at the lowest (or as low as required) level of detail for the intended use of the data?

A

Data Granularity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

____ statistics is about drawing conclusions about the characteristics of the population

A

Inferential

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

When validating the assumptions of a regression, ____ assumes that the relationship between the response variable and the explanatory variable are linear.

A

Linearity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the management feature of a dashboard?

A

Operational data that identify what actions to take to resolve a problem.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the following is Least related to data/information visualization?

A

Graphic Artwork

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

___ are typically used together with other charts and graphs, as opposed to by themselves, and show postal codes, country names, etc.

A

Maps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Visual analytics is widely regarded as the combination of visualization and ___ analytics

A

Predictive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies?

A

BI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

In what decade did disjoint information systems begin to be integrated?

A

1980s

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What has caused the growth of the demand for instant, on-demand access to dispersed information?

A

The more pressing need to close the gap between the operational data and strategic objectives

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The very design that makes an OLTP system efficient for transaction processing makes it ineffective for

A

End-user ad hoc reports, queries, and analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Which type of question does visual analytics seeks to answer

A

Why is it happening?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration?

A

Pie Chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

This measure of central tendency is the sum of all the values/observations divided by the number of observations in the data set.

A

Arithmetic Mean

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Which kind of chart is described as an enhanced version of a scatter plot?

A

Bubble Chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

The internet emerged as a new medium for visualization and brought all the following EXCEPT
a.

A

New forms of computation of business logic.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Key Performance Indicators (KPIs) are metrics typically used to measure

A

Internal results

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

List and Explain three levels or categories of analytics that are most often viewed as sequential and independent, but also occasionally overlapping.

A

Descriptive or reporting analytics refers to knowing what is happening in the organization and understanding some underlying trends and causes of such occurrences.
Predictive analytics aims to determine what is likely to happen in the future. This analysis is based on statistical techniques that fall under the general category of data mining.
Prescriptive analytics recognize what is going on as well as the likely forecast and makes decisions to achieve the best performance possible

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

A web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of

A

three-tier architecture

26
Q

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are

A

Subject-oriented and nonvolatile

27
Q

Oper marts are created when operational data needs to be analyzed

A

multidimensionally

28
Q

The three main types of data warehouses are data marts, operational ________ , and enterprise data warehouses

A

data store

29
Q

A(n) ____ data store (ODS) provides a fairly recent form of customer information file.

A

Operational

30
Q

When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?

A

Star schema

31
Q

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?

A

Cleanse

32
Q

Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehousing?

A

Improved Customer Service

33
Q

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

A

Enterprise application integration

34
Q

Data ____ comprises data access, data federation, and change capture

A

Integration

35
Q

____ as a ____, or “The Extended ASP Model “, is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand.

A

Software, Service

36
Q

Why is performance management system superior to a performance measurement system?

A

Because measurement alone has little use without action

37
Q

What is Six Sigma?

A

A methodology aimed at reducing the number of defects in a business process

38
Q

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

A

source of the data

39
Q

_____ is an evolving tool space that promises real-time data integration from a variety of sources such as relational databases, Web services, and multidimensional databases.

A

Enterprise information integration (EII)

40
Q

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

A

Enterprise Application Integration

41
Q

What is the main reason parallel processing is sometimes used for data mining?

A

Because of the massive data amounts and search efforts involved

42
Q

Which broad area of data mining applications analyzes data, forming rules to distinguish between defined classes?

A

Classification

43
Q

The data field “ethnic group” can best be describe as

A

Nominal data

44
Q

Data are often buried deep within very large ___, which sometimes contain data from several years.

A

databases

45
Q

There has been an increase in data mining to deal with global competition and customer more sophisticated _____ and wants

A

Needs

46
Q

Data preparation, the third step in the CRISP-DM data mining process, is more commonly known as _____

A

data processing.

47
Q

Business applications have moved from transaction processing and monitoring to other activities. Which of the following is NOT one of those activities?

a. data monitoring
b. problem analysis
c. mobile access
d. solution applications

A

a. data monitoring

48
Q

Which characteristic of data means that all the required data elements are included in the data set?

A

Data Richness

49
Q

Dashboards can be presented at all the following levels EXCEPT

a. the self-service cube level
b. the visual cube level
c. the static report level
d. the visual dashboard level

A

b. the visual cube level

50
Q

Which of the following statements about Big Data is true?

a. data chunks are stored in different locations on one computer.
b. Hadoop is a type of processor used to process Big Data applications
c. MapReduce is a storage filing system.
d. Pure Big Data systems do not involve fault tolerance

A

d. Pure Big Data systems do not involve fault tolerance

51
Q

The competitive imperatives for BI include all of the following EXCEPT

a. right information
b. right user
c. right time
d. right place

A

d. right place

52
Q

Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT

a. mobile platforms such as the iPhone are supported by these products
b. it is easier to spot useful patterns and trends in the data
c. they explore massive amounts of data in hours, not days
d. there is less demand on IT departments for reports

A

c. they explore massive amounts of data in hours, not days

53
Q

KPIs have all of the distinguishing criteria, EXCEPT

a. Limits
b. Benchmarks
c. Ranges
d. Encodings
e. Targets

A

a. Limits

54
Q

The DMAIC performance improvement model all of the following steps, EXCEPT

a. Monitor
b. Define
c. Improve
d. Control

A

a. Monitor

55
Q

Six Sigma Performance Measurement System has all of the following characteristics, EXCEPT

a. Emphasize learning and innovation
b. Emphasizes targets for each measurement
c. Identifies measures that drive performance
d. Includes all business processors

A

b. Emphasizes targets for each measurement

56
Q

All of the following are benefits of hosted data warehouses EXCEPT

a. smaller upfront investment
b. better quality hardware
c. frees up in-house systems
d. greater control of data

A

d. greater control of data

57
Q

Which kind of data warehouse is created separately from the enterprise data warehouse by department and not reliant on it for updates?

A

Independent data mart

58
Q

When querying a dimensional database a user went from summarized data to its underlying details. The function that served this purpose is

A

Drill down

59
Q

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?

a. use of the web by users as a front-end
b. parallel processing
c. Microsoft Windows
d. a larger IT staff

A

b. parallel processing

60
Q

A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n)

A

Data Lake

61
Q

All of the following about data mining are true EXCEPT

a. the process aspect means that data mining should be a one-step process to results
b. the novel aspect means that previously unknown patterns are discovered
c. the potentially useful aspect means that results should lead to some business benefit
d. the valid aspect means that the discovered patterns should hold true on new data

A

a. the process aspect means the data mining should be a one-step process to results