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

CS614 Midterm Past Paper online Practice Quiz

Abdurrab

January 15, 2022

773

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

c. Ranking

d. Measurement Selection

2 / 30

Category: CS614-mid

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

a. Business requirement definition

b. Deployment

c. Maintenance and growth

d. Project planning

3 / 30

Category: CS614-mid

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

a. Adding Redundant Columns

b. Splitting Tables

c. ER Modeling

d. Pre-joining

4 / 30

Category: CS614-mid

4. Waterfall model is appropriate when

a. When resources are limited

b. When budget is low

c. Requirements are clearly defined

d. When the deadline is strict

5 / 30

Category: CS614-mid

5. 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. Customers can not review the product during development

d. It does not work when the resources are limited

6 / 30

Category: CS614-mid

6. Identify the TRUE statement

a. Clustering is supervised learning and classification is unsupervised learning

b. Both clustering and classification are supervised learning

c. Both clustering and classification are unsupervised learning

d. Clustering is unsupervised learning and classification is supervised learning

7 / 30

Category: CS614-mid

7. 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. Min and max

b. Min

c. Max

d. None of give

8 / 30

Category: CS614-mid

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

a. Derived Column

b. Multivalve column

c. Composite Column

d. Single value column

9 / 30

Category: CS614-mid

9. 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. They should get information in timely manner

c. Proper partitioning technique should be used

d. Tables should be properly de-normalized

10 / 30

Category: CS614-mid

10. 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. None of the given options

b. Requirement preplanning

c. Business requirements collection

d. Post collection

11 / 30

Category: CS614-mid

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

a. It pre-calculates changed aggregates

b. It loads the transformed data in real time

c. It can automate the transformation of extracted data

d. It only processes the data that has been changed

12 / 30

Category: CS614-mid

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

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 changed data occurs immediately

c. No incremental on-line I/O required for log tape

d. Limited query interface is required for data extraction

14 / 30

Category: CS614-mid

14. most common use of range partitioning is on

a. Date

b. Color

c. Name

d. phoneNo

15 / 30

Category: CS614-mid

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

a. Associative

b. Algebraic

c. Holistic

d. Distributive

16 / 30

Category: CS614-mid

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

a. Is semantically dirty

b. Has Coverage anomaly

c. Is syntactically dirty

d. Has extraction issue

17 / 30

Category: CS614-mid

17. A top down implementation approach is useful when

a. The business objectives are very much clear

b. Organization cannot implement latest technologie

c. Technology is matured and well understands

d. All requirements are well documented

18 / 30

Category: CS614-mid

18. Spiral model is

a. Risk oriented model

b. All of the given

c. Sequence of waterfall model

d. An iterative model

19 / 30

Category: CS614-mid

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

a. Structured and homogeneous

b. Structured and heterogeneous

c. Unstructured and homogeneous

d. Unstructured and Heterogeneous

20 / 30

Category: CS614-mid

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

a. 1960s

b. 1950s

c. 1970s

d. 1990s

21 / 30

Category: CS614-mid

21. In context of requirement definition phase of Kimball’s DWH development approach, is positioned as a findings review and prioritization meeting.

a. System analysis

b. Requirement configuration

c. Scope definition

d. Requirements wrap-up presentation

22 / 30

Category: CS614-mid

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

a. Requirement elicitation

b. Project Planning

c. Project management

d. Deployment

23 / 30

Category: CS614-mid

23. Which is not an issue of ROLAP in the following?

a. Maintenance

b. Slandered hierarchy of dimensions

c. Non slandered conventions

d. Aggregations pitfalls

24 / 30

Category: CS614-mid

24. 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. Transformation of extracted data is difficult

d. Source systems may not support extraction of changed aggregates

25 / 30

Category: CS614-mid

25. Following the coding standards during development helps to:

a. Verify the requirements

b. To refine the project scope

c. Minimize the future rework

d. To establish the test cases

26 / 30

Category: CS614-mid

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

a. Incremental

b. Full

c. Online

d. Offline

27 / 30

Category: CS614-mid

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

a. Enhancement

b. Operation

c. Maintenance

d. Deployment

28 / 30

Category: CS614-mid

28. A bottom up implementation approach is useful when

a. All requirements are well documented

b. Organizationcannot implement latest technologies

c. The business objectives are very much clear

d. Technology is matured and well understands

29 / 30

Category: CS614-mid

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

a. Buffer table

b. Checkmark table

c. Change table

d. Change control table

30 / 30

Category: CS614-mid

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

a. Syntactically dirty data

b. Extraction issue

c. Semantically dirty data

d. Coverage anomaly

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: