Comprehensive Resource To Help You Ace 2026-2027 Exams
Includes Frequently Tested Questions With ELABORATED
100% Correct COMPLETE SOLUTIONS
Guaranteed Pass First Attempt!! Current Update!!
Instant Download Pdf
1. The steps involved in data mining when viewed as a process of knowledge discovery
(KDD), include ___.
-data modeling, data cleaning, and outlier detection
-data transformation, data storage, and pattern evaluation
-data cleaning, data integration, and data selection
-class description, data selection, and knowledge presentation - Correct Answer: -
data cleaning, data integration, and data selection
2. In the following example, a concept description was obtained using ___.
A manager of a store orders the following data mining task: summarize the
characteristics of customers who spend more than $1000 a month at the store website.
The result is a profile of customers stating that they are all employed, over 45 years old,
50% male. 50% female.
-data characterization
-data discrimination
-outlier analysis
-active learning - Correct Answer: -data characterization
3. Major issues or challenges in data mining research include ___.
-data warehouses
-dealing with diverse data types
-cluster analysis
,-Web search engines - Correct Answer: -dealing with diverse data types
4. An example of proximity measure is the ___.
-Gini index
-minimum support count threshold
-supremum distance
-information gain - Correct Answer: -supremum distance
5. One of the factors comprising data quality is ___.
-consistency
-integration
-numerosity
-resolution - Correct Answer: -consistency
6. Measures of proximity are used in data mining applications such as clustering and outlier
analysis. For numeric attributes, Euclidean, Minkowski, and supremum distances are
often used as measures of proximity.
Consider the objects i and j given below, represented by tuples.
i = (4, 14) and j = (17, 2).
Compute the Euclidean distance between i and j. Round the result to one decimal place.
- Correct Answer: 18
7. Suppose that the minimum and the maximum values of the attribute cholesterol_level
are 108 and 251. respectively. Use min-max normalization to transform the value 183 for
cholesterol_level onto the range [0.0, 1.0]. Round your result to one decimal place. -
Correct Answer: 0.5
8. A major feature of a data warehouse is that ___.
-it focuses on the day-to-day operations of an organization
-typical users include clerks and database professionals
-is time-variant
, -old data is removed periodically to improve performance - Correct Answer: -is time
variant
9. Consider a data cube measure obtained by applying the average() function. The measure
is ___.
-algebraic
-analytic
-holistic
-atomic - Correct Answer: -algebraic
10. Consider a data cube measure obtained by applying the mode() function. The measure is
___.
-algebraic
-analytic
-holistic
-atomic - Correct Answer: -holistic
11. In the ___ schema some dimension tables are normalized, generating additional tables.
-galaxy
-snowflake
-data mart
star - Correct Answer: -snowflake
12. Consider the 2-D data cube
LOCATION RESOURCE
South America 10,365
North America 5,971
Asia 2,840
, which represents information on freshwater resources per country (in kms cubed). The
cube contains the dimensions location and resource. The concept hierarchy for location
is defined as the total order "country < continent."
13. Which operation materializes the view provided below?
LOCATION RESOURCE
Brazil 8,233
United States 3,069
Canada 2,902
China 2,840
Colombia 2,132
-roll-up
-drill-down
-slice
-pivot - Correct Answer: -drill-down
14. Intuitively, the drill-down OLAP operation corresponds to concept ____ in a concept
hierarchy.
- cooperation
- ascension
- forecasting
- specialization - Correct Answer: -specialization
15. The ___ OLAP operation is realized by either stepping down a concept hierarchy for a
dimension or introducing additional dimensions.
- dice
- rotate
- drill-down
- drill-up - Correct Answer: -drill-down