Unit 4 - Practice Quiz

INT323 50 Questions
0 Correct 0 Wrong 50 Left
0/50

1 What does the acronym ETL stand for in the context of data warehousing?

A. Execute, Transform, Load
B. Extract, Transform, Load
C. Extract, Transfer, Load
D. Enter, Transact, Log

2 Which phase of the ETL process involves retrieving data from various source systems?

A. Loading
B. Transformation
C. Extraction
D. Staging

3 In the context of multi-dimensional data, what is a 'Data Cube'?

A. A three-dimensional visualization tool
B. A relational database table
C. A hardware storage unit for backups
D. A data structure that allows analysis of data from multiple perspectives

4 What is the primary purpose of the 'Transformation' step in ETL?

A. To convert data into a format suitable for the destination system
B. To store raw data immediately
C. To delete all historical data
D. To visualize data for end-users

5 Which OLAP operation involves moving from detailed data to a higher level of summarization?

A. Roll-up
B. Drill-down
C. Slice
D. Dice

6 What is the 'Staging Area' in an ETL process?

A. The final destination for the data
B. A temporary storage area used between extraction and transformation
C. The user interface for reporting
D. The source system database

7 Which of the following is a common data transformation task?

A. Creating backup tapes
B. Data cleansing (removing duplicates/nulls)
C. Hardware maintenance
D. Data entry

8 Which OLAP operation allows you to navigate from summarized data to more detailed data?

A. Drill-down
B. Roll-up
C. Pivot
D. Slice

9 What is 'Incremental Loading'?

A. Loading data without any transformation
B. Deleting the database and reloading everything
C. Loading data manually one record at a time
D. Loading only the data that has changed or is new since the last load

10 In Informatica and other ETL tools, what is a 'Mapping'?

A. A list of user passwords
B. The physical cabling diagram
C. A geographical map of server locations
D. A definition of the flow of data from source to target including transformations

11 What does CDC stand for in the context of data extraction?

A. Change Data Capture
B. Create Data Cubes
C. Central Data Core
D. Computer Disk Check

12 Which operation selects a single dimension from a data cube, effectively creating a 2D view?

A. Drilling
B. Slicing
C. Dicing
D. Rolling

13 What is a 'Full Load' strategy?

A. Loading data incrementally
B. Completely erasing the target and reloading all data from the source
C. Loading only error logs
D. Loading data only on weekends

14 The 'Dice' operation in a data cube performs which action?

A. Summarizes the data
B. Rotates the axes of the cube
C. Selects a single value for one dimension
D. Selects a sub-cube by selecting specific values for multiple dimensions

15 Which of the following is a major benefit of using an ETL tool like Informatica over hand-coding SQL?

A. It is always free of cost
B. It provides metadata management and visual workflow design
C. It requires no training
D. It eliminates the need for a database

16 In a data cube, what are 'Measures'?

A. The security protocols
B. The numerical data being analyzed (e.g., Sales Amount)
C. The keys linking tables
D. The descriptive attributes like Product Name

17 What is 'Data Validation' during the Transformation phase?

A. Copying data to a backup drive
B. Encrypting the data
C. Compressing the data for storage
D. Ensuring data meets defined business rules and constraints

18 Which transformation type is used to combine data from two different sources based on a common key?

A. Filter
B. Aggregator
C. Sorter
D. Joiner

19 What allows an ETL process to pause and restart from a specific point in case of failure?

A. Primary Keys
B. Checkpoints
C. Firewalls
D. Data Marts

20 The 'Pivot' or 'Rotate' operation is used to:

A. Filter out null values
B. Add new data to the cube
C. Reorient the view of the data to provide an alternative presentation
D. Delete dimensions

21 Which of the following is an example of a heterogeneous data source in ETL?

A. Copying a table within the same database
B. Extracting from Oracle and loading into Oracle
C. Extracting from a CSV file and a SQL database to load into a Data Warehouse
D. Renaming a table

22 What is the role of a 'Surrogate Key' generated during transformation?

A. To act as a foreign key to the source system
B. To sort the data alphabetically
C. To replace the natural primary key with a unique internal system identifier
D. To encryption the data

23 Latency in ETL refers to:

A. The number of rows in a table
B. The time difference between data creation in the source and availability in the target
C. The size of the hard drive
D. The cost of the software

24 Which ETL approach loads data into the target system first and then transforms it?

A. ETL
B. ELT
C. CDC
D. OLTP

25 In simple ETL processing, what is a 'Lookup' transformation used for?

A. To search for relevant values in another table or file based on a source value
B. To aggregate sums
C. To export data to Excel
D. To delete records

26 What is 'Data Granularity'?

A. The security level of the data
B. The speed of the processor
C. The type of database used
D. The level of detail or summary of the data

27 Which component in Informatica PowerCenter executes the sessions and workflows?

A. Repository Service
B. Designer
C. Client Tools
D. Integration Service

28 A 'Dimension' in a data cube represents:

A. The quantitative data
B. The calculation algorithm
C. The perspective or category by which data is viewed (e.g., Time, Location)
D. The total size of the database

29 What is the primary function of an 'Aggregator' transformation?

A. To split data into multiple streams
B. To perform calculations like Sum, Avg, Count on groups of data
C. To join tables
D. To filter rows

30 Why is 'Metadata' important in ETL?

A. It increases the storage size unnecessarily
B. It is the actual user data
C. It provides data about the data (e.g., source, format, lineage)
D. It slows down the extraction process

31 Which loading strategy performs an 'Update else Insert' (Upsert) operation?

A. Incremental Merge
B. Static Load
C. Full Load
D. Truncate and Load

32 The process of tracking the flow of data from origin to destination is called:

A. Data Lineage
B. Data Mining
C. Data Compression
D. Data Encryption

33 What type of transformation is 'Filtering'?

A. Passive transformation
B. Active transformation
C. Loading transformation
D. Extraction transformation

34 In a Star Schema, which tables connect to the central Fact Table?

A. Other Fact Tables
B. Dimension Tables
C. System Tables
D. Temporary Tables

35 What is the purpose of 'Error Handling' in ETL?

A. To capture, log, and manage records that fail validation or transformation
B. To delete the source database
C. To stop the server permanently
D. To ignore all errors

36 Which of the following is strictly an ETL Tool?

A. Google Chrome
B. Microsoft Word
C. Informatica PowerCenter
D. Adobe Photoshop

37 What is a 'Flat File' in the context of data extraction?

A. A plain text file (like CSV or TXT) containing data records
B. A corrupted file
C. A database with no relationships
D. A 3D image file

38 During the Loading phase, what does 'Referential Integrity' ensure?

A. That the data is encrypted
B. That relationships between tables remain consistent (e.g., Foreign Keys exist)
C. That the disk is not full
D. That data is loaded quickly

39 What is the benefit of a 'Passive' transformation?

A. It does not change the number of rows passing through (e.g., calculation derived from a column)
B. It deletes data
C. It requires user interaction
D. It changes the number of rows

40 In multidimensional data, a 'Hierarchy' defines:

A. The parent-child relationships within a dimension (e.g., Year -> Quarter -> Month)
B. The network topology
C. The security levels of users
D. The speed of data access

41 Which ETL process is most likely to be used for 'Real-time' data warehousing?

A. Manual Entry
B. Batch Processing
C. Stream Processing / Micro-batching
D. Quarterly Loading

42 What is 'Data Normalization' usually associated with?

A. Flat Files
B. Data Cubes
C. Transactional (OLTP) Source Systems
D. OLAP Systems

43 The 'Router' transformation is used to:

A. Join two tables
B. Split data into multiple groups based on conditions
C. Send data to a single target
D. Sort data

44 What is the definition of 'Data Quality'?

A. The fitness of data for its intended use (accuracy, completeness, consistency)
B. The cost of the database license
C. The speed of the internet connection
D. The amount of data stored

45 Which step usually comes immediately after Extraction in a standard ETL workflow?

A. Transformation (or Staging)
B. Archiving
C. Loading
D. Reporting

46 What is a 'Derived Column'?

A. A new column created through calculation or concatenation during transformation
B. A deleted column
C. A primary key
D. A column extracted directly from the source

47 In the context of Informatica, what is a 'Workflow'?

A. The error log
B. A single SQL query
C. The database installation file
D. A set of instructions describing how and when to run tasks (sessions)

48 Why might 'Data Type Conversion' be necessary during ETL?

A. Because the source system and target system may use different data formats (e.g., String vs Date)
B. To confuse hackers
C. It is never necessary
D. To make the file look bigger

49 Which operation is the opposite of 'Pivot'?

A. Join
B. Slice
C. Unpivot
D. Filter

50 What is the main advantage of using a Data Cube over a standard SQL query for analysis?

A. It pre-aggregates data, providing faster query response for multidimensional analysis
B. It uses less memory
C. It is slower
D. It allows for data entry