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

One feature of Change Data Capture (CDC) is that:

a. It pre-calculates changed aggregates

b. It only processes the data that has been changed

c. It can automate the transformation of extracted data

d. It loads the transformed data in real time

2 / 30

Category: CS614-mid

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

a. Flat Files are not required.

b. Limited Query interface is required for data extraction

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

d. Extraction of Change Data occurs immediately

3 / 30

Category: CS614-mid

In data mining, initially you what you are looking for. Know

a. know

b. None of the given options

c. May or may not know

d. Don't Know

4 / 30

Category: CS614-mid

Which of the following is NOT one of the examples of dynamic attributes?

a. Air pressure

b. Daily Sale

c. None of the given options

d. Date of Birth cnfim not

5 / 30

Category: CS614-mid

Following the coding standards during development helps to:

a. To refine the project scope

b. Verify the requirements

c. To establish the test cases

d. Minimize the future rework

6 / 30

Category: CS614-mid

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

a. Data Driven

b. User Driven

c. Goal Driven

d. System Driven

7 / 30

Category: CS614-mid

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

a. Enrichment

b. Conversion

c. Full Data Refresh

d. Summarization

8 / 30

Category: CS614-mid

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

a. Homogeneous

b. Heterogeneous

c. Base lined

d. Centralized

9 / 30

Category: CS614-mid

One of the drawbacks of waterfall model is that:

a. It does not define the project timeline/schedule

b. All of the given options

c. It does not work when the resources are limited

d. Customers can not review the product during development

10 / 30

Category: CS614-mid

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

a. Education

b. Technical education

c. Interface Deployment

d. Program Support

11 / 30

Category: CS614-mid

Online Extraction is a kind of data extraction.

a. Physical

b. Logical

c. Multivalued

d. Dimensional

12 / 30

Category: CS614-mid

Three parallel tracks in kimbal’s DWH development approach converge at Phase

a. Deployment

b. Project planning

c. Business requirement definition

d. Maintenance and growth

13 / 30

Category: CS614-mid

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

a. Architectural design

b. Analytical application development

c. Requirement definition

d. Product development

14 / 30

Category: CS614-mid

In context of Change Data Capture (CDC), sometimes a object can be used to store the recently modified data:

a. Change table

b. Buffer table

c. Change control table

d. Checkmark table

15 / 30

Category: CS614-mid

In Extract, Load, Transform (ELT) process, data transformation

a. Does not take place

b. Takes place on the data warehouse server

c. Takes place on a separate transformation server

d. Depends on the nature of the source database

16 / 30

Category: CS614-mid

In the data warehouse environment the data is .

a. Both subject and time oriented

b. Neither time-oriented nor subject-oriented

c. Time-oriented

d. Subject-oriented

17 / 30

Category: CS614-mid

In Four Cell Quadrant Technique, The quadrant's vertical axis refers to

a. Feasibility

b. scope

c. Resources available

d. The potential impact or value to the business

18 / 30

Category: CS614-mid

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

a. Fast data retrieval

b. Increase I/O overhead

c. Organize Tables for different queries.

d. Enhance Security

19 / 30

Category: CS614-mid

In which class of aggregate average function can be placed ?

a. Associative

b. Distributive

c. Algebraic

d. Holistic

20 / 30

Category: CS614-mid

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

a. Lifecycle Analytical Applications track

b. Lifecycles technology track

c. Lifecycle Data track

d. Lifecycle Maintenance track

21 / 30

Category: CS614-mid

The min operator is conservative in that it assign to the dimension an aggregate value on higher than the value of its weakest data quality.

a. None of give

b. Min

c. Min and max

d. Max

22 / 30

Category: CS614-mid

Bill Inmon argues that requirements are well understood only after

a. Data warehouse is populated

b. They extracted and verified

c. All schemes are defined

d. They are documented

23 / 30

Category: CS614-mid

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

a. Business Dimensional Lifecycle

b. Data Warehouse Dimension

c. OLAP Dimension

d. Business Definition Lifecycle

24 / 30

Category: CS614-mid

technique requires a separate column to specify the time and date when the last modification was occurred.

a. TimeStamps

b. RealTime extraction

c. Just-In-Time

d. CheckMarks

25 / 30

Category: CS614-mid

Which one of the following is not a technique of "Change Data Capture” in currently used Modem Source Systems?

a. Dimensional Modeling

b. Triggers

c. Timestamps

d. Partitioning

26 / 30

Category: CS614-mid

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

a. Development -> QA

b. Development -> Production -> QA Production-

c. Production -> QA ->Development

d. Development -> QA -> Production

27 / 30

Category: CS614-mid

Which is not a basic task of data transformation?

a. Splitting / joining

b. Aggregation

c. Selection

d. Conversion

28 / 30

Category: CS614-mid

OLTP implementations are fully .

a. Demoralized

b. Predictive

c. Normalized

d. Additive

29 / 30

Category: CS614-mid

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

a. dirty data Coverage

b. Syntactically dirty data

c. Semantically

d. anomaly Extraction issue

30 / 30

Category: CS614-mid

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

a. They should get information in timely manner

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

c. Tables should be properly de-normalized

d. Proper partitioning technique should be used

Your score is

The average score is 0%

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:

Never miss your Quiz, Assignment, or GDB.
Always try to do your Assignment on your own.
Try your best to finish your video lectures 10 days before exams.
Try your best to read your handouts twice before exams.
Read forward attempt backward.
Never schedule more than one paper on the same day.
Your most difficult paper should have a gap of 1 or more days.
Toughest paper must be scheduled first.
Read questions forward and attempt backward.
Don’t waste your time during a paper on illegal activities.

You can also download the Latest VU Handouts

To download the CS614 midterm past paper click here.

CS614 Midterm Past Paper online Practice Quiz

CS614 Midterm Past Paper

Practice Quiz from CS614 Midterm Past Paper

Note before downloading CS614 midterm past paper

Golden rules for good marks in VU Exams.

Leave a Comment Cancel Reply