Top 250+ Solved Data Mining and Business Intelligence MCQ Questions Answer
Q. The load and index is_______.
a. A process to reject data from the data warehouse and to create the necessary indexes
b. A process to load the data in the data warehouse and to create the necessary indexes
c. A process to upgrade the quality of data after it is moved into a data warehouse
d. A process to upgrade the quality of data before it is moved into a data warehouse
Q. Data transformation includes___________.
a. A process to change data from a detailed level to a summary level
b. A process to change data from a summary level to a detailed level
c. Joining data from one source into various sources of data
d. Separating data from one source into various sources of data
Q. ______ is called a multifield transformation.
a. Converting data from one field into multiple fields
b. Converting data from fields into field
c. Converting data from double fields into multiple fields
d. Converting data from one field to one field
Q. The type of relationship in star schema is_________.
a. Many-to-many
b. One-to-one
c. One-to-many
d. Many-to-one
Q. Fact tables are_______.
a. Completely demoralized
b. Partially demoralized
c. Completely normalize
d. D Partially normalized
Q. ____________is the goal of data mining.
a. To explain some observed event or condition
b. To confirm that data exists
c. To analyze data for expected relationships
d. To create a new data warehouse
Q. Business Intelligence and data warehousing is used for________.
a. Forecasting
b. Data Mining
c. Analysis of large volumes of product sales data
d. All of the above
Q. The data administration subsystem helps you perform all of the following, except_________.
a. Backups and recovery
b. Query optimization
c. Security management
d. Create, change, and delete information
Q. The most common source of change data in refreshing a data warehouse is__________.
a. Query able change data
b. Cooperative change data
c. Logged change data
d. Snapshot change data
Q. ___________are responsible for running queries and reports against data warehouse tables.
a. Hardware
b. Software
c. End users
d. Middle ware
Q. Query tool is meant for_________.
a. Data acquisition
b. Information delivery
c. Information exchange
d. Communication
Q. Classification rules are extracted from____________.
a. Root node
b. Decision tree
c. Siblings
d. Branches
Q. Dimensionality reduction reduces the data set size by removing_____________.
a. Relevant attributes
b. Irrelevant attributes
c. Derived attributes
d. Composite attributes
Q. Effect of one attribute value on a given class is independent of values of other attribute iscalled____________.
a. Value independence
b. Class conditional independence
c. Conditional independence
d. Unconditional independence