Archive for December 2018

All of the following are true about in-database processing technology EXCEPT

All of the following are true about in-database processing technology EXCEPT



A) it pushes the algorithms to where the data is.
B) it makes the response to queries much faster than conventional databases.
C) it is often used for apps like credit card fraud detection and investment risk management.
D) it is the same as in-memory storage technology.


Answer: D

How does the use of cloud computing affect the scalability of a data warehouse?

How does the use of cloud computing affect the scalability of a data warehouse?



A) Cloud computing vendors bring as much hardware as needed to users' offices.
B) Hardware resources are dynamically allocated as use increases.
C) Cloud vendors are mostly based overseas where the cost of labor is low.
D) Cloud computing has little effect on a data warehouse's scalability.


Answer: B

Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses?

Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses?



A) strategic decisions whose impacts are hard to measure
B) detailed data available for strategic use only
C) large numbers of users, including operational staffs
D) restrictive reporting with daily and weekly data currency


Answer: C

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

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



A) country of (data) origin.
B) nature of the data.
C) speed of data transfer.
D) source of the data.


Answer: C

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?



A) independent data marts architecture
B) centralized data warehouse architecture
C) hub-and-spoke data warehouse architecture
D) federated architecture


Answer: D

All of the following statements about metadata are true EXCEPT

All of the following statements about metadata are true EXCEPT



A) metadata gives context to reported data.
B) there may be ethical issues involved in the creation of metadata.
C) metadata helps to describe the meaning and structure of data.
D) for most organizations, data warehouse metadata are an unnecessary expense.


Answer: D

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT



A) decision makers get to see the same results to queries.
B) decision makers have the same data available to support their decisions.
C) decision makers get to use more dependable data for their decisions.
D) decision makers have unfettered access to all data in the warehouse.


Answer: D

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

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



A) centralized storage creates too many vulnerabilities.
B) the "Big" in Big Data necessitates over 10,000 processing nodes.
C) the processing power needed for the centralized model would overload a single computer.
D) Big Data systems have to match the geographical spread of social media.


Answer: C

Which of the following statements about Big Data is true?

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: D

Prescriptive BI capabilities are viewed as more powerful than predictive ones for all the following reasons EXCEPT

Prescriptive BI capabilities are viewed as more powerful than predictive ones for all the following reasons EXCEPT



A) prescriptive BI gives actual guidance as to actions.
B) understanding the likelihood of certain events often leaves unclear remedies.
C) only prescriptive BI capabilities have monetary value to top-level managers.
D) prescriptive models generally build on (with some overlap) predictive ones.


Answer: C

How are descriptive analytics methods different from the other two types?

How are descriptive analytics methods different from the other two types?



A) They answer "what-if?" queries, not "how many?" queries.
B) They answer "what-is?" queries, not "what will be?" queries.
C) They answer "what to do?" queries, not "what-if?" queries.
D) They answer "what will be?" queries, not "what to do?" queries.


Answer: B

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

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



A) They are used for customization of BI solutions.
B) All a user needs to do is insert the numbers.
C) The shell provides a secure environment for the organization's BI data.
D) They host an enterprise data warehouse that can assist in decision making.


Answer: B

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

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



A) the increasing divide between users who focus on the strategic level and those who are more oriented to the tactical level
B) the need to create a database infrastructure that is always online and contains all the information from the OLTP systems
C) the more pressing need to close the gap between the operational data and strategic objectives
D) the fact that BI cannot simply be a technical exercise for the information systems department


Answer: C

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

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



A) it is no longer necessary to start BI within the company.
B) it is wise to start BI and establish a BI Competency Center (BICC) within the company.
C) the organization is ready for the introduction of new data-generating technologies, such as radio-frequency identification (RFID).
D) business leaders are required to document their business processes and to sign off on the legitimacy of the information they rely on.


Answer: B

What can the BI users in an organization help guide and direct?

What can the BI users in an organization help guide and direct?



A) how to implement and deploy a BI initiative that can be lengthy, expensive, and failure prone
B) how the DW is structured and the types of BI tools and other supporting software that are needed
C) how to decompose the planning and execution into business, organization, functionality, and infrastructure components
D) how the DW is structured and the costs and the appreciation for different classes of potential users


Answer: B

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

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



A) end-user ad hoc reports, queries, and analysis
B) transaction processing systems that constantly update operational databases
C) the collection of reputable sources of intelligence
D) transactions such as ATM withdrawals, where we need to reduce a bank balance accordingly


Answer: A

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically



A) the end result of BI processes and operations.
B) a repository of actionable intelligence obtained from a data mart.
C) a distinct system that provides storage for data that will be made use of in analysis.
D) an integral subsystem of an online analytical processing (OLAP) system.


Answer: C

When middles look across an organization to ensure that project priorities reflect the needs of the entire business, what is their main concern?

When middles look across an organization to ensure that project priorities reflect the needs of the entire business, what is their main concern?



A) that their proprietary BI methods are protected from industrial espionage
B) that additional information available through an enterprise data warehouse should assist in decision making
C) that a project does not just serve to sub-optimize one area over others
D) that return on investment (ROI) and total cost of ownership justify the cost—benefit ratio


Answer: C

Once a data warehouse is in place, the general process of intelligence creation begins with

Once a data warehouse is in place, the general process of intelligence creation begins with



A) end-user examinations of decision-making impacts.
B) identifying and prioritizing specific BI projects.
C) estimating the cost-benefit ratio of the ROI.
D) establishing the critical partnerships required for BI governance.


Answer: B

When Sabre developed their Enterprise Data Warehouse, they chose to use near-real time updating of their database. The main reason they did so was

When Sabre developed their Enterprise Data Warehouse, they chose to use near-real time updating of their database. The main reason they did so was



A) to provide a 360 degree view of the organization.
B) to aggregate performance metrics in an understandable way.
C) to be able to assess internal operations.
D) to provide up-to-date executive insights.


Answer: D

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?

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?



A) customer profitability
B) propensity to buy
C) customer attrition
D) channel optimization


Answer: B

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

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



A) data to information to decisions to actions.
B) Big Data to data to information to decisions.
C) actions to decisions to feedback to information.
D) data to processing to information to actions.


Answer: A

In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of predictive analytics?

In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of predictive analytics?



A) real time reports of the shipment's temperature
B) warning of an open shipment seal
C) location of the shipment
D) optimal temperature setting


Answer: B

In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of prescriptive analytics?

In the Magpie Sensing case study, the automated collection of temperature and humidity data on shipped goods helped with various types of analytics. Which of the following is an example of prescriptive analytics?



A) real time reports of the shipment's temperature
B) warning of an open shipment seal
C) location of the shipment
D) optimal temperature setting


Answer: D

The two critical partnerships required for BI governance are (a) a partnership between functional area users and/or product/service area employees, and (b) a partnership between representatives of the marketing and vendor sides. T/F

The two critical partnerships required for BI governance are (a) a partnership between functional area users and/or product/service area employees, and (b) a partnership between representatives of the marketing and vendor sides. T/F



Answer: False

If you have survey results from 100 people and the average response is 40% with a standard deviation of 5. Which of the following can you approximate from the results

You have a survey question that asks: "What do you think the likelihood is that the FSU football team will win the ACC championship?"

If you have survey results from 100 people and the average response is 40% with a standard deviation of 5. Which of the following can you approximate from the results



  • 95% of the respondents think that there is a 30% - 50% chance that the FSU football team will win the ACC championship.
  • 70% of the respondents think that there is a 30% - 50% chance that the FSU football team will win the ACC championship.
  • 100% of the respondents think that there is a 30% - 50% chance that the FSU football team will win the ACC championship.
  • 0% of the respondents think that there is a 30% - 50% chance that the FSU football team will win the ACC championship.



Answer: 95% of the respondents think that there is a 30% - 50% chance that the FSU football team will win the ACC championship.

Which of the following is NOT a qualitative data type?

Which of the following is NOT a qualitative data type?




  • Conversations
  • Surveys with numerical answers
  • Magazine articles
  • Media broadcasts



Answer: Surveys with numerical answers

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?

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?



  • Ordinal
  • Discrete
  • Interval
  • Ratio


Answer: Interval

Subscribe to: Posts (Atom)