DBW301_P2

In a table, there is only one ............. index. A. Bitmap B. Clustered C. non-clustered D. Tree

B

What is Transformation? A. Data is pulled from multiple sources to be merged into one or more destinations. B. It is used to import text files for ETL processing. C. Process to move data from a source to destination. D. It is used to massage data in transit between the source and destination.

D

What kind of datamining techniques help to find the natural group of objects? A. Classification B. Regression C. Association Rules D. Clustering

D

............. indicator of high-quality data ensures the value stored in the system for a data element is the right value for that occurrence of the data element. A. Accuracy B. Domain Integrity C. Data Type D. Consistency

A

................. means populating all the data warehouse tables for the very first time. A. Initial load B. Incremental load C. Load all D. Load

A

Regarding OLAP, which statement is true? A. An OLAP cube is a technology that stores data in an optimized way to provide a quick response to various types of complex queries by using dimensions and measures. B. Most cubes store dimensional values with its special storage structure to provide quick response to queries. C. An OLAP cube is a technology that stores data in data warehouse. D. None of the others

A

What is Decision Tree? A. It is a unsupervised learning method B. It is a supervised learning method C. It is a machine learning algorithm D. Non of others

B

Which data mining techniques can be applied to predict the value of a feature based on values of other given features? A. Classification B. Regression C. Clustering D. None of others

B

MOLAP refers to ............OLAP. A. Multiple B. Multidimensional C. Many-to-Many D. Mix

B

Online process of the classification contains: A. The training dataset B. Learning algorithm C. Model D. All of others

D

OLAP stands for A. Offline Analytical Processing B. Online Analytical Processing C. Online Analytical Production D. Object Analytical Processing

B

...........means applying ongoing changes as necessary in a periodic manner. A. Incremental load B. Updating load C. Full refresh D. Immediate load

A

BIDS (Business Intelligence Development Studio) provides environment for developing your OLAP Cube and Deploy on SQL Server. A. True B. False

A

Data on salary may be represented as monthly salary, weekly salary, and bimonthly salary in different source payroll systems. What do you call the above problem in ETL? A. Inconsistency B. Consistency C. Diverse D. Multiple-form

A

In any analytical system, time is a critical dimension. A. True B. False

A

SSAS (SQL Server Analysis Services) is Microsoft BI Tool for creating Online Analytical Processing and data mining functionality. A. True B. False

A

The .............model contains the structures and relationships represented in the database schema coded with the data definition language (DDL) of the DBMS. A. Physical B. Logical C. Final D. Star

A

The detailed plan results in the definition of the transformation/conversion rules. A. True B. False

A

Which statement is correct? A. OLAP cube help us reduce the cost (time, CPU usage) of updating the data warehouse database. B. With OLAP cube, we are able to create data mining structure on this data which can be helpful in forecasting, prediction. C. OLAP is an optimized way to design the data warehouse system. D. None of the others.

B

............. indicator of high-quality data ensures value for a data attribute is actually stored as the data type defined for that attribute. A. Accuracy B. Domain Integrity C. Data Type D. Consistency

C

A table may contain some ............. indexes. Select one answer only. A. Bitmap B. Clustered C. non-clustered, bitmap D. non-clustered

C

............. indicator of high-quality data ensures that there are no missing values for a given attribute in the system. A. Accuracy B. Domain Integrity C. Data Type D. Completeness

D

............. indicator of high-quality data ensures the form and content of a data field is the same across multiple source systems. A. Accuracy B. Domain Integrity C. Data Type D. Consistency

D

An OLAP cube is an array of data understood in terms of...... dimensions. A. 3 B. 2 C. 1 D. its 0 or more

D

In data quality, which is (are) the Sources of Data Pollution? (choose one answer only) A. Input Errors B. Incomplete Information at Data Entry C. Internationalization/Localization D. All the others

D

In data quality, which is (are) the Sources of Data Pollution? (choose one answer only) A. System Conversions B. Poor Database Design C. Heterogeneous System Integration D. All the others

D

OLAP systems provide ............. and roll-up capabilities. A. drill-down B. drop-down C. top-down D. up-down

A

ROLAP refers to ............OLAP. A. Relational B. Rapid C. Running D. Roll

A

Use bitmap indexes for attributes with low cardinality. Is it true? A. YES B. NO

A

Using parallel processing technologies (e.g. multithreading), the performance of ETL can be improved. Is it true? A. Yes B. No

A

What should we do before executing ETL? A. Remove indexes in data warehouse database B. Create some non-clustered indexes in data warehouse database C. Do nothing D. None of the others

A

Which is the act of picking a rectangular subset of a cube by choosing a single value for one of its dimensions, creating a new cube with one fewer dimension? A. Slice B. Dice C. Roll-up D. Drill Down/Up

A

Which is the challenge of ETL? A. Source system structures keep changing over time because of new business conditions. B. Source system structures are very different. C. Source systems are hosted in very low performance systems. D. None of the others

A

Which operation allows an analyst to rotate the cube in space to see its various faces? A. Pivot B. Dice C. Roll-up D. Slice

A

Which operation allows the user to navigate among levels of data ranging from the most summarized to the most detailed? A. Drill Down B. Dice C. Roll-up D. Slice

A

Which operation involves summarizing the data along a dimension? A. Roll-up B. Dice C. Slice D. Drill Down

A

Which operation produces a subcube by allowing the analyst to pick specific values of multiple dimensions? A. Dice B. Slice C. Roll-up D. Drill Down/Up

A

Which statement is TRUE? A. A clustered index is a physical concept - it's an index that affects the order in which records are stored on disk. B. We can create some clustered indexes on a table. C. In SQL server, all foreign keys are clustered indexes. D. None of the others.

A

Which statement is correct? A. We have to choose OLAP Cube when performance is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your huge database. B. We have to choose OLAP Cube when storage is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your small database. C. We have to choose OLAP Cube when we do not want to implement ETL. D. None of the others.

A

What are Data access methods? A. Pull Method B. Push and Pull C. Load in Parallel D. Union all

B

IF You are using Classification to build the mobile application for forecasting. What kind of output you should store in your mobile application? A. Everything B. The Training data C. Model D. All of others

C

In which case, indexes can improve the performance? A. Insert data B. Update data C. Read data D. None of the others

C

Indexing in data warehouse database reduces performance of ........ A. Information delivery B. ETL C. Loading data into data warehouse D. OLAP

C

Regarding to Online Analytical Processing (OLAP), which statement is INCORRECT? A. Designed to hold historical data for analyses and forecast business needs B. Data stored in denormalized format C. Used by users who are associated with the decision making process, e.g., Managers, CEO. D. Holds daily Latest Transactional Data related to your application

D

Regarding to data warehouse. Which statement is true? A. All indexes are always specified at the design time. B. All indexes are NOT always specified at the design time. C. All indexes are always specified at the maintenance time. D. Some indexes are specified at the design time, and some others are added at maintenance time.

D

Which are the optimization strategies in data warehouse system? A. Use Index B. Aggregate Table C. Query Optimization D. All the other choices

D

Which is the challenge of ETL? A. Historical data on changes in values are not preserved in source operational systems. B. Difficulties in finding the historical data. C. Historical data mixed with current data. D. None of the others

D

Which is the challenge of ETL? A. Source systems are usually in one platform. B. Source systems are very diverse and disparate. C. Specify all the source systems. D. None of the others

D

Which is(are) the common transformation type(s)? (choose one answer only) A. Decoding of fields B. Conversion of units of measurements C. Character set conversion D. All the others

D

Which statement is TRUE? A. Clustered index uses a huge amount of storage to store indexing data. B. In SQL Server, primary key is clustered index as default. This makes it a very fast index when accessing data, though it may slow down writes if your primary key is not a sequential number. C. Clustered index can increase both read and write operations. D. None of the others.

D