Trend Nxt BI Testing | Question and Answers

BI Testing | Mock Test

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

Answer : Pivot

2
A ________ involves computing all of the data relationships for one or more dimensions
a. Roll up
b. Dice
c. Drillup
d. Data Storage
Answer : Roll up

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
Answer : Slice

4
Aggregations are part of
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Data Storage
Answer : Data Presentation

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
Answer : A process to upgrade the quality of data before it is moved into a data warehouse

6
Data Profiling is part of
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Data Storage
Answer : Data Acquisition

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
Answer : its purely performance of tool

8
Duplication and truncation of source
a. Data Acquisition
b. Data Integration
c. Data Presentation
d. Tranformation
Answer : Data Acquisition

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
Answer : Both aand b

10
Incremental data pull is
a. Extraction
b. Loading
c. Transportation
d. Tranformation
Answer : Extraction