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 deleting duplicate data from a database
D. The process of encrypting data for security

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

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

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

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

4 What does ETL stand for?

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

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

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

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. Tape Backup
C. Data Virtualization (Federation)
D. Manual Data Entry

7 What is 'Semantic Heterogeneity' in data integration?

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

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

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

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

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

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

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

11 What is a Data Warehouse?

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

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

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

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 slower than OLAP
D. OLTP is for transactions; OLAP is for analysis

14 What is a Data Mart?

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

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

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

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

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

A. To run the operating system
B. To visualize data for the end-user
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. Security
B. Volume
C. Timeliness
D. Accuracy

19 Data Completeness refers to:

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

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

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

21 What is Data Cleansing (Scrubbing)?

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

22 What is 'Metadata'?

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

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

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

24 Which approach to Data Warehousing is known as the 'Bottom-Up' approach?

A. Kimball Approach
B. Cloud Approach
C. Spiral Approach
D. Inmon Approach

25 What is Change Data Capture (CDC)?

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

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

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

27 What is 'Deduplication'?

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

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

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

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

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

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

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

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

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

32 Which of the following refers to 'Data Consistency'?

A. Data is stored on a consistent hardware platform
B. Data values are the same across all systems and copies
C. Data is accessed consistently every day
D. Data is consistently backed up

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

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

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

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

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

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

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

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

37 What is a 'Dimension Table'?

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

38 Batch processing in data integration means:

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

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

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

40 What is 'Granularity' in a Data Warehouse?

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

41 EII stands for:

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

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

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

43 Informatica PowerCenter is primarily used for:

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

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

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

45 Why is a Data Mart often faster to query than a Data Warehouse?

A. It does not use indexes
B. It is connected directly to the CPU
C. It uses better hardware
D. It holds less data and is optimized for specific queries

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

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

47 Which comes first in the standard ETL process?

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

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 encrypt the data
C. To unlock the server room
D. To link to the internet

49 What is 'Data Transformation'?

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

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

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