Category Archives: CIS 429

CIS 429 Midterm Exam Recent

CIS 429 Midterm Exam Recent

Check this A+ tutorial guideline at

http://www.uopassignments.com/cis-429-strayer/cis-429-midterm-exam-recent

For more classes visit

http://www.uopassignments.com/

CIS 429 Midterm Exam Recent

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

CIS 429 Week 2 Assignment 1 Warehousing Fundamentals Section 1 Recent

CIS 429 Week 2 Assignment 1 Warehousing Fundamentals (Section 1) Recent

Check this A+ tutorial guideline at

http://www.uopassignments.com/cis-429-strayer/cis-429-week-2-assignment-1-warehousing-fundamentals-section-1-recent

For more classes visit

http://www.uopassignments.com/

CIS 429 Week 2 Assignment 1 Warehousing Fundamentals (Section 1) Recent

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.

CIS 429 Week 3 Assignment 2 Business Requirements Recent

CIS 429 Week 3 Assignment 2 Business Requirements Recent

Check this A+ tutorial guideline at

http://www.uopassignments.com/cis-429-strayer/cis-429-week-3-assignment-2-business-requirements-recent

For more classes visit

http://www.uopassignments.com/

CIS 429 Week 3 Assignment 2 Business Requirements Recent

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.

CIS 429 Week 7 Case Study 1 Data Warehousing and Testing Recent

CIS 429 Week 7 Case Study 1 Data Warehousing and Testing Recent

Check this A+ tutorial guideline at

http://www.uopassignments.com/cis-429-strayer/cis-429-week-7-case-study-1-data-warehousing-and-testing-recent

For more classes visit

http://www.uopassignments.com/

CIS 429 Week 7 Case Study 1 Data Warehousing and Testing Recent

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.

CIS 429 Week 8 Case Study 2 Data Warehousing and the Web Recent

CIS 429 Week 8 Case Study 2 Data Warehousing and the Web Recent

Check this A+ tutorial guideline at

http://www.uopassignments.com/cis-429-strayer/cis-429-week-8-case-study-2-data-warehousing-and-the-web-recent

For more classes visit

http://www.uopassignments.com/

CIS 429 Week 8 Case Study 2 Data Warehousing and the Web Recent

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.

CIS 429 Week 9 Case Study 3 Business Intelligence Recent

CIS 429 Week 9 Case Study 3 Business Intelligence Recent

Check this A+ tutorial guideline at

http://www.uopassignments.com/cis-429-strayer/cis-429-week-9-case-study-3-business-intelligence-recent

For more classes visit

http://www.uopassignments.com/

CIS 429 Week 9 Case Study 3 Business Intelligence Recent

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 lest 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.

CIS 429 Week 10 Term Paper Data Warehouse Project Plan Recent

CIS 429 Week 10 Term Paper: Data Warehouse Project Plan Recent

Check this A+ tutorial guideline at

http://www.uopassignments.com/cis-429-strayer/cis-429-week-10-term-paper-data-warehouse-project-plan-recent

For more classes visit

http://www.uopassignments.com/

CIS 429 Week 10 Term Paper: Data Warehouse Project Plan Recent

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.