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