Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer if true or false a.Large dimensions usually have multiple hierarchies T / F b. Conformed dimensions are not absolutely necessary in a data warehouse

Answer if true or false

a.Large dimensions usually have multiple hierarchies T / F

b. Conformed dimensions are not absolutely necessary in a data warehouse T / F

c.Requirement analysis of operational and data warehouse are very similar T / F

d. Categories are attributes of business dimension. T / F

e. It is not always necessary to conduct pre-interview research T / F

f.The departmental users are very good source for information on data structures of operational system T / F

g.The data warehouse can be defined as the warehouse of data. T / F

h. Data warehouse helps in customized marketing T / F

i.Most of organizations knowledge base contains unstructured data. T / F

j.It is most important to include unstructured data than structured data in data warehouse T / F

k.Normally, data flows from data warehouse repository to data staging area. T / F

l.Technical architecture simply means the vendor tools T / F

m. Sometime the results of individual queries are held in temporary tables for repeated use. T / F

n. Metadata is needed by IT for data warehouse administration T / F

o. Data warehouse in not a product, it is an environment. T / F

p. Every numeric attribute of production database is a fact in fact table T / F

q. Requirement definition document is the basis for next phase T / F

r.Unlike the requirements of operational system, the requirements of data warehouse not very clear. T / F

s.Data warehouse is an ongoing process, each implementation project should have a cycle with a specific beginning and an end. T / F

t.Business requirement gathering and technical architecture design can be done in parallel. T / F

u. Kimballs life cycle is a more practical approach to design and implement data warehouse T / F

v.Priority grid is an effective tool for reaching consensus on a data warehouse starting single process for implementation. T / F

w. Application track coding can start in parallel with dimensional design part of data track..... T / F

x.The questions drafted for interview by Lead should be more data oriented than IT oriented. T / F

y. All facts in fact table should at the same grain or level of detail T / F

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions

Question

Find the derivative of y= cos cos (x + 2x)

Answered: 1 week ago

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago