Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started