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...
All of the following are true about in-database processing technology EXCEPT
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'...
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...
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...
Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?
Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?
A) MOLAP
B)...
When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is
When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is
A) dice.
B)...
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?
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...
All of the following are benefits of hosted data warehouses EXCEPT
All of the following are benefits of hosted data warehouses EXCEPT
A) smaller upfront investment.
B) better quality hardware.
C) greater control of...
Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses?
Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses?
A)...
In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
A) transformation
B) extraction
C)...
In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated?
In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated?
A) transformation
B) extraction
C) load
D)...
Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
A) extraction, transformation,...
Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?
Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?
A) independent data marts architecture
B)...
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...
Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?
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...
A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a
A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a
A) one tier architecture.
B)...
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...
Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?
Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?
A) sectional...
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
A) subject-oriented...
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...
Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. T/F
Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. T/F
Answer:...
Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. T/F
Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. T/F
A...
A well-designed data warehouse means that user requirements do not have to change as business needs change. T/F
A well-designed data warehouse means that user requirements do not have to change as business needs change. T/F
Answer: Fals...
The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage. T/F
The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage. T/F
Answer: Tru...
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. T/F
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. T/F
Answer: Fals...
Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses. T/F
Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses....
In the Starwood Hotels case, up-to-date data and faster reporting helped hotel managers better manage their occupancy rates. T/F
In the Starwood Hotels case, up-to-date data and faster reporting helped hotel managers better manage their occupancy rates. T/F
Answer: Tru...
The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project. T/F
The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project. T/F
Answer: Fals...
Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture, a data mart bus architecture with conformed dimensions. T/F
Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture, a data mart bus architecture with...
Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them. T/F
Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them....
The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. T/F
The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. T/F
Answer: Tru...
Moving the data into a data warehouse is usually the easiest part of its creation. T/F
Moving the data into a data warehouse is usually the easiest part of its creation. T/F
Answer: Fals...
Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones. T/F
Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones. T/F
Answer: Fals...
Without middleware, different BI programs cannot easily connect to the data warehouse. T/F
Without middleware, different BI programs cannot easily connect to the data warehouse. T/F
Answer: Tru...
Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses. T/F
Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses. T/F
Answer...
One way an operational data store differs from a data warehouse is the recency of their data. T/F
One way an operational data store differs from a data warehouse is the recency of their data. T/F
Answer: Tru...
Data warehouses are subsets of data marts. T/F
Data warehouses are subsets of data marts. T/F
Answer: Fals...
Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks. T/F
Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks. T/F
Answer: ...
The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization. T/F
The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization. ...
In the Isle of Capri case, the only capability added by the new software was increased processing speed of processing reports. T/F
In the Isle of Capri case, the only capability added by the new software was increased processing speed of processing reports. T/F
Answer: F...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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)...
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)...
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)...
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?
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?
A)...
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...
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...
Organizations counter the pressures they experience in their business environments in multiple ways. Which of the following is NOT an effective way to counter these pressures?
Organizations counter the pressures they experience in their business environments in multiple ways. Which of the following is NOT an effective way...
Which of the following is NOT an example that falls within the four major categories of business environment factors for today's organizations?
Which of the following is NOT an example that falls within the four major categories of business environment factors for today's organizations?
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....
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....
Volume, velocity, and variety of data characterize the Big Data paradigm. T/F
Volume, velocity, and variety of data characterize the Big Data paradigm. T/F
Answer: Tru...
Pushing programming out to distributed data is achieved solely by using the Hadoop Distributed File System or HDFS. T/F
Pushing programming out to distributed data is achieved solely by using the Hadoop Distributed File System or HDFS. T/F
Answer: Fals...
The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of prescriptive analytics. T/F
The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of prescriptive...
The use of dashboards and data visualizations is seldom effective in finding efficiencies in organizations, as demonstrated by the Seattle Children's Hospital Case Study. T/F
The use of dashboards and data visualizations is seldom effective in finding efficiencies in organizations, as demonstrated by the Seattle Children's...
Almost all BI applications are constructed with shells provided by an outsourcing provider who may themselves create a custom solution for a vendor or work with another client. T/F
Almost all BI applications are constructed with shells provided by an outsourcing provider who may themselves create a custom solution for a vendor...
Traditional BI systems use a large volume of static data that has been extracted, cleansed, and loaded into a data warehouse to produce reports and analyses. T/F
Traditional BI systems use a large volume of static data that has been extracted, cleansed, and loaded into a data warehouse to produce reports and...
BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives. T/F
BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives. T/F
...
The success of BI is assured not because of which personnel would be the most likely to use it, but as a result of pervasive adoption across the organization. T/F
The success of BI is assured not because of which personnel would be the most likely to use it, but as a result of pervasive adoption across the organization....
Many business users in the 1980s referred to their mainframes as "the black hole," because all the information went into it, but little ever came back and ad hoc real-time querying was virtually impossible. T/F
Many business users in the 1980s referred to their mainframes as "the black hole," because all the information went into it, but little ever came back...
Information systems that support such transactions as ATM withdrawals, bank deposits, and cash register scans at the grocery store represent transaction processing, a critical branch of BI. T/F
Information systems that support such transactions as ATM withdrawals, bank deposits, and cash register scans at the grocery store represent transaction...
The term intelligence in a BI context is used to describe clandestine operations dedicated to stealing corporate secrets, in the manner of the government's CIA and other covert agencies. T/F
The term intelligence in a BI context is used to describe clandestine operations dedicated to stealing corporate secrets, in the manner of the government's...
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,...
Data warehouse and BI initiatives typically follow a process similar to that used in military intelligence initiatives. T/F
Data warehouse and BI initiatives typically follow a process similar to that used in military intelligence initiatives. T/F
Answer: Tru...
Actionable intelligence is the primary goal of modern-day Business Intelligence (BI) systems vs. historical reporting that characterized Management Information Systems (MIS). T/F
Actionable intelligence is the primary goal of modern-day Business Intelligence (BI) systems vs. historical reporting that characterized Management...
One of the four components of BI systems, business performance management, is a collection of source data in the data warehouse. T/F
One of the four components of BI systems, business performance management, is a collection of source data in the data warehouse. T/F
Answer: ...
The access to data and ability to manipulate data (frequently including real-time data) are key elements of business intelligence (BI) systems. T/F
The access to data and ability to manipulate data (frequently including real-time data) are key elements of business intelligence (BI) systems. T/F...
The overwhelming majority of competitive actions taken by businesses today feature computerized information system support. T/F
The overwhelming majority of competitive actions taken by businesses today feature computerized information system support. T/F
Answer: Tru...
In addition to deploying business intelligence (BI) systems, companies may also perform other actions to counter business pressures, such as improving customer service and entering business alliances. T/F
In addition to deploying business intelligence (BI) systems, companies may also perform other actions to counter business pressures, such as improving...
The complexity of today's business environment creates many new challenges for organizations, such as global competition, but creates few new opportunities in return. T/F
The complexity of today's business environment creates many new challenges for organizations, such as global competition, but creates few new opportunities...
Computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities. T/F
Computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities....
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?
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...
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?
Statistical Data Variable Type: A variable that contains a countable number of distinct values would best be categorized as which of the following variable...
Which of the following measures of central location would be best to use when the Skewness is approximately zero?
Which of the following measures of central location would be best to use when the Skewness is approximately zero?
Mean
Median
Mode
2nd Quartile
...
Which of the following is a common way of visualizing the frequency distribution of data points over a range of possible values?
Which of the following is a common way of visualizing the frequency distribution of data points over a range of possible values?
Quantitative Easing...
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...
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...
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...
For a column in your dataset, your data analysis tool is telling you that the standard deviation is zero. What does this say about the data in that column?
For a column in your dataset, your data analysis tool is telling you that the standard deviation is zero. What does this say about the data in that...
Subscribe to:
Posts (Atom)