Question

In: Computer Science

Because data warehouses are highly de-normalized, they are highly redundant. A          True B          False Which of...

Because data warehouses are highly de-normalized, they are highly redundant.

A          True

B          False

Which of the following measure is fully additive?

  1. Checking Account Daily Balance
  2. Product Full Price
  3. Sales Revenue Amount
  4. Average Product Cost

After conducting requirements analysis for a data warehouse, it is found that “region” is one of the decision dimensions. The sales are analyzed by zip code, city, state and region. The representation zip → city → state → region is considered a ______.

A Region scale

B Normalization

C Hierarchy

D All of the above

In above problem, the finest granularity is represented by:

A Zip

B City

C State

D Region

E Insufficient information to determine

A surrogate key has following ____ characteristic(s).

A         Only used in dimension tables

B .        System-generated

C .        Non-composite

D          (B) and (C)

E          (A), (B), and (C)

As for a FACT Table in a data warehouse, which following is NOT TRUE.

A          A fact table contains attributes that are typically numeric.

B          Besides keys it contains only one numerical value known as measure.

C.         Each record in fact table represents data about an event arising from interaction of all of the dimensions.

D.         A fact table contains fact-measure attributes and foreign keys that connect the fact table to the dimension tables.

Which of the following is not true of a data warehouse?

a.         The data warehouse is physically separated from all other operational systems.

b.         The data warehouse replaces the need for all other reporting systems within an organization.

c.         The data warehouse holds aggregated data and detailed data for management.

d.         None of the above.

Solutions

Expert Solution

Because data warehouses are highly de-normalized, they are highly redundant.

  • TRUE

Which of the following measure is fully additive?

  • Average Product Cost

After conducting requirements analysis for a data warehouse, it is found that “region” is one of the decision dimensions. The sales are analyzed by zip code, city, state and region. The representation zip → city → state → region is considered a ______.

  • B - Normalization

In above problem, the finest granularity is represented by:

  • D - Region

A surrogate key has following ____ characteristic(s).

  • D    (B) and (C)

As for a FACT Table in a data warehouse, which following is NOT TRUE.

  • B   Besides keys it contains only one numerical value known as measure.

Which of the following is not true of a data warehouse?

  • B.  The data warehouse replaces the need for all other reporting systems within an organization.

Related Solutions

Extrapolation with linear models beyond the given data is highly accurate. TRUE or FALSE? a. True...
Extrapolation with linear models beyond the given data is highly accurate. TRUE or FALSE? a. True b. False Linear regression models may not always acccurately reflect the pattern of data from which they are made a. True b. False The "Portion of Variability" is also known as the a. Correlation coefficient b. Regression line c. Fitted Value d. Coefficient of determination Investigating the difference between the predicted value of y and the actual value y a. Least Squares Regression b....
1. True or false: heating air de-humidifies it.
  1.      True or false: heating air de-humidifies it. 2.      What capacity (power) electric heater would be needed to raise the temperature of 300 cubic feet of concrete from 65° F to 150° F in 120 minutes? As this is electrical power, state response in watts or kilowatts. 3.      What would be the total cost of #2 fuel oil to operate a boiler expected to perform the task in question 2 if the boiler were operating at full fire with an efficiency of...
Viruses are living organisms, because they contain DNA and RNA.        A) TRUE        B) FALSE The...
Viruses are living organisms, because they contain DNA and RNA.        A) TRUE        B) FALSE The field of genetics includes the study of cellular processes including transcription and translation. A) TRUE         B) FALSE Sequencing of organisms’ DNA has in many cases resulted in their original taxonomic reclassification based upon anatomical structure.     A) TRUE     B) FALSE The # of chromosomes per cell never changes at any point during mitotic cell division. A) True           B) False In a diploid organism, __________line up...
1. All mutations are harmful. a) True b) False 2. Which of the following is TRUE...
1. All mutations are harmful. a) True b) False 2. Which of the following is TRUE about mutations? a) Mutations are more likely to occur if they result in a useful trait b) Mutations can be inherited. c) Mutations only occur during DNA replication d) Mutations do not occur in organisms that reproduce asexually 3. Which of the following would increase the chances of getting a mutation? a) Wearing a hat outside b) Putting sunscreen on your face and arms...
B. Theorems--True or False? For each proposition, considered independently: (a) State whether True or False. (b)...
B. Theorems--True or False? For each proposition, considered independently: (a) State whether True or False. (b) Then explain your answer. Define the important terms in your explanation. You may use graphs in your answers. B1. A country's potential output can increase while its actual output decreases. B2. China will likely surpass the United States in per-capita GDP before it surpasses the United States in GDP itself.
The objectives of the data collection activity of the general model for accounting information systems are to collect data that are a. relevant and redundant. b. efficient and objective. c. efficient and redundant. d. efficient and relevant.
The objectives of the data collection activity of the general model for accounting information systems are to collect data that area. relevant and redundant.b. efficient and objective.c. efficient and redundant.d. efficient and relevant. 
True or False 1.  Chromosomecan be thought of as the more highly condensed form of DNAthat is...
True or False 1.  Chromosomecan be thought of as the more highly condensed form of DNAthat is seen in the cell during the mitotic phase portion of the cell cycle. 2. The sporophytecells of a plant are cells that should have the diploidamount of “chromosomes” present and some those cells can perform meiosisto produce spores. 3.  The centromere associated with each monad is a large cluster of numerous proteins, and these proteins are attached to the DNA region of the monad called...
True or false It is important to identify the cheapest bond to deliver because it is...
True or false It is important to identify the cheapest bond to deliver because it is the one the futures contract is priced off of.​ The conversion factor is the price of a bond with a face value of $1, coupon and maturity equal to that of the deliverable bond, and yield of 6 percent.​
which statements are true and false a) Always distill to the dryness of mixture b) Aluminum...
which statements are true and false a) Always distill to the dryness of mixture b) Aluminum foil is wrapped around fractional column so that no heat loss takes place c) Heat the system fast and increase tempt after awhile Group of answer choices F, T, F T, T, T T, T, F T, F, T
Decide which of the following statements are true and which are false. True False  Real gas molecules...
Decide which of the following statements are true and which are false. True False  Real gas molecules behave most ideally at low temperature and high pressure. True False  At constant temperature, the lighter the gas molecules, the smaller the average kinetic energy. True False  At constant temperature, the lighter the gas molecules, the smaller the average velocity. True False  In order for two separate 1.0 L samples of O2(g) and H2(g) to have the same average velocity, the O2(g) sample must be at a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT