Dmw-quiz-1-a
- 1.________________defines the structure of the data held in operational databases .
- A.
User-level metadata.
- B.
Transaction Data
- C.
Operational metadata.
- D.
Data mining metadata.
- 2.The star schema is composed of __________ fact table.
- A.
1
- B.
2
- C.
3
- D.
4
- 3.The source of all data warehouse data is the____________.
- A.
Operational environment.
- B.
Informal environment.
- C.
Formal environment.
- D.
Technology environment.
- 4.Data warehouse contains_____________data that is never found in the operational environment.
- A.
Normalized.
- B.
Informational.
- C.
Summary.
- D.
Denormalized.
- 5.Relation between mean, median and mode
- A.
Mean- mode = 2(mean-median)
- B.
Mean- median = 3(mean-mode)
- C.
Mean- mode = 3(mean-median)
- D.
Mean- median = 2(mean-mode)
- 6.For Quick Searching …………………………………indexing is used in OLAP cube
- A.
Bitmap
- B.
Joint Bitmap
- C.
Composite join Indices
- D.
None of the above
- 7.To Store and Manage warehouse data we use ……………..OLAP
- A.
HOLAP
- B.
MOLAP
- C.
ROLAP
- D.
SQL Servers
- 8.……………………………perfroms selection on One Dimensions of the Given Cube
- A.
Pivot
- B.
SLICE
- C.
DICE
- D.
Drill-Down
- 9.Sequencing of the mappings from a set of low-level concepts to higher-level concepts is known as
- A.
Data mart
- B.
Data warehouse
- C.
Star schema
- D.
Concept Hierarchy
- 10.The model is kept in the normalized form in ……………….Schema
- A.
Fact Constellation
- B.
Snow Flake
- C.
Star schema
- D.
None of the above
- 11.Data to be modeled is multiple dimensions in
- A.
Data Cube
- B.
Data Mart
- C.
Data Model
- D.
Dimension table
- 12.Data Cleaning is used to
- A.
Detect errors in data and rectifies
- B.
Propagates updates from the data sources to the warehouse
- C.
Converts data from legacy formats to warehouse format
- D.
Gather data from Multiple, heterogeneous resources
- 13.Data warehouse has
- A.
4-Tiers
- B.
3-Tiers
- C.
2-Tiers
- D.
N-Tiers
- 14.Data are extracted using application program interfaces are known as
- A.
Hubs
- B.
Processcors
- C.
Switches
- D.
Gateways
- 15.OLAP is
- A.
Informational Processing
- B.
Lots of Scans
- C.
Summarized & Consolidated
- D.
All of the above
Questions: 9 | Attempts: 7926 | Last updated: Apr 2, 2021
-
Sample QuestionWhich of the following makes it possible for entities toshare a relationship?
Questions: 31 | Attempts: 5470 | Last updated: May 6, 2021
-
Sample Question-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Questions: 15 | Attempts: 4752 | Last updated: Jan 5, 2021
-
Sample QuestionWhich of the following is a disadvantage of a computerized database?
Back to top