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
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.
3
All data in the flat file is in this format
a. Sort
b. ETL
c. format
d. 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
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
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
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.
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
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.
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
