Back to Subject

Unit 5: ETL Processing with SQL Server Integration Services and Rapid Miner - Practice Quiz

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

1 What is the primary file extension for an SSIS package?

A. .sln
B. .dtproj
C. .ssis
D. .dtsx

2 Which component in the SSIS architecture is responsible for defining the logical flow of tasks such as sending emails or executing SQL scripts?

A. Control Flow
B. Data Flow
C. Connection Managers
D. Event Handlers

3 In SSIS, which IDE is typically used for developing Integration Services projects?

A. Eclipse
B. Visual Studio with SSDT
C. RapidMiner Studio
D. SQL Server Management Studio (SSMS)

4 What is the primary function of a 'Connection Manager' in SSIS?

A. To schedule the package execution
B. To establish and maintain links to data sources and destinations
C. To debug the data flow
D. To transform data types

5 Which SSIS task is specifically designed to move data from a source to a destination while allowing for transformations?

A. File System Task
B. Execute SQL Task
C. Data Flow Task
D. Script Task

6 In an SSIS Data Flow, what does a 'Precedence Constraint' define?

A. The error handling mechanism inside a transformation
B. The condition under which the next task in the Control Flow is executed
C. The data type of a column
D. The speed of data transfer

7 Which SSIS transformation is used to combine data from two sorted inputs based on a matching column?

A. Derived Column
B. Multicast
C. Merge Join
D. Union All

8 What is the purpose of the 'Conditional Split' transformation in SSIS?

A. To convert data types
B. To remove duplicate rows
C. To route data rows to different outputs based on expressions
D. To combine multiple data streams into one

9 If you need to perform a lookup against a reference table to retrieve related columns, which SSIS transformation should you use?

A. Sort Transformation
B. Lookup Transformation
C. Fuzzy Grouping
D. Row Count

10 Which SSIS transformation creates new column values by applying expressions to existing columns?

A. Aggregate
B. Data Conversion
C. Derived Column
D. Multicast

11 In SSIS, what is required before using a 'Merge' or 'Merge Join' transformation?

A. The data must be sorted
B. The data must be in XML format
C. The data must be normalized
D. The data must be aggregated

12 What is the purpose of the 'Multicast' transformation in SSIS?

A. To perform an inner join
B. To send identical copies of the data to multiple output paths
C. To merge multiple inputs into one
D. To filter data based on criteria

13 Which transformation would you use to change the data type of a column (e.g., from String to Integer) in SSIS?

A. Data Conversion
B. Copy Column
C. Percentage Sampling
D. Character Map

14 In the SSIS ecosystem, where are project-level parameters and connection managers usually managed?

A. In the destination database
B. In the Windows Registry
C. In a text file on the desktop
D. In the Project.params file and Solution Explorer

15 What is the function of the 'Aggregate' transformation in SSIS?

A. To perform calculations like Sum, Average, or Count on grouped data
B. To encrypt sensitive data
C. To sort data alphabetically
D. To split data into training and testing sets

16 RapidMiner is primarily known as a platform for which of the following?

A. Data Science and Machine Learning
B. Operating System Management
C. Web Development
D. Network Security

17 In RapidMiner, the central workspace where you store data, processes, and results is called a:

A. Repository
B. Database
C. Registry
D. Warehouse

18 The building blocks of a RapidMiner process that perform specific actions (like loading data or training a model) are called:

A. Functions
B. Operators
C. Tasks
D. Nodes

19 In the RapidMiner GUI, which view is used to build and edit analysis processes?

A. Auto Model
B. Turbo Prep
C. Design View
D. Results View

20 In RapidMiner terminology, what are the rows of a dataset called?

A. Factors
B. Examples
C. Attributes
D. Dimensions

21 In RapidMiner terminology, what are the columns of a dataset called?

A. Indices
B. Keys
C. Examples
D. Attributes

22 What is the purpose of the 'Store' operator in RapidMiner?

A. To pause the process
B. To save a process result or dataset into the Repository
C. To export data to a CSV file
D. To cache data in RAM only

23 Which port on an operator typically provides the output data to be passed to the next operator?

A. inp (input)
B. exa (example set)
C. out (output)
D. mod (model)

24 To connect the final output of a process to the 'Results' view in RapidMiner, where must the wire be connected?

A. To the 'log' port
B. To the 'inp' port of the process
C. No connection is needed
D. To the 'res' (result) port on the process panel wall

25 Which feature in RapidMiner allows you to inspect the data flowing through a connection without finishing the whole process?

A. Breakpoints
B. Validation
C. Macros
D. Turbo Prep

26 When loading data for EDA in RapidMiner, which view provides immediate summary statistics (min, max, average) for all attributes?

A. Results View -> Statistics Tab
B. Log View
C. XML View
D. Design View

27 Which chart type in RapidMiner is best suited for visualizing the distribution of a single numerical attribute?

A. Network Graph
B. Scatter Plot
C. Pie Chart
D. Histogram

28 In RapidMiner visualization, what is a Scatter Plot primarily used for?

A. To show the hierarchy of data
B. To count missing values
C. To view the summary statistics
D. To see the correlation or relationship between two numerical attributes

29 If you want to identify 'Outliers' visually in RapidMiner, which plot is most effective?

A. Box Plot
B. Area Chart
C. Venn Diagram
D. Pie Chart

30 What does the 'Correlation Matrix' in RapidMiner help a user identify?

A. The number of rows in the data
B. The causal relationship between attributes
C. The missing values in the dataset
D. The linear relationship strength between pairs of numerical attributes

31 Which operator in RapidMiner is used to select specific columns (attributes) to keep or remove from the dataset?

A. Replace Missing Values
B. Select Attributes
C. Sort
D. Filter Examples

32 Which operator is used to filter rows based on specific conditions (e.g., Age > 25)?

A. Append
B. Normalize
C. Select Attributes
D. Filter Examples

33 In Data Preparation, what does 'Normalization' typically achieve?

A. It removes all missing values
B. It deletes duplicate rows
C. It converts text to numbers
D. It scales numeric attributes to a specific range (e.g., 0 to 1)

34 What is 'Standardization' (Z-transformation) in the context of RapidMiner data prep?

A. Scaling data to have a mean of 0 and a standard deviation of 1
B. Sorting data alphabetically
C. Removing all outliers
D. Rounding numbers to the nearest integer

35 How does the 'Replace Missing Values' operator handle data gaps?

A. It stops the process with an error
B. It replaces the missing value with a specified value (like the average) or a constant
C. It leaves the value empty
D. It deletes the row containing the missing value

36 If a dataset in RapidMiner contains a column 'Gender' with values 'M' and 'F', what is the data type of this attribute?

A. Polynominal (Nominal)
B. Date_Time
C. Real
D. Integer

37 Which operator allows you to change the type of an attribute, for example, from Integer to Real or Nominal to Text?

A. Guess Types
B. Select Attributes
C. Rename
D. Numerical to Polynominal

38 What is the purpose of the 'Remove Duplicates' operator?

A. To remove outliers
B. To remove rows that are identical across all (or selected) attributes
C. To remove attributes with constant values
D. To remove columns with similar names

39 Which RapidMiner operator is used to merge two datasets horizontally based on a key attribute?

A. Union
B. Join
C. Aggregate
D. Append

40 If you want to create a new attribute calculated from existing attributes (e.g., Revenue = Price * Quantity), which operator should you use?

A. Generate Attributes
B. Select Attributes
C. Filter Examples
D. Discretize

41 What does the 'Discretize' operator do in RapidMiner?

A. Converts nominal data to numerical data
B. Encrypts the data
C. Converts continuous numerical data into bin/ranges (categorical)
D. Removes discrete values

42 In RapidMiner, what does the color 'Red' typically indicate in the Statistics view next to an attribute?

A. The attribute contains missing values
B. The attribute is the label (target variable)
C. The data is sorted
D. The attribute is highly correlated

43 Which SSIS control flow task is used to run a snippet of C# or VB.NET code?

A. Execute SQL Task
B. Script Task
C. Expression Task
D. Analysis Services Task

44 In RapidMiner, if you want to combine two datasets vertically (stacking them), which operator do you use?

A. Merge
B. Append
C. Group By
D. Join

45 What is the primary usage of the 'Sample' operator in RapidMiner?

A. To test the chemical properties of data
B. To generate synthetic data
C. To sort the data randomly
D. To reduce the dataset size by selecting a subset of rows

46 In SSIS, what is a 'Variable' used for?

A. To create a primary key
B. To store temporary values that can be used across tasks and containers
C. To define the database schema
D. To visualize data

47 Which RapidMiner view is specifically designed for quick, interactive data cleaning without building a complex process manually?

A. Auto Model
B. Turbo Prep
C. Background Process
D. Design View

48 When defining an SSIS connection manager for a flat file (CSV), what must be defined?

A. The SQL dialect
B. The column delimiter (e.g., comma, tab)
C. The primary key constraint
D. The server IP address

49 In RapidMiner, what does the 'Map' operator do?

A. Calculates the mean average
B. Visualizes data on a geographical map
C. Replaces specific values in an attribute with new values based on a defined mapping
D. Joins tables together

50 Which of the following represents the correct flow of an ETL process?

A. Extract -> Load -> Transform
B. Load -> Transform -> Extract
C. Transform -> Extract -> Load
D. Extract -> Transform -> Load
Previous MCQ
Unit 4
Next MCQ
Unit 6