26. d
27. d
28. a
29. a
30. c
31. d
32. a
33. d
34. a
35. c
36. b
37. d
38. d
39. b
40. d
41. d
42. a
43. d
44. a
45. a
46. a
47. d
48. c
49. a
50. c
Monday, September 26, 2011
Data Warehousing Answers - Part 1
1. c
2. d
3. a
4. a
5. c
6. a
7. b
8. a
9. c
10. d
11. a
12. d
13. b
14. a
15. c
16. a
17. b
18. a
19. d
20. d
21. b
22. b
23. a
24. c
25. d
2. d
3. a
4. a
5. c
6. a
7. b
8. a
9. c
10. d
11. a
12. d
13. b
14. a
15. c
16. a
17. b
18. a
19. d
20. d
21. b
22. b
23. a
24. c
25. d
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
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
Data Warehousing Questions - Part1
1. Date warehousing refers to
a. Storing data offline at a separate site.
b. Backing up data regularly
c. Data mining
d. Uses tapes as opposed to disk
2. When you ___________ the data, you are aggregating the data to higher level.
a. Drill down
b. Drill up
c. Wrap up
d. Roll up
3. State whether true or false: The entity relationship modeling technique is not suitable for data warehouses, the dimensional modeling technique is appropriate
a. True
b. False
4. A single database couldn’t server both operational high performance transaction processing and DSS, analytical processing, all at the same time
a. True
b. False
5. Which is not feature of fact table?
a. Few attributes
b. Large number of records
c. Dense data
d. Concatenated fact table key
6. In operational system numbers of users are large
a. True
b. False
7. Which one is not the component of data warehouse?
a. Source data
b. External data
c. Data storage
d. Data staging
8. Which of the following operation differentiates HOLAP architecture from ROLAP and MOLAP architectures.
a. Drill across
b. Drill through
c. Drill down
d. Roll up
9. Which one is the key component of data warehouse architecture?
a. Data retrieval
b. Information retrieval
c. Read only data
d. Information delivery
10. Which is not the feature of dimension table?
a. Dimension table key
b. Attributes
c. Ability to drill down
d. Normalized data
11. Data warehouse is a
a. Computing environment
b. A software tool
c. A hardware product
d. All the above
12. Cube is a ________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
a. Logical
b. Physical
c. Analytical
d. None of these
13. During the data ______ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities
a. Analysis
b. Preparation
c. Classification
d. Acquisition
14. Snow flaking means
a. Normalizing the data
b. De normalizing data
c. Stabilizing data
d. None of the above
15. Which is not the nature of data in data warehouse?
a. Subject oriented data
b. Integrated data
c. Volatile data
d. Time variant data
16. Data mart is a subset of data warehouse statement is
a. True
b. False
17. The goal of star schema design is to simply __________________
a. Logical data model
b. Physical data model
c. Conceptual data model
d. None of these
18. State whether true or false: The STAR schema used for data design is a relational model consisting of fact and dimension tables.
a. True
b. False
19. Data warehouse is about taking/collecting data from different __________ sources.
a. Harmonized
b. Identical
c. Homogeneous
d. Heterogeneous
20. The dimension that is not available in the operational systems
a. Product
b. Store
c. Customer
d. Time
21. The input to the data warehouse can come from OLTP or transactional system but not from other third party database.
a. True
b. False
22. Which of the following is not a characteristic of strategic information?
a. Integrated
b. Raw data
c. Timely
d. Credible
23. Grain is the _______ level of data stored in the warehouse.
a. Atomic
b. Summarized
c. Aggregated
d. Cube
24. RDMS is a
a. Remote DBMS
b. Relative DBMS
c. Relational DBMS
d. Reliable DBMS
25. A snowflake is which of the following types of tables
a. Fact
b. Dimension
c. Helper
d. All the above
a. Storing data offline at a separate site.
b. Backing up data regularly
c. Data mining
d. Uses tapes as opposed to disk
2. When you ___________ the data, you are aggregating the data to higher level.
a. Drill down
b. Drill up
c. Wrap up
d. Roll up
3. State whether true or false: The entity relationship modeling technique is not suitable for data warehouses, the dimensional modeling technique is appropriate
a. True
b. False
4. A single database couldn’t server both operational high performance transaction processing and DSS, analytical processing, all at the same time
a. True
b. False
5. Which is not feature of fact table?
a. Few attributes
b. Large number of records
c. Dense data
d. Concatenated fact table key
6. In operational system numbers of users are large
a. True
b. False
7. Which one is not the component of data warehouse?
a. Source data
b. External data
c. Data storage
d. Data staging
8. Which of the following operation differentiates HOLAP architecture from ROLAP and MOLAP architectures.
a. Drill across
b. Drill through
c. Drill down
d. Roll up
9. Which one is the key component of data warehouse architecture?
a. Data retrieval
b. Information retrieval
c. Read only data
d. Information delivery
10. Which is not the feature of dimension table?
a. Dimension table key
b. Attributes
c. Ability to drill down
d. Normalized data
11. Data warehouse is a
a. Computing environment
b. A software tool
c. A hardware product
d. All the above
12. Cube is a ________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
a. Logical
b. Physical
c. Analytical
d. None of these
13. During the data ______ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities
a. Analysis
b. Preparation
c. Classification
d. Acquisition
14. Snow flaking means
a. Normalizing the data
b. De normalizing data
c. Stabilizing data
d. None of the above
15. Which is not the nature of data in data warehouse?
a. Subject oriented data
b. Integrated data
c. Volatile data
d. Time variant data
16. Data mart is a subset of data warehouse statement is
a. True
b. False
17. The goal of star schema design is to simply __________________
a. Logical data model
b. Physical data model
c. Conceptual data model
d. None of these
18. State whether true or false: The STAR schema used for data design is a relational model consisting of fact and dimension tables.
a. True
b. False
19. Data warehouse is about taking/collecting data from different __________ sources.
a. Harmonized
b. Identical
c. Homogeneous
d. Heterogeneous
20. The dimension that is not available in the operational systems
a. Product
b. Store
c. Customer
d. Time
21. The input to the data warehouse can come from OLTP or transactional system but not from other third party database.
a. True
b. False
22. Which of the following is not a characteristic of strategic information?
a. Integrated
b. Raw data
c. Timely
d. Credible
23. Grain is the _______ level of data stored in the warehouse.
a. Atomic
b. Summarized
c. Aggregated
d. Cube
24. RDMS is a
a. Remote DBMS
b. Relative DBMS
c. Relational DBMS
d. Reliable DBMS
25. A snowflake is which of the following types of tables
a. Fact
b. Dimension
c. Helper
d. All the above
Subscribe to:
Posts (Atom)