Reference no: EM132594189

Question 1

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

Select one:
a. transaction processing systems that constantly update operational databases.
b. end-user ad hoc reports, queries, and analysis.
c. the collection of reputable sources of intelligence.
d. transactions such as ATM withdrawals, where we need to reduce a bank balance accordingly.

Question 2

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

Select one:
a. DSS
b. BI
c. MIS
d. ERP

Question 3

How are enterprise resources planning (ERP) systems related to supply chain management (SCM) systems?

Select one:
a. different terms for the same system
b. complementary systems
c. mutually exclusive systems
d. None of these; these systems never interface

Question 4

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

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

Question 5

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

Select one:
a. They are used for customization of BI solutions.
b. They host an enterprise data warehouse that can assist in decision making.
c. All a user needs to do is insert the numbers.
d. The shell provides a secure environment for the organization's BI data.

Question 6

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

Select one:
a. 1970s
b. 1990s
c. 2000s
d. 1980s

Question 7

The competitive imperatives for BI include all of the following EXCEPT

Select one:
a. right time
b. right place
c. right information
d. right user

Question 8

In the Opening Vignette on Sports Analytics, what type of modeling was used to predict offensive tactics?

Select one:
a. sentiment analysis
b. heat maps
c. cascaded decision trees
d. heuristics

Question 9

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

Select one:
a. the processing power needed for the centralized model would overload a single computer.
b. Big Data systems have to match the geographical spread of social media.
c. the "Big" in Big Data necessitates over 10,000 processing nodes.
d. centralized storage creates too many vulnerabilities.

Question 10

Which of the following developments is NOT contributing to facilitating growth of decision support and analytics?

Select one:
a. Big Data
b. locally concentrated workforces
c. knowledge management systems
d. collaboration technologies

Question 11

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

Select one:
a. public data mart
b. sectional data mart
c. volatile data mart
d. independent data mart

Question 12

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 aNo

Select one:
a. relational database.
b. data lake.
c. data cloud.
d. extended ASP.

Question 13

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

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

Question 14

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

Select one:
a. slice.
b. drill down.
c. dice.
d. roll-up.

Question 15

Oper marts are created when operational data needs to be analyzed

Select one:
a. linearly.
b. unidimensionally.
c. in a dashboard.
d. multidimensionally.

Question 16

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

Select one:
a. subject-oriented and volatile.
b. subject-oriented and nonvolatile.
c. product-oriented and volatile.
d. product-oriented and nonvolatile.

Question 17

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

Select one:
a. cleanse
b. transformation
c. load
d. extraction

Question 18

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

Select one:
a. because performance measurement systems are only in their infancy
b. because measurement automatically leads to problem solution
c. because performance management systems cost more
d. because measurement alone has little use without action

Question 19

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

Select one:
a. two-tier architecture.
b. one-tier architecture.
c. three-tier architecture.
d. four-tier architecture.

Question 20

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

Select one:
a. Enterprise information integration (EII)
b. Extraction, transformation, and load (ETL)
c. Enterprise application integration (EAI)
d. None of these