1
What is the primary definition of Data Integration?
A. The process of backing up data to the cloud
B. The process of deleting duplicate data from a database
C. The process of encrypting data for security
D. The process of combining data from different sources into a unified view
Correct Answer: The process of combining data from different sources into a unified view
Explanation:
Data integration involves combining data residing in different sources and providing users with a unified view of them.
2
Which of the following is a key driver/need for Data Integration in an enterprise?
A. To facilitate business intelligence and decision-making
B. To isolate departmental data silos
C. To decrease the speed of the network
D. To increase the size of the hard drives used
Correct Answer: To facilitate business intelligence and decision-making
Explanation:
Data integration allows organizations to analyze combined data, leading to better business intelligence and informed decision-making.
3
In the context of data integration, what does 'Heterogeneity' refer to?
A. Data that is exactly the same across all systems
B. The security protocols used for data
C. The speed at which data is transferred
D. Differences in hardware, operating systems, and data models across sources
Correct Answer: Differences in hardware, operating systems, and data models across sources
Explanation:
Heterogeneity refers to the diversity in data representation, storage, and semantics across different source systems.
4
What does ETL stand for?
A. Enter, Transfer, Load
B. Extract, Test, Lock
C. Execute, Transmit, Log
D. Extract, Transform, Load
Correct Answer: Extract, Transform, Load
Explanation:
ETL stands for Extract, Transform, Load, a traditional approach to data integration.
5
In the ELT approach, where does the transformation of data primarily occur?
A. In the target data warehouse
B. In the middleware application
C. In the source system
D. In a separate staging server before loading
Correct Answer: In the target data warehouse
Explanation:
In ELT (Extract, Load, Transform), data is loaded into the target system first, and the transformation happens there using the target's processing power.
6
Which integration approach provides a real-time, unified view of data without physically moving the data to a central repository?
A. Data Warehousing
B. Manual Data Entry
C. Tape Backup
D. Data Virtualization (Federation)
Correct Answer: Data Virtualization (Federation)
Explanation:
Data virtualization or federation leaves data in source systems and retrieves it on-the-fly to create a virtual unified view.
7
What is 'Semantic Heterogeneity' in data integration?
A. Using different operating systems
B. Using different network cables
C. Differences in file compression formats
D. Differences in the meaning or interpretation of data (e.g., synonyms, homonyms)
Correct Answer: Differences in the meaning or interpretation of data (e.g., synonyms, homonyms)
Explanation:
Semantic heterogeneity occurs when there is a disagreement about the meaning, interpretation, or intended use of the same or related data.
8
Which of the following is an advantage of a Data Warehouse?
A. It provides a volatile, changing view of data
B. It is optimized for transaction processing
C. It supports historical analysis and reporting
D. It slows down analytical queries
Correct Answer: It supports historical analysis and reporting
Explanation:
A Data Warehouse is designed to store historical data to support analysis, reporting, and decision-making.
9
What creates a 'Single Version of the Truth' (SVOT)?
A. Keeping data in silos
B. Effective Data Integration
C. Avoiding data cleaning
D. Using Excel spreadsheets
Correct Answer: Effective Data Integration
Explanation:
Effective data integration resolves inconsistencies across sources to provide a single, accurate reference point for data, known as the Single Version of the Truth.
10
Which technology is commonly used for Application-based Integration?
A. Enterprise Application Integration (EAI)
B. Printers
C. Standalone Firewalls
D. CD-ROMs
Correct Answer: Enterprise Application Integration (EAI)
Explanation:
EAI uses middleware to enable different applications to share data and business processes.
11
What is a Data Warehouse?
A. A subject-oriented, integrated, time-variant, and non-volatile collection of data
B. A system for recording daily business transactions
C. A physical storage room for hard drives
D. A temporary cache for web browsers
Correct Answer: A subject-oriented, integrated, time-variant, and non-volatile collection of data
Explanation:
This is the standard definition of a Data Warehouse provided by Bill Inmon.
12
In the context of a Data Warehouse, what does 'Non-volatile' mean?
A. Data is not changed once loaded; it is read-only for analysis
B. Data is updated in real-time by users
C. Data is highly explosive
D. Data disappears when power is lost
Correct Answer: Data is not changed once loaded; it is read-only for analysis
Explanation:
Non-volatile means that once data is entered into the warehouse, it is not updated or deleted row-by-row; it is kept for historical comparison.
13
What is the primary difference between OLTP and OLAP?
A. OLTP is for analysis; OLAP is for transactions
B. There is no difference
C. OLTP is for transactions; OLAP is for analysis
D. OLTP is slower than OLAP
Correct Answer: OLTP is for transactions; OLAP is for analysis
Explanation:
OLTP (Online Transaction Processing) manages day-to-day operations, while OLAP (Online Analytical Processing) is used for analysis and reporting.
14
What is a Data Mart?
A. A subset of a data warehouse oriented to a specific business line or team
B. The hardware component of a database
C. A type of database virus
D. A market where data is bought and sold
Correct Answer: A subset of a data warehouse oriented to a specific business line or team
Explanation:
A Data Mart is a focused version of a data warehouse designed for a specific department (e.g., Sales, HR).
15
Which type of Data Mart draws data directly from operational sources without a central Data Warehouse?
A. Integrated Data Mart
B. Independent Data Mart
C. Hybrid Data Mart
D. Dependent Data Mart
Correct Answer: Independent Data Mart
Explanation:
An Independent Data Mart is built directly from source systems without utilizing a central enterprise data warehouse.
16
What is a 'Dependent Data Mart'?
A. A mart that relies on manual data entry
B. A mart sourced from the central Data Warehouse
C. A mart sourced directly from flat files
D. A mart that cannot function without internet
Correct Answer: A mart sourced from the central Data Warehouse
Explanation:
Dependent Data Marts receive their data from the Enterprise Data Warehouse, ensuring consistency across the organization.
17
What is the role of a Staging Area in data integration?
A. To permanently store data
B. To visualize data for the end-user
C. To run the operating system
D. To hold data temporarily for processing and cleaning before loading into the warehouse
Correct Answer: To hold data temporarily for processing and cleaning before loading into the warehouse
Explanation:
The staging area is an intermediate storage area used for data processing (cleaning, transformation) during the ETL process.
18
Which dimension of Data Quality refers to the data correctly representing the real-world object or event?
A. Accuracy
B. Timeliness
C. Volume
D. Security
Correct Answer: Accuracy
Explanation:
Accuracy measures the degree to which data correctly describes the 'real world' object or event being described.
19
Data Completeness refers to:
A. Whether the data is stored in the cloud
B. Whether the data is encrypted
C. Whether all required data is present
D. Whether the data format is JSON
Correct Answer: Whether all required data is present
Explanation:
Completeness ensures that there are no missing values or records that are required for the business process.
20
Which process involves examining data to understand its structure, content, and quality?
A. Data Transmission
B. Data Encryption
C. Data Compression
D. Data Profiling
Correct Answer: Data Profiling
Explanation:
Data profiling is the process of reviewing source data to understand structure, content, and quality anomalies before integration.
21
What is Data Cleansing (Scrubbing)?
A. Wiping the hard drive clean
B. The process of detecting and correcting corrupt or inaccurate records
C. Organizing cables in the server room
D. Removing old hardware
Correct Answer: The process of detecting and correcting corrupt or inaccurate records
Explanation:
Data cleansing involves identifying incorrect, incomplete, or irrelevant parts of the data and replacing, modifying, or deleting the dirty data.
22
What is 'Metadata'?
A. Data about data
B. Big data
C. Encrypted data
D. Mobile data
Correct Answer: Data about data
Explanation:
Metadata provides information about other data, such as its source, format, owner, and lineage.
23
Which approach to Data Warehousing is known as the 'Top-Down' approach?
A. Kimball Approach
B. Waterfall Approach
C. Agile Approach
D. Inmon Approach
Correct Answer: Inmon Approach
Explanation:
Bill Inmon advocates a Top-Down approach: build the Enterprise Data Warehouse first, then build Data Marts from it.
24
Which approach to Data Warehousing is known as the 'Bottom-Up' approach?
A. Spiral Approach
B. Kimball Approach
C. Cloud Approach
D. Inmon Approach
Correct Answer: Kimball Approach
Explanation:
Ralph Kimball advocates a Bottom-Up approach: start by building dimensional Data Marts that can be conformed together.
25
What is Change Data Capture (CDC)?
A. Capturing data from the internet
B. Changing the database password
C. Taking a photo of the database
D. Identifying and capturing only the data that has changed since the last extraction
Correct Answer: Identifying and capturing only the data that has changed since the last extraction
Explanation:
CDC optimizes integration by only moving data that has been inserted, updated, or deleted, rather than moving the whole database every time.
26
Which of the following is NOT a benefit of high Data Quality?
A. Better decision making
B. Regulatory compliance
C. Improved customer relations
D. Increased operational costs
Correct Answer: Increased operational costs
Explanation:
High data quality typically reduces operational costs (less rework, fewer errors). Increased costs are a result of poor data quality.
27
What is 'Deduplication'?
A. Splitting data into two tables
B. Doubling the storage capacity
C. Removing duplicate copies of repeating data
D. Creating a backup copy
Correct Answer: Removing duplicate copies of repeating data
Explanation:
Deduplication is a data quality technique to eliminate redundant copies of data.
28
The 'Time-variant' characteristic of a Data Warehouse implies that:
A. Queries must be run within a specific time limit
B. Data is stored with a time element (historical perspective)
C. The warehouse only operates during business hours
D. The system clock is synchronized
Correct Answer: Data is stored with a time element (historical perspective)
Explanation:
Time-variant means every unit of data in the warehouse is relevant to a specific moment in time, allowing historical trend analysis.
29
Which technology allows for data integration via standard XML-based messages over the web?
A. Floppy Disks
B. Web Services (SOAP/REST)
C. Direct Memory Access
D. FTP
Correct Answer: Web Services (SOAP/REST)
Explanation:
Web services provide a standard means of interoperating between different software applications running on a variety of platforms using XML/JSON.
30
What is a major disadvantage of 'Manual Data Integration'?
A. High cost of software tools
B. Too fast for humans to track
C. Requires complex installation
D. Prone to human error and difficult to scale
Correct Answer: Prone to human error and difficult to scale
Explanation:
Manual integration (copy-pasting or manual entry) is slow, unscalable, and very likely to introduce errors.
31
In Data Integration, what is a 'Connector' or 'Adapter'?
A. A physical cable
B. A software component that allows the integration tool to communicate with specific data sources
C. A user who connects systems
D. A power supply unit
Correct Answer: A software component that allows the integration tool to communicate with specific data sources
Explanation:
Connectors/Adapters are drivers or software modules that enable connection to specific databases (e.g., Oracle, SAP, Salesforce).
32
Which of the following refers to 'Data Consistency'?
A. Data values are the same across all systems and copies
B. Data is consistently backed up
C. Data is accessed consistently every day
D. Data is stored on a consistent hardware platform
Correct Answer: Data values are the same across all systems and copies
Explanation:
Consistency means that data across the enterprise is synchronized and does not contradict itself.
33
What is 'Latency' in the context of data integration?
A. The number of users
B. The cost of the integration tool
C. The time delay between data generation and its availability for use
D. The size of the data
Correct Answer: The time delay between data generation and its availability for use
Explanation:
Latency refers to the lag time. Low latency implies near real-time integration; high latency implies batch processing.
34
What is 'Subject-Oriented' in the context of Data Warehousing?
A. Organized around major entities like Customer, Product, Sales
B. Organized around applications (e.g., Payroll app)
C. Organized around storage media
D. Organized around file types
Correct Answer: Organized around major entities like Customer, Product, Sales
Explanation:
Subject-oriented means the data is grouped by business subjects (Customer, Product) rather than by the software application that generated it.
35
Which schema is most commonly associated with Data Marts and Warehouses?
A. Hierarchical Schema
B. Network Schema
C. XML Schema
D. Star Schema
Correct Answer: Star Schema
Explanation:
The Star Schema is the simplest style of data mart schema, consisting of one or more fact tables referencing dimension tables.
36
What is a 'Fact Table' in a Data Warehouse?
A. A table containing descriptive attributes (text)
B. A table of users
C. A table containing quantitative measurements (numbers/metrics)
D. A table of system logs
Correct Answer: A table containing quantitative measurements (numbers/metrics)
Explanation:
Fact tables contain the metrics, measurements, or facts of a business process (e.g., sales amount, quantity sold).
37
What is a 'Dimension Table'?
A. A table for metadata only
B. A table for temporary calculations
C. A table containing descriptive attributes (context for facts)
D. A table containing measurements
Correct Answer: A table containing descriptive attributes (context for facts)
Explanation:
Dimension tables contain descriptive attributes (e.g., Customer Name, Product Category) that provide context to the facts.
38
Batch processing in data integration means:
A. Processing data in large groups at scheduled intervals
B. Processing data via email
C. Processing data manually
D. Processing data one record at a time instantly
Correct Answer: Processing data in large groups at scheduled intervals
Explanation:
Batch processing collects data over a period and processes it all at once (e.g., nightly loads).
39
Which of the following is a symptom of poor Data Quality?
A. Marketing mail sent to the wrong addresses
B. Seamless system integration
C. Reports are trusted by executives
D. Fast query performance
Correct Answer: Marketing mail sent to the wrong addresses
Explanation:
Sending mail to the wrong address is a classic example of inaccurate or outdated data.
40
What is 'Granularity' in a Data Warehouse?
A. The security level
B. The level of detail of the data
C. The texture of the hard drive
D. The cost of the storage
Correct Answer: The level of detail of the data
Explanation:
Granularity refers to the level of detail or summary of the data (e.g., daily sales vs. monthly sales).
41
EII stands for:
A. Electronic Internet Interface
B. Enterprise Internal Internet
C. Enterprise Information Integration
D. Early Information Input
Correct Answer: Enterprise Information Integration
Explanation:
EII is the ability to support a unified view of data and information across the enterprise (often via virtualization).
42
Which of the following is considered 'Unstructured Data'?
A. A CSV file
B. An Excel spreadsheet with headers
C. Rows in a SQL database
D. Emails, videos, and social media posts
Correct Answer: Emails, videos, and social media posts
Explanation:
Unstructured data does not have a predefined data model or schema, unlike relational database tables.
43
Informatica PowerCenter is primarily used for:
A. Operating System Management
B. Data Integration / ETL
C. Graphic Design
D. Word Processing
Correct Answer: Data Integration / ETL
Explanation:
Informatica PowerCenter is a leading enterprise ETL tool used for data integration.
44
What is the relationship between Data Governance and Data Quality?
A. They are unrelated
B. Governance reduces Data Quality
C. Data Governance provides the policies and roles to ensure Data Quality
D. Data Quality eliminates the need for Governance
Correct Answer: Data Governance provides the policies and roles to ensure Data Quality
Explanation:
Governance sets the rules, responsibilities, and standards, while Data Quality is the execution and measurement of those standards.
45
Why is a Data Mart often faster to query than a Data Warehouse?
A. It holds less data and is optimized for specific queries
B. It does not use indexes
C. It uses better hardware
D. It is connected directly to the CPU
Correct Answer: It holds less data and is optimized for specific queries
Explanation:
Data Marts contain a subset of data relevant to a specific domain, resulting in smaller volume and optimized structures for that domain's queries.
46
The 'Integrated' characteristic of a Data Warehouse means:
A. Data from various sources is converted to a standard format/naming convention
B. It is integrated with the printer network
C. It is built on a single chip
D. It includes email integration
Correct Answer: Data from various sources is converted to a standard format/naming convention
Explanation:
Integration ensures that encoding inconsistencies (e.g., m/f vs. 0/1) are resolved so data is uniform.
47
Which comes first in the standard ETL process?
A. Transform
B. Extract
C. Load
D. Analyze
Correct Answer: Extract
Explanation:
The process order is Extract (from source), Transform (clean/format), then Load (into target).
48
What is the purpose of a 'Surrogate Key' in a Data Warehouse?
A. To link to the internet
B. To replace the natural primary key with a unique internal system identifier
C. To unlock the server room
D. To encrypt the data
Correct Answer: To replace the natural primary key with a unique internal system identifier
Explanation:
Surrogate keys are system-generated unique keys used in the warehouse to decouple it from changes in source system keys (natural keys).
49
What is 'Data Transformation'?
A. Moving data from A to B
B. Archiving data
C. Deleting data
D. Converting data from source format to destination format (e.g., calculation, filtering)
Correct Answer: Converting data from source format to destination format (e.g., calculation, filtering)
Explanation:
Transformation involves applying business rules, cleaning, aggregating, or reformatting data.
50
Which of the following is a 'Target System' in an ETL flow?
A. The legacy mainframe system
B. The operational database where transactions happen
C. The flat file containing raw logs
D. The Data Warehouse where data is loaded
Correct Answer: The Data Warehouse where data is loaded
Explanation:
In an ETL flow, the source is where data comes from, and the target (or destination) is where data is loaded, typically the Data Warehouse.