Databases - Upwork

Question: In a star schema, a table which contains data about one of the dimensions is called a:
A
Fact table

B
Meta table

C
Data Dictionary

D
Pivot table

E
Dimension table

Note: Not available
1. Report
Question: Which of the following would not be an application of Data Mining in the banking field?
A
Detect patterns of fraudulent credit card use

B
Ascertaining the number of transactions made in a day

C
Determine credit card spending by customer groups

D
Find hidden correlation between different financial indicators

E
Predict the customers likely to change their credit card affiliation

Note: Not available
1. Report
Question: A Star Schema is a database design that consists of:
A
A fact table

B
Dimension tables

C
Pivot tables

D
A fact and pivot tables

E
A fact table and one or more dimension tables

Note: Not available
1. Report
Question: HOLAP stands for:
A
Hierarchical On-line Analytical Processing

B
Hybrid On-line Analytical Processing

C
Horizontal On-line Analytical Processing

D
Hyper On-line Analytical Processing

E
HyperCube On-line Analytical Processing

Note: Not available
1. Report
Question: A structure that stores multi-dimensional information, having one cell for each possible combination of dimensions is known as:
A
Table

B
Section

C
Partition

D
Cube

E
Repository

Note: Not available
1. Report
Question: Which Data Mining function/technique is used to analyse a collection of records over a period of time?
A
Classification

B
Associations

C
Sequential/Temporal patterns

D
Clustering

E
Segmentation

Note: Not available
1. Report
Question: Which technique of Data Mining involves developing mathematical structures with the ability to learn?
A
Clustering and Segmentation

B
Neural Networks

C
Fuzzy Logic

D
Linear Regression Analysis

E
Rule based Analysis

Note: Not available
1. Report
Question: A datawarehouse should be able to implement advanced query functionality. This means :
A
The RDBMS must provide a complete set of analytic operations including core sequential and statistical operations

B
The RDBMS must not have any architectural limitations

C
The RDBMS server must support hundreds, even thousands, of concurrent users while maintaining acceptable query performance

D
Query performance must not be dependent on the size of the database, but rather on the complexity of the query

E
The warehouse must ensure local consistency, global consistency, and referential integrity

Note: Not available
1. Report
Question: The modification of data as it is moved into the data warehouse is:
A
Data Transformation

B
Replication

C
Synchronization

D
Data migration

E
Normalization

Note: Not available
1. Report
Question: Which of the following statements is incorrect regarding Data Mining?
A
It is the process of turning data into information

B
It is a collection of many techniques

C
It is a replacement for OLAP

D
It is based on machine generated hypothesis

E
It is used in Decision Support, Prediction, Forecasting and Estimation

Note: Not available
1. Report

First Prev 18 19 20 21 22 Next Last

Question: In a star schema, a table which contains data about one of the dimensions is called a:

Question: Which of the following would not be an application of Data Mining in the banking field?

Question: A Star Schema is a database design that consists of:

Question: HOLAP stands for:

Question: A structure that stores multi-dimensional information, having one cell for each possible combination of dimensions is known as:

Question: Which Data Mining function/technique is used to analyse a collection of records over a period of time?

Question: Which technique of Data Mining involves developing mathematical structures with the ability to learn?

Question: A datawarehouse should be able to implement advanced query functionality. This means :

Question: The modification of data as it is moved into the data warehouse is:

Question: Which of the following statements is incorrect regarding Data Mining?