Back to Subject

Unit 2: Basics of Data Integration - Practice Quiz

INT323 — Database Essentials Toward Informatica 50 Questions
0 Correct 0 Wrong 50 Left
0/50

1 What is the primary definition of Data Integration?

A. The process of combining data from different sources into a unified view
B. The process of backing up data to the cloud
C. The process of encrypting data for security
D. The process of deleting duplicate data from a database

2 Which of the following is a key driver/need for Data Integration in an enterprise?

A. To decrease the speed of the network
B. To facilitate business intelligence and decision-making
C. To isolate departmental data silos
D. To increase the size of the hard drives used

3 In the context of data integration, what does 'Heterogeneity' refer to?

A. Differences in hardware, operating systems, and data models across sources
B. Data that is exactly the same across all systems
C. The speed at which data is transferred
D. The security protocols used for data

4 What does ETL stand for?

A. Enter, Transfer, Load
B. Execute, Transmit, Log
C. Extract, Transform, Load
D. Extract, Test, Lock

5 In the ELT approach, where does the transformation of data primarily occur?

A. In the target data warehouse
B. In a separate staging server before loading
C. In the middleware application
D. In the source system

6 Which integration approach provides a real-time, unified view of data without physically moving the data to a central repository?

A. Manual Data Entry
B. Data Warehousing
C. Tape Backup
D. Data Virtualization (Federation)

7 What is 'Semantic Heterogeneity' in data integration?

A. Using different network cables
B. Differences in the meaning or interpretation of data (e.g., synonyms, homonyms)
C. Using different operating systems
D. Differences in file compression formats

8 Which of the following is an advantage of a Data Warehouse?

A. It supports historical analysis and reporting
B. It is optimized for transaction processing
C. It provides a volatile, changing view of data
D. It slows down analytical queries

9 What creates a 'Single Version of the Truth' (SVOT)?

A. Using Excel spreadsheets
B. Avoiding data cleaning
C. Keeping data in silos
D. Effective Data Integration

10 Which technology is commonly used for Application-based Integration?

A. Enterprise Application Integration (EAI)
B. CD-ROMs
C. Standalone Firewalls
D. Printers

11 What is a Data Warehouse?

A. A physical storage room for hard drives
B. A temporary cache for web browsers
C. A system for recording daily business transactions
D. A subject-oriented, integrated, time-variant, and non-volatile collection of data

12 In the context of a Data Warehouse, what does 'Non-volatile' mean?

A. Data disappears when power is lost
B. Data is not changed once loaded; it is read-only for analysis
C. Data is highly explosive
D. Data is updated in real-time by users

13 What is the primary difference between OLTP and OLAP?

A. OLTP is for transactions; OLAP is for analysis
B. OLTP is for analysis; OLAP is for transactions
C. OLTP is slower than OLAP
D. There is no difference

14 What is a Data Mart?

A. A type of database virus
B. The hardware component of a database
C. A subset of a data warehouse oriented to a specific business line or team
D. A market where data is bought and sold

15 Which type of Data Mart draws data directly from operational sources without a central Data Warehouse?

A. Hybrid Data Mart
B. Independent Data Mart
C. Integrated Data Mart
D. Dependent Data Mart

16 What is a 'Dependent Data Mart'?

A. A mart that relies on manual data entry
B. A mart sourced directly from flat files
C. A mart that cannot function without internet
D. A mart sourced from the central Data Warehouse

17 What is the role of a Staging Area in data integration?

A. To visualize data for the end-user
B. To run the operating system
C. To permanently store data
D. To hold data temporarily for processing and cleaning before loading into the warehouse

18 Which dimension of Data Quality refers to the data correctly representing the real-world object or event?

A. Timeliness
B. Volume
C. Security
D. Accuracy

19 Data Completeness refers to:

A. Whether the data is stored in the cloud
B. Whether the data format is JSON
C. Whether all required data is present
D. Whether the data is encrypted

20 Which process involves examining data to understand its structure, content, and quality?

A. Data Profiling
B. Data Encryption
C. Data Compression
D. Data Transmission

21 What is Data Cleansing (Scrubbing)?

A. Removing old hardware
B. Organizing cables in the server room
C. Wiping the hard drive clean
D. The process of detecting and correcting corrupt or inaccurate records

22 What is 'Metadata'?

A. Encrypted data
B. Big data
C. Mobile data
D. Data about data

23 Which approach to Data Warehousing is known as the 'Top-Down' approach?

A. Waterfall Approach
B. Agile Approach
C. Kimball Approach
D. Inmon Approach

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

25 What is Change Data Capture (CDC)?

A. Identifying and capturing only the data that has changed since the last extraction
B. Changing the database password
C. Taking a photo of the database
D. Capturing data from the internet

26 Which of the following is NOT a benefit of high Data Quality?

A. Increased operational costs
B. Improved customer relations
C. Better decision making
D. Regulatory compliance

27 What is 'Deduplication'?

A. Creating a backup copy
B. Removing duplicate copies of repeating data
C. Splitting data into two tables
D. Doubling the storage capacity

28 The 'Time-variant' characteristic of a Data Warehouse implies that:

A. The system clock is synchronized
B. The warehouse only operates during business hours
C. Queries must be run within a specific time limit
D. Data is stored with a time element (historical perspective)

29 Which technology allows for data integration via standard XML-based messages over the web?

A. FTP
B. Web Services (SOAP/REST)
C. Direct Memory Access
D. Floppy Disks

30 What is a major disadvantage of 'Manual Data Integration'?

A. Requires complex installation
B. Too fast for humans to track
C. High cost of software tools
D. Prone to human error and difficult to scale

31 In Data Integration, what is a 'Connector' or 'Adapter'?

A. A user who connects systems
B. A software component that allows the integration tool to communicate with specific data sources
C. A power supply unit
D. A physical cable

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

33 What is 'Latency' in the context of data integration?

A. The size of the data
B. The number of users
C. The cost of the integration tool
D. The time delay between data generation and its availability for use

34 What is 'Subject-Oriented' in the context of Data Warehousing?

A. Organized around file types
B. Organized around applications (e.g., Payroll app)
C. Organized around major entities like Customer, Product, Sales
D. Organized around storage media

35 Which schema is most commonly associated with Data Marts and Warehouses?

A. Star Schema
B. Hierarchical Schema
C. XML Schema
D. Network Schema

36 What is a 'Fact Table' in a Data Warehouse?

A. A table of system logs
B. A table of users
C. A table containing descriptive attributes (text)
D. A table containing quantitative measurements (numbers/metrics)

37 What is a 'Dimension Table'?

A. A table containing descriptive attributes (context for facts)
B. A table for metadata only
C. A table containing measurements
D. A table for temporary calculations

38 Batch processing in data integration means:

A. Processing data one record at a time instantly
B. Processing data manually
C. Processing data in large groups at scheduled intervals
D. Processing data via email

39 Which of the following is a symptom of poor Data Quality?

A. Reports are trusted by executives
B. Seamless system integration
C. Fast query performance
D. Marketing mail sent to the wrong addresses

40 What is 'Granularity' in a Data Warehouse?

A. The security level
B. The texture of the hard drive
C. The cost of the storage
D. The level of detail of the data

41 EII stands for:

A. Enterprise Internal Internet
B. Electronic Internet Interface
C. Enterprise Information Integration
D. Early Information Input

42 Which of the following is considered 'Unstructured Data'?

A. Rows in a SQL database
B. A CSV file
C. An Excel spreadsheet with headers
D. Emails, videos, and social media posts

43 Informatica PowerCenter is primarily used for:

A. Graphic Design
B. Word Processing
C. Data Integration / ETL
D. Operating System Management

44 What is the relationship between Data Governance and Data Quality?

A. Data Governance provides the policies and roles to ensure Data Quality
B. Data Quality eliminates the need for Governance
C. Governance reduces Data Quality
D. They are unrelated

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 is connected directly to the CPU
C. It uses better hardware
D. It does not use indexes

46 The 'Integrated' characteristic of a Data Warehouse means:

A. It includes email integration
B. It is built on a single chip
C. It is integrated with the printer network
D. Data from various sources is converted to a standard format/naming convention

47 Which comes first in the standard ETL process?

A. Analyze
B. Transform
C. Extract
D. Load

48 What is the purpose of a 'Surrogate Key' in a Data Warehouse?

A. To replace the natural primary key with a unique internal system identifier
B. To unlock the server room
C. To encrypt the data
D. To link to the internet

49 What is 'Data Transformation'?

A. Deleting data
B. Moving data from A to B
C. Archiving data
D. Converting data from source format to destination format (e.g., calculation, filtering)

50 Which of the following is a 'Target System' in an ETL flow?

A. The legacy mainframe system
B. The flat file containing raw logs
C. The operational database where transactions happen
D. The Data Warehouse where data is loaded
Previous MCQ
Unit 1
Next MCQ
Unit 3