We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>


Looking For Something at vustudents.ning.com? Click Here to Search

CS614_Share your Current Mid Term Papers Spring 2016 at One Place from 27 May 2016 to 8 June 2016

CS614_Share your Current Mid Term Papers

Spring 2016 at One Place

from 27 May 2016 to 8 June 2016  

 

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). View Featured discussions.

For view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

 

Solutions for not opening files..
 

PDF Files downloading Solution from ning..

 
Problem in downloading PDF files..

    

Thanks and Regards!

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 2524

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

Share Your Current Mid Term Papers (Questions/Pattern) 28 May 2016 to 04 June 2016  to help each other. Thanks 

Solved Mid Terms Papers By MOAAZ & Other Students

 

Click On the below link to download

 

Solved Mid Term Papers

 

Note: (This is Featured Discussion)

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

Almost complete paper was from Past papers.

19 Mcqs was from Past and 5 subjective was from past just 1 question was new but very easy .

01. _________ is one class of decision support environment.

OLAP 30page

OLTP

Data Cleansing

ETL

DOLAP model facilitates ___________ computing paradigm.

Mobile pg 78

Permanent

Rigid

Strict

Collapsing tables can be done on the ___________ relationship(s)

Only One-to-One

Only Many-to-Many

Only One-to-Many

Both One-to-One and Many-to-Many pg 52

Transactional fact tables do not have records for events that do not occur. These are

called

Not Recording Facts pg 120

Fact-less Facts

Null Facts

Empty Facts

Typically a data mart is much smaller to data warehouse and it is pretty easy to take its

______ as compare to data warehouse.

Backup pg 131

Cube

Load

Schema

"Change Data Capture" is one of the challenging technical issues in _____________

Data Extraction pg 149

Data Loading

Data Transformation

Data Cleansing

The most common use of range partitioning in data warehouse is on

Date pg 66

Most redundant column

Fact

Dimensions

The goal of star schema design is to simplify ________

Logical data model

Physical data model pg 107

Conceptual data model

Semantic data model

Source systems for extraction are typically OLTP systems. Extraction is a very complex

task due to reasons:

1. Very complex and poorly documented source system.

2. Data has to be extracted not once but many times.

3. People extracting data have limited expertise.

Which of the following option represents correct reason?

1 & 2 only pg 132

1 & 3 only

2 & 3 only

All 1, 2 and 3

Fact-less fact table is a fact table without numeric fact columns. It is used to capture

relationship between __________

Dimensions pg 121

Attributes

Tables

Facts

Selectivity in OLTP system is

Not present

High

Low

None if these

Typically a data mart is much smaller to data warehouse and it is pretty easy to take its

______ as compare to data warehouse.

Backup

Cube

Load

Schema

In horizontal splitting, we split a relation into multiple tables on the basis of

Common Column Values

Common Row Values

Different Index Values

Value resulted by ad-hoc query

"The environment is smart enough to develop or compute higher level aggregates

using lower level or more detailed aggregates". Which of the following approach is

described by the above statement?

Aggregate awareness pg 87

Cube partitioning

Indexing

MOLAP cube aggregation

 

In full extraction, data is extracted completely from the source system. Therefore there

is no need to keep track of changes to the ________

Data Source pg 133

DWH

Data Mart

Data Destination

cube is a logical entity containing values of a certain fact at a certain aggregation level at An Intersection of a combination of dimensions.

 

---------------are created out of the data warehouse to service the needs of different 
departments such as marketing, sales etc.
• MIS
• OLAPs
Data mart page 31

None of the given

 

 

Subjective

Statement was given [In OLAP Analysis is User drived] Correct or not (2 marks)

1. Additive and non-additive facts 2 marks

 


There can be two types of facts i.e. additive and non-additive.
Additive facts are those facts which give the correct result by an addition operation. 
Or Additive facts are easy to work with summing the fact value gives meaningful 
results.
Examples of such facts could be number of items sold, sales amount etc.


Non-additive facts can also be added, but the addition gives incorrect results.
Examples of non-additive facts are average,discount, ratios etc.

 

Identify the following statements as correct or incorrect. (3 marks)
"One of the basic functions of OLTP is to show the historical background of an 
organization."
Answer: incorrect
Correct is: OLTP systems don’t keep history, can’t get balance statement more than 
a year old

Question was: rollup in cube operation used to change the view of data. [3 marks]
Answer:
incorrect
rollup is used to summarize data..........page 80.


In context of MOLAP cube, identify the proportionality relation between the cardinality of dimension and cube size. Justify your answer with logical reason. (5 marks)

 Ans:  The biggest problem with MOLAP is the requirement of large main memory as the cube

size increases. There may be many reasons for the increase in cube size, such as increase

in the number of dimensions, or increase in the cardinality of the dimensions, or increase

in the amount of detail data or a combination of some or all these aspects. Thus there is an

issue of scalability which limits its applications to large data sets.

 

Q:CDC types and its implementation techniques  ( 5 marks )

Ans: CDC types are:

Modern systems

Legacy systems

Implementations techniques are :

Timestamps

Portioning

Triggers

 

 

 

Attachments:

Thanks very much janab NAZEER AHMAD sb. Dear brother u done excellent job. .

Nazeer Ahmad Khan

kon c files sy ye paper aya tha please upload these files please...

Files ..... for Objective and subjective 

Attachments:

more files

Attachments:

thnak u soooo muchh.....

Paper of CS614 Today
1. The goal of star schema design is to simplify ________ ?
2. Grain is the ________ level of data stored in the warehouse?
3. During ETL process of an organization, suppose you have data 
which can be transformed.........?
4. Collapsing tables can be done on the ___________ 
relationships ?
5. For good decision making, data should be integrated across 
the organization to cross the LoB ..........?
6. Full & Incremental Extraction are the types of _____________ 
Extraction ?
7. Data mining is a/an __________ approach?
8. Conversion of data from aggregates to original table.
9. Column Cloumn wise extraction.
10. Extraction.

85%paper was from moaz file including objective and subjective. There was a question about calculation.
Need to find the space in gbs. Header size or table size diya howa tha or number of rows b.

Q1. Which of the following is not an example of fixed inventory byssiness ………..
. Air line
.Hotel
.Utility store
. Car rental
Q2.Pre- computed………….can solve performance problem.
. Aggregate
.Fact
.Dimension
.Primary key
Q3.One major goal of horizontal splitting ………..
Q4.The divide&conquer cube portioning approach help alleviate the scalability limitation of ………………..implementation
.MOLAP
.OLAP
.ROLAP
.All
Q5. High granularity means, more……………. –
Q6. 3NF remove even more data redundancy than 2NF but it is at the cost of …………….
Q7. Mention one factor that load towards long load time of a MLOAP cube ?
Q8 . while using the technique of adding redundant column in a DWH, how will the fact table become a long flat file ?
Q9.identify given statement is correct or incorrect & justify ur ans.
i.we can dissolve the aggregates to get the original data from which the aggregates were created?
Q10..identify correct or in correct ,
I.transformation is the process in which we extract the data from single/multiple data source
ii. Offline extraction is a type of logical data Extraction .
Q11.In context of MOLAP cube, one can perform different operation on it , “Roll UP” & “Drill Down” are two to name . Provide at least one example of each.
12.In context of OLAP, which of the following is not a part of FASMI test .
.FASI
.Fitness
.Multidimention
.Info

my today paper at 10:30

All mcqs from tariq hanif file..

subject past papers sy nahi tha..

Q:write two ways to simplifies the ER data Model:

ans:

Two general methods:
ƒ De-Normalization
ƒ Dimensional Modeling (DM)

Q:write four basic task of transformation?

ans:

Basic tasks
ƒ Selection
ƒ Splitting/Joining
ƒ Conversion
ƒ Summarization
ƒ Enrichment

Q:why OLAP is essential for DWH in decision making?

Q:Transaction fact tables always have records for events that do not occur. this is correct statment or not?

ans:

incorrect.the correct statement is:

Transactional fact tables do not have records for events that do not occur. These are
called not recording facts.

Q:ak q range partitioning sy related tha 5 marks ka..kafi lambi statment thi isliye yad nahi.

Q:additive facts btany thy table diya hua tha us me sy with reason.5 marks

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service