In contrast to data warehouses, operational databases support what type of processing?
Select one:
a. DSS
b. data mining
c. OLAP
d. OLTP
The answer to this question is as follows:
Datawarehouse systems are mainly used for the historical data i.e a large amount of data
The Datawarehouse systems are typically used to design high volume processing i.e OLAP
The answer is OLAP.
In contrast to data warehouses, operational databases support what type of processing? Select one: a. DSS...
Online Analytical Processing (OLAP) and data mining are fundamentally the same type of process, but have functional differences in how they are used in an organization. Explain OLAP and data mining processes. Include the following in your discussion: The functions of OLAP and data mining How OLAP and data mining complement one another How OLAP and data mining exist independently An example of when each system would be used Tools available to support each phase of these processes
One way to perform data integration is through А. DSS B. EIS C. ETL D OLTP
Question 1 A data warehouse differs from an operational database in that most data warehouses have a product orientation and are designed to handle transactions that update the database. Select one: True False Question 2 An operational data store (ODS) provides a fairly recent form of a customer information file (CIF), which is often used as an interim staging area for a data warehouse. Select one: True False Question 3 An advantage of the hub-and-spoke data warehouse architecture is that...
The principal difference between an executive information system (EIS) and a decision support system (DSS) is that an EIS: a. suggests to the user the best choice from among alternative courses of action whereas the DSS merely provides information that could assist in making the decision b. uses both external and internal data whereas a DSS does not c. is primarily about collecting and presenting information without doing additional processing or calculations d. employs decision models whereas a DSS does...
What type of data can be imported in to QBO? Select one: a. Customers b. Vendors c. Accounts d. Products and Services e. All of the above can be imported into QBO
The ANOVA test requires what type of data? Select one 0 a. normally distributed and continuous data O b. normally distributed and discrete data O c. Discrete and measured data O d. Data samples with equal size
Which of the followings is a major type of risk? Select one: a. Equity Price Risk b. Operational Risk c. Foreign Exchange Risk d. Interest Rate Risk
1. You want to spend a maximum of $100,000 on your first house. You need to use a(n) _____ analysis to figure out the location and size of those types of homes. A. affinity B. goal-seeking C. sensitivity D. what-if 2. _______ is a capability of dashboards that reflect the latest data available on KPIs or some other metric often in real time. A. Drill down B. Exception reporting C. Status access D. Trend analysis 3. ___________ decisions deal with...
Abstract Data Type is also called as ? Select one: a. Pop O b. Queue c. Peak d. Stack
[Computer Science, CS2203 - Databases 1] “A student can attend six courses, each with a different instructor. Each instructor teaches at least 3 courses.” What is the type of relationship between students and instructors? Select one: a. one-to-one b. one-to-many c. many-to-many d. None of the above