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

CS614 Midterm Past Paper online Practice Quiz

Abdurrab

January 15, 2022

810

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. 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 already have parallel data warehouse servers

c. You have already performed transformation

d. You have already performed Loading

2 / 30

Category: CS614-mid

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

a. Aggregates don’t change in real time

b. Source systems may not support extraction of changed aggregates

c. Identifying the recently modified data may be difficult

d. Transformation of extracted data is difficult

3 / 30

Category: CS614-mid

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

a. Deployment

b. Business requirement definition

c. Project planning

d. Maintenance and growth

4 / 30

Category: CS614-mid

4. Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development?

a. Not being an accommodating person

b. Not interacting directly with end user

c. Isolating IT support people from business users

d. Training the users with dummy data and considering it success

5 / 30

Category: CS614-mid

5. Which of the following activity executes parallel with all other activities in Kimball’s DWH development approach?

a. Deployment

b. Project Planning

c. Project management

d. Requirement elicitation

6 / 30

Category: CS614-mid

6. 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. Partitioning

d. Timestamps

7 / 30

Category: CS614-mid

7. Robotic libraries are needed for

a. Data warehouse

b. Data marts

c. Cubes

d. Aggregates

8 / 30

Category: CS614-mid

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

a. Operation

b. Enhancement

c. Deployment

d. Maintenance

9 / 30

Category: CS614-mid

9. Normalization _

a. Reduces joins

b. Reduces tables

c. Increases redundancy

d. Reduces redundancy

10 / 30

Category: CS614-mid

10. If actual data structure does not conform to documented formats then it is called:

a. Syntactically dirty data

b. Semantically dirty data

c. Extraction issue

d. Coverage anomaly

11 / 30

Category: CS614-mid

11. Online Extraction is a kind of data extraction.

a. Logical

b. Physical

c. Multivalued

d. Dimensional

12 / 30

Category: CS614-mid

12. For large record spaces and large number of records, the run time of the clustering algorithms is

a. Prohibitive

b. Static

c. Exponential

d. Numerical

13 / 30

Category: CS614-mid

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

a. Flat Files are not required.

b. Extraction of Change Data occurs immediately

c. Limited Query interface is required for data extraction

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

14 / 30

Category: CS614-mid

14. A bottom up implementation approach is useful when

a. All requirements are well documented

b. Technology is matured and well understands

c. The business objectives are very much clear

d. Organizationcannot implement latest technologies

15 / 30

Category: CS614-mid

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

a. All of the given options

b. Train after delivery of the data and analytic applications

c. Postpone education, if DWH not ready

d. Understand the audience, don't overwhelm

16 / 30

Category: CS614-mid

16. 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. Business requirements collection

b. Requirement preplanning

c. None of the given options

d. Post collection

17 / 30

Category: CS614-mid

17. Identify data warehouse query from the following

a. Factors which can affect student performance

b. Total number of students that have 3.5 CGPA

c. List of students belong to Lahore City

d. Number of students studding CS614 Course

18 / 30

Category: CS614-mid

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

a. Full

b. Incremental

c. Online

d. Offline

19 / 30

Category: CS614-mid

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

a. Ralph Kimball

b. Westerman

c. Böhnlein and Ulbrich-vom

20 / 30

Category: CS614-mid

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

a. TimeStamps

b. Just-In-Time

c. CheckMarks

d. RealTime extraction

21 / 30

Category: CS614-mid

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

a. The potential impact or value to the business

b. Resources available

c. scope

d. Feasibility

22 / 30

Category: CS614-mid

22. 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. System vision development

b. Definition of key performance indicators

c. End-user interviews and re-interviews

d. ource system cataloguing

23 / 30

Category: CS614-mid

23. 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. Source systems may not support extraction of changed aggregates

d. Identifying the recently modified data may be difficult

24 / 30

Category: CS614-mid

24. 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

25 / 30

Category: CS614-mid

25. 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

26 / 30

Category: CS614-mid

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

a. ER Modeling

b. Splitting Tables

c. Pre-joining

d. Adding Redundant Columns

27 / 30

Category: CS614-mid

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

a. Joins

b. Values

c. Queries

d. Conditions

28 / 30

Category: CS614-mid

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

a. Algebraic

b. Holistic

c. Associative

d. Distributive

29 / 30

Category: CS614-mid

29. As per Kimball, is the main operational process

a. Business process

b. Global design

c. Requirement extraction

d. Scheme design

30 / 30

Category: CS614-mid

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

a. Incremental Extraction

b. Offline Extraction

c. Partial Extraction

d. Full Extraction

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: