Data Warehousing Questions - Part 2

26. Which of the following is NOT found in an ER Model?
a. A definition for each entity and data element
b. ER diagram
c. Entity and data element names
d. Fact and dimension tables

27. Which one is not true in context with informational system?
a. Smaller number of users
b. Access frequency is medium to low
c. Complex queries
d. Access type is read, update and delete

28. Consolidated data mart is
a. Second level data mart
b. First level data mart
c. All of these
d. None of the above

29. Which one is not the type of metadata in data warehouse?
a. Sequential metadata
b. Extraction and transformation metadata
c. End user metadata
d. Operational metadata

30. ___________ gives total view of an organization
a. OLAP
b. OLTP
c. Data warehouse
d. Database

31. Which of the following is the first step towards physical design process of data warehouse?
a. Complete physical model
b. Preparing indexing strategy
c. Determine data partitioning
d. Develop standards

32. Data warehouses performances highly dependent on proper indexing strategy
a. True
b. False

33. Which of the following is not a user of metadata?
a. IT professionals
b. Power users
c. Casual users
d. Sales person

34. Web based information delivery expands the data warehouse usage and open up new information strategies.
a. True
b. False

35. Types of metadata
a. Technical metadata
b. Business metadata
c. All of above
d. None of above

36. What is the primary responsibility of the project sponsor during data warehouse project?
a. To manage the day to day project activity
b. To approve and monitor the project budget
c. To ensure cooperation and support from all involved departments
d. To communicate project status to higher management and the board of directors

37. Web content can be used to enrich a data warehouse by
a. Add more descriptive attributes to the business dimensions
b. Create a new dimension table
c. Create a new fact table
d. All of above.

38. Which of the following is not an example of business metadata?
a. Connectivity procedures
b. Security and access privileges
c. The overall structure of data in business terms
d. Data aggregation rules

39. OLAP stands for
a. Online Application Processing
b. Online Analytical Processing
c. Online Application Protocol
d. Optical Light Analysis Protocol

40. Which of the following is not a web OLAP approach?
a. Browser plug-ins
b. Pre created HTML documents
c. OLAP in the server
d. Database

41. Back end processes involves
a. Data extraction
b. Preliminary data cleansing
c. Data warehouse structure definition
d. All of above

42. Partitioning means deliberate splitting of a table and its index data into manageable parts
a. True
b. False

43. Which one of the following is not an OLAP operation?
a. Roll up
b. Drill down
c. Drill access
d. Roll down

44. Metadata is a critical need for using, building and administering the data warehouse
a. True
b. False

45. Hypercube, a representation that accommodates more than 3 dimensions
a. True
b. False

46. A web enabled data warehouse uses the web for information delivery
a. True
b. False

47. Which of the following is not a definition of metadata?
a. Data about data
b. Data warehouse roadmap
c. Data warehouse atlas
d. Data about knowledge

48. Metadata is like a _______________
a. Knowledge center
b. Brain centre
c. Nerve centre
d. Data centre

49. OLAP supports multi dimensional analysis
a. True
b. False

50. MOLAP stands for
a. Model Online Analytical Processing
b. Multiple Online Analytical Processing
c. Multidimensional Online Analytical Processing
d. Model Online Analysis Processing