organized around important subject areas.

contains numerous naming conventions and formats

Data Warehousing MCQ Multiple Choice Questions Answers - Page 2 for Practice

Q: 31. The type of relationship in star schema is

Correct Answer is: one-to-many.

Q: 33. Which of the following is not a component of a data warehouse?

Correct Answer is: Component Key

Q: 34. Detail data in single fact table is otherwise known as

Correct Answer is: atomic data.

Q: 35. _____________consists of information in the enterprise that is not in classical form.

Correct Answer is: Mushy metadata.

Q: 39. Record cannot be updated in

Correct Answer is: data warehouse

Q: 41. The full form of OLAP is

Correct Answer is: Online Analytical Processing

Q: 42. The source of all data warehouse data is the

Correct Answer is: operational environment.

Q: 44. The biggest drawback of the level indicator in the classic star-schema is that it limits

Correct Answer is: flexibility.

Q: 47. ........................ is a good alternative to the star schema.

Correct Answer is: Fact constellation

Q: 48. ___________ is a good alternative to the star schema.

Correct Answer is: Fact constellation.

31. The type of relationship in star schema is

many-to-many.
one-to-one.
one-to-many.
many-to-one.

32. _______test is used in an online transactional processing environment.

MEGA.
MICRO.
MACRO.
ACID.

33. Which of the following is not a component of a data warehouse?

Metadata
Current detail data
Lightly summarized data
Component Key

34. Detail data in single fact table is otherwise known as

monoatomic data.
diatomic data.
atomic data.
multiatomic data.

35. _____________consists of information in the enterprise that is not in classical form.

Mushy metadata.
Differential metadata.
Data warehouse.
Data mining.

36. Data warehouse contains_____________data that is never found in the operational environment.

normalized.
informational.
summary.
denormalized.

37. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

OLAP
OLTP
Both of the above
None of the above

38. The data is stored, retrieved & updated in

OLAP.
OLTP.
SMTP.
FTP.

39. Record cannot be updated in

OLTP
files
RDBMS
data warehouse

40. The star schema is composed of __________ fact table.

one.
two.
three.
four.

41. The full form of OLAP is

Online Analytical Processing
Online Advanced Processing
Online Advanced Preparation
Online Analytical Performance

42. The source of all data warehouse data is the

operational environment.
informal environment.
formal environment.
technology environment.

43. ________________ is the specialized data warehouse database.

Oracle.
DBZ.
Informix.
Redbrick.

44. The biggest drawback of the level indicator in the classic star-schema is that it limits

quantify.
qualify.
flexibility.
ability.

45. The data Warehouse is

read only
write only
read write only
none

46. __________describes the data contained in the data warehouse.

Relational data.
Operational data.
Metadata.
Informational data.

47. ........................ is a good alternative to the star schema.

Star schema
Snowflake schema
Fact constellation
Star-snowflake schema

48. ___________ is a good alternative to the star schema.

Star schema.
Snowflake schema.
Fact constellation.
Star-snowflake schema.

49. The important aspect of the data warehouse environment is that data found within the data warehouseis___________.

subject-oriented.
time-variant.
integrated.
All of the above.

50. The key used in operational environment may not have an element of

time.
cost.
frequency.
quality.

51. _______________ is the goal of data mining.

To explain some observed event or condition.
To confirm that data exists.
To analyze data for expected relationships.
To create a new data warehouse.

52. The ............................ exposes the information being captured, stored, and managed by operational systems.

top-down view
data warehouse view
data source view
business query view

53. The .................. allows the selection of the relevant information necessary for the data warehouse.

top-down view
data warehouse view
data source view
business query view

54. A data warehouse is

updated by end users.
contains numerous naming conventions and formats
organized around important subject areas.
contains only current data.

55. An operational system is

used to run the business in real time and is based on historical data.
used to run the business in real time and is based on current data.
used to support decision making and is based on current data.
used to support decision making and is based on historical data.

56. ________________defines the structure of the data held in operational databases and used byoperational applications.

User-level metadata.
Data warehouse metadata.
Operational metadata.
Data mining metadata.

57. The data is stored, retrieved and updated in

OLAP
OLTP
SMTP
FTP