Mr Raza
NAME: __Muhammad Raza______________________________________________________________________________
MULTIPLE CHOICE: Please circle the correct answer. (4 Points Each)
1. The four components of a data warehouse are a. Source processing, data design, data programming, data files b. Operational source systems, data staging, data presentation, data access tools c. Transaction coding, data development, data analysis, data reporting d. None of the above 2. ETL represents the process where e. the data is sorted, indexed and standardized f. the data is used by statistical and report writing software g. the data that is used by transactional and/or operational systems h. None of the above 3. The table in the data warehouse that contains detailed information and a primary key is called the i. Dimension j. Fact table k. Factless table l. None of the above 4. The table in the data warehouse that contains foreign keys and quantitative/qualitative information is called the m. Dimension n. Fact table o. Factless table p. None of the above
Match the characteristics to the component of a data warehouse
5. _____c___________ operational source systems 6. _____b___________ primary key 7. _____a___________ data staging 8. _____d___________ foreign key 9. _____g___________ composite key 10. _____e___________ data presentation 11. _____f___________ data access tools
q. this component is also called the ETL r. a unique identifier s. data is fed into the data warehouse from these systems t. a primary key in another table u. users think that this area is the entire data warehouse v. users utilize these to create reports and generate trend analysis w. a series of keys which together make uniqueness
For the following questions, refer to the information provided below
MULTIPLE CHOICE: Please circle the correct answer. (4 Points Each)
1. The four components of a data warehouse are a. Source processing, data design, data programming, data files b. Operational source systems, data staging, data presentation, data access tools c. Transaction coding, data development, data analysis, data reporting d. None of the above 2. ETL represents the process where e. the data is sorted, indexed and standardized f. the data is used by statistical and report writing software g. the data that is used by transactional and/or operational systems h. None of the above 3. The table in the data warehouse that contains detailed information and a primary key is called the i. Dimension j. Fact table k. Factless table l. None of the above 4. The table in the data warehouse that contains foreign keys and quantitative/qualitative information is called the m. Dimension n. Fact table o. Factless table p. None of the above
Match the characteristics to the component of a data warehouse
5. _____c___________ operational source systems 6. _____b___________ primary key 7. _____a___________ data staging 8. _____d___________ foreign key 9. _____g___________ composite key 10. _____e___________ data presentation 11. _____f___________ data access tools
q. this component is also called the ETL r. a unique identifier s. data is fed into the data warehouse from these systems t. a primary key in another table u. users think that this area is the entire data warehouse v. users utilize these to create reports and generate trend analysis w. a series of keys which together make uniqueness
For the following questions, refer to the information provided below