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

CS614 Midterm Past Paper online Practice Quiz

Abdurrab

January 15, 2022

812

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 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. End-user interviews and re-interviews

c. ource system cataloguing

d. Definition of key performance indicators

2 / 30

Category: CS614-mid

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

a. Analytical application development

b. Product development

c. Requirement definition

d. Architectural design

3 / 30

Category: CS614-mid

3. Normalization _

a. Increases redundancy

b. Reduces redundancy

c. Reduces joins

d. Reduces tables

4 / 30

Category: CS614-mid

4. A top down implementation approach is useful when

a. The business objectives are very much clear

b. All requirements are well documented

c. Organization cannot implement latest technologie

d. Technology is matured and well understands

5 / 30

Category: CS614-mid

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

a. Design of complete project before implementation

b. Full time project manager assigned to the project

c. Components of complete project before implementation

d. QA team ready for testing the code

6 / 30

Category: CS614-mid

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

a. Splitting Tables

b. ER Modeling

c. Adding Redundant Columns

d. Pre-joining

7 / 30

Category: CS614-mid

7. Grain of a fact table means:

a. Summary of aggregates in all dimension tables

b. The meaning of one dimensional table row

c. The meaning of one fact table row

d. Summary of aggregates in all fact tables

8 / 30

Category: CS614-mid

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

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

b. Flat files are not required

c. Extraction of changed data occurs immediately

d. Limited query interface is required for data extraction

9 / 30

Category: CS614-mid

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

a. Structured and heterogeneous

b. Structured and homogeneous

c. Unstructured and Heterogeneous

d. Unstructured and homogeneous

10 / 30

Category: CS614-mid

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

a. Full

b. Incremental

c. Online

d. Offline

11 / 30

Category: CS614-mid

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

a. Train after delivery of the data and analytic applications

b. All of the given options

c. Postpone education, if DWH not ready

d. Understand the audience, don't overwhelm

12 / 30

Category: CS614-mid

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

a. Requirement configuration

b. Requirements wrap-up presentation

c. Scope definition

d. System analysis

13 / 30

Category: CS614-mid

13. In phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users

a. Deployment

b. Design

c. Operation

d. Prototype

14 / 30

Category: CS614-mid

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

a. Numerical of string measure assigned to an attribute

b. Importance of hidden patterns discovered

c. The primary key of table

d. Index location of the record

15 / 30

Category: CS614-mid

15. As per kimball’s approach the second phase of DWH life cycle is:

a. Requirement definition

b. Project Planning

c. Requirement validation

d. Requirement verification

16 / 30

Category: CS614-mid

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

a. Source systems may not support extraction of changed aggregates

b. Aggregates don’t change in real time

c. Identifying the recently modified data may be difficult

d. Transformation of extracted data is difficult

17 / 30

Category: CS614-mid

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

a. Data Warehouse Dimension

b. Business Dimensional Lifecycle

c. Business Definition Lifecycle

d. OLAP Dimension

18 / 30

Category: CS614-mid

18. A bottom up implementation approach is useful when

a. All requirements are well documented

b. The business objectives are very much clear

c. Organizationcannot implement latest technologies

d. Technology is matured and well understands

19 / 30

Category: CS614-mid

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

a. Project Planning

b. Deployment

c. Requirement elicitation

d. Project management

20 / 30

Category: CS614-mid

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

a. Composite Column

b. Derived Column

c. Single value column

d. Multivalve column

21 / 30

Category: CS614-mid

21. Suppose the amount of data recorded in an organization is doubled every year. This increase is .

a. Logarithmic

b. Linear

c. Exponential

d. Quadratic

22 / 30

Category: CS614-mid

22. 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. Feasibility

d. scope

23 / 30

Category: CS614-mid

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

24 / 30

Category: CS614-mid

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

a. Extraction issue

b. Semantically dirty data

c. Syntactically dirty data

d. Coverage anomaly

25 / 30

Category: CS614-mid

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

a. The difference between the primary keys of two records

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

c. None of the given options

d. Similarity/dissimilarity of records

26 / 30

Category: CS614-mid

26. Robotic libraries are needed for

a. Data marts

b. Aggregates

c. Data warehouse

d. Cubes

27 / 30

Category: CS614-mid

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

a. only (II)

b. only (III)

c. only (I)

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

28 / 30

Category: CS614-mid

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

a. Extraction of Change Data occurs immediately

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

c. Flat Files are not required.

d. Limited Query interface is required for data extraction

29 / 30

Category: CS614-mid

29. Normally it is recommended to have

a. Different servers for development and production environment

b. Interference while having different database environments on a single server

c. All of the given options

d. Same server for development and production environment

30 / 30

Category: CS614-mid

30. Which is not a/an data quality validation technique?

a. Attribute domain

b. Consistency integrity

c. Using data quality rules

d. Referential integrity

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: