BI Testing | Mock Test

1
___________ is called Rotate operation
a. Slice
b. Roll up
c. Pivot
d. Drilldown
Show Answer

2
A ________ involves computing all of the data relationships for one or more dimensions
a. Roll up
b. Dice
c. Drillup
d. Data Storage
Show Answer
3
A _________ is a subset of a multi-dimensional array corresponding to a single value for one or more members of the dimensions not in the subset.
a. Slice
b. Dice
c. Drillup
d. Data Storage
Show Answer
4
Aggregations are part of
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Data Storage
Show Answer
5
Check Constraints part of
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. A process to upgrade the quality of data before it is moved into a data warehouse
Show Answer
6
Data Profiling is part of
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Data Storage
Show Answer
7
Data scrubbing is which of the following?
a. A process to reject data from the data warehouse and to create the necessary indexes
b. A process to load the data in the data warehouse and to create the necessary indexes
c. A process to upgrade the quality of data after it is moved into a data warehouse
d. its purely performance of tool
Show Answer
8
Duplication and truncation of source
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Tranformation
Show Answer
9
ETL using lookup files boost up performance due to
a. Stored in memory
b. Use hash algorithm
c. Both aand b
d. its purely performance of tool
Show Answer
10
Incremental data pull is
a. Extraction
b. Loading
c. Transportation
d. Tranformation
Show Answer