CIS 429 Entire Course New Flashcards
CIS 429 Midterm Exam NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-midterm-exam-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Midterm Exam NEW
1 ) The requirements definition for a data warehouse drives the plan for the Information Delivery architectural component in the following areas EXCEPT:
2 ) The requirements definition for a data warehouse drives the plan for the Source Data architectural component in the following areas EXCEPT:
3 ) In the design of data models for a data warehouse, the requirements definition is NOT the driving force for which of the following?
4 ) Requirements definition for a data warehouse must include information about data cleansing to drive the architectural plan for the Data Staging architectural component.
5 ) The requirements definition for a data warehouse drives which of the following in the plan for the Data Storage architectural component?
6 ) Typically, the data warehouse makes decision-support possible in a separate environment without hindering the operational systems.
7 ) Which of the following relates to the usefulness of strategic information for an enterprise?
8 ) In which way informational systems are different from operational systems?
9 ) Typically, which of the following is NOT a function of an operational system?
10 ) What were Executive Information Systems?
11) Which of the following is the correct matching of role and responsibility in a data warehouse project?
12 ) Which of the following are the three major functional components of a data warehouse that are wrapped around by the phases of SDLC in a data warehouse project? I.Data acquisition II.Data storage III.Data protection IV.Information Delivery V.Concurrency control
13 ) Assessment of readiness of an organization for a data warehouse would include which of the following?
14 ) A key success factor for a data warehouse project is to have a project manager being more technology-oriented than being user-oriented.
15 ) Which of the following is NOT an example of an activity for justifying a data warehouse in an organization before starting the project?
16 ) For a manufacturing company, which two of the following would represent business dimensions? I.Sales revenue II.Number of orders III.Product IV.Unit cost V.Ship method
17 ) Which of the following may be a “category” in an information package while defining requirements for a data warehouse?
I.Holiday flag in the time dimension
II.District in the sales region dimension
III.Package type in the product dimension
18 ) Which of the following is NOT a component of an information package created during the requirements definition for a data warehouse?
19 ) The JAD approach to requirements gathering is a structured methodology with defined roles for the participants.
20 ) For an insurance business, which of the following would represent facts or metrics?
21 ) Predictive Analytics enable organizations to recognize opportunities and anticipate problems.
22 ) A CRM-ready data warehouse must hold details of every transaction at every touchpoint with each customer.
23 )Of the three options for integration of ERP and data warehouse, the hybrid option involves building a custom data warehouse and using third-party tools to extract data from the ERP datasets.
24 ) Which of the following is an example of use of agent technology in a data warehouse?
25 ) Which of the following is NOT an example of infrastructure products in a data warehouse?
26 ) In a data warehouse with independent data marts, all data for information delivery is kept in the centralized data warehouse repository.
27 ) Which of the following represents the data flow in the major area of data acquisition in the data warehouse?
28 ) Which of the following is the correct matching of architectural components of the data warehouse and how they prepare data for the data flow?
29 ) MDDBs are generally proprietary database products.
30 ) Which of the following are the major functions of the management and control module of the data warehouse?
31 ) Data in the data warehouse is said to be nonvolatile because it is standardized and well-integrated.
32 ) Which of the following is an advantage of the top-down approach to building a data warehouse?
33 ) Data granularity in the data warehouse refers to the level of detail of the data.
34 )For a data warehouse of the hub-and-spoke architectural type, which of the
following applies?
35 ) Which of the following is true of the fundamental features of the data warehouse?
I. Contains time-variant data
II.Contains event-driven data
III.Contains nonvolatile data
36 ) Which of the following is the correct matching of parallel processing hardware options of the data warehouse and their corresponding limitations?
37 ) Which of the following is the correct matching of platform options for the staging area of the data warehouse and their corresponding benefits?
38 ) While adopting the client/server architecture for the data warehouse, which of the following are the purposes of the application servers?
39 ) Which of the following is the correct matching of parallel processing hardware options of the data warehouse and their corresponding features?
40 ) For selection of the operating system for the data warehouse, which of the following general criteria apply?
I.Reliability - protect the environment from application malfunctions
II.Security - protect each client and associated resources
III.Preemptive Multitasking - allow higher priority task to preempt another task
IV.Automatic Shutdown - shut down automatically when idle
V.Memory Protection - prevent one task from violating memory space of another
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-midterm-exam-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 2 Assignment 1 Warehousing Fundamentals (Section 1) NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-2-assignment-1-warehousing-fundamentals-section-1-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 2 Assignment 1 Warehousing Fundamentals (Section 1) NEW
Due Week 2 and worth 100 points
This assignment contains two (2) sections: Written Report and PowerPoint Presentation. You must submit both sections for the completion of this assignment.
Section 1: Written Report
Imagine you are the information technology specialist at your organization. The CIO has asked you to give a presentation to a select group of managers from different departments on business intelligence (BI). He suggested that you start by writing a report that would address the basics and bring the managers to the point of understanding the need for business intelligence. Considering the fact that the managers will be technical and nontechnical, you decide to take the CIO’s advice. In your report, start with the basics and conclude with a compare and contrast analysis of two (2) BI solutions.
Write a three to five (3-5) page paper in which you:
Examine and explain the relationship between data, information, and knowledge.
Define “strategic information” and explain its relationship to a data warehouse.
Explain the role of decision support systems (DSS), Enterprise Resource Planning (ERP), and business Intelligence (BI) as they relate to strategic decision-making within an organization.
Using the Internet, identify two (2) BI providers; then, compare and contrast the software capabilities.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Section 2: PowerPoint Presentation
In addition to the report, the CIO asks you to create a PowerPoint that can be used to illustrate the concepts from your report to the company’s management team.
Create a ten (10) slide PowerPoint presentation in which you:
Illustrate the concepts from your written report in Section 1 of this assignment.
Create bulleted speaking notes for the CIO’s reference in the notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.
Use a professional style to graphically convey the information.
The specific course learning outcomes associated with this assignment are:
Explain the significance of a data warehouse and its basic structure.
Use technology and information resources to research issues in data warehousing.
Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-2-assignment-1-warehousing-fundamentals-section-1-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 3 Assignment 2 Business Requirements NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-3-assignment-2-business-requirements-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 3 Assignment 2 Business Requirements NEW
Due Week 3 and worth 100 points
Imagine the CIO comes to your office and tells you that since you did such an outstanding job on your previous assignment, he would like your help with explaining requirements gathering. He confesses that he is good with requirements gathering for operational systems but has never had to gather requirements for a data warehouse. He asks you to write him a report to explain the differences. In addition, he mentions that he has read that joint application development (JAD) is a development methodology that could be used to rally stakeholders and that it would be a good fit for the company’s development effort. He asks you to include, in your report, relevant information relating to JAD.
Write a three to five (3-5) page paper in which you:
Analyze the purpose of requirements gathering and justify its role in any development process.
Explain three (3) differences between building an operational system and a data warehouse.
Explain the significance of information package diagrams.
Assess the importance of JAD to database warehouse development based on the following:
user involvement
requirements gathering
the development process
Compare and contrast JAD to the Waterfall methodology, which is commonly used in software development projects. Include the following items:
user involvement
requirements gathering
the development process
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Explain the significance of a data warehouse and its basic structure.
Use technology and information resources to research issues in data warehousing.
Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-3-assignment-2-business-requirements-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 4 Assignment 3 The Importance of Metadata NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-4-assignment-3-the-importance-of-metadata-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 4 Assignment 3 The Importance of Metadata NEW
Due Week 4 and worth 100 points
This assignment contains two (2) sections: Written Report and PowerPoint Presentation. You must submit both sections for the completion of this assignment.
Section 1: Written Report
Imagine that the CIO comes to you with a frustrated look on his face. He has realized that metadata is a key foundational piece of a data warehouse. He asks you to write a report that emphasis the importance of metadata, the types of metadata, and the impact of metadata on the ETL process. He shows you an article that states that faulty metadata will lead to poor information from the data warehouse. The executive team is eager to move forward but the risk of faulty metadata is making the CIO apprehensive. He reiterates that the report will be used to explain metadata to the company’s management team. He reminds you that the team comprises of technical and nontechnical stakeholders. In your report, you must show why metadata is a major building block for a data warehouse and how it impacts ETL.
Write a three to five (3-5) page paper in which you:
List and explain three (3) differences between data dictionaries used in database management systems and metadata that is used in data warehousing. Identify three (3) primary reasons why metadata are important in a data warehouse. List three (3) significant differences between business and technical metadata. Explain why each difference is relevant. Identify and explain three (3) significant points that show the impact of metadata on the ETL process. Be sure to state where in the ETL process the impact would occur. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Section 2: PowerPoint Presentation
In addition to the report, the CIO asks you to create a PowerPoint that can be used to illustrate the concepts from your report to the company’s management team.
Create a ten (10) slide PowerPoint presentation in which you:
Illustrate the concepts from your written report in Section 1 of this assignment.
Create bulleted speaking notes for the CIO’s reference in the notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.
Use a professional style to graphically convey the information.
The specific course learning outcomes associated with this assignment are:
Describe the significance, use, and types of meta-data and meta-modeling.
Use technology and information resources to research issues in data warehousing.
Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-4-assignment-3-the-importance-of-metadata-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 7 Case Study 1 Data Warehousing and Testing NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-7-case-study-1-data-warehousing-and-testing-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 7 Case Study 1 Data Warehousing and Testing NEW
Due Week 7 and worth 80 points
Read the case study titled, “A comprehensive approach to data warehouse testing” found in Week 7 of the course shell.
Write a three to five (3-5) page paper in which you:
Consider the author’s viewpoints on testing. Do you agree? List and explain five (5) reasons why testing is important.
Evaluate the differences between testing data warehouse systems and software systems. Determine which differences are more pronounced.
Reflect upon the author’s lessons learned, select three (3) lessons with the highest importance, and explain why you chose them.
Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Analyze the evolution, ethical issues, and future trends in data warehousing.
Use technology and information resources to research issues in data warehousing.
Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-7-case-study-1-data-warehousing-and-testing-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 8 Case Study 2 Data Warehousing and the Web NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-8-case-study-2-data-warehousing-and-the-web-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 8 Case Study 2 Data Warehousing and the Web NEW
Due Week 8 and worth 80 points
Read the case study titled, “Real-time data warehousing for Business Intelligence” found in Week 8 of the course shell.
Write a three to five (3-5) page paper in which you:
Analyze and support why the ETL system is considered to be the most resource-consuming system in a data warehouse framework.
Take a position on the author’s opinion of semi-structured DMM over structured DMM. Support your position with evidence.
Take a position on the validity of the author’s implication of using semi-structured DMM for real-time updates. Support your position with evidence.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Compare the features and functions of OLAP models.
Use technology and information resources to research issues in data warehousing.
Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-8-case-study-2-data-warehousing-and-the-web-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 9 Case Study 3 Business Intelligence NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-9-case-study-3-business-intelligence-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 9 Case Study 3 Business Intelligence NEW
Due Week 9 and worth 80 points
Read the case study titled, “Business Intelligence for small and middle-sized enterprises” found in Week 9 of the course shell.
Write a three to five (3-5) page paper in which you:
Provide a succinct narrative of the main lessons learned from the article.
Compare the advantages and disadvantages of Web, memory, and vector BI solutions.
Consider the author’s notation that BI has become an essential part of all enterprises; discuss three (3) reasons why solutions that are aimed at large-scaled enterprises do not fit well with small and middle-sized enterprises.
Reflect upon the commonalities of Web and memory-based BI solutions.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Describe the relationship between business intelligence, data warehousing, and data mining.
Use technology and information resources to research issues in data warehousing.
Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-9-case-study-3-business-intelligence-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 10 Term Paper: Data Warehouse Project Plan NEW
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-10-term-paper-data-warehouse-project-plan-new
For more classes visit
http://www.assignmentcloud.com
CIS 429 Week 10 Term Paper: Data Warehouse Project Plan NEW
Due Week 10 and worth 200 points
Imagine that the CIO has been impressed with your past performance and has promoted you to database administrator. Your first project is to create a data warehouse project plan that will merge five (5) disparate operational data sources into a common warehouse and associated data marts. The project plan will address the technical design for the future implementation of the data warehouse. Your company has realized that there is a great amount of data within the company’s disparate data sources and a data warehouse with a robust interface is needed to provide quality information. You approach the project plan with the understanding that a data warehouse is a system that:
Gathers data from three (3) internal organizational systems and two (2) external sources.
Combines the data into one database.
Manipulates and conforms it to common and organizational standards.
Restructures it for easy exploration, reporting, and data mining.
Using your knowledge of requirements gatherings, architectural framework, the ETL system, and testing methodologies for data warehouse projects, develop a project plan which details the implementation concepts and strategy that will lead to a successfully deployed data warehouse.
Write a twelve to fifteen (12-15) page paper in which you:
Write a problem statement to include an introduction of the company and the factors that have lead to the need for a data warehouse.
Construct a requirements document that details the business user and technical requirements.
Use Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, or OpenOffice to complete the following. Note: The graphically depicted solution may not exceed five (5) pages toward the required page length. Ensure that each depiction has a written explanation that explains the illustration.
Construct the business and technical metadata that would be necessary for the data warehouse.
Create a schema for the data warehouse.
Construct the necessary fact table(s) and dimensional table(s).
Illustrate the flow of data including both inputs and outputs for the data warehouse.
Recommend and justify a business intelligence (BI) solution; then, depict the probable dashboard needed by expert users.
Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the Word document before the paper is submitted.
The specific course learning outcomes associated with this assignment are:
Develop a data warehousing solution to solve a proposed business problem.
Use graphic software to Illustrate and apply the use of dimensional modeling to address and solve a proposed business problem.
Use technology and information resources to research issues in data warehousing.
Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.
Check this A+ tutorial guideline at
http://www.assignmentcloud.com/cis-429-strayer/cis-429-week-10-term-paper-data-warehouse-project-plan-new
For more classes visit
http://www.assignmentcloud.com
