SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Data Mining
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Which data mining technique utilizes linkage analysis to search operational transactions for patterns with a high probability of repetition?
Horizontal integration
Breakeven analysis
artificial Key
Association
2. Which function should be used to calculate the total of all entries in a given column?
data mart
the relationship
neural networks & Decision Trees
Sum
3. Why are Star Schemas so useful in Financial Planning and Accounting Information Systems?
Document Analyzer
drill-across report
degrees of summarization
MAE (Mean Absolute Error) deviation
4. The SQL built-in functions - which may appear on the same line as the SELECT statement (before the FROM clause) are called _____ functions.
association semantic object
aggregate
drill-across report
knowledge data discovery
5. 'Signatures' are used for intrusion detection by _______?
dimension
Document Analyzer
recognizing known patterns
n
6. _________ seeks to ensure that each application under development is fully integrated within its own boundaries and to eliminate any inconsistencies in the final software product.
average error
Horizontal integration
drill-across report
UNION
7. Which statement will take away user privileges to the database?
Revoke
performance metrics - Numeric Prediction
Top-down approach
Breakeven analysis
8. In general - ______________ are transformed to relations/tables by defining one relation for the object itself and another relation for each multivalued attribute.
operational and external layer
near-line secondary storage devices
maximum
composite semantic objects
9. A compound semantic object is an object that contains at least one ____.
Fact or Measurement table
semantic object (SOL) attribute
data visualization
n
10. The term "ETL" in data warehousing stands for: Extraction - ________________________ - & Loading.
DROP TABLE Salesrep;
Transformation
Horizontal integration
UNION
11. A common example of the use of association methods where a retailer can mine the data generated by a point-of-sale system - such as the price scanner you are familiar with at the grocery store is referred to as:
market basket analysis
composite semantic objects
database administrator
performance metrics - Numeric Prediction
12. Which of the following database design and data warehouse design approaches is viewed to take a more strategic rather than operational perspective?
Sum
the relationship
Top-down approach
average error
13. The _______________________ represents the source data for the DW. This layer is comprised - primarily - of operational transaction processing systems and external secondary databases.
artificial Key
system catalog
Into
operational and external layer
14. ___________ is not a characteristic of a data warehouse.
Transformation
volatile data
n
Association
15. ___________ determines exactly what level of detail constitutes a fact record.
The degree of granularity
Transformation
numeric prediction
semantic object (SOL) attribute
16. Increased affordability of ____________ is a reason for the growth in popularity of data mining.
transformation mapping
groves law
machine learning
database administrator
17. Not the same as goodness-of-fit; We want to know how well the model predicts new data - not how well it fits the data it was trained with; Key component of most measures is difference between actual y and predicted y (error)
measuring predictive error
maximum
data mart
DROP TABLE Salesrep;
18. To add a new row to a table - use the _____ command.
decile chart
Transformation
Group By
Insert
19. The product of two tables is also called the ________ product.
Cartesian
Horizontal integration
operational and external layer
machine learning
20. Gives us an idea of the magnitude of errors. Actual value - estimated value.
measuring predictive error
Horizontal integration
MAE (Mean Absolute Error) deviation
Scope creep
21. Which statement removes the table Salesrep from a DBMS?
DROP TABLE Salesrep;
artificial Key
ERD Modeling
association semantic object
22. The ACCESS feature that tests to see if your tables are normalized properly is the ____.
numeric prediction
cascading delete
Document Analyzer
maximum
23. The term _____ has been generally agreed to represent the broadest category of software technology that enables decision makers to conduct many dimensional analysis of consolidated enterprise data.
Insert
OLAP
near-line secondary storage devices
measuring predictive error
24. The set of activities used to find new - hidden - or unexpected patterns in data is referred to as _____.
lift charts
market basket analysis
drill-across report
data mining
25. An economic feasibility measure. So is Internal rate of return.
surrogate key
Transformation
Sum
Breakeven analysis
26. A ___________ combines result sets from more than one fact table.
DROP TABLE Salesrep;
drill-across report
performance metrics - Numeric Prediction
Top-down approach
27. Organizes and analyzes data as an n-dimensional cube. The cube can be thought of as a common spreadsheet with two extensions: (1) support for multiple dimensions and (2) support for multiple concurrent users.
ERD Modeling
MOLAP
changing/UPDATE-ing
surrogate key
28. Which of the following is at the center of a star schema?
Fact or Measurement table
MAE (Mean Absolute Error) deviation
lift charts
data visualization
29. A synonym for data mining
association semantic object
cascading delete
n
knowledge data discovery
30. A powerful trend in IT is known as - which maintains that Computer transmission speed doubles every 18 months.
semantic object (SOL) attribute
groves law
ALTER TABLE Part DELETE Warehouse;
machine learning
31. Which rule would you be violating - if you tried to delete a sales rep record - who currently has customers on file?
The degree of granularity
PRIMARY KEY (CustomerNum)
principle component analysis
Referential integrity
32. When an entity has a minimum cardinality of one it means the entity is required in _______.
decile chart
operational and external layer
the relationship
Top-down approach
33. This is not considered one of the four major categories of processing algorithms and rule approaches.
ALTER TABLE Part DELETE Warehouse;
database administrator
drill-across report
principle component analysis
34. A single column that you create for an entity to serve as the primary key - because you otherwise would need many concatenated columns to do so - is called a(n) ____________.
artificial Key
Cartesian
neural networks & Decision Trees
Count
35. Twice as likely to identify the important class (compared to avg. prevalence)
knowledge data discovery
groves law
decile chart
ALTER TABLE Part DELETE Warehouse;
36. An analytical-oriented organizational structure is a data warehouse _____________.
drill-across report
numeric prediction
project readiness assessment factor
data mining
37. Generally Semantic Object Modeling (SOM) is consideredmore bottom-up oriented than _____________.
Count
ERD Modeling
numeric prediction
database administrator
38. You can save the results of a query as a table by including the _____ clause in the query.
drill-across report
recognizing known patterns
changing/UPDATE-ing
Into
39. A _____________ is a system-generated primary key.
the relationship
drill-across report
database administrator
surrogate key
40. Models that do ___________: MLR; KNN; Regression and Classification Trees; ANN; SVM
near-line secondary storage devices
numeric prediction
Breakeven analysis
Top-down approach
41. Are a data mining technology.
operational and external layer
degrees of summarization
neural networks & Decision Trees
Document Analyzer
42. On an ER Diagram the number (mark) on relationship line that is farthest away from each entity (rectangle) represents the _______ cardinality.
Transformation
transformation mapping
maximum
Horizontal integration
43. Information about tables in the database is kept in the _____.
ERD Modeling
PRIMARY KEY (CustomerNum)
system catalog
average error
44. These are considered an alternate storage techniques for data warehousing include.
knowledge data discovery
principle component analysis
UNION
near-line secondary storage devices
45. An alternative to the data warehouse concept is a lower-cost - scaled-down version referred to as the _____________.
database administrator
project readiness assessment factor
data mart
Association
46. Semantic object link (SOL) attributes establish a relationship between one _______ and another.
degrees of summarization
transformation mapping
association semantic object
semantic object
47. The minimum cardinality and m is the maximum cardinality Cardinalities in Semantic Objects are shown as subscripts in the format n-m where _____
database administrator
cascading delete
maximum
n
48. Gives an idea of systematic over- or under-prediction. Magnitude of average absolute error.
average error
semantic object (SOL) attribute
the relationship
UNION
49. ___________________ is used to relate one set of outcomes (dependent variable) to a set of predictor (independent) variables (e.g. - in time series analysis). Through this analysis we attempt to predictive future events - as the dependent variables b
Revoke
Breakeven analysis
volatile data
Regression analysis
50. Within most organizations - the person known as the _____ determines the type of access various users can have to the corporate or enterprise database.
data visualization
database administrator
n
near-line secondary storage devices