Assignment 1: XXXXXXXXXXDue date: 08/26/2020 By definition, a graduate-level research paper provides a discussion of the content in the scholarly article from peer-reviewed sources where research was...

Please review the assigned file and let me know if you will be able to accurately answer all.



Assignment 1: Due date: 08/26/2020 By definition, a graduate-level research paper provides a discussion of the content in the scholarly article from peer-reviewed sources where research was performed using relevant keywords. Do a research on the UMGC library for scholarly articles related to the below question, and then answer the below question. Answer the below questions by providing 150 words for each. 2) Describe the importance of denormalization as part of data warehouse design (150 words). 3) Review the key roles involved in the design of a dimensional model such as data modeler, business analyst, business intelligence application developer, data steward, ETL developer, database administrator, security manager, data warehouse administrator. Select a role and define the tasks that this person performs (150 words). 4) Identify the importance of selecting the Grain of a data warehouse in the Kimball Data Warehouse Model. Provide examples of grains within a Data Warehouse (150 words). 7) Compare and contrast the models used for developing a data warehouse for unstructured data versus structured data (150 words). 8) Define the importance of ontologies for unstructured data warehouses. Provide an example of unstructured data and the use of an ontology used to manage this data (150 words). 9) Define the importance of indexes for unstructured data warehouses. Provide an example of unstructured data and the indexes that you would define to manage this data (150 words). 10) Identify design decisions that must be made as part of the ETL process. Describe the importance of these design decisions (150 words). Grading rubric: · APA formatting of each question including citations and references is worth 10 points. One point off for each error. · Each scholarly article from peer-reviewed sources from the UMGC library is worth two points for a maximum of 8 points. · Content relevant to each question is worth 10 points. Distinguished (10), Advanced (8), Proficient (6), Basic (4), or Unacceptable (2). · Question length between 100 and 150 words for the Content is worth 9 points, met (9) or unmet (0). The References section is not included in the word count. · Proper spelling, punctuation, and grammar are worth 9 points. One point off for each error. Warning: Wikipedia and sites such as blogs are not scholarly sources and will result in a zero grade for APA citation and references. You should use the UMGC library to perform graduate-level research for scholarly articles from peer-reviewed sources. Therefore, use only references from the UMGC library for all research in this assignment. This assignment will be submitted to Turnitin; therefore, similarity index should be less than 10%. UMGC Libray: https://sites.umgc.edu/library/index.cfm?_ga=2.26659579.75802204.1590034987-36080969.1569956532 If it prompts you to login, use this Username: saku Password: chk@25SA