Lydia Kesatie

Question 1

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

Answer 1

All a user needs to do is insert the number

Question 2

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

Answer 2

Locally concentrated workforces

Question 3

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

Answer 3

Intelligent Agents

Question 4

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

Answer 4

Business

Question 5

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

Answer 5

Box-and-whiskers plot

Question 6

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

Answer 6

Standard Deviation

Question 7

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?

Answer 7

Data Granularity

Question 8

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

Answer 8

Inferential

Question 9

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

Answer 9

Linearity

Question 10

What is the management feature of a dashboard?

Answer 10

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

Question 11

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

Answer 11

Graphic Artwork

Question 12

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

Answer 12

Maps

Question 13

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

Answer 13

Predictive

Question 14

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

Answer 14

BI

Question 15

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

Answer 15

1980s

Question 16

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

Answer 16

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

Question 17

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

Answer 17

End-user ad hoc reports, queries, and analysis

Question 18

Which type of question does visual analytics seeks to answer

Answer 18

Why is it happening?

Question 19

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?

Answer 19

Pie Chart

Question 20

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

Answer 20

Arithmetic Mean

Question 21

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

Answer 21

Bubble Chart

Question 22

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

Answer 22

New forms of computation of business logic.

Question 23

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

Answer 23

Internal results

Question 24

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

Answer 24

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

Question 25

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

Answer 25

three-tier architecture

Question 26

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

Answer 26

Subject-oriented and nonvolatile

Question 27

Oper marts are created when operational data needs to be analyzed

Answer 27

multidimensionally

Question 28

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

Answer 28

data store

Question 29

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

Answer 29

Operational

Question 30

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?

Answer 30

Star schema

Question 31

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

Answer 31

Cleanse

Question 32

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

Answer 32

Improved Customer Service

Question 33

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

Answer 33

Enterprise application integration

Question 34

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

Answer 34

Integration

Question 35

____ 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.

Answer 35

Software, Service

Question 36

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

Answer 36

Because measurement alone has little use without action

Question 37

What is Six Sigma?

Answer 37

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

Question 38

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

Answer 38

source of the data

Question 39

_____ 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.

Answer 39

Enterprise information integration (EII)

Question 40

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

Answer 40

Enterprise Application Integration

Question 41

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

Answer 41

Because of the massive data amounts and search efforts involved

Question 42

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

Answer 42

Classification

Question 43

The data field "ethnic group" can best be describe as

Answer 43

Nominal data

Question 44

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

Answer 44

databases

Question 45

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

Answer 45

Needs

Question 46

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

Answer 46

data processing.

Question 47

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

Answer 47

a. data monitoring

Question 48

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

Answer 48

Data Richness

Question 49

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

Answer 49

b. the visual cube level

Question 50

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

Answer 50

d. Pure Big Data systems do not involve fault tolerance

Question 51

The competitive imperatives for BI include all of the following EXCEPT a. right information b. right user c. right time d. right place

Answer 51

d. right place

Question 52

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

Answer 52

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

Question 53

KPIs have all of the distinguishing criteria, EXCEPT a. Limits b. Benchmarks c. Ranges d. Encodings e. Targets

Answer 53

a. Limits

Question 54

The DMAIC performance improvement model all of the following steps, EXCEPT a. Monitor b. Define c. Improve d. Control

Answer 54

a. Monitor

Question 55

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

Answer 55

b. Emphasizes targets for each measurement

Question 56

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

Answer 56

d. greater control of data

Question 57

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

Answer 57

Independent data mart

Question 58

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

Answer 58

Drill down

Question 59

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

Answer 59

b. parallel processing

Question 60

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)

Answer 60

Data Lake

Question 61

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

Answer 61

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