Skip to main content

CS614 Quiz No.1 Shared by Manzar (UnSolved)



Question # 1 of 10 ( Start time: 03:35:24 PM )  Total Marks: 1
MDX by Microsoft is an example of _______
Select correct option:
HOLAP
DOLAP
ROLAP
None of the given options


Question # 2 of 10 ( Start time: 03:36:40 PM )  Total Marks: 1
In decision support system ease of use is achieved by:
Select correct option:
Normalization
Denormalization
Drill up
Drill down


Question # 3 of 10 ( Start time: 03:38:07 PM )  Total Marks: 1
Which of the denormalization technique squeezes master table into detail?
Select correct option:
Pre-joining
Horizontal splitting
Vertical splitting
Adding redundant column


Question # 4 of 10 ( Start time: 03:38:28 PM )  Total Marks: 1
The trade-offs of denormalization is/are:
Select correct option:
Storage
Performance
Ease-of-use
All of the given options


Question # 5 of 10 ( Start time: 03:38:46 PM )  Total Marks: 1
________is usually deployed when expressions can be used to group data together in such a way that access can be targeted to a small set of partitions for a significant portion of the DW workload.
Select correct option:
Expression elimination
Expression partitioning
Expression indexing
None of the given option


Question # 6 of 10 ( Start time: 03:39:49 PM )  Total Marks: 1
Which of the following is NOT an example of derived attribute?
Select correct option:
Age
CGPA
Area of rectangle
Height


Question # 7 of 10 ( Start time: 03:41:00 PM )  Total Marks: 1
Increasing level of normalization _______ number of tables.
Select correct option:
Increases
Decreases
Does not effect
None of the given options


Question # 9 of 10 ( Start time: 03:42:10 PM )  Total Marks: 1
De-normalization affects:
Select correct option:
Database size and query performance
Database Usability and query reliability
Database availability and query success
None of the given options


Question # 10 of 10 ( Start time: 03:43:17 PM )  Total Marks: 1
Table collapsing technique is applied in case of:
Select correct option:
One-to-one relation or many-to-many relation
One-to-many relation
many to many relateion
None of the given options

Comments

Post a Comment

Please give us your feedback & help us to improve this site.

Popular posts from this blog

CS614 Quiz No.4 Shared by Abdul_Mateen (Solved)

Question # 1 of 10 ( Start time: 01:03:34 PM ) Total Marks: 1 The first step of the “12-steps data warehouse implementation approach” of Shaku Atre is: Select correct option: Finding user needs (Page No. 336) Planning system resources Finding system scope Data acquisition and cleansing Question # 2 of 10 ( Start time: 01:04:15 PM ) Total Marks: 1 Users do not care, how advance the front end of your DWH is, what they care is that: Select correct option: Tables should be properly denormalized Proper partitioning technique should be used At least star or snow flake schema should be implemented They should get information in timely manner and the way they want   Question # 3 of 10 ( Start time: 01:04:49 PM ) Total Marks: 1 Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development? Select correct option: Not interacting directly with end user Not being an accommodating person (Page No. 316) Isolating IT support p...
Post a Comment
Read more

CS614 Quiz No.3 Shared by Sweety (Solved)

Question # 1 of 10 ( Start time: 09:48:28 PM ) Total Marks: 1 Mining multi dimensional databases allow users to: Select correct option: Categorize the data Analyze the data Summarize the data All of the given options   (Correct) Question # 2 of 10 ( Start time: 09:49:23 PM ) Total Marks: 1 As per Bill Inmon, a data warehouse, in contrast with classical applications is: Select correct option: Data driven   (Correct) Resource driven Requirement driven Time sensitive Question # 3 of 10 ( Start time: 09:50:11 PM ) Total Marks: 1 In ________learning you don’t know the number of clusters and no idea about their attributes. Select correct option: Supervised learning Unsupervised learning   (Correct) Multi Dimension modeling None of the given options Question # 4 of 10 ( Start time: 09:51:04 PM ) Total Marks: 1 Identify the TRUE statement: Select correct option: The data value increases as volume decreases   (Correct) The data value decreases ...
Post a Comment
Read more