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. Useful for assessing performance in terms of identifying the most important class. Helps such choices as: How many tax records to examine; How many loans to grant; How many customers to mail an offer
cascading delete
DROP TABLE Salesrep;
lift charts
changing/UPDATE-ing
2. An alternative to the data warehouse concept is a lower-cost - scaled-down version referred to as the _____________.
OLAP
data mart
changing/UPDATE-ing
knowledge data discovery
3. Which function should be used to calculate the total of all entries in a given column?
UNION
Transformation
Sum
semantic object (SOL) attribute
4. Increased affordability of ____________ is a reason for the growth in popularity of data mining.
market basket analysis
Group By
The degree of granularity
machine learning
5. A powerful trend in IT is known as - which maintains that Computer transmission speed doubles every 18 months.
decile chart
groves law
Transformation
Horizontal integration
6. A Star diagram has two types of tables (objects). They are called the___________________ tables and ; fact tables.
dimension
lift charts
the relationship
semantic object (SOL) attribute
7. Which statement removes the table Salesrep from a DBMS?
measuring predictive error
data mart
DROP TABLE Salesrep;
near-line secondary storage devices
8. The term "ETL" in data warehousing stands for: Extraction - ________________________ - & Loading.
ERD Modeling
MOLAP
UNION
Transformation
9. Gives an idea of systematic over- or under-prediction. Magnitude of average absolute error.
transformation mapping
degrees of summarization
average error
data visualization
10. The _____ operation of two tables results in a single table with the same columns as the first table - and containing all rows that are in the first table merged with all the rows in the second table - minus any duplicate rows.
data mining
UNION
knowledge data discovery
MOLAP
11. The ACCESS feature that tests to see if your tables are normalized properly is the ____.
n
degrees of summarization
Document Analyzer
operational and external layer
12. Which of the following is at the center of a star schema?
Fact or Measurement table
decile chart
Referential integrity
MOLAP
13. Within most organizations - the person known as the _____ determines the type of access various users can have to the corporate or enterprise database.
database administrator
dimension
drill-across report
The degree of granularity
14. Which rule would you be violating - if you tried to delete a sales rep record - who currently has customers on file?
Insert
Horizontal integration
UNION
Referential integrity
15. ___________ is not a characteristic of a data warehouse.
data mart
MOLAP
volatile data
Top-down approach
16. These are considered an alternate storage techniques for data warehousing include.
market basket analysis
near-line secondary storage devices
groves law
Revoke
17. An economic feasibility measure. So is Internal rate of return.
data mart
Count
Breakeven analysis
Referential integrity
18. In general - ______________ are transformed to relations/tables by defining one relation for the object itself and another relation for each multivalued attribute.
UNION
association semantic object
numeric prediction
composite semantic objects
19. The SQL command for deleting the Warehouse field from the Part table is _____.
machine learning
data mart
Count
ALTER TABLE Part DELETE Warehouse;
20. The process by which numerical data is converted into graphical images is referred to as:
groves law
data visualization
data mining
data mart
21. Semantic object link (SOL) attributes establish a relationship between one _______ and another.
semantic object
The degree of granularity
the relationship
neural networks & Decision Trees
22. The _______________________ represents the source data for the DW. This layer is comprised - primarily - of operational transaction processing systems and external secondary databases.
Regression analysis
Association
operational and external layer
neural networks & Decision Trees
23. 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.
neural networks & Decision Trees
drill-across report
Top-down approach
MOLAP
24. Models that do ___________: MLR; KNN; Regression and Classification Trees; ANN; SVM
numeric prediction
ERD Modeling
Fact or Measurement table
Top-down approach
25. A ___________ combines result sets from more than one fact table.
dimension
drill-across report
Fact or Measurement table
MAE (Mean Absolute Error) deviation
26. __________ occurs when the initial scope of a project continues to expand as new features are incorporated into the project.
association semantic object
Transformation
MOLAP
Scope creep
27. Information about tables in the database is kept in the _____.
dimension
semantic object (SOL) attribute
system catalog
The degree of granularity
28. A compound semantic object is an object that contains at least one ____.
cascading delete
semantic object (SOL) attribute
Document Analyzer
project readiness assessment factor
29. An ___________ relates two other objects.
Count
Regression analysis
decile chart
association semantic object
30. The SQL built-in functions - which may appear on the same line as the SELECT statement (before the FROM clause) are called _____ functions.
dimension
the relationship
artificial Key
aggregate
31. 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)
MAE (Mean Absolute Error) deviation
measuring predictive error
Revoke
near-line secondary storage devices
32. Which function calculates the number of entries in a table?
Count
n
MOLAP
Horizontal integration
33. Gives us an idea of the magnitude of errors. Actual value - estimated value.
transformation mapping
MAE (Mean Absolute Error) deviation
knowledge data discovery
recognizing known patterns
34. Which clause would be used to create groups of records?
operational and external layer
transformation mapping
Group By
Sum
35. The deletion of a record that also deletes related records is referred to as a(n) _____.
data mart
cascading delete
degrees of summarization
drill-across report
36. ___________________ 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
Transformation
semantic object (SOL) attribute
measuring predictive error
Regression analysis
37. You can save the results of a query as a table by including the _____ clause in the query.
PRIMARY KEY (CustomerNum)
Into
data visualization
numeric prediction
38. Generally Semantic Object Modeling (SOM) is consideredmore bottom-up oriented than _____________.
ERD Modeling
market basket analysis
machine learning
Horizontal integration
39. Which data mining technique utilizes linkage analysis to search operational transactions for patterns with a high probability of repetition?
maximum
Association
Cartesian
composite semantic objects
40. Are a data mining technology.
neural networks & Decision Trees
changing/UPDATE-ing
surrogate key
Sum
41. The set of activities used to find new - hidden - or unexpected patterns in data is referred to as _____.
Cartesian
data visualization
data mining
changing/UPDATE-ing
42. To add a new row to a table - use the _____ command.
MAE (Mean Absolute Error) deviation
the relationship
Insert
cascading delete
43. R- squared(and adjusted r-squared) - A measure of how much of the variability around the target mean is explained by your predictive variables. Doesn't mean you have a good predictive model—only validation will tell you that
performance metrics - Numeric Prediction
semantic object (SOL) attribute
composite semantic objects
semantic object
44. ___________ determines exactly what level of detail constitutes a fact record.
The degree of granularity
Referential integrity
Breakeven analysis
Into
45. An analytical-oriented organizational structure is a data warehouse _____________.
maximum
semantic object (SOL) attribute
project readiness assessment factor
OLAP
46. 'Signatures' are used for intrusion detection by _______?
Insert
ALTER TABLE Part DELETE Warehouse;
recognizing known patterns
dimension
47. On an ER Diagram the number (mark) on relationship line that is farthest away from each entity (rectangle) represents the _______ cardinality.
maximum
semantic object (SOL) attribute
Cartesian
data mining
48. 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.
machine learning
lift charts
OLAP
near-line secondary storage devices
49. _________ 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.
changing/UPDATE-ing
groves law
data mining
Horizontal integration
50. The process that records how data from operational data stores and external sources are transformed on the way into the warehouse is referred to as ________________.
Group By
MOLAP
drill-across report
transformation mapping