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

A.

.dtproj

B.

.sln

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.

Connection Managers

B.

Event Handlers

C.

Control Flow

D.

Data Flow

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

A.

SQL Server Management Studio (SSMS)

B.

RapidMiner Studio

C.

Eclipse

D.

Visual Studio with SSDT

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

A.

To transform data types

B.

To schedule the package execution

C.

To debug the data flow

D.

To establish and maintain links to data sources and destinations

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

A.

Script Task

B.

File System Task

C.

Data Flow Task

D.

Execute SQL Task

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

A.

The speed of data transfer

B.

The error handling mechanism inside a transformation

C.

The condition under which the next task in the Control Flow is executed

D.

The data type of a column

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

A.

Merge Join

B.

Derived Column

C.

Union All

D.

Multicast

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

A.

To combine multiple data streams into one

B.

To route data rows to different outputs based on expressions

C.

To convert data types

D.

To remove duplicate rows

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

A.

Lookup Transformation

B.

Row Count

C.

Fuzzy Grouping

D.

Sort Transformation

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

A.

Derived Column

B.

Multicast

C.

Data Conversion

D.

Aggregate

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

A.

The data must be in XML format

B.

The data must be sorted

C.

The data must be aggregated

D.

The data must be normalized

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

A.

To merge multiple inputs into one

B.

To filter data based on criteria

C.

To send identical copies of the data to multiple output paths

D.

To perform an inner join

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.

Percentage Sampling

C.

Character Map

D.

Copy Column

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

A.

In the Project.params file and Solution Explorer

B.

In a text file on the desktop

C.

In the Windows Registry

D.

In the destination database

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

A.

To sort data alphabetically

B.

To perform calculations like Sum, Average, or Count on grouped data

C.

To encrypt sensitive data

D.

To split data into training and testing sets

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

A.

Network Security

B.

Web Development

C.

Operating System Management

D.

Data Science and Machine Learning

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

A.

Repository

B.

Warehouse

C.

Registry

D.

Database

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

A.

Tasks

B.

Operators

C.

Functions

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.

Attributes

B.

Dimensions

C.

Examples

D.

Factors

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

A.

Keys

B.

Examples

C.

Attributes

D.

Indices

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

A.

To cache data in RAM only

B.

To save a process result or dataset into the Repository

C.

To pause the process

D.

To export data to a CSV file

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

A.

out (output)

B.

mod (model)

C.

exa (example set)

D.

inp (input)

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 'res' (result) port on the process panel wall

C.

No connection is needed

D.

To the 'inp' port of the process

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

A.

Macros

B.

Breakpoints

C.

Validation

D.

Turbo Prep

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

A.

Log View

B.

XML View

C.

Design View

D.

Results View -> Statistics Tab

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

A.

Network Graph

B.

Pie Chart

C.

Scatter Plot

D.

Histogram

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

A.

To see the correlation or relationship between two numerical attributes

B.

To count missing values

C.

To show the hierarchy of data

D.

To view the summary statistics

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

A.

Box Plot

B.

Venn Diagram

C.

Area Chart

D.

Pie Chart

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

A.

The linear relationship strength between pairs of numerical attributes

B.

The number of rows in the data

C.

The missing values in the dataset

D.

The causal relationship between attributes

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

A.

Sort

B.

Select Attributes

C.

Replace Missing Values

D.

Filter Examples

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

A.

Select Attributes

B.

Normalize

C.

Append

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 scales numeric attributes to a specific range (e.g., 0 to 1)

D.

It converts text to numbers

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

A.

Rounding numbers to the nearest integer

B.

Sorting data alphabetically

C.

Removing all outliers

D.

Scaling data to have a mean of 0 and a standard deviation of 1

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

A.

It stops the process with an error

B.

It deletes the row containing the missing value

C.

It leaves the value empty

D.

It replaces the missing value with a specified value (like the average) or a constant

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

A.

Date_Time

B.

Real

C.

Integer

D.

Polynominal (Nominal)

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 rows that are identical across all (or selected) attributes

B.

To remove attributes with constant values

C.

To remove columns with similar names

D.

To remove outliers

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

A.

Append

B.

Union

C.

Aggregate

D.

Join

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

A.

Discretize

B.

Filter Examples

C.

Generate Attributes

D.

Select Attributes

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

A.

Removes discrete values

B.

Converts continuous numerical data into bin/ranges (categorical)

C.

Encrypts the data

D.

Converts nominal data to numerical data

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 data is sorted

C.

The attribute is the label (target variable)

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.

Analysis Services Task

B.

Expression Task

C.

Execute SQL Task

D.

Script Task

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

A.

Append

B.

Join

C.

Merge

D.

Group By

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

A.

To test the chemical properties of data

B.

To reduce the dataset size by selecting a subset of rows

C.

To generate synthetic data

D.

To sort the data randomly

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

A.

To create a primary key

B.

To define the database schema

C.

To visualize data

D.

To store temporary values that can be used across tasks and containers

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

A.

Design View

B.

Background Process

C.

Auto Model

D.

Turbo Prep

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

A.

The server IP address

B.

The column delimiter (e.g., comma, tab)

C.

The SQL dialect

D.

The primary key constraint

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

A.

Replaces specific values in an attribute with new values based on a defined mapping

B.

Joins tables together

C.

Visualizes data on a geographical map

D.

Calculates the mean average

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

A.

Transform -> Extract -> Load

B.

Extract -> Load -> Transform

C.

Extract -> Transform -> Load

D.

Load -> Transform -> Extract

Unit 5 - Practice Quiz