Trend Nxt ETL Testing | Question and Answers


ETL Testing | Mock Test

1
A data warehouse is which of the following?
a. Can be updated by end users.
b. Contains numerous naming conventions and formats.
c. Organized around important subject areas.
d. String

Answer : Organized around important subject areas.
2
A goal of data mining includes which of the following?
a. To explain some observed event or condition
b. To confirm that data exists
c. To analyze data for expected relationships
d. A system that is used to support decision making and is based on historical data.
Answer : To explain some observed event or condition
3
All data in the flat file is in this format
a. Sort
b. ETL
c. format
d. Load testing
Answer : Load testing
4
An operational system is which of the following?
a. A system that is used to run the business in real time and is based on historical data.
b. A system that is used to run the business in real time and is based on current data.
c. A system that is used to support decision making and is based on current data.
d. Separating data from one source into various sources of data
Answer : A system that is used to run the business in real time and is based on current data
5
Data set containing out of range data to identify application boundary cases and prepare data set that will cover lower as well as upper end conditions is called ?
a. Invalid data set validation
b. Valid data set validation
c. Boundary data set validation
d. Partially normalized
Answer : Boundary data set validation
6
Data transformation includes which of the following?
a. A process to change data from a detailed level to a summary level
b. A process to change data from a summary level to a detailed level
c. Joining data from one source into various sources of data
d. Shows the path to the file to be imported
Answer : A process to change data from a detailed level to a summary level
7
Fact tables are which of the following?
a. Completely denormalized
b. Partially denormalized
c. Completely normalized
d. Only the current employee record is available.
Answer : Completely normalized
8
Flat File Control
a. Three components of data flow
b. It is used to import text file for ETL Processing
c. The easiest to consume from the ETL standpoint
d. This should be check if column name have been included in the first row of the file
Answer : It is used to import text file for ETL Processing
9
How to test the SCD type 2 is implemented properly in a employee table?
a. Partial history is maintained for all the employee.
b. No single active record for any given employee.
c. Complete history is maintained and only one active record for any given employee
d. Only the current employee record is available.
Answer : Complete history is maintained and only one active record for any given employee
10
Load In Parallel
a. A value of delimited should be selected for delimited file
b. Data is pulled from multiple sources to be merge into multiple dimentions
c. This will reduce the run time of ETL process and reduce the window for hardware failure to affect the process
d. This should be check if column name have been included in the first row of the file
Answer : This will reduce the run time of ETL process and reduce the window for hardware failure to affect the process

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: