Question - 1
It is used to push data into a relation database table. This control will be the destination for most fact table data flows.
Web Scraping
Data inspection
OLE DB Source
OLE DB Destination
Answer- D
Question - 2
Extract, Transform, Load
Extract, Transition, Load
Explain, Transform, Locate
Explain, Transform, Load
Answer- A
Question - 3
Which of the metadata approach helps in integration with multi-vendor tools along with flexibility?
Centralized API approach
Decentralized API approach
Centralized or repository approach
Decentralized or interchange approach
Answer- D
Question - 4
Extract is the process____?
of adding new data to a database
of reading and collecting data from a database, the data is often collected from multiple sources.
of analyzing collected information
none of the above
Answer- B
Question - 5
Which is not the ETL tools?
IBM- Websphere DataStage
Informatica- Power Center
Microsoft Dynamic AX
SAP- Business objects data service BODS
Answer- C
Question - 6
Which following are the type of Data Warehouse systems?
Online Analytical Processing (OLAP)
Predictive Analysis
Online Transactional Processing
All the Above
Answer- D
Question - 7
Which of the following are the ETL bugs??
Source Bugs
Load Condition Bugs
Calculation Bugs
All the above
Answer- D
Question - 8
Which of the following is a data cleansing process?
Extracting only valid data
Checking referential integrity
Building dimensions
Summarizing data
Answer- B
Question - 9
using filters to remove bad data
using ERP systems to clean the data
using rules or lookup tables or by combining the data with other data.
None of the above
Answer- C
Question - 10
Which method will decompose a free form product code having size and color information?
Mapping
Parsing
Using foreign keys
Defining an intelligent primary key
Answer- B
Question - 11
The Transformation stage could include joining data from two different data sources, aggregating, concatenating, sorting and applying many advanced validation rules using
PTP Technologies
SQL SELECT Statements
ERP Technologies
None of above
Answer- B
Question - 12
What is the benefit of storing attribute definitions as metadata?
Allows data load rules to be shared across multiple tools
Reduces overall storage requirements
Significantly enhances load time performance
Allows for bi-directional update of operational data
Answer- A
Question - 13
of writing the data into the target database.
of publishing the data to decision makers
of reviewing data in the database
of writing data into a RPA tool
Answer- A
Question - 14
What are the Open Source ETL tools?
Pentaho
Kettle
Both
None of above
Answer- C
Question - 15
Which one is not Enterprise ETL tool?
Informatica
Talend
IBM Datastage
Pentaho
Answer- D
Question - 16
Two methods to ensure data integrity
Sources, Transformation, Destination
Data inspection
Row Count Inspection, Data Inspection
Row Count Inspection
Answer- C
Question - 17
Three common usages of ETL
Data Scrubbing
Sources, Transformation, Destination
Merging Data
Merging Data, Data Scrubbing, Automation
Answer- D
Question - 18
this should be check if column name have been included in the first row of the file.
Row Count Inspection, Data Inspection
Format of the Date
Column names in the first data row checkbox
Do most work in transformation phase
Answer- C
Question - 19
This can be computationally expensive excluding SSD.
Hard Drive I/O
Mainframe
Tool Suite
Data Scrubbing
Answer- A
Question - 20
A value of delimited should be selected for delimited files
Answer- B
Practice more set questions
