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

Have any Question or Comment?

Leave a Reply

Exciting Offers

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 90 other subscribers

Exciting Offers

Exciting Offers

Exciting Offers

Close
%d bloggers like this: