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

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

a. Centralized

b. Base lined

c. Heterogeneous

d. Homogeneous

2 / 30

Category: CS614-mid

Spiral model is

a. Sequence of waterfall model

b. An iterative model

c. All of the given

d. Risk oriented model

3 / 30

Category: CS614-mid

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. Element Selection

b. Ranking

c. Prioritization

d. Measurement Selection

4 / 30

Category: CS614-mid

Which of the following is/are example(s) of static attributes?

a. Employee Date of Birth

b. Employee Blood Group

c. Employee Name

d. All of the given options

5 / 30

Category: CS614-mid

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

a. Don't Know

b. May or may not know

c. None of the given options

d. know

6 / 30

Category: CS614-mid

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

a. Requirement definition

b. Analytical application development

c. Product development

d. Architectural design

7 / 30

Category: CS614-mid

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

a. Identifying the recently modified data may be difficult

b. Aggregates don’t change in real time

c. Source systems may not support extraction of changed aggregates

d. Transformation of extracted data is difficult

8 / 30

Category: CS614-mid

The phase of fundamental data warehouse life cycle model includes data warehouse scheduled maintenance

a. Operation

b. Maintenance

c. Deployment

d. Enhancement

9 / 30

Category: CS614-mid

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

10 / 30

Category: CS614-mid

Suppose in system A, the possible values of “marital status” attribute were “Male” & “Female”, however in data warehouse, the values stored were “M” for male and “F” for female. The above scenario is an example of:

a. Many-to-one element transformation

b. One-to-many element transformation

c. One-to-One scalar transformation

d. Many-to-Many element transformation

11 / 30

Category: CS614-mid

Bill Inmon argues that requirements are well understood only after

a. All schemes are defined

b. Data warehouse is populated

c. They extracted and verified

d. They are documented

12 / 30

Category: CS614-mid

Mining multi-dimensional databases allow users to:

a. Analyze the data

b. Summarize the data

c. Categorize the data

d. All of the given options

13 / 30

Category: CS614-mid

Which is not a basic task of data transformation?

a. Conversion

b. Selection

c. Aggregation

d. Splitting / joining

14 / 30

Category: CS614-mid

As per Kimball, is the main operational process

a. Business process

b. Requirement extraction

c. Scheme design

d. Global design

15 / 30

Category: CS614-mid

Which of the following is not a technique of "De-Normalization" ?

a. Splitting Tables

b. Pre-joining

c. ER Modeling

d. Adding Redundant Columns

16 / 30

Category: CS614-mid

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 have already performed transformation

d. You already have parallel data warehouse servers

17 / 30

Category: CS614-mid

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. Train after delivery of the data and analytic applications

d. Understand the audience, don't overwhelm

18 / 30

Category: CS614-mid

OLTP implementations are fully .

a. Additive

b. Demoralized

c. Normalized

d. Predictive

19 / 30

Category: CS614-mid

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

a. TimeStamps

b. CheckMarks

c. RealTime extraction

d. Just-In-Time

20 / 30

Category: CS614-mid

In contrast to data mining, statistics is driven.

a. Database

b. human

c. Assumption

d. Knowledge

21 / 30

Category: CS614-mid

Technical architecture design supports the communication about technical requirements: I) within the team II) Upward to management III) Outward to vendors

a. only (III)

b. only (II)

c. only (I)

d. (I), (II) and (III)

22 / 30

Category: CS614-mid

Waterfall model is appropriate when

a. When resources are limited

b. When the deadline is strict

c. When budget is low

d. Requirements are clearly defined

23 / 30

Category: CS614-mid

Identify data warehouse query from the following

a. Total number of students that have 3.5 CGPA

b. List of students belong to Lahore City

c. Factors which can affect student performance

d. Number of students studding CS614 Course

24 / 30

Category: CS614-mid

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

a. Feasibility

b. The potential impact or value to the business

c. Resources available

d. scope

25 / 30

Category: CS614-mid

In context of requirement definition phase in Kimball’s DWH development approach, activities like debriefing, documentation, and prioritization are considered to be the part of:

a. Post collection

b. None of the given options

c. Business requirements collection

d. Requirement preplanning

26 / 30

Category: CS614-mid

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

a. Enhance Security

b. Organize Tables for different queries.

c. Fast data retrieval

d. Increase I/O overhead

27 / 30

Category: CS614-mid

Which is not a/an data quality validation technique?

a. Using data quality rules

b. Referential integrity

c. Attribute domain

d. Consistency integrity

28 / 30

Category: CS614-mid

Normalization _

a. Reduces tables

b. Reduces redundancy

c. Reduces joins

d. Increases redundancy

29 / 30

Category: CS614-mid

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

a. Establish the preliminary scope and justification

b. All of the given options

c. Obtain resources

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

30 / 30

Category: CS614-mid

Identify the TRUE statement

a. Clustering is unsupervised learning and classification is supervised learning

b. Both clustering and classification are supervised learning

c. Clustering is supervised learning and classification is unsupervised learning

d. Both clustering and classification are unsupervised learning

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