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 clause would be used to create groups of records?
Regression analysis
Group By
performance metrics - Numeric Prediction
Breakeven analysis
2. The set of activities used to find new - hidden - or unexpected patterns in data is referred to as _____.
Cartesian
surrogate key
Regression analysis
data mining
3. Semantic object link (SOL) attributes establish a relationship between one _______ and another.
performance metrics - Numeric Prediction
Scope creep
semantic object
DROP TABLE Salesrep;
4. A powerful trend in IT is known as - which maintains that Computer transmission speed doubles every 18 months.
system catalog
groves law
market basket analysis
project readiness assessment factor
5. Models that do ___________: MLR; KNN; Regression and Classification Trees; ANN; SVM
numeric prediction
knowledge data discovery
groves law
Breakeven analysis
6. An analytical-oriented organizational structure is a data warehouse _____________.
near-line secondary storage devices
machine learning
decile chart
project readiness assessment factor
7. A _____________ is a system-generated primary key.
average error
knowledge data discovery
measuring predictive error
surrogate key
8. The term "ETL" in data warehousing stands for: Extraction - ________________________ - & Loading.
Transformation
Fact or Measurement table
lift charts
PRIMARY KEY (CustomerNum)
9. 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:
transformation mapping
PRIMARY KEY (CustomerNum)
recognizing known patterns
market basket analysis
10. The _______________________ represents the source data for the DW. This layer is comprised - primarily - of operational transaction processing systems and external secondary databases.
market basket analysis
ALTER TABLE Part DELETE Warehouse;
operational and external layer
Transformation
11. An alternative to the data warehouse concept is a lower-cost - scaled-down version referred to as the _____________.
near-line secondary storage devices
aggregate
semantic object (SOL) attribute
data mart
12. Which function should be used to calculate the total of all entries in a given column?
Top-down approach
Sum
Breakeven analysis
Group By
13. A ___________ combines result sets from more than one fact table.
drill-across report
data visualization
numeric prediction
performance metrics - Numeric Prediction
14. 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
drill-across report
MAE (Mean Absolute Error) deviation
Referential integrity
15. An economic feasibility measure. So is Internal rate of return.
maximum
Insert
aggregate
Breakeven analysis
16. The SQL built-in functions - which may appear on the same line as the SELECT statement (before the FROM clause) are called _____ functions.
aggregate
changing/UPDATE-ing
data mart
composite semantic objects
17. These are considered an alternate storage techniques for data warehousing include.
ALTER TABLE Part DELETE Warehouse;
degrees of summarization
near-line secondary storage devices
Referential integrity
18. Gives us an idea of the magnitude of errors. Actual value - estimated value.
aggregate
artificial Key
Group By
MAE (Mean Absolute Error) deviation
19. Which of the following is at the center of a star schema?
maximum
UNION
Fact or Measurement table
ERD Modeling
20. 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 ________________.
near-line secondary storage devices
Breakeven analysis
transformation mapping
Fact or Measurement table
21. 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) ____________.
surrogate key
system catalog
PRIMARY KEY (CustomerNum)
artificial Key
22. 'Signatures' are used for intrusion detection by _______?
data mart
Horizontal integration
Breakeven analysis
recognizing known patterns
23. Within most organizations - the person known as the _____ determines the type of access various users can have to the corporate or enterprise database.
Breakeven analysis
database administrator
near-line secondary storage devices
association semantic object
24. Increased affordability of ____________ is a reason for the growth in popularity of data mining.
machine learning
Document Analyzer
MOLAP
Horizontal integration
25. Which statement removes the table Salesrep from a DBMS?
neural networks & Decision Trees
ALTER TABLE Part DELETE Warehouse;
knowledge data discovery
DROP TABLE Salesrep;
26. Why are Star Schemas so useful in Financial Planning and Accounting Information Systems?
cascading delete
average error
degrees of summarization
volatile data
27. 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
Insert
dimension
surrogate key
lift charts
28. Gives an idea of systematic over- or under-prediction. Magnitude of average absolute error.
average error
data visualization
association semantic object
data mining
29. Are a data mining technology.
neural networks & Decision Trees
Scope creep
Count
principle component analysis
30. A Star diagram has two types of tables (objects). They are called the___________________ tables and ; fact tables.
Sum
the relationship
Group By
dimension
31. 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.
DROP TABLE Salesrep;
MOLAP
OLAP
Fact or Measurement table
32. The product of two tables is also called the ________ product.
maximum
Cartesian
aggregate
project readiness assessment factor
33. To add a new row to a table - use the _____ command.
project readiness assessment factor
Cartesian
Group By
Insert
34. A compound semantic object is an object that contains at least one ____.
project readiness assessment factor
semantic object
semantic object (SOL) attribute
lift charts
35. Generally Semantic Object Modeling (SOM) is consideredmore bottom-up oriented than _____________.
ERD Modeling
Group By
average error
measuring predictive error
36. Which statement will take away user privileges to the database?
Revoke
principle component analysis
performance metrics - Numeric Prediction
data visualization
37. ___________________ 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
the relationship
MAE (Mean Absolute Error) deviation
Regression analysis
changing/UPDATE-ing
38. You can save the results of a query as a table by including the _____ clause in the query.
machine learning
Scope creep
Into
recognizing known patterns
39. The process by which numerical data is converted into graphical images is referred to as:
dimension
volatile data
data visualization
Insert
40. Which rule would you be violating - if you tried to delete a sales rep record - who currently has customers on file?
Referential integrity
drill-across report
Cartesian
changing/UPDATE-ing
41. The SQL command for deleting the Warehouse field from the Part table is _____.
ALTER TABLE Part DELETE Warehouse;
project readiness assessment factor
DROP TABLE Salesrep;
The degree of granularity
42. Twice as likely to identify the important class (compared to avg. prevalence)
decile chart
Referential integrity
groves law
near-line secondary storage devices
43. A synonym for data mining
composite semantic objects
knowledge data discovery
near-line secondary storage devices
drill-across report
44. ____________ would not normally be associated with ROUTINE data warehouse maintenance.
Into
Revoke
changing/UPDATE-ing
the relationship
45. ___________ is not a characteristic of a data warehouse.
data visualization
groves law
volatile data
operational and external layer
46. This is not considered one of the four major categories of processing algorithms and rule approaches.
decile chart
groves law
principle component analysis
association semantic object
47. In general - ______________ are transformed to relations/tables by defining one relation for the object itself and another relation for each multivalued attribute.
association semantic object
maximum
composite semantic objects
recognizing known patterns
48. When an entity has a minimum cardinality of one it means the entity is required in _______.
PRIMARY KEY (CustomerNum)
lift charts
the relationship
average error
49. Information about tables in the database is kept in the _____.
data visualization
system catalog
UNION
dimension
50. 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.
near-line secondary storage devices
Cartesian
Group By
MOLAP