BI Testing | Mock Test

1
___________ is called Rotate operation
a. Slice
b. Roll up
c. Pivot
d. Drilldown
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Pivot [/bg_collapse]
2
A ________ involves computing all of the data relationships for one or more dimensions
a. Roll up
b. Dice
c. Drillup
d. Data Storage
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Roll up[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Slice [/bg_collapse]
4
Aggregations are part of
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Data Storage
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data Presentation[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A process to upgrade the quality of data before it is moved into a data warehouse [/bg_collapse]
6
Data Profiling is part of
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Data Storage
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data Acquisition [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : its purely performance of tool [/bg_collapse]
8
Duplication and truncation of source
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Tranformation
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data Acquisition[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both aand b [/bg_collapse]
10
Incremental data pull is
a. Extraction
b. Loading
c. Transportation
d. Tranformation
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Extraction [/bg_collapse]