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...
Relational Databases are designed for what specific kind of processing? Select the best answer from the following. Online Transaction Processing (OLTP) Service Oriented Architecture (SOA) Data warehousing. Stream data processing. QUESTION 3 How should the components within Service Oriented Architecture be viewed? Select the best answer from the following. Hardware. Services. Custom developed software. Tasks. QUESTION 4 In a web database architecture what is the primary concern? Select the best answer from the following. Hardware. Services. Software. Security. Elasticity. QUESTION...
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