OLAP – Database Questions & Answers
1) A Top level executive in a company needs to understand health of important indicators of the business and needs alerts when thresholds are crossed in one glance. Which of the tool below best meets his need?
a. Operational Reports
b. Dashboard
c. Report with drill features
d. None of the above
2) Which is the most common type of Dimension?
a. Customer
b. Product
c. Location
d. None of the above
3) Which type of data storage architecture gives fastest performance?
a. DOLAP
b. ROLAP
c. MOLAP
d. None of the above
4) Which type of SCD preserves all information?
a. SCD Type II
b. SCD Type III
c. New SCD
d. None of the above
5) Database explosion was a common problem for?
a. Oracle RDBMS
b. DB2 RDBMS
c. DOLAP
d. None of the above
6) What of the following constitute a Business Intelligence?
a. ABC
b. PM
c. Reporting
d. All of the above
7) Which of the following data storage architecture is not server based?
a. MOLAP
b. ROLAP
c. RDBMS
d. DOLAP
8) Which of the following BI Governance models will help in reducing development costs?
a. BI Competency Center
b. BI Solution center
c. All of the above
d. None of the above
9) OLAP technology is not well suited for?
a. Trends
b. Monitor KPI
c. Analyzing anomaly
d. Behavior patterns
10) Most important aspect of Single Sign-On (SSO) is
a. User-id and password is always required
b. Secures all BI Data automatically
c. Authorization feature of the BI Tool is used
d. None of the above
11) The least important aspect of BI Security is
a. Authentication of authorized user
b. Authorization to use certain features of BI Tool
c. Allow access to relevant data only
d. Encrypt data sent to and received from database
12) BI audit is performed to
a. Force users to use BI Tool
b. Understand usage of BI
c. Charge user’s cost center for usage
d. All of the above
13) Which is the most robust method to secure data accessed by BI Tools?
a. Apply security at database level
b. Apply security on semantic layer
c. Apply security at report level
d. None of the above
14) Which is the least convenient method to secure data at row level for a user?
a. Secure data using database
b. Secure data using semantic layer
c. Secure data using LDAP
d. None of the above
15) Which of the following statement describes “Closed loop BI”?
a. A BI Report connecting to another Report and so on
b. A Dashboard KPI drilling down to a detailed report
c. A Dashboard KPI performing What-if analysis and able to drill down to granular level
d. None of the above
16) Which is the cheapest method from below options to achieve ‘High Availability’?
a. BI system has enough power backup
b. Use of third party clustering hardware
c. Use built-in clustering features
d. Use Operating system based clustering
17) Which feature in a BI architecture speeds up report retrieval?
a. Well designed & tuned database server
b. BI server’s cache service
c. Ultra-fast network
d. None of the above
18) Which statement determines most successful implementation of BI?
a. Integrated Data from all source systems in an EDW
b. User relies on the BI to make decisions
c. Every BI request has sub-second response
d. All of the above
19) Which component is mandatory in a typical BI server architecture?
1) Web server
2) Cache server
3) Authentication server
a. 1),2)
b. 1),2),3)
c. 1), 3)
d. None of the above
20) Which is the most important factor that determines a MOLAP database size?
a. Aggregation levels
b. Number of dimensions
c. Number of Facts
d. Number of rows extracted from source systems
21) Which architecture is most suitable for Real-time BI?
a. BI Frontend connecting to a DW fed by ODS
b. BI Frontend connecting to ODS with real-time data feeds
c. BI Frontend connecting to source system
d. None of the above
22) How can you make a BI Server architecture “Fault Tolerant”?
a. By configuring multiple instances of components
b. All components of BI Server run on single server
c. By having a BI Server SOA compliant
d. All of the above
23) Which is the best method to scale up a BI architecture?
a. Vertical scale up
b. Utilize latest BI Tool in market
c. Horizontal scale up
d. None of the above
24) Which one of the following is a key consideration for a BI architecture?
a. Data Architecture
b. Technical Architecture
c. Product architecture
d. All of the above
25) What is an optimum strategy for metadata for a large BI initiative involving multiple BI tools
a. Build an interface to view BI tool provided metadata
b. Integrate tool provided metadata to a central repository and build an UI
c. Buy a COTS solution instead of building it in-house
d. All of the above
26) Which of the following falls under the category of unstructured data mining
a. Tree mining
b. database mining
c. Text mining
d. Graph mining
27) Predictive analysis model cannot be used for
a. Cross-sell
b. Direct marketing
c. Customer retention
d. None of the above
28) Which one of the following is used as a data access middleware?
a. JDBC
b. MDX
c. ODBC
d. All of the above
29) Analytics application does not include the following model:
a. Predictive
b. Statistical
c. Descriptive
d. In-line
30) Which one of the following does not directly aid in performance improvement?
a. Index
b. aggregate aware
c. Normalization
d. Hint
31) Which of the following reporting framework consideration will not aid in enforcing enterprise wide reporting standardization
a. Run time formatting
b. Inheritance from library components
c. Report template
d. None of the above
32) Which Solution will you suggest to get the enterprise level net income, expense, gross profit for the quarter and year
a. BI Solution
b. OLTP Solution
c. Account Books
d. CRM Solution
33) What are the different approaches you will suggest for taking maximum advantages of only Relational Data
a. HOLAP
b. DOLAP
c. ROLAP
d. a and b
34) A power user wants to see the monthly sales figures of a product. The data structure stores data in ‘daily’ granular level. The least practical option for building monthly aggregate is
a. MOLAP server
b. Semantic layer
c. RDBMS
d. Reporting variable
35) A rollup operation can not be achieved by
a. climbing up the concept hierarchy
b. Dimension reduction
c. Introducing new dimension
d. All of the above
36) The real time needs of BI architecture can be achieved through
a. BAM tools
b. EAI tools
c. ETL tools with real time capability
d. All of the above
37) A CPM solution is implemented with an aim to
a. greater visibility into business
b. better execution of strategy
c. faster reaction to events
d. All of the above
38) A dashboard implementation at the least must have the following application as a building bock
a. A monitoring application
b. An analysis and reporting application
c. A management application
d. All of the above
39) A prime component of a management application is
a. Strategy maps
b. workflows
c. Annotations
d. All of the above
40) A manager wants to analyze the real time performance of his field forces. He should consider implementing
a. Strategic dashboard
b. Operational dashboard
c. Tactical Dashboard
d. All of the above
41) A corporate wants to monitor the execution of corporate objectives at each level of the organization. The following dashboard solution can cater to this need
a. Tactical Dashboard
b. Strategic dashboard
c. Operational dashboard
d. Informational dashboard
42) A Key performance indicator (KPI) is
a. A metric
b. A metric with a target
c. A metric with the result realized
d. A metric with an alert
43) To build a customer centric BI implementation, an architect should not rely on
a. Customer identifiers (primary keys) for customer data integration
b. Fuzzy matching logic with algorithms to identify similar records
c. Merge rules to identify which data will be integrated from which source
d. All of the above
44) A report is created with a set of objects and consists of data for different countries where not all objects can be seen by all counties users and can only see data for there own country. What type of security has been implemented in this?
a. Row and Group Level Security
b. Column and User Level Security
c. Row and Column Level Security
d. User and Group Level Security
45) Mike Straut is a middle level manager in Actual Graphics and is responsible for managing the St. Louis branch. He logs into the Dashboard and sees information for his branch performance for last 6 months checks the attendance record for his employees and
a. Strategic Dashboard
b. Tactical Dashboard
c. Operational Dashboard
d. Status Tracker Dashboard
46) Adhoc Report are :
a. Canned Reports
b. Scheduled Report
c. Corporate Reports
d. None
47) Cascading prompt based report is better defined as?
a. A Drill Thru Report
b. Report extracted by getting the data by clicking the column data
c. Works based on pre-defined conditions
d. Works based on the data item selected as a drill thru options
48) William receives a new requirement from the client for a set of reports. The report fields contain Regions, Product, Sub Products, Months, Target and Actuals. Each row should display target and Actual data for each region for each month by each Product an
a. Section Report
b. Master Detail Report
c. Slice and Dice Report
d. Both A and D
49) What is the most preferred schema type for best performance of a reporting tool?
a. Snowflake schema
b. Normalized Schema
c. Star Schema
d. All of the above
50) A new reporting project has come up for Vsoft Company. The client is more concerned about quality and is not very cost concerned. The requirements clearly specify that the customer is quality and process oriented. In one of the clauses the document also s
a. a, and c
b. a and b
c. b and c
d. a,b,c,d and e
51) Which of the following is a must dimension for producing Dashboard reports and widgets?
a. Location
b. Product
c. Time
d. a and b
52) Guided decision is a associated to
a. Discovery and Applications
b. Analytics
c. Performance Management
d. Reporting
53) Following are part of Analytics
a. Operations DSS
b. Time series
c. Predictive Analytics
d. All of above
54) If Ci is the cardinality of dimension i
then the cube will have size (C1+1)·(C2+1) ··· (Cn+1)
a. True
b. FALSE
55) How is ‘Group by’ computed
a. Nested Loop
b. Sorting
c. Hashing
d. All of above
56) Each ARC in multidimensional data structure represents
a. link to Fact
b. Integrity constraint
c. Parent Child relationship
d. None of the above
57) What will be considered for optimization of Cube
a. Smallest Parents
b. Cache Results
c. Share Partitions
d. All of above
58) Which are valid techniques for visualizing OLAP data
a) Geometric
b) Iconbased
c) Hierarchical
d) All above
a. a) and b)
b. a) and c)
c. b) and c)
d. d)
59) An “umbrella” dimension uniting heterogeneous
members from multiple relations in a single superclass, is called
a. Multiple hierarchy
b. Composite Hierarchy
c. Mixed-level Hierarchy
d. Single Hierarchy
60) Text Analytics is rightly defined as
a. a process of analyzing text and identify the trend
b. a process of searching known fact from structured data pool
c. a process of parsing text and extracting facts about key entities
d. None of the above
61) Which one is the most possible source of unstructured data
a. Email
b. XML File
c. Flat files
d. None of the above
62) What are the following considered as configurable items in BI projects
a) Data Model
b) Analysis report structure
c) Meta data
d) All of the above
a. b)
b. a) and c)
c. b) and c)
d. All of above
63) BAM is associated with
a. Decision making
b. Real time summary of business process
c. Complex analysis (such as predictive and historical)
d. All of above
64) Which are correct for Open Source BI –
a) lack of formal training
b) stable
c) no long term roadmap
d) all above
a. a) and b)
b. a) and c)
c. d)
d. a),b) and c)
65) A company has deployed a BI system. It needs to integrate it with their existing system and also have a common user name for logging into both the existing system and the new BI system. What is the best way to achieve this?
a. Provide same user names to both the systems
b. Provide a common group user id to every one so that they all use the same is to login
c. Remove authentication system from th BI application
d. Use Single Sign ON capability of a BI system to implant one time login and authentication
66) Analysis of records according to some future behavior corresponds to
a. Clustering
b. Classification
c. Prediction
d. Profiling
67) Segmenting of heterogeneous population into number of homogeneous subgroups corresponds to
a. Classification
b. Clustering
c. Profiling
d. None of the above
68) Decision tree corresponds to
a. Profiling
b. Classification
c. Prediction
d. Clustering
69) Tax on a product depends on both product category and state. It can be represented by
a. Cross dimension attribute
b. Descriptive attributes
c. Convergence
d. None of the above
70) If two dimension attributes in a hierarchy are connected by 2 or more alternative paths, this is called
a. shared hierarchy
b. ragged hierarchy
c. Convergence
d. None of the above
71) A hierarchy where, for some instances, value of one or two incidents are missing, is called
a. Unbalanced hierarchy
b. ragged hierarchy
c. Shared hierarchy
d. None of the above
72) Ragged hierarchy will result in to a summarizability problem
a. Yes
b. No
73) Monthly revenue is a _____________ type measure
a. Stock
b. Flow
c. Unit
d. None of the above
74) Which of these statements is not TRUE?
a. Inmon’s view : Each Star is a data mart
b.
c. Kimball’s view : Detailed view in Star formats
d. Kimball’s view : Summary view in Star formats
e. Inmon’s view : DW is sum total of all Data marts
75) Which of these is not components of Warehouse Databases?
a. Source DB
b. ROLAP Engine
c. Central Warehouse
d. MultiDimensional DB
76) Overwrite, Partition history and organizational changes are examples of
a. Rapidly changing dimensions
b. OLTP transactions
c. Slowly changing dimensions
d. Slow Changing Facts
77) 1. Attributes are characteristics and properties of entities
2. Use of ER modeling technique assists the basic allure of DWH in high -performance retrieval of data
3. Dimensional model is concerned with concurrency & locking
4. In snowflake schema each d
a. 1 only
b. 1 & 4 only
c. 1, 2 & 3 only
d. All
78) Which of these statements about aggregates is/are TRUE
a. Aggregates should be stored in FACT tables
b. Pre-Stored summaries in DB
c. Decrease performance in a query
d. All of the above
79) ______ can exploit patterns & relationships to produce predictive & descriptive models
a. Data Profiling
b. Data Warehousing
c. Data mining
d. Data Integration
80) Find the odd one out
a. Clustering
b. Classification
c. Regression
d. Time-series
81) Forecasting future trends by considering seasonality and holidays is best done by
a. Regression
b. Association
c. Classification
d. Time-series
82) _______ is a way of representing series of rules
a. Neural Networks
b. K Nearest neighbor
c. Decision Trees
d. Rule Induction
83) What is the Unit of code measure in Datawarehousing
a. DWP
b. DWU
c. DFP
d. LOC
84) BI application can assign and track events or tasks allotted to specific users, based on predefined business rules. This corresponds to
a. Workflow
b. Collaboration
c. Association
d. None of the above
85) OLAP Reporting provides this feature
a. Multidimensional viewing Capabilities
b. Calculation Intensive Capabilities
c. Time Intelligence
d. All of the above
86) Data, Pre-aggregated data, pre-calculated data is stored is which one of the following architectures
a. MOLAP
b. ROLAP
c. HOLAP
d. Both A & C
87) In data mining, this is a technique used to predict future behavior and anticipate the consequences of change.
a. What -if analysis
b. Predictive Modeling
c. Phase Change
d. None of the above
88) One of the ways to handle reporting on very large data warehouses is
a. Right mix of resources skills in the development team
b. Tuning query processing by using Aggregated tables, Partitions and Virtual Dimensions
c. Strategy to support global spread of the Business Users
d. All of the above
89) If a BI application is being used by global spread of users then
a. Support team should include resources with multi-lingual skills
b. User support shifts should cover all time zones
c. Strategy for report refresh should ensure that users in any time zone do not get affected
d. All of the above
90) Decision to go for build option vis-a-vis buy option when
a. Time is a constraint
b. Requirements are unique
c. Lack of IT skills required
d. None of the above
91) A Key Performance Indicator is
a. A business metric used to evaluate factors that are crucial to the success of an organization
b. Another name for a executive dashboard
c. Has nothing to do with how the organization is performing.
d. A measurement level of knowledge management of the organization
92) Decision of tool selection for BI should be based on
a. Requirements, Cost
b. Proof-of-Concept, Vendor support
c. Ease of use, Architecture complexity
d. All of the above
93) In a hierarchical dimension (Product), there are 12 input members and 8 derived members, then the inflation factor is
a. 1.5
b. 3
c. 1.67
d. 0.67
94) Inflation factor for a hierarchical dimensional model equals
a. ratio of total members to input members
b. average ratio of total members to input members raised to the power of number of dimension
c. average ratio of derived members to input members raised to the power of number of dimension
d. ratio of total members to derived members
95) Sparsity in a cube cane be contributed by ..
1) Missing values
2) inapplicable values
3) Zero values
a. 1), 2)
b. 1), 3)
c. 3)
d. all of them
96) In case of any interactive analysis such as ‘what-if analysis, which approach is more suitable
a. Disk Based model processing
b. Memory based model processing
c. Compressed data environment
d. Mutiuser database architecture
97) What is true about a virtual memory
a. It is not a part of ‘on-line memory subsystems’
b. It is slower than file storage
c. is responsible for transparently copying data between the disk and main memory
d. All of the above
98) Cache is faster than Virtual memory
a. True
b. FALSE
99) Hashing is
a. good for Read and not good for write
b. good for dynamic sparsity
c. good for data compression
d. good for small number of dimension
100) You have been assigned to an engagement as a lead from solution provider of OLAP solution. Which question will not be typically asked to understand the problem of the current solution?
a. Are you facing any inconsistency of data
b. Can end user generates reports without too much IT support
c. Is there any Ad-hoc computations performed on server?
d. Is there too many redundant reports across organization
101) A high level architecture document consists of
a. downstream file transfer process
b. mapping between source and target
c. use case scenario
d. None of the above
102) In a scenario where product and product category are having many to many relationship, then which design approach will be preferred
a. Disconnected hierarchies
b. Multiple levels in a dimension
c. Separate dimensions
d. Links
103) table data region
a. report item on a report layout that displays data in a columnar format
b. data value derived on Integrating 2 tables or views
104) Which of the following statement describes a Closed loop BI?
a. A BI Report connecting to another Report and so on
b. A Dashboard KPI drilling down to a detailed report
c. A Dashboard KPI performing What-if analysis and able to drill down to granular level
d. None of the above
105) Enable _____________ For High Frequency Searches
a. Partitioned Indexes
b. Bitmap Indexes
c. Hash Index
d. Join Index
106) In order to avoid database explosions, the sparsity of individual data objects is reduced by –
a. Good application design
b. Using a multi-cube approach
c. Using a hypercube approach
d. Both A and B
107) Second level data mart
a. Data mart that combine business measurements
b. from multiple business processes
c. A data mart that is derived from a single primary
d. source system
e. Data mart derived from another data mart
108) data explosion consequence (select the best)
A) Large costs to build and maintain monolithic models
B) Load and or calculation times that take hours rather than seconds or minutes
C) Expensive hardware
D) faster drill down and roll-up
a. A),B),D)
b. B),C),D)
c. A),B),C)
d. All the options
109) balanced hierarchy
a. A dimension hierarchy in which all leaf nodes are the same distance from the root node.
b. The building block of dimensions and their hierarchies that corresponds to a single column
110) Term ‘Sementic Model’ referred as (Select the best ans)
a. business representation layer
b. collection of automic sources
c. OLAP sources
d. All of the above
111) Critical design time issues of Cubes involves
a. Storage Mode and Aggregation
b. Datamart size and table partition
c. query performance & tuning
d. dimensions and hierarchies
112) In Zachman framework, ‘System Model’ corresponds to
A) Logical Models
B) Business process model
C) Requirement Definition
D) Solution definition and development
a. B), D)
b. A),B),C)
c. A),B)
d. A),C)
113) Read the following scenario..
You are in an English pub and you buy a drink and don’t buy any meal, you are more likely to buy crisps (US. chips) at the same time than somebody who didn’t buy drink. This is an incident where you buy a certain group of ite
a. Stochastic Modeling Techniques
b. Market Basket analysis
c. Predictive Analytics
d. None of the above
114) Which analysis is/are associated to Market Basket Analysis
a. Analysis of telecom service purchases
b. Identification of fraudulent medical insurance claims
c. Analysis of telephone calling patterns
d. All of above
115) A telecom service provider identified during last few quarters customer churning rates have been raised. Is it because of poor product quality or lack of success in customer services. They would like to have a BI solution for identifying such issues. Whic
a. Analytical BI
b. Operational BI
c. Strategic BI
d. None of the above
116) Which statement is/are correct for Operational BI
A) This provides an insight why certain event occurs
B) helps decision-making that happens at the lower levels of an organization
C) supports critical business processes through their integration of realti
a. A),B),C)
b. B),D)
c. B),C),D)
d. A),D)
117) Fact table covered with too many dimension is refer to as
a. Coverage fact
b. Factless fact
c. Centipede fact
d. none of the above
118) Low cardinality in a relational table means
a. It refers to a limited number of values, relative to the
b. overall number of rows in the table
c. It refers to a large number of values, relative to the
d. overall number of rows in the table
e. none of the above
119) The OLAP should present the user with a single logical schema of the data’ – this statement is valid for which category of Cod Rule?
a. Transparency
b. Flexible reporting
c. Accessibility
d. Dynamic sparse-matrix handling
120) You have a Static P&L (Profit and Loss) Report for the Company Executives. The ETL load typically finishes around 4.00 AM daily . The Report SLS is set at 30 seconds . As a consultant and team lead you have to design the optimal strategy what would you ch
a. Push the Report Via email
b. Print the Report and make it available before they reach work
c. Data Aggregation and Report Caching
d. Solution not Possible
121) Single Sign (SSO) is primarily
a. Using Windows NT for User Authentication
b. Using Active Directory for user Authentication
c. Integrating the user credentials across all applications
d. Use the BI Server to authenticate Users
122) It is advisable to create Bitmap index on
a. Column value with low cardinality
b. Column value with high cardinality
123) Which comment is valid for Decision Trees
a. Useful for data exploration, classification and scoring
b. It automatically generates association rules
c. It is based on Graph theory
d. Logic depends on genome
124) What are the valid metadata information
A) Date when data got loaded
B) When code moves to QA environment
C) Indication how recently data has been updated
D) value legally allowed to a field
a. A),B),C)
b. A),C),D)
c. A),B),D)
d. B),C),D)
125) The best suitable OLAP for complex analysis is
a. ROLAP
b. MOLAP
c. DOLAP
d. None of the Above
126) OLAP Stands for
a. Order Line Analytical Process
b. Online Arithmetic Progression
c. Online Analytical Processing
d. None of the Above
127) The concept to show an aggregated view of charts and reports (information at glance) is
a. Trends Analysis
b. Dash Boards
c. Predictive Analysis
d. None of the Above
128) Query Performance w.r.t Business Intelligence is better when the model is
a. Star Schema Dimensional Model
b. Snow Flake Schema Dimensional Model
c. 3NF Relational Model
d. None of the Above
129) Data Mining is “Slicing & Dicing” of data to get good insight of data at a more granular level
a. TRUE
b. False
130) Multi Dimensional Analysis is “Slicing & Dicing” of data to get good insight of data at a more granular level
a. True
b. FALSE
131) The BI concept which helps to analyze the data factors correlate one another is
a. Data Analysis
b. Data Mining
c. Forecasting
d. Trend Analysis
132) Bitmap Index is the most efficient index applied on Data Warehouse for better analytics performance
a. True
b. FALSE
133) The aggregation or calculated value goes into the
a. Fact Table
b. Dimension Table
c. Lookup Table
d. None of the Above
134) Dimensional Model constitute of
a. Fact Tables
b. Dimension Tables
c. Lookup Tables
d. All of the above
135) The key requirement to start designing a DataMart Data Model is
a. Report Layouts
b. Source Systems
c. Business Transformations
d. None of the Above
136) The history for a particular record can be traced within a Data Warehouse if we adapt
a. Type 1 Slowly Changing Dimension
b. Type 2 Slowly Changing Dimension
c. Type 3 Slowly Changing Dimesion
d. None of the Above
137) 1) Conceptual Modeling
2) Physical Modeling
3) Logical Modeling
The sequence for Data Modeling is
a. 1,2,3
b. 3,2,1
c. 2,1,3
d. 1,3,2
138) 1) Define Entity Names
2) Define Entity Relations
3) Define Attributes
4) Define Pri Keys
5) Define Foreign Keys
6) Define Table Names
7) Define Column Names
8) Define Column Data Types
Features defined during of Logical Data Model is
a. 1,2,4,7,8
b. 1,2,4,5,6
c. 1,2,3,4,5
d. 1,3,5,7,8
139) Non Addictive Facts are facts that cannot be summed up for any of the dimensions present in the fact table
a. True
b. FALSE
140) What type of data OLTP contains ?
a. Transaction data
b. Historical data
c. Aggrigated data
d. All the above
141) What are the types of OLAP
a. MOLAP
b. ROLAP
c. DOLAP
d. All of the above
142) Which has Two dimensional data ?
a. MOLAP
b. ans)ROLAP
c. DOLAP
d. All of the above
143) Which type of storage architecture gives faster performance ?
a. MOLAP
b. ROLAP
c. DOLAP
d. All of the above
144) What are the Key Objectives With in OLAP ?
a. Dimensions
b. Measures
c. a and b
d. None of the above
145) Different Types of Measures are ?
a. Additive
b. Semi Additive
c. Non Additive
d. All the above
146) Operational data store is used to hold ——— ?
a. Detailed data
b. Aggregate data
c. Reporting data
d. None of the above
147) Give any one example of reporting tool for MOLAP ?
a. Business Object
b. Hyperion
c. Cognos
d. None of the above
148) OLAP Technology is not well suited for ?
a. Trends
b. Monitor KPI
c. analyzing anomalies
d. Behavior patterns
149) Which data Modeling Approach is suitable for OLTP?
a. ER Modeling
b. Dimensional Modeling
c. Snowflake Modeling
d. None of the above
150) What are the Key Components in Dimensions?
a. Hierarchies
b. Levels
c. Attributes
d. All the above
151) Which OLAP is used to create Multidimensional Cubes?
a. MOLAP
b. ROLAP
c. DOLAP
d. All of the above
152) Which type of SCD preserves all information?
a. SCD II
b. SCD III
c. NEW SCD
d. None of the above
154) What is the difference between Star schema and Normalized schema?
a. Both are same
b. Star schema has less data than Normalized schema
c. Star schema is not normalized
d. All of the above
155) why surrogate key is used?
a. To track type 2 slowly changing dimensions
b. To be primary key for fact table
c. For faster query performance in data mart
d. All of the above
156) Which is most important factor that determines a MOLAP data base size?
a. Aggregation Level
b. Number of Dimensions
c. Number of Fact
d. All of the above
157) Which Solution is used for BI?
a. OLTP
b. Data Mining
c. OLAP
d. None
158) OLAP provides
a. Analysis with respective to time
b. Adhoc queries
c. Slice and Dice
d. All of the above
159) In OLAP System data is refreshed when
a. User Changes the data
b. Periodic jobs are run to refresh the data
c. Data is changed through data entry screen
d. All of the above
160) Drill across refers to
a. Querying multiple fact tables and combining results into a single data set
b. Querying multiple hierarchies and combining results into single data set
c. Data analysis across multiple dimensions
d. None of the above
161) Bridge table is user for
a. Confirmed dimension
b. Multi valued dimension
c. Degenerate dimension
d. None of the above
162) Which of the dimension belongs to Fastly Changing dimension
a. Product Dimension
b. Customer Dimension
c. Time Dimension
d. None of the above
163) Choose the best option to use bitmap index
a. Employee name
b. Employee ID
c. Employee Joining date
d. None of the above
164) “A student tracking system that detects each student attendance event each day.”, What type of table is it
a. Fact less facts
b. Additive facts
c. Casual Dimension
d. Coverage Tables
165) Acronym for KPI ?
a. Key Performance Indicators
b. Key Performance Index
c. Both
d. None of the above
166) Can we normalize a fact tables ?
a. Yes
b. No
167) What is a junk dimension
a. A junk dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension. Simply to say a randomly used dimension is junk dimension
b. Junk dimension is a Cartesian product of dimensions which have very low cardinality.
c. A and B
d. None of the above
168) Type 2 SCD Stands for
a. Overwriting the existing record
b. Creating a new dimension record
c. Creating a current value field
d. None of the above
169) Define the table name used to implement many to many relationship
a. Bridge table
b. Hierarchies
c. Both
d. None of the above
170) Whats most important char of OLAP
a. time variant
b. non volatile
c. integrated
d. All of the above
171) In DWH , generally data setup will be in which form?
a. 3NF
b. BCNF
c. Normalized
d. Denormalized
172) __ Is the Numerical property of a fact which describes quantitative aspects for analysis.
a. FACT
b. Measure
c. Dimension
d. All of the above
173) This operation limits analysis to subset of an attribute
a. Drill down
b. Dice
c. Slice
d. Drill Through
174) MDDB technology is proprietary to which OLAP Architecture ?
a. ROLAP
b. MOLAP
c. DOLAP
d. All of the above
175) ROLAP Architecture is Non Intuitive ?
a. True
b. FALSE
176) When it is best to pre-calculate data in any OLAP architecture ?
a. Data that is Slow to calculate at run-time, because it depends on many other cells or complex formulae or
b. Data that is frequently viewed
c. Data that is the basis of many other calculations
d. All of the Above
177) To efficiently handle high frequency searching operation in OLAP application
what is used ?
a. Binary Index
b. Bitmap Index
c. Secondary Index
d. None of the above
178) What are the prerequisites for OLAP Administration ?
a. Data management
b. Application management
c. Metadata management
d. All of the Above
179) What is the disadvantage of HOLAP architecture from the below options ?
a. Integration with data maintained in RDBMS
b. Support for large volumes of data by Relational Mappings
c. Complex Architecture
d. None of the Above
180) Which is a 3- tiered Architecture from the following ?
a. MOLAP
b. ROLAP
c. None of the above
d. Both (a) and (b)
181) Property of fact across which its analysis co-ordinates are defined is called ?
a. Dimension
b. Fact
c. Measure
d. None
182) DWH generally contains data in which of the following form ?
a. Star Schema
b. Snowflake
c. None of the above
d. Both (a) and (b)
183) Removing Partial dependency is step to which normal form ?
a. 1st NF
b. 2nd NF
c. 3rd NF
d. BCNF
184) which of the following is not the schema for data warehouse
a. a) 3 NF
b. Star Schema
c. Snowflake
d. None of the above
185) Summary tables is data warehouse is called as ______________________-
a. Aggregate tables
b. Factless fact Table
c. Both
d. None of the above
186) How do you join 2 fact tables______________-
a. Confirmed Dimension
b. Degenerated Dimension
c. Junk Dimension
d. None of the above
187) Which of the following is not a data modeling practice
a. Conceptual data model
b. Logical data model
c. Dimensional Data model
d. Physical data model
188) How to select distinct values without using SQL distinct statements
a. ORDER BY
b. UNIQUE FUNCTION
c. MINUS OPERATOR
d. GROUP BY
189) OLAP is an acronym for
a. Online Analytical Processing
b. Online Analysis Process
c. Online Arithmetic Processing
d. Object Linking and Processing
190) Multidimensional data can be queried and manipulated using
a. T-SQL
b. MDX
c. MDAC
d. OWC
191) Different Storage Modes used for storage of cubes are
a. MOLAP
b. ROLAP
c. HOLAP
d. All the above
192) Which of the following is false
a. A private dimension is a dimension created for an individual cube
b. A shared dimension is a dimension that can be used by multiple cubes
c. A virtual dimension is a logical dimension based on the columns from a physical dimension
d. The storage mode of a virtual dimension can be MOLAP, ROLAP or HOLAP
193) Which of the following is TRUE for Cube Storage Mode
a. MOLAP copies all of the data and all the aggregates to the analysis server in an optimized multidimensional format
b. ROLAP leaves the original data in the relational tables and uses separate set of relational tables to store the aggregates
c. In HOLAP, data remains in the relational tables, but aggregations are stored on the server in optimized multidimensional format
d. All the above
194) The following Storage Mode gives the best Query Performance
a. MOLAP
b. ROLAP
c. HOLAP
d. DOLAP
195) Which of the following is false for Cubes
a. Cubes are multi-dimensional data representation
b. Cubes replicate data in the dimension and fact tables
c. Cubes do not require updating when the data warehouse data is updated
d. Cubes provide an easy-to-use mechanism for querying data with quick and uniform response times
196) The methods of processing the cubes
a. Incremental Update
b. Refresh Data
c. Process (Rebuild) Data
d. All the Above
197) Which of the following is false
a. Cube contains one or more Partitions
b. Virtual Cubes retrieve information across multiple cubes
c. Every Partition in a Cube should have the same storage mode
d. All the above
198) The following is the characteristic(s) of Aggregations
a. Aggregations are precalculated summaries of data
b. Aggregations are stored in the multidimensional structure in cells at coordinates specified by the dimensions
c. Results in the fastest possible response time
d. All the above
199) The Data Analysis Tools that can be used to analyze data that is stored in data warehouse
a. OLAP Manager
b. Microsoft Excel 2000
c. Microsoft English Query
d. All the above
200) Which of the following method is used to view the data at different levels of granularity
a. Drill Down
b. Drill Up
c. Drill Through
d. All the above
201) Drill Across generally uses the following join to generate report
a. Self Join
b. Inner Join
c. Outer Join
202) What is the primary purpose of having multi-dimensional data models
a. To deliver structured information that the business user can easily navigate by using any possible combination of Business terms to show the KPIs
b. To make it easier for Developers to build applications, that will be helpful for the Business users
c. To make it easier to store data in the database
d. All of the above
203) This method of online analytical processing stores data in both a relational and a multidimensional database
a. ROLAP
b. HOLAP
c. OLAP
d. DIMM
204) What are the three primary build methods for building dimensions
a. Generation references
b. Level references
c. Parent-Child references
d. All of the above
205) What is UDA
a. UDA represents the class of the members
b. UDA is another name for the members
c. UDA is member of attribute dimension
d. None of the above
206) How does Attribute dimension impact report performance
a. They negatively impact the report performance
b. They improve the report performance
c. They don’t impact report performance
d. They have nothing to do with reports
207) What is true about Dynamic calc
a. Dynamic calc decreases the retrieval time and increases batch database calculation time
b. Dynamic calc increases the retrieval time and decreases batch database calculation time
c. Dynamic calc increases the retrieval time and increases batch database calculation time
d. Dynamic calc decreases the retrieval time and decreases batch database calculation time
208) What are the actual data values that occupy the cells as defined by the dimensions selected
a. Nesting
b. Aggregation
c. Dimensions
d. Measures
209) The term that defines filtering data in an OLAP cube is ___________.
a. Dicing
b. Slicing
c. Rotating
d. Nesting
210) What is an item that matches a specific description or classification
a. Category
b. Measure
c. Dimensions
d. Nest
211) The cube structure in OLAP achieves the __________ functionality
a. Shared
b. Information
c. Collection
d. Multidimensional
212) Aggregation provides OLAP with __________
a. Multidimensional data
b. Pre-calculated data
c. Nested Data
d. Slow Data Retrieval
213) What is the acronym that defines OLAP
a. FHTMI
b. FASMI
c. ASFMI
d. MASHF
214) __________ in OLAP allows you to define a subcube of the original space
a. Dicing
b. Slicing
c. Rotating
d. Nesting
215) When you nest in OLAP, you _________
a. select multiple cube aggregations
b. select multiple cube measures
c. select multiple cube dimensions
d. select multiple cube slices
216) The _________ in OLAP enable you to drill-up or drill-down to view different levels of detail about your data
a. Dimensions
b. Measures
c. Nesting
d. Aggregation
217) Which of the following is not an OLAP operation:
a. drill along
b. drill across
c. drill down
d. drill through
218) A data warehouse bus matrix helps to:
a. integrate data marts
b. improve speed of retrieval from the database
c. index OLAP data
d. generate aggregated information
219) In multi-dimensional analysis, roll-up can be achieved by:
a. moving up a dimension hierarchy like city -> state, etc.
b. moving down a dimension hierarchy like state -> city, etc
c. adding a new dimension
d. removing one or more dimensions
220) In a star schema, usually
a. the fact table is normalized
b. the dimension tables are normalized
c. the fact table is denormalized
d. the dimension tables are denormalized
221) What of the following is correct ?
a. A data cube stores data in a summarized version which helps in a faster analysis of data
b. A data cube stores data in a detailed version which helps in a faster analysis of data
c. In cube, the data is stored in such a way that it allows reporting easily
d. A & C
222) Fact Tables contains :
a. Details
b. Measures
c. Summary
d. None of the above
223) Database roles can be :
a. Fixed
b. Flexible
c. A & B
d. None of the above
224) Capabilities of OLAP.
a. performs analysis of business data and provides the ability to perform complex calculations on usually low volumes of data.
b. helps the user gain an insight on the data coming from different sources (multi dimensional).
c. helps analysts getting a detailed insight of data which helps them for a better decision making.
d. All the above
225) Which of the following are correct?
a. MOLAP requires the data to be computed before hand.
b. MOLAP does not require the data to be computed beforehand
c. The data in MOLAP is stored in a single dimensional array.
d. None of the above
226) Which of the following are correct?
a. ROLAP require the data to be computed beforehand
b. ROLAP does not require the data to be computed beforehand
c. ROLAP does not have access to relational database
d. B & C
227) Explain the role of bitmap indexes to solve aggregation problems.
a. Bitmap indexes are useful in connecting smaller databases to larger databases.
b. Bit map indexes can be very useful in performing repetitive indexes
c. Multiple Bitmap indexes can be used to compute conditions on a single table.
d. All the above
228) What is Binning?
a. hold multiple values in one bin in bitmap index
b. hold single value in one bin for unique index
c. helps in increasing index encoding machanisim
d. None of the above
229) What is candidate check?
a. Check the base data in bitmap index process
b. Check the base data in unique index process
c. A & B
d. None of the above
230) Explain the Dashboard in the business intelligence.
a. Single graphical interface
b. measures seen at a glance
c. analyze root cause of any business performance
d. All the above
231) SAS Business Intelligence is capable of.
a. Statistics
b. Data Mining
c. Forecasting
d. All the above
232) What is slicing and dicing in business objects?
a. allows changing the position of data by interchanging rows and columns
b. used to rotate the cube to view it from different perspective
c. A & B
d. None of the above
233) What is the security level used in BO?
a. Row level
b. Column level
c. A & B
d. None of the above
234) Explain about multidimensional features present in OLAP?
a. very essential if we are to include multiple hierarchies in our data analysis
b. Multidimensional feature allows a user to analyze business and organization
c. OLAP efficiently handles support for multidimensional features.
d. All the above
235) Which of the following is not a DOLAP (Desktop OLAP)?
a. Hyperion Intelligence
b. Personal Express
c. Business Objects
d. Oracle ODBC
236) What is the max possible number of aggregations for a system with 2 dimensions and 3 levels?
a. 6
b. 3
c. 8
d. 9
237) Which among the following is true with respect to view selection in OLAP?
a. View selection is not constrained by execution time
b. View selection chooses between materialized views and normal views
c. View selection is not affected by the time required to update the changes from base data
d.
e. Objective of view selection is to minimize the average time to answer OLAP queries
f.
238) Which of the following is not an OLAP operation?
a. Slice
b. Pivot
c. Rollup
d. Burst
239) —— is termed as changing the dimensional orientation of a report or page display
a. Slice
b. Dice
c. Rollup
d. Pivot
240) Linking cubes is a method of overcoming ——-
a. Hierarchy
b. Cardinality
c. Aggregation
d. Sparsity
241) Which among the following is true regarding causes for multidimensional database explosion?
a. Poor suppression of sparsity
b. Lack of data compression
c. Software Errors
d. None of the above
242) The state or province level in a geography hierarchy contains no members for countries or regions that do not have states or provinces. This is termed —— hierarchy
a. Regular
b. Irregular
c. Sparse
d. Ragged
243) ——— process must address errors such as incorrect spellings, conflicting spelling conventions between two systems, and conflicting data while building a DWH
a. Normalization
b. Tuning
c. Data Modeling
d. Data Scrubbing
244) Which has Two dimensional data
a. MOLAP
b. DOLAP
c. ROLAP
d. All the above
245) Which type of storage architecture gives faster performance
a. ROLAP
b. DOLAP
c. MOLAP
d. HOLAP
246) What are the Key Objectives With in OLAP
a. Dimensions
b. Measures
c. A and B
d. None of the above
247) Types of Measures
a. Additive
b. semi additive
c. Non Additive
d. All the above
248) Operational data store is used to hold ———
a. Detailed data
b. Aggregate data
c. Reporting data
d. none of the above
249) Give any one example of reporting tool for MOLAP
a. Business Object
b. Hyperion
c. Cognos
d. None of the above
250) OLAP Technology is not well suited for
a. Trends
b. Monitor KPI
c. analyzing anomalies
d. behavior patterns
251) Which data Modeling Approach is suitable for OLTP
a. ER Modeling
b. Dimensional Modeling
c. Snowflake Modeling
d. None of the above
252) What are the Key Components in Dimensions
a. Hierarchies
b. Levels
c. Attributes
d. All the above
253) Which OLAP is used to create Multidimensional Cubes
a. MOLAP
b. HOLAP
c. DOLAP
d. All the above
254) Which type of SCD preserves all information?
a. SCD II
b. SCD III
c. NEW SCD
d. None of the above
256) What is the difference between Star schema and Normalized schema?
a. Both are same
b. Star schema has less data than Normalized schema
c. Star schema is not normalized
d. All of the above
257) why surrogate key is used?
a. To track type 2 slowly changing dimensions
b. To be primary key for fact table
c. For faster query performance in data mart
d. All the above
258) Which is most important factor that determines a MOLAP data base size
a. Aggregation Level
b. Number of Dimensions
c. Number of Fact
d. All the above
259) Which Solution is used for BI
a. OLTP
b. Data Mining
c. OLAP
d. None
260) OLAP provides
a. Analysis with respective to time
b. Adhoc queries
c. Slice and Dice
d. ALL the above
261) In OLAP System data is refreshed when
a. user Changes the data
b. Periodic jobs are run to refresh the data
c. data is changed through data entry screen
d. All the above
262) What is the Functionality of OLAP?
a. Fast Access and Calculations
b. o Powerful Analytical Capabilities
c. o Multi-End-User Support
d. All the above
263) How Functionality of OLAP is characterized
a. Trend analysis over sequential time periods
b. Slicing subsets for on-screen viewing
c. Reach-through to underlying detail data
d. All the above
264) What are Features of OLAP
a. Dimensions
b. The Ability to display Cubes
c. Hierarchies
d. All the above
265) API`s of OLAP?
a. OLE DB
b. XML
c. MDX
d. All the above
266) What type of aggregation can be used for inventory related measures?
a. SUM
b. LASTNONEMPTY
c. COUNT
d. All of the above
267) Profit Margin is a ________ type of measure
a. Additive
b. Semi Additive
c. Non Additive
d. None
268) Inventory Quantity is a __________ type of measure
a. Additive
b. Semi Additive
c. Non Additive
d. None
269) Which property of a KPI denotes the KPI is improving over time or degrading over time?
a. Value
b. Status
c. Trend
d. Goal
270) Which type of dimension enables a Market Basket type of analysis i.e. which things were bought together
a. Degenerate
b. Regular
c. Audit
d. Multi value
271) What is not a possible cardinality between Measures and Dimensions?
a. 1:1
b. 1:N
c. N:N
d. None
272) Which features provide a performance enhancement in an OLAP Cube structure?
a. Precalculated Aggregations
b. Hierarchies
c. Both
d. None
273) What type of data structure is more suitable for current state analysis?
a. OLAP
b. OLTP
c. ODS
d. EDW
274) DW 2.0 champions the use of ______ for analysis
a. Unstructured Data
b. Functional Knowledge
c. Experience
d. Case Studies
275) Who shall decide on the data security approach in a OLAP environment
a. IT Manager
b. Business Owners
c. Consultants
d. CIO
276) What type of reporting is essential for success of a OLAP environment?
a. Adhoc
b. Canned
c. Both
d. None
277) What could be a good starting point for identifying OLAP analysis requirements?
a. KPIs
b. Sales Targets
c. Finance Statements
d. None
278) Which is a well accepted specification for OLAP?
a. SOAP
b. XML/A
c. RPC
d. All
279) What is the optimization problem for creating precomputed aggregations in OLAP called as?
a. Aggregation Dilemma Problem
b. View Selection Problem
c. Optimization Size Problem
d. None
280) Which MDX function preserves the underlying aggregation applied to measures?
a. SUM()
b. AGGREGATE()
c. CHILD()
d. PRESERVE()
281) What type of hierarchy is more suitable for Family dimension?
a. Balanced
b. Ragged
c. Unbalanced
d. Network
282) What type of hierarchy is more suitable for Geography dimension?
a. Balanced
b. Ragged
c. Unbalanced
d. Network
283) What type of hierarchy is more suitable for Product dimension?
a. Balanced
b. Ragged
c. Unbalanced
d. Network
284) Slicing of a OLAP Cube slice can be considered as dicing (True / False)
a. True
b. False
285) OLAP Cubes are always READ ONLY.
a. True
b. False
286) A company “A” buys another company “B” with similar product portfolio. What could be the biggest challenge(s) in integrating their OLAP environments?
a. Integrating Products
b. Integrating Customers
c. Integrating different technology environments
d. All of these
287) A manager determines fall in Sales Revenues in a particular region. What OLAP feature would help in identifying the reason for the fall in Sales?
a. Slice and Dice
b. Drill Down
c. Properly defined measures
d. Aggregate Functions
288) What is a suitable mechanism to avoid existing unwanted / dirty data from source systems to enter an OLAP Cube?
a. Clean up source systems
b. Implement Filters to remove bad data in ETL
c. Apply Filters in Source extraction Query for a OLAP Cube
d. Apply filters on Reports to remove dirty data
289) In order to analyse the Quote to Invoice cycle a OLAP Cube is created. Which dimension(s) could participate in a Role playing mode?
a. Date Dimension
b. Employee Dimension
c. Location Dimension
d. All of these
290) What results from a Rapidly Changing Dimension?
a. Outrigger
b. Junk Dimension
c. Mini Dimension
d. None of these
291) How do outriggers differ from a mini dimension?
a. Outriggers have a primary key, Mini dimension doesn’t have a PK.
b. Mini dimension has FK in Fact table, Outrigger has a FK in Dimension table.
c. Outriggers are from source data and Minidimension is from calculated data.
d. No difference
292) Which is the right place to create a calculation in an OLAP analysis?
a. ETL
b. Cube
c. Report
d. Depends on the calculation.
293) How do we address performance concerns due to Adhoc Query reporting?
a. Create Indexes on primary key columns
b. Provide training to users
c. Set an appropriate Query Timeout
d. Provide predefined queries to users
294) A company did not have its Sales data for some intermediate months. These values were all set to zeros in the OLAP Cube. As a result, which aggregation function(s) would get affected?
a. MAX()
b. AVERAGE()
c. COUNT()
d. All of these
295) If you have a measure that returns null values in some circumstances and you want your users to see something other than null then what would be the preferred method to implement the same?
a. Handle the same using MDX.
b. Handle the same in Reports Calculations.
c. Handle the same using FormatString property for measures.
d. Hard Code the Null values with the required values in data itself.
296) Operational databases are databases that support OLAP
a. True
b. False
297) What is the manipulation of information to support decision making
a. OLAP
b. OLTP
c. A database
d. An operational database
298) Which of the following is not the ETL step?
a. Copling
b. combining
c. matching
d. stardardizing
299) Which of the following is inaccurate in reference to a database?
a. A collection of information
b. Organized by logical structure
c. Accessed by physical structure
d. None of the above
300) which of the following are aims of data mining?
a. To discover anomlaous pattern in the data
b. to better understand the customer
c. to improve human judgement
d. All the above
301) which of the following are steps in building a data warehouse?
a. Requirement analysis
b. Modelling
c. identifying data sources
d. All the above
302) which one of the following is NOT true?
a. OLTP system are for office workers while OLAP is for manager
b. OLTP system are mission critical while OLAP is not
c. OLTP system process aggregation quries efficiency
d. OLTP system are used for updating information while OLAP system are not
303) Which view of information deals with how the information is physically arranged, stored, and accessed?
a. Physical view
b. Logical view
c. Information view
d. None of the above
304) Intelligent agents are used in OLAP and in online searching
a. True
b. False
305) Which data-mining tool uses various artificial intelligence tools to form the basis of information discovery and building business intelligence in OLAP
a. Intelligent agents
b. Query-and-reporting tools
c. Multidimensional analysis tools
d. None of the above
306) Which term describes each two-dimensional table or file in the relational model
a. Database
b. Relational database
c. Data warehouse
d. None of the above
307) Which view of information focuses on how you need to arrange and access information to meet the needs of the business?
a. Physical view
b. Logical view
c. Information view
d. None of the above
308) Which of the following is a data manipulation tool
a. Report generator
b. Query-by-example tool
c. Structure query language
d. All of the above
309) which of the following is not a use of data warehousing?
a. Manager queries
b. customer enquires
c. OLAP
d. Data Mining
310) Which data manipulation tool allows you to graphically design the answer to a question
a. Report generator
b. Query-by-example tool
c. Structure query language
d. None of the above
311) Which of the following are included in data-mining tools
a. Query-and-reporting tools
b. Intelligent agents
c. Multidimensional analysis tools
d. All of the above
312) Which data-mining tool uses slice-and-dice techniques that allow you to view multidimensional information from different perspectives
a. Statistical tools
b. Query-and-reporting tools
c. Multidimensional analysis tools
d. None of the above
313) What is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept
a. Data mining tool
b. Data mart
c. Data warehouse
d. None of the above
314) which one of the following is a part of web mining ?
a. Crawler
b. Indexer
c. Structur mining
d. Hiperlink mining
315) which of the following is not required in building a data warehouse?
a. Testing
b. Requirements analysis
c. data modelling
d. Data recovery
316) Which of the following tools is used to help an organization build and use business intelligence
a. Data warehouse
b. Data-mining tools
c. Database management systems
d. All of the above
317) The logical view of information focuses on how you arrange and access information to meet the needs of the business
a. True
b. False
318) Data marts focus on the entire organization, while data warehouses focus on specific needs
a. True
b. False
319) What do databases and DBMSs directly support
a. OLDP
b. OLTP
c. Databases
d. Operational databases
320) which one of the following is correct?
a. OLAP is esentially the same as data warehousing
b. ODS is essentially the same as an OLTP system
c. ROLAP and MOLAP are the same
d. ETL is an esssential part of implementing DW.
321) Which of the following do you create first when creating a database
a. Primary keys
b. Foreign keys
c. Data dictionary
d. All of the above
322) Data-mining tools permit the user to query information in a data warehouse.
a. True
b. False
323) Multidimensional analysis (MDA) tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.
a. True
b. False
324) Data warehouses support only OLTP.
a. True
b. False
325) Which one of the following is true?
a. Dimension is an attribute
b. A measure is numeric attribute of a fact
c. A fact table has dimensions and measures
d. All the abowe
