Code Question Option A Option B Option C Option D Answer
CS614 __________ If Fits Into Memory Costs Only One Disk I/O Access To Locate A Record By Given Key An Inverted Index A Sparse Index A Dense Index None Of These C
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 __________ In Agriculture Extension Is That Pest Population Beyond Which The Benefit Of Spraying Outweighs Its Cost Profit Threshold Level Economic Threshold Level Medicine Threshold Level None Of These A
CS614 __________ Is A Process Which Involves Gathering Of Information About Column Through Execution Of Certain Queries With Intention To Identify Erroneous Records Record Duplicate Detection Data Anomaly Detection Data Profiling None Of These C
CS614 __________ Is The Technique In Which Existing Heterogeneous Segments Are Reshuffled Relocated Into Homogeneous Segments Clustering Aggregation Segmentation Partitioning A
CS614 ___________ Breaks A Table Into Multiple Tables Based Upon Common Column Values Horizontal Splitting Vertical Splitting Both None Of These A
CS614 ___________ Contributes To An Under-Utilization Of Valuable And Expensive Historical Data And Inevitably Results In A Limited Capability To Provide Decision Support And Analysis The Lack Of Data Integration And Standardization Missing Data Data Stored In Heterogeneous Sources None Of These A
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
CS614 A Data Warehouse Implementation Without An Olap Tool Is Always Possible True False Na Na B
CS614 A Data Warehouse May Include Legacy Systems Only Internal Data Sources Privacy Restrictions Small Data Mart A
CS614 A Dense Index If Fits Into Memory Costs Only Disk I/O Access To Locate A Record By Given Key One Two Linear Quadratic A
CS614 Ad-Hoc Access Means To Run Such Queries Which Are Known Already True False Na Na B
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 An Optimized Structure Which Is Built Primarily For Retrieval With Update Being Only A Secondary Consideration Is Oltp Olap Dss Inverted Index D
CS614 Analytically Processing Uses __________ Instead Of Record Level Access Multi-Level Aggregates Single-Level Aggregates Single-Level Hierarchy None Of The Given A
CS614 As Apposed To The Out Come Of Classification Estimation Deal With __________ Value Outcome Discrete Isolated Continuous Distinct C
CS614 Change Data Capture Is One Of The Challenging Technical Issues In __________ Data Extraction Data Loading Data Transformation Data Cleansing A
CS614 Collapsing Tables Can Be Done On The __________ Relationships One-To-One Many-To-Many Both One-To-One And Many-To-Many None Of These C
CS614 Companies Collect And Record Their Own Operational Data But At The Same Time They Also Use Reference Data Obtained From Sources Such As Codes Prices Etc. Operational Internal External None Of These C
CS614 Cube Is A __________ Entity Containing Values Of A Certain Fact At A Certain Aggregation Level At An Intersection Of A Combination Of Dimensions Logical Physical Analytical None Of These A