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

CS614 Midterm Past Paper online Practice Quiz

Abdurrab

January 15, 2022

811

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. Which of the following is/are example(s) of static attributes?

a. Employee Name

b. Employee Blood Group

c. Employee Date of Birth

d. All of the given options

2 / 30

Category: CS614-mid

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

a. Development -> QA

b. Production -> QA ->Development

c. Development -> Production -> QA Production-

d. Development -> QA -> Production

3 / 30

Category: CS614-mid

3. Users do not care, how advance the front end of your DWH is, what they care is that

a. At least star or snow flake schema should be implementing

b. Proper partitioning technique should be used

c. Tables should be properly de-normalized

d. They should get information in timely manner

4 / 30

Category: CS614-mid

4. The saw the advent of disk storage, or DASD (Direct Access Storage Device).

a. 1990s

b. 1970s

c. 1960s

d. 1950s

5 / 30

Category: CS614-mid

5. Technical architecture design specifies the:

a. Minimum project completion time

b. Project schedule

c. Umbrella activities

d. Required Components

6 / 30

Category: CS614-mid

6. The Kimball s iterative data warehouse development approach drew on decades of experience to develop the .

a. Data Warehouse Dimension

b. OLAP Dimension

c. Business Dimensional Lifecycle

d. Business Definition Lifecycle

7 / 30

Category: CS614-mid

7. In phase of kimballs approach, we identify the components needed now and in future.

a. Analytical application development

b. Requirement definition

c. Product development

d. Architectural design

8 / 30

Category: CS614-mid

8. In contrast to data mining, statistics is driven.

a. Knowledge

b. Database

c. Assumption

d. human

9 / 30

Category: CS614-mid

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

a. Unstructured and homogeneous

b. Unstructured and Heterogeneous

c. Structured and heterogeneous

d. Structured and homogeneous

10 / 30

Category: CS614-mid

10. Which of the following is NOT one of the methodologies for Data Warehouse project development

a. Data Driven

b. System Driven

c. Goal Driven

d. User Driven

11 / 30

Category: CS614-mid

11. 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. Is semantically dirty

c. Has Coverage anomaly

d. Has extraction issue

12 / 30

Category: CS614-mid

12. Which of the following is not a task of Data Transformation?

a. Summarization

b. Enrichment

c. Full Data Refresh

d. Conversion

13 / 30

Category: CS614-mid

13. Normally the term "DWH face to the business user" refers to:

a. Lifecycles technology track

b. Lifecycle Analytical Applications track

c. Lifecycle Maintenance track

d. Lifecycle Data track

14 / 30

Category: CS614-mid

14. An effective user education program includes, among other, the following guideline(s):

a. All of the given options

b. Postpone education, if DWH not ready

c. Understand the audience, don't overwhelm

d. Train after delivery of the data and analytic applications

15 / 30

Category: CS614-mid

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

a. Numerical of string measure assigned to an attribute

b. Index location of the record

c. Importance of hidden patterns discovered

d. The primary key of table

16 / 30

Category: CS614-mid

16. Non uniform use of abbreviations, units and values refers to:

a. anomaly Extraction issue

b. Syntactically dirty data

c. dirty data Coverage

d. Semantically

17 / 30

Category: CS614-mid

17. In case of multiple sources for the same data element, we need to prioritize the source systems per element bases, the process is called:

a. Prioritization

b. Measurement Selection

c. Ranking

d. Element Selection

18 / 30

Category: CS614-mid

18. Waterfall is a/an model

a. Rapid development

b. Simple linear sequential

c. Object oriented

d. Iterative

19 / 30

Category: CS614-mid

19. One of the drawbacks of waterfall model is that:

a. Customers can not review the product during development

b. It does not work when the resources are limited

c. It does not define the project timeline/schedule

d. All of the given options

20 / 30

Category: CS614-mid

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

a. Design of complete project before implementation

b. QA team ready for testing the code

c. Components of complete project before implementation

d. Full time project manager assigned to the project

21 / 30

Category: CS614-mid

21. In context of clustering, the term "distance" means

a. The relation of a record with corresponding record in child table

b. Similarity/dissimilarity of records

c. None of the given options

d. The difference between the primary keys of two records

22 / 30

Category: CS614-mid

22. Following the coding standards during development helps to:

a. Verify the requirements

b. To establish the test cases

c. Minimize the future rework

d. To refine the project scope

23 / 30

Category: CS614-mid

23. Data mining is all about

a. Finding hidden relations in data

b. Knowledge discovery in database

c. Finding hidden patterns in data

d. All of the given options

24 / 30

Category: CS614-mid

24. A top down implementation approach is useful when

a. Organization cannot implement latest technologie

b. Technology is matured and well understands

c. All requirements are well documented

d. The business objectives are very much clear

25 / 30

Category: CS614-mid

25. Change Data Capture (CDC) can be challenging task because:

a. Transformation of extracted data is difficult

b. Aggregates don’t change in real time

c. Identifying the recently modified data may be difficult

d. Source systems may not support extraction of changed aggregates

26 / 30

Category: CS614-mid

26. Which one among the following is not an advantage of horizontal splitting

a. Fast data retrieval

b. Increase I/O overhead

c. Enhance Security

d. Organize Tables for different queries.

27 / 30

Category: CS614-mid

27. Change Data Capture (CDC) can be challenging task because:

a. Source systems may not support extraction of changed aggregates

b. Identifying the recently modified data may be difficult

c. Transformation of extracted data is difficult

d. Aggregates don’t change in real time

28 / 30

Category: CS614-mid

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

a. Conditions

b. Values

c. Queries

d. Joins

29 / 30

Category: CS614-mid

29. Spiral model is

a. Risk oriented model

b. Sequence of waterfall model

c. An iterative model

d. All of the given

30 / 30

Category: CS614-mid

30. Online Extraction is a kind of data extraction.

a. Logical

b. Multivalued

c. Dimensional

d. Physical

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: