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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
2) Which is the most common type of Dimension?
a. Customer
b. Product
c. Location
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
3) Which type of data storage architecture gives fastest performance?
a. DOLAP
b. ROLAP
c. MOLAP
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
4) Which type of SCD preserves all information?
a. SCD Type II
b. SCD Type III
c. New SCD
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
5) Database explosion was a common problem for?
a. Oracle RDBMS
b. DB2 RDBMS
c. DOLAP
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
6) What of the following constitute a Business Intelligence?
a. ABC
b. PM
c. Reporting
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
7) Which of the following data storage architecture is not server based?
a. MOLAP
b. ROLAP
c. RDBMS
d. DOLAP
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
9) OLAP technology is not well suited for?
a. Trends
b. Monitor KPI
c. Analyzing anomaly
d. Behavior patterns
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
27) Predictive analysis model cannot be used for
a. Cross-sell
b. Direct marketing
c. Customer retention
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
28) Which one of the following is used as a data access middleware?
a. JDBC
b. MDX
c. ODBC
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
29) Analytics application does not include the following model:
a. Predictive
b. Statistical
c. Descriptive
d. In-line
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
30) Which one of the following does not directly aid in performance improvement?
a. Index
b. aggregate aware
c. Normalization
d. Hint
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
39) A prime component of a management application is
a. Strategy maps
b. workflows
c. Annotations
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
46) Adhoc Report are :
a. Canned Reports
b. Scheduled Report
c. Corporate Reports
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
52) Guided decision is a associated to
a. Discovery and Applications
b. Analytics
c. Performance Management
d. Reporting
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
53) Following are part of Analytics
a. Operations DSS
b. Time series
c. Predictive Analytics
d. All of above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
55) How is ‘Group by’ computed
a. Nested Loop
b. Sorting
c. Hashing
d. All of above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
56) Each ARC in multidimensional data structure represents
a. link to Fact
b. Integrity constraint
c. Parent Child relationship
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
57) What will be considered for optimization of Cube
a. Smallest Parents
b. Cache Results
c. Share Partitions
d. All of above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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)
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
61) Which one is the most possible source of unstructured data
a. Email
b. XML File
c. Flat files
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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)
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
66) Analysis of records according to some future behavior corresponds to
a. Clustering
b. Classification
c. Prediction
d. Profiling
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
67) Segmenting of heterogeneous population into number of homogeneous subgroups corresponds to
a. Classification
b. Clustering
c. Profiling
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
68) Decision tree corresponds to
a. Profiling
b. Classification
c. Prediction
d. Clustering
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
72) Ragged hierarchy will result in to a summarizability problem
a. Yes
b. No
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
73) Monthly revenue is a _____________ type measure
a. Stock
b. Flow
c. Unit
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
75) Which of these is not components of Warehouse Databases?
a. Source DB
b. ROLAP Engine
c. Central Warehouse
d. MultiDimensional DB
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
79) ______ can exploit patterns & relationships to produce predictive & descriptive models
a. Data Profiling
b. Data Warehousing
c. Data mining
d. Data Integration
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
80) Find the odd one out
a. Clustering
b. Classification
c. Regression
d. Time-series
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
81) Forecasting future trends by considering seasonality and holidays is best done by
a. Regression
b. Association
c. Classification
d. Time-series
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
82) _______ is a way of representing series of rules
a. Neural Networks
b. K Nearest neighbor
c. Decision Trees
d. Rule Induction
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
83) What is the Unit of code measure in Datawarehousing
a. DWP
b. DWU
c. DFP
d. LOC
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
85) OLAP Reporting provides this feature
a. Multidimensional viewing Capabilities
b. Calculation Intensive Capabilities
c. Time Intelligence
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
98) Cache is faster than Virtual memory
a. True
b. FALSE
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
105) Enable _____________ For High Frequency Searches
a. Partitioned Indexes
b. Bitmap Indexes
c. Hash Index
d. Join Index
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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)
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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)
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
122) It is advisable to create Bitmap index on
a. Column value with low cardinality
b. Column value with high cardinality
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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)
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
125) The best suitable OLAP for complex analysis is
a. ROLAP
b. MOLAP
c. DOLAP
d. None of the Above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
126) OLAP Stands for
a. Order Line Analytical Process
b. Online Arithmetic Progression
c. Online Analytical Processing
d. None of the Above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
129) Data Mining is “Slicing & Dicing” of data to get good insight of data at a more granular level
a. TRUE
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
130) Multi Dimensional Analysis is “Slicing & Dicing” of data to get good insight of data at a more granular level
a. True
b. FALSE
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
132) Bitmap Index is the most efficient index applied on Data Warehouse for better analytics performance
a. True
b. FALSE
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
133) The aggregation or calculated value goes into the
a. Fact Table
b. Dimension Table
c. Lookup Table
d. None of the Above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
134) Dimensional Model constitute of
a. Fact Tables
b. Dimension Tables
c. Lookup Tables
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
140) What type of data OLTP contains ?
a. Transaction data
b. Historical data
c. Aggrigated data
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
141) What are the types of OLAP
a. MOLAP
b. ROLAP
c. DOLAP
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
142) Which has Two dimensional data ?
a. MOLAP
b. ans)ROLAP
c. DOLAP
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
143) Which type of storage architecture gives faster performance ?
a. MOLAP
b. ROLAP
c. DOLAP
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
144) What are the Key Objectives With in OLAP ?
a. Dimensions
b. Measures
c. a and b
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
145) Different Types of Measures are ?
a. Additive
b. Semi Additive
c. Non Additive
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
146) Operational data store is used to hold ——— ?
a. Detailed data
b. Aggregate data
c. Reporting data
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
147) Give any one example of reporting tool for MOLAP ?
a. Business Object
b. Hyperion
c. Cognos
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
148) OLAP Technology is not well suited for ?
a. Trends
b. Monitor KPI
c. analyzing anomalies
d. Behavior patterns
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
149) Which data Modeling Approach is suitable for OLTP?
a. ER Modeling
b. Dimensional Modeling
c. Snowflake Modeling
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
150) What are the Key Components in Dimensions?
a. Hierarchies
b. Levels
c. Attributes
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
151) Which OLAP is used to create Multidimensional Cubes?
a. MOLAP
b. ROLAP
c. DOLAP
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
152) Which type of SCD preserves all information?
a. SCD II
b. SCD III
c. NEW SCD
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
157) Which Solution is used for BI?
a. OLTP
b. Data Mining
c. OLAP
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
158) OLAP provides
a. Analysis with respective to time
b. Adhoc queries
c. Slice and Dice
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
161) Bridge table is user for
a. Confirmed dimension
b. Multi valued dimension
c. Degenerate dimension
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
162) Which of the dimension belongs to Fastly Changing dimension
a. Product Dimension
b. Customer Dimension
c. Time Dimension
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
163) Choose the best option to use bitmap index
a. Employee name
b. Employee ID
c. Employee Joining date
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
165) Acronym for KPI ?
a. Key Performance Indicators
b. Key Performance Index
c. Both
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
166) Can we normalize a fact tables ?
a. Yes
b. No
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
169) Define the table name used to implement many to many relationship
a. Bridge table
b. Hierarchies
c. Both
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
170) Whats most important char of OLAP
a. time variant
b. non volatile
c. integrated
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
171) In DWH , generally data setup will be in which form?
a. 3NF
b. BCNF
c. Normalized
d. Denormalized
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
173) This operation limits analysis to subset of an attribute
a. Drill down
b. Dice
c. Slice
d. Drill Through
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
174) MDDB technology is proprietary to which OLAP Architecture ?
a. ROLAP
b. MOLAP
c. DOLAP
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
175) ROLAP Architecture is Non Intuitive ?
a. True
b. FALSE
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
178) What are the prerequisites for OLAP Administration ?
a. Data management
b. Application management
c. Metadata management
d. All of the Above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
180) Which is a 3- tiered Architecture from the following ?
a. MOLAP
b. ROLAP
c. None of the above
d. Both (a) and (b)
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
181) Property of fact across which its analysis co-ordinates are defined is called ?
a. Dimension
b. Fact
c. Measure
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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)
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
183) Removing Partial dependency is step to which normal form ?
a. 1st NF
b. 2nd NF
c. 3rd NF
d. BCNF
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
185) Summary tables is data warehouse is called as ______________________-
a. Aggregate tables
b. Factless fact Table
c. Both
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
186) How do you join 2 fact tables______________-
a. Confirmed Dimension
b. Degenerated Dimension
c. Junk Dimension
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
188) How to select distinct values without using SQL distinct statements
a. ORDER BY
b. UNIQUE FUNCTION
c. MINUS OPERATOR
d. GROUP BY
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
189) OLAP is an acronym for
a. Online Analytical Processing
b. Online Analysis Process
c. Online Arithmetic Processing
d. Object Linking and Processing
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
190) Multidimensional data can be queried and manipulated using
a. T-SQL
b. MDX
c. MDAC
d. OWC
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
191) Different Storage Modes used for storage of cubes are
a. MOLAP
b. ROLAP
c. HOLAP
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
194) The following Storage Mode gives the best Query Performance
a. MOLAP
b. ROLAP
c. HOLAP
d. DOLAP
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
196) The methods of processing the cubes
a. Incremental Update
b. Refresh Data
c. Process (Rebuild) Data
d. All the Above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
201) Drill Across generally uses the following join to generate report
a. Self Join
b. Inner Join
c. Outer Join
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
209) The term that defines filtering data in an OLAP cube is ___________.
a. Dicing
b. Slicing
c. Rotating
d. Nesting
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
210) What is an item that matches a specific description or classification
a. Category
b. Measure
c. Dimensions
d. Nest
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
211) The cube structure in OLAP achieves the __________ functionality
a. Shared
b. Information
c. Collection
d. Multidimensional
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
212) Aggregation provides OLAP with __________
a. Multidimensional data
b. Pre-calculated data
c. Nested Data
d. Slow Data Retrieval
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
213) What is the acronym that defines OLAP
a. FHTMI
b. FASMI
c. ASFMI
d. MASHF
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
214) __________ in OLAP allows you to define a subcube of the original space
a. Dicing
b. Slicing
c. Rotating
d. Nesting
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
217) Which of the following is not an OLAP operation:
a. drill along
b. drill across
c. drill down
d. drill through
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
222) Fact Tables contains :
a. Details
b. Measures
c. Summary
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
223) Database roles can be :
a. Fixed
b. Flexible
c. A & B
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
231) SAS Business Intelligence is capable of.
a. Statistics
b. Data Mining
c. Forecasting
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
233) What is the security level used in BO?
a. Row level
b. Column level
c. A & B
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
235) Which of the following is not a DOLAP (Desktop OLAP)?
a. Hyperion Intelligence
b. Personal Express
c. Business Objects
d. Oracle ODBC
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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.
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
238) Which of the following is not an OLAP operation?
a. Slice
b. Pivot
c. Rollup
d. Burst
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
239) —— is termed as changing the dimensional orientation of a report or page display
a. Slice
b. Dice
c. Rollup
d. Pivot
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
240) Linking cubes is a method of overcoming ——-
a. Hierarchy
b. Cardinality
c. Aggregation
d. Sparsity
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
244) Which has Two dimensional data
a. MOLAP
b. DOLAP
c. ROLAP
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
245) Which type of storage architecture gives faster performance
a. ROLAP
b. DOLAP
c. MOLAP
d. HOLAP
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
246) What are the Key Objectives With in OLAP
a. Dimensions
b. Measures
c. A and B
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
247) Types of Measures
a. Additive
b. semi additive
c. Non Additive
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
248) Operational data store is used to hold ———
a. Detailed data
b. Aggregate data
c. Reporting data
d. none of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
249) Give any one example of reporting tool for MOLAP
a. Business Object
b. Hyperion
c. Cognos
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
250) OLAP Technology is not well suited for
a. Trends
b. Monitor KPI
c. analyzing anomalies
d. behavior patterns
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
251) Which data Modeling Approach is suitable for OLTP
a. ER Modeling
b. Dimensional Modeling
c. Snowflake Modeling
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
252) What are the Key Components in Dimensions
a. Hierarchies
b. Levels
c. Attributes
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
253) Which OLAP is used to create Multidimensional Cubes
a. MOLAP
b. HOLAP
c. DOLAP
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
254) Which type of SCD preserves all information?
a. SCD II
b. SCD III
c. NEW SCD
d. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
259) Which Solution is used for BI
a. OLTP
b. Data Mining
c. OLAP
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
260) OLAP provides
a. Analysis with respective to time
b. Adhoc queries
c. Slice and Dice
d. ALL the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
264) What are Features of OLAP
a. Dimensions
b. The Ability to display Cubes
c. Hierarchies
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
265) API`s of OLAP?
a. OLE DB
b. XML
c. MDX
d. All the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
266) What type of aggregation can be used for inventory related measures?
a. SUM
b. LASTNONEMPTY
c. COUNT
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
267) Profit Margin is a ________ type of measure
a. Additive
b. Semi Additive
c. Non Additive
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
268) Inventory Quantity is a __________ type of measure
a. Additive
b. Semi Additive
c. Non Additive
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
271) What is not a possible cardinality between Measures and Dimensions?
a. 1:1
b. 1:N
c. N:N
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
272) Which features provide a performance enhancement in an OLAP Cube structure?
a. Precalculated Aggregations
b. Hierarchies
c. Both
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
273) What type of data structure is more suitable for current state analysis?
a. OLAP
b. OLTP
c. ODS
d. EDW
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
274) DW 2.0 champions the use of ______ for analysis
a. Unstructured Data
b. Functional Knowledge
c. Experience
d. Case Studies
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
275) Who shall decide on the data security approach in a OLAP environment
a. IT Manager
b. Business Owners
c. Consultants
d. CIO
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
276) What type of reporting is essential for success of a OLAP environment?
a. Adhoc
b. Canned
c. Both
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
277) What could be a good starting point for identifying OLAP analysis requirements?
a. KPIs
b. Sales Targets
c. Finance Statements
d. None
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
278) Which is a well accepted specification for OLAP?
a. SOAP
b. XML/A
c. RPC
d. All
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
280) Which MDX function preserves the underlying aggregation applied to measures?
a. SUM()
b. AGGREGATE()
c. CHILD()
d. PRESERVE()
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
281) What type of hierarchy is more suitable for Family dimension?
a. Balanced
b. Ragged
c. Unbalanced
d. Network
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
282) What type of hierarchy is more suitable for Geography dimension?
a. Balanced
b. Ragged
c. Unbalanced
d. Network
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
283) What type of hierarchy is more suitable for Product dimension?
a. Balanced
b. Ragged
c. Unbalanced
d. Network
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
284) Slicing of a OLAP Cube slice can be considered as dicing (True / False)
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
285) OLAP Cubes are always READ ONLY.
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
290) What results from a Rapidly Changing Dimension?
a. Outrigger
b. Junk Dimension
c. Mini Dimension
d. None of these
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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.
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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.
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
296) Operational databases are databases that support OLAP
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
297) What is the manipulation of information to support decision making
a. OLAP
b. OLTP
c. A database
d. An operational database
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
298) Which of the following is not the ETL step?
a. Copling
b. combining
c. matching
d. stardardizing
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
304) Intelligent agents are used in OLAP and in online searching
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
309) which of the following is not a use of data warehousing?
a. Manager queries
b. customer enquires
c. OLAP
d. Data Mining
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
314) which one of the following is a part of web mining ?
a. Crawler
b. Indexer
c. Structur mining
d. Hiperlink mining
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
315) which of the following is not required in building a data warehouse?
a. Testing
b. Requirements analysis
c. data modelling
d. Data recovery
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
318) Data marts focus on the entire organization, while data warehouses focus on specific needs
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
319) What do databases and DBMSs directly support
a. OLDP
b. OLTP
c. Databases
d. Operational databases
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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.
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
322) Data-mining tools permit the user to query information in a data warehouse.
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
323) Multidimensional analysis (MDA) tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
324) Data warehouses support only OLTP.
a. True
b. False
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
