SSAS Quiz

Posted on: | By: – Comments Off

SSAS Beginner Quiz

 



1) What BISM stands for

  1. Business Intelligence Semantic Model
  2. Business Intelligence Syntax Model
  3. Business Intelligence Semantic Meta Model
  4. Business Intelligence System Model

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
2) Can we use Web Service as a data source in Analysis Services project directly?

  1. YES
  2. NO

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
3) MOLAP is a storage system using

  1. File
  2. Database
  3. Both A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
4) ROLAP is a storage system using

  1. File
  2. Database
  3. 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]
 
5) HOLAP is a storage system using

  1. File
  2. Database
  3. Both A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
6) How many measures can be created with same name In a Cube, when cube has two measure groups?

  1. One measure
  2. two measures
  3. three measures
  4. four measures

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
7) Which is not an AggregateFunction property of a measure?

  1. DistinctCount
  2. None
  3. Average
  4. Sum

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
8) Which is a Semiadditive AggregateFunction property of a measure?

  1. Sum
  2. None
  3. Max
  4. DistinctCount

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
9) Where do you create relation between a dimension and a measure group?

  1. Perspective tab
  2. Dimension Usage tab
  3. Actions tab
  4. Translation tab

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



10) Fact dimension relationship in SQL Server 2005 onwards is a

  1. Referenced Relationship
  2. Fact Relationship
  3. Self Relationship
  4. Regular Relation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
11) A cube contains Time and Department dimensions along with Salary, DA measures. How many measures will that cube contain?

  1. 2
  2. 3
  3. 4
  4. 5

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
12) Calculated members can be created with

  1. Measure
  2. Dimension
  3. Both A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
13) What are the basic attributes of a KPI?

  1. Goal, Value
  2. Value, Status
  3. Goal, Status
  4. Value, Trend

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
14) How to query a Cube?

  1. Using MDX
  2. Using XMLA
  3. using SQL Script
  4. Any of A or B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
15) What is Calculated Measure?

  1. It’s a measure that is cacculated using MDX in runtime
  2. It’s a measure that calculates some
  3. ALL of A and B
  4. None of A or B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
16) How to get OLAP data in Excel

  1. Create VBA script
  2. Connect to OLAP Cube using Pivot Table
  3. ALL of A and B
  4. Any of A or B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
17) Which Schema (Star, Snowflake) has better performance?

  1. Star
  2. Snowflake
  3. Any Of the Above
  4. None of Above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
18) What is the default instance name of the Analysis Service?

  1. MSSQLServer
  2. MSSQLServerOLAP
  3. MSSQLServerOLAPService
  4. MSSQLServerAnalysisService

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
19) Default instance of Analysis Services listens on TCP/IP port

  1. 1433
  2. 2433
  3. 2383
  4. 2338

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



20) Cube storage file extension

  1. .acube
  2. .cub
  3. .cube
  4. 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]
 
21) KPI helps your organization to

  1. Define and measure quantitative progress toward organizational goals.
  2. Shows cube statistics
  3. Shows Dimnesion statistics
  4. 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]
 
22) SSAS provides an option of creating a view of a cube that only contains a subset of objects within the cube. What is that?

  1. Translation
  2. Semi-cube
  3. Perspective
  4. 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]
 
23) MDX is a query language used to retrieve data from

  1. Relational database
  2. Cube
  3. Excel
  4. Oracle

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
24) What are the key elements of Data Warehouse?

  1. Fact tables
  2. Dimension tables
  3. Both of them
  4. None of them

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
25) Which of the following is an Action supported by SSAS

  1. commandLine
  2. Backup
  3. XML
  4. 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]
 
26) Attributes correspond to columns of a dimension table

  1. TRUE
  2. False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
27) Calculated Member refers to:

  1. The creation of any MDX object through a calculation
  2. Another dimension in a star schema
  3. Special member in a snow flake schema
  4. 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]
 
28) Cube is a multidimensional data structure from which you can query

  1. business information
  2. log information
  3. system information
  4. 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]
 
29) Hierarchies are logical entities by which a business user might want to analyze

  1. fact data
  2. log data
  3. group data
  4. 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]



30) Which of the following is not a property of KPI

  1. Value Indicator
  2. Trend Indicator
  3. Trend Expression
  4. Value Expression

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
31) What is XMLA

  1. Advanced version of XML
  2. A protocol
  3. A new language
  4. 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]
 
32) OLAP System is

  1. Highly Normalized with Many tables
  2. Denormalized with fewer tables
  3. Depends on the design
  4. 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]
 
33) _____________ is know as degenerate dimension

  1. fact table
  2. fact dimension
  3. Dimension Table
  4. 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]
 
34) Perspectives allow you to hide

  1. dimensions
  2. measure goups
  3. attributes
  4. 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]
 
35) Can we add columns into table present in Data Source View

  1. yes
  2. no

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
36) which of the following is the feature of OLTP

  1. Consolidated Data
  2. denormalized with fewer tables
  3. uses complex queries
  4. opertional data

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
37) SQL Server Analysis Services (SSAS) provides

  1. Data mining
  2. KPI
  3. All of the Above
  4. 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]
 
38) Which of the following is a feature of SnowFlakeSchema

  1. dimensions are created from single table that are joined to a fact table
  2. two or more joined dimension tables are used to create dimensions where one of the tables is joined to the fact table
  3. Both A and B
  4. 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]
 
39) how are Hierarchies created

  1. Attributes of fact table
  2. Attributes of dimensions
  3. All of the Above
  4. 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]



40) What type of data OLTP contains ?

  1. Transaction data
  2. Historical data
  3. Aggrigated data
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
41) What are the types of OLAP

  1. MOLAP
  2. ROLAP
  3. DOLAP
  4. 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]
 
42) Which has Two dimensional data ?

  1. MOLAP
  2. ROLAP
  3. DOLAP
  4. 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]
 
43) What are the Key Objectives With in OLAP ?

  1. Dimensions
  2. Measures
  3. a and b
  4. 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]
 
44) Different Types of Measures are ?

  1. Additive
  2. Semi Additive
  3. Non Additive
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
45) Operational data store is used to hold ——— ?

  1. Detailed data
  2. Aggregate data
  3. Reporting data
  4. 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]
 
46) Give any one example of reporting tool for MOLAP ?

  1. Business Object
  2. Hyperion
  3. Cognos
  4. 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]
 
47) OLAP Technology is not well suited for ?

  1. Trends
  2. Monitor KPI
  3. analyzing anomalies
  4. Behavior patterns

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
48) Which data Modeling Approach is suitable for OLTP?

  1. ER Modeling
  2. Dimensional Modeling
  3. Snowflake Modeling
  4. 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]
 
49) What are the Key Components in Dimensions?

  1. Hierarchies
  2. Levels
  3. Attributes
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



50) Which OLAP is used to create Multidimensional Cubes?

  1. MOLAP
  2. ROLAP
  3. DOLAP
  4. 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]
 
51) Which type of SCD preserves all information?

  1. SCD II
  2. SCD III
  3. NEW SCD
  4. 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]
 
52) What are the different approaches you will suggest for taking maximum advantages of only Relational Data

  1. HOLAP
  2. ROLAP
  3. DOLAP
  4. a and b

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
53) Which is most important factor that determines a MOLAP data base size?

  1. Aggregation Level
  2. Number of Dimensions
  3. Number of Fact
  4. 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]
 
54) Which Solution is used for BI?

  1. OLTP
  2. Data Mining
  3. OLAP
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
55) OLAP provides

  1. Analysis with respective to time
  2. Adhoc queries
  3. Slice and Dice
  4. 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]
 
56) In OLAP System data is refreshed when

  1. User Changes the data
  2. Periodic jobs are run to refresh the data
  3. Data is changed through data entry screen
  4. 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]
 
57) Which of the following functions is NOT a standard key performance indicator function?

  1. KPITrend
  2. KPIGoal
  3. KPICause
  4. KPIValue

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
58) You use SQL Server Profiler to watch the events generated as a result of a processing operation. You need to find how many records the server has read from the data source when processing a dimension.
Which Profiler column do you need to examine?

  1. IntegerData
  2. EventSubclass
  3. Duration
  4. TextData

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
59) You need to implement a measure that uses the DistinctCount aggregation function. You are considering adding the measure to a measure group that already has a Distinct Count measure.
How many Distinct Count measures can a measure group have?

  1. 0
  2. 2
  3. Unlimited number
  4. 1

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



60) Which multidimensional expressions statement will return the status of the Reseller Sales key performance indicator that is defined in the Adventure Works DW cube?

  1. SELECT KPIStatus(Reseller Sales) ON COLUMNS FROM [Adventure Works DW]
  2. SELECT KPIStatus(“Reseller Sales”) ON COLUMNS FROM [Adventure Works DW]
  3. SELECT KPIs(“Reseller Sales”).KPIStatus ON COLUMNS FROM [Adventure Works DW]
  4. SELECT Status.KPI(Reseller Sales) ON COLUMNS FROM [Adventure Works DW]

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
61) You need to enable end users to browse the fact data behind an aggregated cube cell. The solution should require minimum implementation effort.
Which action type should you use?

  1. Drill-through action
  2. Reporting action
  3. URL action
  4. Rowset action

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
62) You have a measure group that contains several partitions. One of the partitions stores historical data for several years and is rarely queried. You need to select a storage mode that saves the most storage space on the server. The historical partition ha

  1. Hybrid OLAP (HOLAP)
  2. Let the server decide
  3. Multidimensional OLAP (MOLAP)
  4. Relational OLAP (ROLAP)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
63) Analysis Services does not provide a way to sort dimension members in DESCending order

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
64) Which of these is a default Measure in AS 2005?

  1. NULL default measure
  2. No Default Measure
  3. Semi-Additive Measures
  4. 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]
 
65) What is the ideal limit of aggregation designs in a measure group to help improve the performance?

  1. 5
  2. 4
  3. 3
  4. 6

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
66) What is the ideal limit of aggregations that can be designed for a partition?

  1. 500
  2. 100
  3. 300
  4. 700

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
67) How do I clear Analysis Services (SSAS) database cache?

  1. The Process of clearing the SSAS Database cache is done automatically at frequent intervals.
  2. Use an XMLA command to clear the cache.
  3. Any of the above.
  4. a or b

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
68) A data warehouse is which of the following?

  1. Can be updated by end users.
  2. Contains numerous naming conventions and formats.
  3. Organized around important subject areas.
  4. Contains only current data.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
69) An operational system is

  1. A system that is used to run the business in real time and is based on historical data.
  2. A system that is used to run the business in real time and is based on current data.
  3. A system that is used to support decision making and is based on current data.
  4. A system that is used to support decision making and is based on current data.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



70) Which of the following is part of generic two-level datawarehouse architecture

  1. At least one data mart
  2. Data that can extracted from numerous internal and external sources
  3. Near real-time updates
  4. 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]
 
71) Data scrubbing is which of the following?

  1. A process to reject data from the data warehouse and to create the necessary indexes
  2. A process to load the data in the data warehouse and to create the necessary indexes
  3. A process to upgrade the quality of data after it is moved into a data warehouse
  4. A process to upgrade the quality of data before it is moved into a data warehouse

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
72) A snowflake schema is which of the following types of tables?

  1. Fact
  2. Dimension
  3. Helper
  4. 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]
 
73) A goal of data mining includes which of the following?

  1. To explain some observed event or condition
  2. To confirm that data exists
  3. To analyze data for expected relationships
  4. To create a new data warehouse

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
74) Fact tables are

  1. Completely demoralized
  2. Partially demoralized
  3. Completely normalized
  4. Partially normalized

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
75) A star schema has what type of relationship between a dimension and fact table?

  1. Many-to-many
  2. One-to-one
  3. One-to-many
  4. 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]
 
76) Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
77) The Keys used to join the fact table with a dimension table is?

  1. Primary Key
  2. Surrogate Key
  3. Candidate Key
  4. 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]
 
78) What is load index?

  1. A process to reject data from the data warehouse and to create the necessary indexes
  2. A process to load the data in the data warehouse and to create the necessary indexes
  3. A process to upgrade the quality of data after it is moved into a data warehouse
  4. A process to upgrade the quality of data before it is moved into a data warehouse

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
79) “Count” function in the calculation comes under?

  1. Value Function
  2. KPI Function
  3. Set Function
  4. Statistical Function

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



80) The chief Component of OLAP in SSAS is the?

  1. Olap Server
  2. DBMS
  3. Client
  4. Analysis Server

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
81) KPI Stands for?

  1. Key performance identification
  2. Key Point Identification
  3. Key performance indicator
  4. Key point Indicator

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
82) Hierarchies can be defined by?

  1. dimension table
  2. fact table
  3. dimensional attributes
  4. fact attributes

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
83) SCD stands for

  1. Service changing dimension
  2. Service changing delivery
  3. Slowly changing delivery
  4. Slowly changing dimension

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
84) Which of the following OLAP storage methods usually have poor reporting  performance.

  1. MOLAP
  2. HOLAP
  3. ROLAP
  4. Both (a) and (b)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
85) What is the most commonly used tool to analyze SSAS Cube data?

  1. PPS
  2. SSRS
  3. Excel
  4. 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]
 
86) What is data mart?

  1. A superset of data warehouse and focus on single subject area
  2. A subset of data warehouse and focus on single subject area
  3. A set of OLTP databases
  4. 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]
 
87) Which of the following is the basic unit of storage and analysis in Analysis Services.

  1. Dimension
  2. Measure
  3. Cube
  4. Level

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
88) In which mode MOLAP store the data?

  1. File Mode
  2. Database Mode
  3. Both A & B
  4. 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]
 
89) In which mode HOLAP store the data?

  1. Database Mode
  2. File Mode
  3. Both A and B
  4. 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]
 
90) OLAP applications differ from OLTP applications

  1. The way that they store data
  2. The way that  they  analyze  data
  3. The way  that  they  present  data  to  the
  4. end-user.
  5. All o the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz