Categories
CIS 429 Midterm Exam
$10.00

CIS 429 Midterm Exam

This Tutorial was purchased 5 times & rated A by student like you.

 

This Tutorial contains following Attachments

  • CIS 429 Midterm Exam.docx

CIS 429 Midterm Exam

 

           

           

           

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

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$15.00

This Tutorial was purchased 4 times & rated B+ by student like you.

CIS 429 Week 10 Term Paper: Data Warehouse Project Plan Term Paper: Data Warehouse Project Plan   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 ..
$9.99

This Tutorial was purchased 0 times & rated No rating by student like you.

CIS 429 Week 9 Case Study 3: Business Intelligence Case Study 3: Business Intelligence   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.   Wr..
$9.99

This Tutorial was purchased 2 times & rated A+ by student like you.

CIS 429 Week 8 Case Study 2: Data Warehousing and the Web Case Study 2: Data Warehousing and the Web   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.   ..
$9.99

This Tutorial was purchased 0 times & rated No rating by student like you.

CIS 429 Week 7 Case Study 1: Data Warehousing and Testing Case Study 1: Data Warehousing and Testing   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.   ..
$9.99

This Tutorial was purchased 4 times & rated A by student like you.

This Tutorial contains Section 1  (Only Paper, No PPT)     CIS 429 Week 4 Assignment 3: The Importance of Metadata Assignment 3: The Importance of Metadata   Due Week 4 and worth 100 points   This assignment contains two (2) sections: Writt..
$9.99

This Tutorial was purchased 0 times & rated No rating by student like you.

CIS 429 Week 3 Assignment 2 Business Requirements Assignment 2: Business Requirements   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 hel..
$10.00

This Tutorial was purchased 3 times & rated A+ by student like you.

This Tutorial contains Section 1 Only (Only Paper, No PPT)   CIS 429 Week 2 Assignment 1 Warehousing Fundamentals Assignment 1: Warehousing Fundamentals   Due Week 2 and worth 100 points   This assignment contains two (2) sections: Written Report and Pow..