Home Virtual university online quiz CS614 Midterm Past Paper online Practice Quiz

CS614 Midterm Past Paper online Practice Quiz

Abdurrab

January 15, 2022

788

Facebook

Twitter

Tumblr

CS614 Midterm Past Paper

You have come here while searching for CS614 midterm past papers. But before going to download the CS614 midterm past paper. I have a better option for you. That is, that you can attempt the online quiz of CS614.

Practice Quiz from CS614 Midterm Past Paper

This quiz will evaluate your preparation for the CS614 midterm examination and it is based on the past papers of CS614. The purpose of this quiz is to evaluate your performance in this subject. If you can pass this quiz, then there is a great chance that you can secure good marks in your exams.

0 votes, 0 avg

Your Time starts now

Times Up

Created on January 15, 2022 By

faisal_faisi

CS614

CS614 Midterm Past Papers Practice Quiz

Welcome to CS614 Midterm Online Practice Quiz.

You can check your preparation of CS614 for your Exams here.

Questions Will be different every time you will attempt.

1 / 30

Category: CS614-mid

1. A top down implementation approach is useful when

a. The business objectives are very much clear

b. All requirements are well documented

c. Organization cannot implement latest technologie

d. Technology is matured and well understands

2 / 30

Category: CS614-mid

2. As per Kimball, is the main operational process

a. Requirement extraction

b. Scheme design

c. Business process

d. Global design

3 / 30

Category: CS614-mid

3. Development of data warehouse is hard because data source are usually .

a. Structured and homogeneous

b. Structured and heterogeneous

c. Unstructured and Heterogeneous

d. Unstructured and homogeneous

4 / 30

Category: CS614-mid

4. Which is not a basic task of data transformation?

a. Splitting / joining

b. Selection

c. Conversion

d. Aggregation

5 / 30

Category: CS614-mid

5. Normally it is recommended to have

a. Different servers for development and production environment

b. Interference while having different database environments on a single server

c. Same server for development and production environment

d. All of the given options

6 / 30

Category: CS614-mid

6. Which of the following is NOT one of the activities of “Maintenance and Growth” phase in Kimball’s DWH development approach?

a. Technical education

b. Interface Deployment

c. Program Support

d. Education

7 / 30

Category: CS614-mid

7. Which of the following is NOT one of the advantages of changed data capture (CDC) technique.

a. No incremental online I/O required for log tape

b. Flat Files are not required.

c. Limited Query interface is required for data extraction

d. Extraction of Change Data occurs immediately

8 / 30

Category: CS614-mid

8. In which class of aggregate average function can be placed ?

a. Associative

b. Holistic

c. Algebraic

d. Distributive

9 / 30

Category: CS614-mid

9. In context of data warehouse, normally it becomes difficult to extract data from different sources because these sources are normally:

a. Base lined

b. Heterogeneous

c. Homogeneous

d. Centralized

10 / 30

Category: CS614-mid

10. Flat files are one of the prevalent structures used in data extraction.

a. Full

b. Offline

c. Online

d. Incremental

11 / 30

Category: CS614-mid

11. Which Logical Data Extraction has significant performance impacts on the data warehouse server?

a. Offline Extraction

b. Full Extraction

c. Partial Extraction

d. Incremental Extraction

12 / 30

Category: CS614-mid

12. Spiral model is

a. Risk oriented model

b. Sequence of waterfall model

c. An iterative model

d. All of the given

13 / 30

Category: CS614-mid

13. For smooth DWH project implementation, one of the recommendations is to have

a. Components of complete project before implementation

b. Full time project manager assigned to the project

c. QA team ready for testing the code

d. Design of complete project before implementation

14 / 30

Category: CS614-mid

14. We should follow a proper cycle to implement a change even if it is smaller one.

a. Development -> Production -> QA Production-

b. Development -> QA

c. Development -> QA -> Production

d. Production -> QA ->Development

15 / 30

Category: CS614-mid

15. In context of the most fundamental data warehouse life cycle model, which of the following is NOT one of the data warehouse design activities?

a. End-user interviews and re-interviews

b. ource system cataloguing

c. Definition of key performance indicators

d. System vision development

16 / 30

Category: CS614-mid

16. In context of data mining definition, the term "value" means

a. Index location of the record

b. Numerical of string measure assigned to an attribute

c. Importance of hidden patterns discovered

d. The primary key of table

17 / 30

Category: CS614-mid

17. A relation is said to be in first normal for (1NF) if it does not contain .

a. Multivalve column

b. Derived Column

c. Composite Column

d. Single value column

18 / 30

Category: CS614-mid

18. Which of the following activity/activities is/are part of project planning phase in Kimballs DWH development approach?

a. Assess organization's readiness for a data warehouse initiative

b. Obtain resources

c. All of the given options

d. Establish the preliminary scope and justification

19 / 30

Category: CS614-mid

19. Goal driven approach of data warehouse development was result of _ work Bill Inmon

a. Ralph Kimball

b. Böhnlein and Ulbrich-vom

c. Westerman

20 / 30

Category: CS614-mid

20. A bottom up implementation approach is useful when

a. Technology is matured and well understands

b. Organizationcannot implement latest technologies

c. The business objectives are very much clear

d. All requirements are well documented

21 / 30

Category: CS614-mid

21. If one or more records in a relational table do not satisfy one or more integrity constraint, then the data:

a. Is syntactically dirty

b. Has extraction issue

c. Is semantically dirty

d. Has Coverage anomaly

22 / 30

Category: CS614-mid

22. In the data warehouse environment the data is .

a. Subject-oriented

b. Neither time-oriented nor subject-oriented

c. Time-oriented

d. Both subject and time oriented

23 / 30

Category: CS614-mid

23. Technical architecture design specifies the:

a. Project schedule

b. Minimum project completion time

c. Required Components

d. Umbrella activities

24 / 30

Category: CS614-mid

24. In a fully normalized database, too many_ _ are required.

a. Values

b. Queries

c. Conditions

d. Joins

25 / 30

Category: CS614-mid

25. Normalization _

a. Reduces redundancy

b. Reduces joins

c. Increases redundancy

d. Reduces tables

26 / 30

Category: CS614-mid

26. In phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users

a. Design

b. Prototype

c. Deployment

d. Operation

27 / 30

Category: CS614-mid

27. In Extract, Load, Transformation (ELT) process, you don’t need to purchase extra devices to achieve parallelism because:

a. ELT does not support parallelism

b. You have already performed Loading

c. You already have parallel data warehouse servers

d. You have already performed transformation

28 / 30

Category: CS614-mid

28. Robotic libraries are needed for

a. Cubes

b. Aggregates

c. Data warehouse

d. Data marts

29 / 30

Category: CS614-mid

29. Data mining is all about

a. Finding hidden relations in data

b. All of the given options

c. Finding hidden patterns in data

d. Knowledge discovery in database

30 / 30

Category: CS614-mid

30. Which is not a/an data quality validation technique?

a. Attribute domain

b. Using data quality rules

c. Consistency integrity

d. Referential integrity

Your score is

The average score is 0%

Share your results with your fellow students

LinkedIn Facebook Twitter VKontakte

Exit

Note before downloading CS614 midterm past paper

One thing to note dear fellows that you must don’t rely on these papers only. They can be a source of help but not an ultimate solution. If you want to get good marks in your exams you are advised to go through all of your handouts and must watch all of the video lectures.

Golden rules for good marks in VU Exams.

As per my experience, I have developed some golden rules for getting good marks in Virtual University Exams based on experience. I got 3.96 CGPA by following these rules. So here they are: