About Us
Pehchan
Maharat
Parwaaz
Jobs

About Us
Pehchan
Maharat
Parwaaz
Jobs

Data Mining Online Test

Storing, data mapping and transformation from source systems to the Data Warehouse fall into:

1. None of the above

2. Operational metadata

3. Business metadata

4. Technical metadata

Which of the following RAID level does not implement error checking?

1. RAID0

2. RAID1

3. RAID (0+1)

4. RAID5

Which of the following tools provide enterprise intelligence?

1. Data warehouse

2. Databases

3. Data mining

4. None of the above

Which one of the following is not a tool for Data warehouse development?

1. SCCS

2. COGNOS

3. Informatica

4. Busin ess Objects

Fact -Tables usually consists of ___ relationships.

1. One to one

2. Many to many

3. One too many

4. Many to one

Which of the following schema supports the normalization in dimensional modeling

1. None of these

2. Snow-Flake schema

3. Star schema

4. Fact-Constellation

___ is used as a (dynamic) indexing method in relational database management systems.

1. B+ tree indexing

2. Bit map indexing

3. Clustered indexing

4. Compression indexing

Which of the following are the main areas of testing that should be done for the ETL process.

1. All of the extracted and transformed data is successfully loaded into Data Warehouse

2. All of the above

3. Making sure that all the records in the source system that should be brought into the warehouse and all the

4. All of the extracted source data is correctly transformed into dimension tables and fact tables

CMMI means ____.

1. Comprehensive Material Management Information

2. Capability Maturity Model Information

3. Capability Maturity Model Integration

4. Capability Model Maturity Integration

___ provides the Enterprise with intelligence and ___ provides the Enterprise with a memory.

1. Databases, Data Mining

2. Data mining, Data warehouse

3. Data Warehouse, Data Mining

4. Data Warehouse, Databases

Click stream data is used for the following

1. All the above

2. To study customer buying patterns

3. To track the user activity on the web page

4. Feed about web site design

The system delivers the result of requests for information through remote browsers is called,

1. Information delivery

2. Data dissemination

3. Data presentation

4. Web browser

Data Warehouse is ___ triggered whereas OLTP is ___ triggered.

1. Event, User

2. Insert, Update

3. System, Event

4. System, User

Confirmed dimension allows user to:

1. Work on fact and business subjects for which all users have the same meaning

2. Share non -Key dimension data

3. Query Across fact tables with consistency

4. All of the above

Parallelism improve processing for

1. Creation of large indexes

2. Bulk inserts, update and deletes

3. All of the above

4. Large table scans and joins

Data mining is ____ driven approach not ____ driven approach

1. User, Data

2. Event, Data

3. User, Event

4. Data, User

Writing the same data to two disk drives connected to the same controller ifs known as ___.

1. Data Mirroring

2. Disk Striping

3. Data Profiling

4. Data Duplexing

The full form of CMM is:

1. Computer Material Management

2. Capability Maturity Model

3. Comprehensive Material Management

4. Capability Model Maturity

OLAP stands for

1. On-Line Ability Processing

2. On-Line Application Processing

3. On-Line Analytical Processing

4. None of the above

Which of the following is true for the CMM level2?

1. Data quality issues are acknowledged

2. Both a and b.

3. Major problems are handled as and when they surface d

4. None of these

Which of the following is the private network to access the data through web

1. Internet

2. None of the above

3. Intranet

4. Extranet

Data Warehouse is defined as subject -oriented, integrated, time -variant and ___.

1. Non -Volatile

2. Volatile

3. Distributed

4. None of the above

According to Ralph Kimball, Back -room metadata guides

1. All the above

2. Loading processes

3. Cleaning

4. Extraction

Who is called the Father of Data Warehouse?

1. Bill Inmon

2.Fritz Bauer

3. Charles Babbage

4.Ralph Kimball

Which of the following is not a type of data loading?

1. Full refresh

2. Incremental load

3. Iterative load

4. Initial load

Each Dimension table has a ___ relationship to the fact table.

1. One to many

2. One to one

3. Many to many

4. Many to one

Meta Data means

1. Data about Data

2. Catalogue of data

3. Data Warehouse Roadmap

4. All of the above

Data Warehouse contains data for ___ purpose.

1. All of the above

2. Real -Time Operation

3. Validation

4. Analysis

Adding value to the data to give it more meaning is called ___.

1. Data profiling

2. Data cleansing

3. Data integration

4. Data Enrichment

True/False:

1. Data Warehouse contains only aggregated data and individual transactions.
2. A dimension is an entity or Subject area, which can group the data.
3. E-R modelling and dimensional modelling are the same.

1.1-F, 2-F, 3-F

2.1-T, 2-T, 3-F

3.1-T, 2-F, 3-T

4.1-F, 2-T, 3-T

Key hierarchies and key performance indicators are ___ kind of metadata.

1. Business metadata

2. None of the above

3. Technical metad ata

4. Operational metadata

True/False:

1. Sorting the data in the given source file is a transformation
2. OLAP tools enable the user to access the data in Data Warehouse in an interactive manner.
3. Data mining is a data-driven approach, not a user-driven approach

1. 1-T, 2-T, 3-T

2.1-T, 2-T, 3-F

3.1-F, 2-F, 3-F

4.1-F, 2-T, 3-T

Which of the following is the white box testing?

1. User accepting testing

2. Unit testing

3. Regression

4. Integration testing

A dimensional table does not contain hierarchies. (True/False)

1.True

2.False

Web house is what kind of network?

1. Client and server only

2. Distributed system

3. Parallel system

4. None of the above

Data Cubes contains ___ and ___.

1. Data, Information

2. Dimensions, Facts

3. Dimensions, Weight

4. Facts, Information

Data Marts are

1. Limited in size

2. Read -only

3. Department level

4. All the above

The advantage of using a data cube is that it allows fast indexing to pre-computed summarized data. (True/False)

1.True

2.False

Web-enabling the Data Warehouse uses the following as the information delivery mechanism,

1. Artificial intelligence

2. None of these

3. Grid computing

4. Web technology

____ and ____ of data take place on a large scale in the data staging area.

1. Sorting, searching

2. Searching, acquisition

3. Sorting, merging

4. Searching, merging

How many levels does CMM have?

1. Two

2. One

3. Five

4. Four

Which of the following analytic tools should be used for extracting the data from the Data Warehouse?

1. SQL

2. All the above

3. OLAP tools

4. Data mining tools

Predictive modelling requires which of the following Data set for initial model creation?

1. All of the above

2. Raw data set

3. Test data set

4. Training data set

RAID stands for

1. Redundant Array of Integrated Disks

2. Redundant Application of Inexpensive Disks

3. Redundant Array of Inexpensive Disks

4. Rapid Application integration and Development

Dimensional model can be implemented with the following databases

1. Relation database

2. Excel data files

3. MDDB

4. Flat files

Which of the following is true for Administrative Metadata?

1. Access rights, audit control, process automation, usage stat istics

2. Protocols, audit controls, source tables, usage statistics

3. Audit control, schema definition, physical location, retention criteria

4. Access rights, protocols, physical location, retention criteria

Dimensional table and a fact table can be connected with the following database keys:

1. Foreign key

2. Candidate key

3. All of the above

4. Surrogate key

The three major Data Staging Components are Data Extraction, Data Transformation and ___.

1. Data Access

2. Data Retrieval

3. Data Loading

4. Data Refresh

UAT means

1. Usage Acceptance Test

2. User Acceptance Test

3. Usage Ambiguity Test

4. User Acquisition Test

In Data Warehouse, a single record link to all the duplicate record in the source systems is called ___.

1. Merging of Information

2. Decoding of fields

3. Summarization

4. De-duplication

Which of the following are th e intermediate servers that stand in between a relational back -end server and client

1.ont end tools?

2. All of the above

3. HOLAP

4. MOLAP

5. ROLAP

The hypercube is the cube with ____dimensions.

1. Four

2. Three

3. Two

4. One

In Data Warehouse, the requirements are gathered subject area wise. (True/False)

1.True

2.False

In the star schema, the dimension table is ___ and the fact table is ___.

1. Wide, Wide

2. Wide, Deep

3. Deep, Deep

4. Deep, Wide

The Data Warehouse does not cater to the Real -time operational requirements of the enterprise. (True/False).

1.True

2.False

Which of the following is an open-source Data mining tool?

1. Enterprise Miner

2. Intelligent Miner

3. Clementine

4. Weka3

Which of the following data mining technique is used for optimization?

1. Artificial Neural Networks

2. If then rule induction

3. Genetic algorithms

4. Decision trees

Which of the following interfaces are used to access the Data Warehouse?

1. Browser

2. Active X applets

3.All the above

4.Search engine

Which of the following is a Source Data Component in Data Warehouse?

1. Sales Data

2. Marketing Data

3. Purchase Data

4. Production Data

Which of the following is an open-source ETL tool?

1. Cognos Decision Stream

2. Microsoft DTS

3. Cover

4. SAS data Integrator

Please enter a valid email address, as we'll send your results to your email address. We will not share your email address with anyone else.

Your email address:

Your name:

Phone:

How did you hear about us?

Clicking Submit means that you agree to the Kamyabi terms, and privacy statement.

Loading...

Ready To Get Started

What’s holding you back from reaching for the stars and realising your true potential? It’s time to take the first step towards Kamyabi – A world of opportunities awaits!

Kamyabi is here to make life easier for employers and employees. Find the right talent or find the right job. We are here to help.

Linkedin Facebook Twitter Instagram Youtube

Take Free Test

Apni Pehchan Index
Personality Test
Information Technology Tests
English Language Tests
Finance Tests
Human Resource Tests
Management Tests

Useful Links

Blog
Jobs
Hiring
Free Resources
Terms and Conditions

Copyright 2023 © Kamyabi Solutions (Pvt) Ltd, All Rights Reserved.

Looking for Talent?

Employers

Looking for Jobs?

Candidates

Looking for projects/gigs?

Freelancers

Looking for freelancers?

Clients