SSAS Beginner Quiz
1) What BISM stands for
- Business Intelligence Semantic Model
- Business Intelligence Syntax Model
- Business Intelligence Semantic Meta Model
- Business Intelligence System Model
2) Can we use Web Service as a data source in Analysis Services project directly?
- YES
- NO
3) MOLAP is a storage system using
- File
- Database
- Both A and B
4) ROLAP is a storage system using
- File
- Database
- Both A and B
5) HOLAP is a storage system using
- File
- Database
- Both A and B
6) How many measures can be created with same name In a Cube, when cube has two measure groups?
- One measure
- two measures
- three measures
- four measures
7) Which is not an AggregateFunction property of a measure?
- DistinctCount
- None
- Average
- Sum
8) Which is a Semiadditive AggregateFunction property of a measure?
- Sum
- None
- Max
- DistinctCount
9) Where do you create relation between a dimension and a measure group?
- Perspective tab
- Dimension Usage tab
- Actions tab
- Translation tab
10) Fact dimension relationship in SQL Server 2005 onwards is a
- Referenced Relationship
- Fact Relationship
- Self Relationship
- Regular Relation
11) A cube contains Time and Department dimensions along with Salary, DA measures. How many measures will that cube contain?
- 2
- 3
- 4
- 5
12) Calculated members can be created with
- Measure
- Dimension
- Both A and B
13) What are the basic attributes of a KPI?
- Goal, Value
- Value, Status
- Goal, Status
- Value, Trend
14) How to query a Cube?
- Using MDX
- Using XMLA
- using SQL Script
- Any of A or B
15) What is Calculated Measure?
- It’s a measure that is cacculated using MDX in runtime
- It’s a measure that calculates some
- ALL of A and B
- None of A or B
16) How to get OLAP data in Excel
- Create VBA script
- Connect to OLAP Cube using Pivot Table
- ALL of A and B
- Any of A or B
17) Which Schema (Star, Snowflake) has better performance?
- Star
- Snowflake
- Any Of the Above
- None of Above
18) What is the default instance name of the Analysis Service?
- MSSQLServer
- MSSQLServerOLAP
- MSSQLServerOLAPService
- MSSQLServerAnalysisService
19) Default instance of Analysis Services listens on TCP/IP port
- 1433
- 2433
- 2383
- 2338
20) Cube storage file extension
- .acube
- .cub
- .cube
- none of the above
21) KPI helps your organization to
- Define and measure quantitative progress toward organizational goals.
- Shows cube statistics
- Shows Dimnesion statistics
- none of the above
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?
- Translation
- Semi-cube
- Perspective
- None of the above
23) MDX is a query language used to retrieve data from
- Relational database
- Cube
- Excel
- Oracle
24) What are the key elements of Data Warehouse?
- Fact tables
- Dimension tables
- Both of them
- None of them
25) Which of the following is an Action supported by SSAS
- commandLine
- Backup
- XML
- None of the Above
26) Attributes correspond to columns of a dimension table
- TRUE
- False
27) Calculated Member refers to:
- The creation of any MDX object through a calculation
- Another dimension in a star schema
- Special member in a snow flake schema
- None of the above
28) Cube is a multidimensional data structure from which you can query
- business information
- log information
- system information
- None of the above
29) Hierarchies are logical entities by which a business user might want to analyze
- fact data
- log data
- group data
- None of the above
30) Which of the following is not a property of KPI
- Value Indicator
- Trend Indicator
- Trend Expression
- Value Expression
31) What is XMLA
- Advanced version of XML
- A protocol
- A new language
- None of the above
32) OLAP System is
- Highly Normalized with Many tables
- Denormalized with fewer tables
- Depends on the design
- None of the above.
33) _____________ is know as degenerate dimension
- fact table
- fact dimension
- Dimension Table
- None of the above
34) Perspectives allow you to hide
- dimensions
- measure goups
- attributes
- all of the above
35) Can we add columns into table present in Data Source View
- yes
- no
36) which of the following is the feature of OLTP
- Consolidated Data
- denormalized with fewer tables
- uses complex queries
- opertional data
37) SQL Server Analysis Services (SSAS) provides
- Data mining
- KPI
- All of the Above
- None of the Above
38) Which of the following is a feature of SnowFlakeSchema
- dimensions are created from single table that are joined to a fact table
- two or more joined dimension tables are used to create dimensions where one of the tables is joined to the fact table
- Both A and B
- None of the Above
39) how are Hierarchies created
- Attributes of fact table
- Attributes of dimensions
- All of the Above
- None of the Above
40) What type of data OLTP contains ?
- Transaction data
- Historical data
- Aggrigated data
- All the above
41) What are the types of OLAP
- MOLAP
- ROLAP
- DOLAP
- All of the above
42) Which has Two dimensional data ?
- MOLAP
- ROLAP
- DOLAP
- All of the above
43) What are the Key Objectives With in OLAP ?
- Dimensions
- Measures
- a and b
- None of the above
44) Different Types of Measures are ?
- Additive
- Semi Additive
- Non Additive
- All the above
45) Operational data store is used to hold ——— ?
- Detailed data
- Aggregate data
- Reporting data
- None of the above
46) Give any one example of reporting tool for MOLAP ?
- Business Object
- Hyperion
- Cognos
- None of the above
47) OLAP Technology is not well suited for ?
- Trends
- Monitor KPI
- analyzing anomalies
- Behavior patterns
48) Which data Modeling Approach is suitable for OLTP?
- ER Modeling
- Dimensional Modeling
- Snowflake Modeling
- None of the above
49) What are the Key Components in Dimensions?
- Hierarchies
- Levels
- Attributes
- All the above
50) Which OLAP is used to create Multidimensional Cubes?
- MOLAP
- ROLAP
- DOLAP
- All of the above
51) Which type of SCD preserves all information?
- SCD II
- SCD III
- NEW SCD
- None of the above
52) What are the different approaches you will suggest for taking maximum advantages of only Relational Data
- HOLAP
- ROLAP
- DOLAP
- a and b
53) Which is most important factor that determines a MOLAP data base size?
- Aggregation Level
- Number of Dimensions
- Number of Fact
- All of the above
54) Which Solution is used for BI?
- OLTP
- Data Mining
- OLAP
- None
55) OLAP provides
- Analysis with respective to time
- Adhoc queries
- Slice and Dice
- All of the above
56) In OLAP System data is refreshed when
- User Changes the data
- Periodic jobs are run to refresh the data
- Data is changed through data entry screen
- All of the above
57) Which of the following functions is NOT a standard key performance indicator function?
- KPITrend
- KPIGoal
- KPICause
- KPIValue
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?
- IntegerData
- EventSubclass
- Duration
- TextData
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?
- 0
- 2
- Unlimited number
- 1
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?
- SELECT KPIStatus(Reseller Sales) ON COLUMNS FROM [Adventure Works DW]
- SELECT KPIStatus(“Reseller Sales”) ON COLUMNS FROM [Adventure Works DW]
- SELECT KPIs(“Reseller Sales”).KPIStatus ON COLUMNS FROM [Adventure Works DW]
- SELECT Status.KPI(Reseller Sales) ON COLUMNS FROM [Adventure Works DW]
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?
- Drill-through action
- Reporting action
- URL action
- Rowset action
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
- Hybrid OLAP (HOLAP)
- Let the server decide
- Multidimensional OLAP (MOLAP)
- Relational OLAP (ROLAP)
63) Analysis Services does not provide a way to sort dimension members in DESCending order
- TRUE
- FALSE
64) Which of these is a default Measure in AS 2005?
- NULL default measure
- No Default Measure
- Semi-Additive Measures
- None of the above.
65) What is the ideal limit of aggregation designs in a measure group to help improve the performance?
- 5
- 4
- 3
- 6
66) What is the ideal limit of aggregations that can be designed for a partition?
- 500
- 100
- 300
- 700
67) How do I clear Analysis Services (SSAS) database cache?
- The Process of clearing the SSAS Database cache is done automatically at frequent intervals.
- Use an XMLA command to clear the cache.
- Any of the above.
- a or b
68) A data warehouse is which of the following?
- Can be updated by end users.
- Contains numerous naming conventions and formats.
- Organized around important subject areas.
- Contains only current data.
69) An operational system is
- A system that is used to run the business in real time and is based on historical data.
- A system that is used to run the business in real time and is based on current data.
- A system that is used to support decision making and is based on current data.
- A system that is used to support decision making and is based on current data.
70) Which of the following is part of generic two-level datawarehouse architecture
- At least one data mart
- Data that can extracted from numerous internal and external sources
- Near real-time updates
- All of the above.
71) Data scrubbing is which of the following?
- A process to reject data from the data warehouse and to create the necessary indexes
- A process to load the data in the data warehouse and to create the necessary indexes
- A process to upgrade the quality of data after it is moved into a data warehouse
- A process to upgrade the quality of data before it is moved into a data warehouse
72) A snowflake schema is which of the following types of tables?
- Fact
- Dimension
- Helper
- All of the above
73) A goal of data mining includes which of the following?
- To explain some observed event or condition
- To confirm that data exists
- To analyze data for expected relationships
- To create a new data warehouse
74) Fact tables are
- Completely demoralized
- Partially demoralized
- Completely normalized
- Partially normalized
75) A star schema has what type of relationship between a dimension and fact table?
- Many-to-many
- One-to-one
- One-to-many
- All of the above.
76) Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores.
- TRUE
- FALSE
77) The Keys used to join the fact table with a dimension table is?
- Primary Key
- Surrogate Key
- Candidate Key
- None of the above.
78) What is load index?
- A process to reject data from the data warehouse and to create the necessary indexes
- A process to load the data in the data warehouse and to create the necessary indexes
- A process to upgrade the quality of data after it is moved into a data warehouse
- A process to upgrade the quality of data before it is moved into a data warehouse
79) “Count” function in the calculation comes under?
- Value Function
- KPI Function
- Set Function
- Statistical Function
80) The chief Component of OLAP in SSAS is the?
- Olap Server
- DBMS
- Client
- Analysis Server
81) KPI Stands for?
- Key performance identification
- Key Point Identification
- Key performance indicator
- Key point Indicator
82) Hierarchies can be defined by?
- dimension table
- fact table
- dimensional attributes
- fact attributes
83) SCD stands for
- Service changing dimension
- Service changing delivery
- Slowly changing delivery
- Slowly changing dimension
84) Which of the following OLAP storage methods usually have poor reporting performance.
- MOLAP
- HOLAP
- ROLAP
- Both (a) and (b)
85) What is the most commonly used tool to analyze SSAS Cube data?
- PPS
- SSRS
- Excel
- None of the Above
86) What is data mart?
- A superset of data warehouse and focus on single subject area
- A subset of data warehouse and focus on single subject area
- A set of OLTP databases
- None of the above
87) Which of the following is the basic unit of storage and analysis in Analysis Services.
- Dimension
- Measure
- Cube
- Level
88) In which mode MOLAP store the data?
- File Mode
- Database Mode
- Both A & B
- None of The Above
89) In which mode HOLAP store the data?
- Database Mode
- File Mode
- Both A and B
- None of The Above
90) OLAP applications differ from OLTP applications
- The way that they store data
- The way that they analyze data
- The way that they present data to the
- end-user.
- All o the above