Latest Data Warehousing Multiple Choice Questions and Answers for pdf free download
1. Which of the following features usually applies to data in a data warehouse?
2. Which of the following statement is true?
3. The following is true of three-tier data warehouses:
4. The following technology is not well-suited for data mining:
5. What is true of the multidimensional model?
6. The value at the intersection of the row labeled "India" and the column "Savings" in Table2 should be:
7. We want to add the following capabilities to Table2: show the data for 3 age groups (20-39, 40-60, over 60), 3 revenue groups (less than $10,000, $10,000-$30,000, over $30,000) and add a new type of account: Money market. The total number of measures will be:
8. We want to add the following capability to Table2: for each type of account in each region, also show the dollar amount besides the number of customers. This adds to Table2:
9. The most common source of change data in refreshing a data warehouse is:
10. Which of the following statements is not true about refreshing a data warehouse:
11. A data warehouse is which of the following?
12. An operational system is which of the following?
13. The generic two-level data warehouse architecture includes which of the following?
14. The @active data warehouse architecture includes which of the following?
15. Reconciled data is which of the following?
16. Transient data is which of the following?
17. The extract process is which of the following?
18. Data scrubbing is which of the following?
19. The load and index is which of the following?
20. Data transformation includes which of the following?
21. A multi field transformation does which of the following?
22. A star schema has what type of relationship between a dimension and fact table?
23. Fact tables are which of the following?
24. A snowflake schema is which of the following types of tables?
25. A goal of data mining includes which of the following?
26. Which of the following statements does not apply to relational databases?
27. In the relational database terminology, a table is synonymous with:
28. A null value indicates:
29. When the referential integrity rule is enforced, which one is usually not a valid action in response to the deletion of a row that contains a primary key value referenced elsewhere?
30. When an equi-join is performed on a table of N rows and a table of M rows, the resulting table has the following number of rows:
31. The Union of a table of N rows and of a table of M rows (M<=N) has the following number of rows:
32. The following pair of tables is union compatible:
33. A data mart is designed to optimize the performance for well-defined and predicable uses.
34. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
35. Data in operational systems are typically fragmented and inconsistent.
36. Most operational systems are based on the use of transient data.
37. Independent data marts are often created because an organization focuses on a series of short-term business objectives.
38. Joining is the process of partitioning data according to predefined criteria.
39. The role of the ETL process is to identify erroneous data and to fix them.
40. Data in the data warehouse are loaded and refreshed from operational systems.
41. Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
42. Periodic data are data that are physically altered once added to the store.
43. Both status data and event data can be stored in a database.
44. Static extract is used for ongoing warehouse maintenance.
45. Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
46. Every key used to join the fact table with a dimensional table should be a surrogate key.
47. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
48. Because they should not contain SQL manipulation statements, what kind of trigger is typically used to enforce complex integrity constraints?
49. Which of the following is not a common cursor attribute?
50. The INTO clause of the SELECT statement:
1. Which of the following features usually applies to data in a data warehouse?
2. Which of the following statement is true?
3. The following is true of three-tier data warehouses:
4. The following technology is not well-suited for data mining:
5. What is true of the multidimensional model?
6. The value at the intersection of the row labeled "India" and the column "Savings" in Table2 should be:
7. We want to add the following capabilities to Table2: show the data for 3 age groups (20-39, 40-60, over 60), 3 revenue groups (less than $10,000, $10,000-$30,000, over $30,000) and add a new type of account: Money market. The total number of measures will be:
8. We want to add the following capability to Table2: for each type of account in each region, also show the dollar amount besides the number of customers. This adds to Table2:
9. The most common source of change data in refreshing a data warehouse is:
10. Which of the following statements is not true about refreshing a data warehouse:
11. A data warehouse is which of the following?
12. An operational system is which of the following?
13. The generic two-level data warehouse architecture includes which of the following?
14. The @active data warehouse architecture includes which of the following?
15. Reconciled data is which of the following?
16. Transient data is which of the following?
17. The extract process is which of the following?
18. Data scrubbing is which of the following?
19. The load and index is which of the following?
20. Data transformation includes which of the following?
21. A multi field transformation does which of the following?
22. A star schema has what type of relationship between a dimension and fact table?
23. Fact tables are which of the following?
24. A snowflake schema is which of the following types of tables?
25. A goal of data mining includes which of the following?
26. Which of the following statements does not apply to relational databases?
27. In the relational database terminology, a table is synonymous with:
28. A null value indicates:
29. When the referential integrity rule is enforced, which one is usually not a valid action in response to the deletion of a row that contains a primary key value referenced elsewhere?
30. When an equi-join is performed on a table of N rows and a table of M rows, the resulting table has the following number of rows:
31. The Union of a table of N rows and of a table of M rows (M<=N) has the following number of rows:
32. The following pair of tables is union compatible:
33. A data mart is designed to optimize the performance for well-defined and predicable uses.
34. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
35. Data in operational systems are typically fragmented and inconsistent.
36. Most operational systems are based on the use of transient data.
37. Independent data marts are often created because an organization focuses on a series of short-term business objectives.
38. Joining is the process of partitioning data according to predefined criteria.
39. The role of the ETL process is to identify erroneous data and to fix them.
40. Data in the data warehouse are loaded and refreshed from operational systems.
41. Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
42. Periodic data are data that are physically altered once added to the store.
43. Both status data and event data can be stored in a database.
44. Static extract is used for ongoing warehouse maintenance.
45. Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
46. Every key used to join the fact table with a dimensional table should be a surrogate key.
47. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
48. Because they should not contain SQL manipulation statements, what kind of trigger is typically used to enforce complex integrity constraints?
49. Which of the following is not a common cursor attribute?
50. The INTO clause of the SELECT statement:
No comments:
Post a Comment