6 COBOL
A. Process to move data from a source to destination.
B. The easiest to consume from the ETL standpoint.
C. Two methods to ensure data integrity.
D. Many routines of the Mainframe system are written in this.
Ans: D
7 What ETL Stands for
A. Data inspection
B. Transformation
C. Extract, Transform, Load
D. Data Flow
Ans: C
8 The source system initiates the data transfer for the ETL process. This method is uncommon in practice, as each system would have to move the data to the ETL process individually.
A. Custom
B. Automation
C. Pull Method
D. Push Method
Ans: D
9 Sentinel Files
A. These are used to identify which fields from which sources are going to with destinations. It allows the ETL developer to identify if there is a need to do a data type change or aggregation prior to beginning coding of an ETL process.
B. These can be used to flag an entire file-set that is ready for processing by the ETL process. It contains no meaningful data bu the fact it exists is the key to the process.
C. ETL can be used to automate the movement of data between two locations. This standardizes the process so that the load is done the same way every run.
D. This is used to create multiple streams within a data flow from a single stream. All records in the stream are sent down all paths. Typically uses a merge-join to recombine the streams later in the data flow.
Ans: B
10 Checkpoints
A. Similar to "break up processes", checkpoints provide markers for what data has been processed in case an error occurs during the ETL process.
B. Similar to XML's structured text file.
C. Many routines of the Mainframe system are written in this.
D. It is used to import text files for ETL processing.
Ans: A
A. Process to move data from a source to destination.
B. The easiest to consume from the ETL standpoint.
C. Two methods to ensure data integrity.
D. Many routines of the Mainframe system are written in this.
Ans: D
7 What ETL Stands for
A. Data inspection
B. Transformation
C. Extract, Transform, Load
D. Data Flow
Ans: C
8 The source system initiates the data transfer for the ETL process. This method is uncommon in practice, as each system would have to move the data to the ETL process individually.
A. Custom
B. Automation
C. Pull Method
D. Push Method
Ans: D
9 Sentinel Files
A. These are used to identify which fields from which sources are going to with destinations. It allows the ETL developer to identify if there is a need to do a data type change or aggregation prior to beginning coding of an ETL process.
B. These can be used to flag an entire file-set that is ready for processing by the ETL process. It contains no meaningful data bu the fact it exists is the key to the process.
C. ETL can be used to automate the movement of data between two locations. This standardizes the process so that the load is done the same way every run.
D. This is used to create multiple streams within a data flow from a single stream. All records in the stream are sent down all paths. Typically uses a merge-join to recombine the streams later in the data flow.
Ans: B
10 Checkpoints
A. Similar to "break up processes", checkpoints provide markers for what data has been processed in case an error occurs during the ETL process.
B. Similar to XML's structured text file.
C. Many routines of the Mainframe system are written in this.
D. It is used to import text files for ETL processing.
Ans: A
No comments:
Post a Comment