Quiz Start Time: 10:55 AM Time Left 89View more random threads:
- cs614 data ware house mcq's and quiz by imran g
- mkt621 advertising promotion on line quiz mcqs download...
- cs302 quiz by Saira Qamar
- cs605 mid term paper spring 2011
- MGT402- Cost & Management Accounting (Session - 4)
- latest paper MTH401 Differential Equations 2011 virtual...
- MGT402 Cost & Management Accounting mcq's spring 2010...
- MTH302- Business Mathematics & Statistics mid term paper...
- FIN621 Online Quiz 1 spring 2011 on 12 april 2011
- Which of the following is NOT the method of...
sec(s)
Question # 1 of 10 ( Start time: 10:55:43 AM ) Total Marks: 1
The STAR schema used for data design is a __________ consisting of fact and dimension tables.
Select correct option:
Network model
Relational model
Hierarchical data model
None of the given
Sponsored Links
Quiz Start Time: 10:55 AM Time Left 89
sec(s)
Question # 2 of 10 ( Start time: 10:57:07 AM ) Total Marks: 1
The performance in a MOLAP cube comes from the O(1) look-up time for the array data structure.
Select correct option:
True
False
Quiz Start Time: 10:55 AM Time Left 88
sec(s)
Question # 3 of 10 ( Start time: 10:57:50 AM ) Total Marks: 1
A data warehouse implementation without an OLAP tool is always possible.
Select correct option:
True
False
Quiz Start Time: 10:55 AM Time Left 89
sec(s)
Question # 4 of 10 ( Start time: 10:58:40 AM ) Total Marks: 1
In a traditional MIS system, there is an almost linear sequence of queries.
Select correct option:
True
False
Quiz Start Time: 10:55 AM Time Left 89
sec(s)
Question # 5 of 10 ( Start time: 10:59:11 AM ) Total Marks: 1
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
Select correct option:
Mandatory
Whole
Analysis
Prediction
Quiz Start Time: 10:55 AM Time Left 89
sec(s)
Question # 6 of 10 ( Start time: 10:59:29 AM ) Total Marks: 1
The divide&conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
Select correct option:
Flexibility
Maintainability
Security
Scalability
Quiz Start Time: 10:55 AM Time Left 89
sec(s)
Question # 7 of 10 ( Start time: 10:59:50 AM ) Total Marks: 1
_____modeling technique is more appropriate for data warehouses.
Select correct option:
entity-relationship
dimensional
physical
None of the given
Quiz Start Time: 10:55 AM Time Left 89
sec(s)
Question # 8 of 10 ( Start time: 11:00:56 AM ) Total Marks: 1
Multi-dimensional databases (MDDs) typically use ___________ formats to store pre-summarized cube structures.
Select correct option:
SQL
proprietary file
Object oriented
Non- proprietary file
Quiz Start Time: 10:55 AM Time Left 86
sec(s)
Question # 9 of 10 ( Start time: 11:01:19 AM ) Total Marks: 1
Analytical processing uses ____________ , instead of record level access.
Select correct option:
multi-level aggregates
Single-level aggregates
Single-level hierarchy
None of the Given
Quiz Start Time: 10:55 AM Time Left 89
sec(s)
Question # 10 of 10 ( Start time: 11:01:41 AM ) Total Marks: 1
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
Select correct option:
Unusual
Essential
Optional
None of the given