|
CS614
|
Dss Queries Do Not Involve A Primary Key
|
True
|
False
|
Na
|
Na
|
A
|
|
CS614
|
__________ If Too Big And Does Not Fit Into Memory Will Be Expensive When Used To Find A Record By Given Key
|
An Inverted Index
|
A Sparse Index
|
A Dense Index
|
None Of These
|
C
|
|
CS614
|
Slice And Dice Is Changing The View Of The Data
|
True
|
False
|
Na
|
Na
|
A
|
|
CS614
|
The Star Schema Used For Data Design Is A __________ Consisting Of Fact And Dimension Tables
|
Network Model
|
Relational Model
|
Hierarchical Data Model
|
None Of The Given
|
B
|
|
CS614
|
A Data Warehouse May Include
|
Legacy Systems
|
Only Internal Data Sources
|
Privacy Restrictions
|
Small Data Mart
|
A
|
|
CS614
|
All Data Is __________ Of Something Real. (I) An Abstraction (Ii) A Representation. Which Of The Following Option Is True?
|
I Only
|
Ii Only
|
Both I & Ii
|
None Of I & Ii
|
A
|
|
CS614
|
To Measure Or Quantify The Similarity Or Dissimilarity Different Techniques Are Available. Which Of The Following Option Represent The Name Of Available Techniques?
|
Pearson Correlation Is The Only Technique
|
Euclidean Distance Is The Only Technique
|
Both Pearson Correlation And Euclidean Distance
|
None Of These
|
C
|
|
CS614
|
Modeling Technique Is More Appropriate For Data Warehouses
|
Entity-Relationship
|
Dimensional
|
Physical
|
None Of The Given
|
A
|
|
CS614
|
The Key Idea Behind __________ Is To Take A Big Task And Break It Into Subtasks That Can Be Processed Concurrently On A Stream Of Data Inputs In Multiple Overlapping Stages Of Execution
|
Pipeline Parallelism
|
Overlapped Parallelism
|
Massive Parallelism
|
Distributed Parallelism
|
A
|
|
CS614
|
Data __________ Is Vitally Important To The Overall Health Of A Warehouse Project
|
Cleansing
|
Scrubbing
|
Both
|
None Of These
|
A
|
|
CS614
|
Relational Databases Allow You To Navigate The Data In __________ That Is Appropriate Using The Primary Foreign Key Structure Within The Data Model
|
Only One Direction
|
Any Direction
|
Two Direction
|
None Of These
|
B
|
|
CS614
|
The Smaller The Portion Of The Program That Must Be Executed __________ The Greater The Scalability Of The Computation
|
In Parallel
|
Distributed
|
Sequentially
|
None Of These
|
C
|
|
CS614
|
For A Given Data Set To Get A Global View In Un-Supervised Learning We Use
|
Bi-Clustering
|
Pearson Correlation
|
Euclidean Distance
|
One-Way Clustering
|
D
|
|
CS614
|
Multi-Dimensional Databases (Mdds) Typically Use __________ Formats To Store Pre-Summarized Cube Structures
|
Sql
|
Proprietary File
|
Object Oriented
|
Non- Proprietary File
|
B
|
|
CS614
|
The Kimball S Iterative Data Warehouse Development Approach Drew On Decades Of Experience To Develop The __________
|
Business Dimensional Lifecycle
|
Data Warehouse Dimension
|
Business Definition Lifecycle
|
Olap Dimension
|
A
|
|
CS614
|
Analytically Processing Uses __________ Instead Of Record Level Access
|
Multi-Level Aggregates
|
Single-Level Aggregates
|
Single-Level Hierarchy
|
None Of The Given
|
A
|
|
CS614
|
The Input To The Data Warehouse Can Come From Oltp Or Transactional System But Not From Other Third Party Database
|
True
|
False
|
Na
|
Na
|
B
|
|
CS614
|
For A Dwh Project The Key Requirement Are __________ And Product Experience
|
Tools
|
Industry
|
Software
|
None Of These
|
B
|
|
CS614
|
Data Warehousing And On-Line Analytical Processing (Olap) Are Elements Of Decision Support System
|
Unusual
|
Essential
|
Optional
|
None Of The Given
|
B
|
|
CS614
|
A __________ Dimension Is A Collection Of Random Transactional Codes Flags And/Text Attributes That Are Unrelated To Any Particular Dimension. The Dimension Is Simply A Structure That Provides A Convenient Place To Store The Attributes
|
Junk
|
Time
|
Parallel
|
None Of These
|
A
|