SSAS Quiz

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

Answer : A

 
2) Can we use Web Service as a data source in Analysis Services project directly?

  1. YES
  2. NO

Answer : A

 
3) MOLAP is a storage system using

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

Answer : A

 
4) ROLAP is a storage system using

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

Answer : B

 
5) HOLAP is a storage system using

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

Answer : C

 
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

Answer : B

 
7) Which is not an AggregateFunction property of a measure?

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

Answer : C

 
8) Which is a Semiadditive AggregateFunction property of a measure?

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

Answer : C

 
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

Answer : B




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

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

Answer : B

 
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

Answer : B

 
12) Calculated members can be created with

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

Answer : C

 
13) What are the basic attributes of a KPI?

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

Answer : A

 
14) How to query a Cube?

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

Answer : D

 
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

Answer : A

 
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

Answer : D

 
17) Which Schema (Star, Snowflake) has better performance?

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

Answer : A

 
18) What is the default instance name of the Analysis Service?

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

Answer : B

 
19) Default instance of Analysis Services listens on TCP/IP port

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

Answer : C




20) Cube storage file extension

  1. .acube
  2. .cub
  3. .cube
  4. none of the above

Answer : B

 
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

Answer : A

 
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

Answer : C

 
23) MDX is a query language used to retrieve data from

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

Answer : B

 
24) What are the key elements of Data Warehouse?

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

Answer : B

 
25) Which of the following is an Action supported by SSAS

  1. commandLine
  2. Backup
  3. XML
  4. None of the Above

Answer : A

 
26) Attributes correspond to columns of a dimension table

  1. TRUE
  2. False

Answer : A

 
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

Answer : A

 
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

Answer : A

 
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

Answer : A




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

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

Answer : A

 
31) What is XMLA

  1. Advanced version of XML
  2. A protocol
  3. A new language
  4. None of the above

Answer : B

 
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.

Answer : B

 
33) _____________ is know as degenerate dimension

  1. fact table
  2. fact dimension
  3. Dimension Table
  4. None of the above

Answer : B

 
34) Perspectives allow you to hide

  1. dimensions
  2. measure goups
  3. attributes
  4. all of the above

Answer : D

 
35) Can we add columns into table present in Data Source View

  1. yes
  2. no

Answer : A

 
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

Answer : D

 
37) SQL Server Analysis Services (SSAS) provides

  1. Data mining
  2. KPI
  3. All of the Above
  4. None of the Above

Answer : C

 
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

Answer : B

 
39) how are Hierarchies created

  1. Attributes of fact table
  2. Attributes of dimensions
  3. All of the Above
  4. None of the Above

Answer : B




40) What type of data OLTP contains ?

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

Answer : A

 
41) What are the types of OLAP

  1. MOLAP
  2. ROLAP
  3. DOLAP
  4. All of the above

Answer : D

 
42) Which has Two dimensional data ?

  1. MOLAP
  2. ROLAP
  3. DOLAP
  4. All of the above

Answer : C

 
43) What are the Key Objectives With in OLAP ?

  1. Dimensions
  2. Measures
  3. a and b
  4. None of the above

Answer : C

 
44) Different Types of Measures are ?

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

Answer : D

 
45) Operational data store is used to hold ——— ?

  1. Detailed data
  2. Aggregate data
  3. Reporting data
  4. None of the above

Answer : A

 
46) Give any one example of reporting tool for MOLAP ?

  1. Business Object
  2. Hyperion
  3. Cognos
  4. None of the above

Answer : C

 
47) OLAP Technology is not well suited for ?

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

Answer : D

 
48) Which data Modeling Approach is suitable for OLTP?

  1. ER Modeling
  2. Dimensional Modeling
  3. Snowflake Modeling
  4. None of the above

Answer : A

 
49) What are the Key Components in Dimensions?

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

Answer : D




50) Which OLAP is used to create Multidimensional Cubes?

  1. MOLAP
  2. ROLAP
  3. DOLAP
  4. All of the above

Answer : A

 
51) Which type of SCD preserves all information?

  1. SCD II
  2. SCD III
  3. NEW SCD
  4. None of the above

Answer : A

 
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

Answer : C

 
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

Answer : A

 
54) Which Solution is used for BI?

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

Answer : C

 
55) OLAP provides

  1. Analysis with respective to time
  2. Adhoc queries
  3. Slice and Dice
  4. All of the above

Answer : D

 
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

Answer : C

 
57) Which of the following functions is NOT a standard key performance indicator function?

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

Answer : C

 
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

Answer : A

 
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

Answer : D




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]

Answer : B

 
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

Answer : A

 
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)

Answer : A

 
63) Analysis Services does not provide a way to sort dimension members in DESCending order

  1. TRUE
  2. FALSE

Answer : A

 
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.

Answer : B

 
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

Answer : C

 
66) What is the ideal limit of aggregations that can be designed for a partition?

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

Answer : A

 
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

Answer : B

 
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.

Answer : C

 
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.

Answer : B




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.

Answer : B

 
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

Answer : D

 
72) A snowflake schema is which of the following types of tables?

  1. Fact
  2. Dimension
  3. Helper
  4. All of the above

Answer : D

 
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

Answer : A

 
74) Fact tables are

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

Answer : C

 
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.

Answer : C

 
76) Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores.

  1. TRUE
  2. FALSE

Answer : B

 
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.

Answer : B

 
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

Answer : B

 
79) “Count” function in the calculation comes under?

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

Answer : D




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

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

Answer : A

 
81) KPI Stands for?

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

Answer : C

 
82) Hierarchies can be defined by?

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

Answer : C

 
83) SCD stands for

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

Answer : D

 
84) Which of the following OLAP storage methods usually have poor reporting  performance.

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

Answer : C

 
85) What is the most commonly used tool to analyze SSAS Cube data?

  1. PPS
  2. SSRS
  3. Excel
  4. None of the Above

Answer : C

 
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

Answer : B

 
87) Which of the following is the basic unit of storage and analysis in Analysis Services.

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

Answer : C

 
88) In which mode MOLAP store the data?

  1. File Mode
  2. Database Mode
  3. Both A & B
  4. None of The Above

Answer : A

 
89) In which mode HOLAP store the data?

  1. Database Mode
  2. File Mode
  3. Both A and B
  4. None of The Above

Answer : C

 
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

Answer : D