MSBI SSAS Exam Quiz: MCQ!

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Akshay Mishra

Akshay Mishra, Business Intelligence

Akshya, a dedicated Business Intelligence enthusiast, leverages 8 years of experience to drive data-driven decision-making with passion and expertise.

Quizzes Created: 2 | Total Attempts: 8,280

| Attempts: 2,739

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

1/165 Questions

Which operation of OLAP provides alternate presentation of data by rotating it?
- Slice
- Roll up
- Dice
- Pivot

About This Quiz

The MSBI SSAS Exam Quiz assesses knowledge in Microsoft Business Intelligence (MSBI) focusing on SSAS. It covers key concepts like OLAP operations, data models, and performance optimization, essential for professionals in data analysis and business intelligence.

Quiz Preview

2.

Dice operation is also known as rotate.
- True
- False
Correct Answer

A. False

Explanation

The statement "Dice operation is also known as rotate" is false. The term "dice operation" refers to the process of rolling a dice, not rotating it.

Rate this question:
3.

It is because of ________________ that enables OLAP to achieve great performance for a query.
- Aggeregation
- Composition
- Dice
- Hybrid
Correct Answer

A. Aggeregation

Explanation

Aggregation is the correct answer because it is the process of combining and summarizing data in OLAP (Online Analytical Processing) to provide faster and more efficient query performance. By aggregating data, OLAP systems can reduce the amount of data that needs to be processed, resulting in improved query response times. Aggregation allows OLAP to achieve great performance by pre-calculating and storing summarized data, enabling quicker retrieval and analysis of large datasets.

Rate this question:
4.

What is the source of the OLAP cube’s metadata?
- Star schema
- Snow flake schema
- None of these
- Database
Correct Answer(s)

A. Star schema
A. Snow flake schema

Explanation

The source of the OLAP cube's metadata can be either a star schema or a snowflake schema. Both of these schema designs are commonly used in data warehousing and OLAP systems. A star schema is a simpler design where the fact table is connected directly to multiple dimension tables, while a snowflake schema is a more normalized design where the dimension tables are further normalized into smaller tables. Both schema designs are used to organize and structure the data in the OLAP cube, providing the necessary metadata for analysis and reporting.

Rate this question:
5.

Which type of data models are used by databases configured for OLAP?
- Multidimensional
- Single dimensional
- Two dimensional
- Three dimensional
Correct Answer

A. Multidimensional

Explanation

Databases configured for OLAP (Online Analytical Processing) use multidimensional data models. These models allow for the analysis of data from multiple dimensions or perspectives, such as time, geography, and product. By organizing data in a multidimensional structure, OLAP databases can efficiently perform complex queries and aggregations, enabling users to gain insights and make informed decisions. Single dimensional, two dimensional, and three dimensional data models are not specifically designed for OLAP and may not provide the necessary flexibility and performance for analytical processing.

Rate this question:
6.

MOLAP databases generally give better performance?
- True
- False
Correct Answer

A. True

Explanation

MOLAP databases generally give better performance because they store data in a multidimensional cube format, which allows for faster query processing and analysis. This format enables efficient aggregation and calculation of data across multiple dimensions, resulting in quicker response times for complex queries. Additionally, MOLAP databases often have built-in caching mechanisms and optimized algorithms for data retrieval and storage, further enhancing their performance compared to other database types like ROLAP or HOLAP.

Rate this question:
7.

Which property for objects in the data source view is used to increase the user-friendliness of their name?
- FriendlyName
- Name
- Friendly_Name
- FriendN
Correct Answer

A. FriendlyName

Explanation

The property "FriendlyName" is used to increase the user-friendliness of the objects' names in the data source view. By setting the "FriendlyName" property, the objects can be given more descriptive and intuitive names that are easier for users to understand and work with. This helps to enhance the overall usability and user experience of the data source view.

Rate this question:
8.

Aggregations are built from the _________________ by changing the granularity on specific dimensions
- None of these
- Schema
- Dimension table
- Fact table
Correct Answer

A. Fact table

Explanation

Aggregations are built from the Fact table by changing the granularity on specific dimensions. The Fact table contains the raw data at the most granular level, while the Dimension table provides additional context and attributes for the data. By changing the granularity on specific dimensions, such as grouping data by time periods or other relevant attributes, aggregations can be created to summarize and analyze the data at different levels of detail. Therefore, the Fact table is the correct answer as it is the source from which aggregations are built.

Rate this question:
9.

The output of an OLAP query is displayed as a
- Matrix
- Pivot
- Matrix & Pivot
- Excel
Correct Answer

A. Matrix & Pivot

Explanation

The output of an OLAP query can be displayed as a matrix or a pivot. A matrix is a tabular representation of data where rows and columns intersect to show the values. A pivot, on the other hand, is a way to summarize and manipulate data by rotating rows into columns or columns into rows. Both matrix and pivot are common formats for presenting OLAP query results, depending on the specific requirements and preferences of the user. Excel, while it can be used to display OLAP query results, is not the only option and may not be the best choice in all cases.

Rate this question:
10.

The Analysis Services Processing task can process only analytic objects created by using the SQL Server tools?
- True
- False
Correct Answer

A. True

Explanation

The Analysis Services Processing task can only process analytic objects created by using the SQL Server tools. This means that any other type of analytic object created using different tools or methods will not be compatible with the processing task. Therefore, the statement "True" is correct.

Rate this question:
11.

Which of the following should be kept in mind for a task?
- Task names must be unique.
- Task should be within a package
- None of these
- Task names should be alpha numeric
Correct Answer(s)

A. Task names must be unique.
A. Task should be within a package

Explanation

When performing a task, it is important to keep in mind that the task names must be unique. This means that no two tasks can have the same name. Additionally, the task should be within a package. This ensures that the task is organized and grouped together with related tasks. By following these guidelines, it helps to avoid confusion and maintain a structured system for task management.

Rate this question:
12.

The user can perform data-entry or editing tasks on OLAP data?
- True
- False
Correct Answer

A. False

Explanation

False. The user cannot perform data-entry or editing tasks on OLAP data. OLAP (Online Analytical Processing) is a technology used for analyzing and manipulating large volumes of data from multiple dimensions. It is primarily used for data analysis and reporting purposes rather than data entry or editing. OLAP systems are designed to provide fast and efficient access to pre-aggregated data, allowing users to slice, dice, and drill down into the data for analysis and decision-making. However, they do not provide capabilities for directly entering or modifying data.

Rate this question:
13.

What are the applications of OLAP?
- Business reporting for sales, marketing
- Budgeting
- Forecasting
- All of the above
Correct Answer

A. All of the above

Explanation

OLAP, or Online Analytical Processing, has various applications in business. It is commonly used for business reporting in areas such as sales and marketing, providing valuable insights and analysis. Additionally, OLAP is useful for budgeting purposes, allowing organizations to efficiently allocate resources and plan their finances. Furthermore, OLAP can be applied to forecasting, helping businesses make accurate predictions and projections based on historical data. Therefore, all of the mentioned applications are valid uses of OLAP technology.

Rate this question:
14.

What is the use of Analysis Services Execute DDL task?
- Create, drop, or alter mining models
- Assign permissions and roles
- Create, drop, or alter cubes and dimensions
- None of these
Correct Answer(s)

A. Create, drop, or alter mining models
A. Create, drop, or alter cubes and dimensions

Explanation

The Analysis Services Execute DDL task is used to create, drop, or alter mining models as well as create, drop, or alter cubes and dimensions. This task allows for the management and modification of data mining models and multidimensional structures within Analysis Services. It provides the ability to perform these actions programmatically and automate the process, making it easier to manage and update the models and structures as needed.

Rate this question:
15.

Which of the following attributes can be accessed using a database object?
- Cubes
- Roles
- Cubes & Roles
- Few data sources
Correct Answer

A. Cubes & Roles

Explanation

A database object can be used to access both cubes and roles. Cubes are used in multidimensional databases to store and analyze data, while roles are used to manage user access and permissions within the database. By accessing these attributes through a database object, users can interact with and manipulate the data stored in cubes and manage user permissions through roles.

Rate this question:
16.

The instance of Analysis Services can contain multiple databases?
- True
- False
Correct Answer

A. True

Explanation

In Analysis Services, an instance can indeed contain multiple databases. This allows for the organization and management of different sets of data within a single instance. Each database can have its own set of cubes, dimensions, measures, and other objects, providing flexibility and scalability in data analysis and reporting. This feature enables users to efficiently handle and analyze large amounts of data across various databases within a single Analysis Services instance.

Rate this question:
17.

Which of the following is true for a cube role?
- Cube role applies to only that cube
- A cube role contains additional options such as cell security
- None of these
- Cube role applies to that cube and the dependant cubes.
Correct Answer(s)

A. Cube role applies to only that cube
A. A cube role contains additional options such as cell security

Explanation

A cube role applies to only that cube means that the role is specific and limited to a single cube. It does not have any impact or authority over other cubes in the database. On the other hand, a cube role contains additional options such as cell security, which suggests that the role has the ability to control and restrict access to specific cells within the cube. This provides an extra layer of security and control for the cube and its data.

Rate this question:
18.

The Analysis Services Processing task can be used to process which of the following objects?
- Cubes
- Dimensions
- Mining models
- All of the above
Correct Answer

A. All of the above

Explanation

The Analysis Services Processing task in SQL Server Integration Services (SSIS) can be used to process Cubes, dimensions, and mining models. This task allows for the automation of processing these objects, which involves tasks such as loading data into the objects, building aggregations, and updating metadata. By selecting "All of the above" as the answer, it indicates that the Analysis Services Processing task can be used to process all of these objects simultaneously.

Rate this question:
19.

CALCULATE statement is used to populate each cell in the cube with aggregated data.
- True
- False
Correct Answer

A. True

Explanation

The CALCULATE statement is indeed used to populate each cell in the cube with aggregated data. This statement allows for the calculation of values based on specified criteria, such as filters or conditions. By using the CALCULATE statement, aggregated data can be derived and populated in each cell of the cube, providing a comprehensive view of the data. Therefore, the given answer, True, is correct.

Rate this question:
20.

What is sparsity?
- A condition when each cell of the cube is filled with data and that leads to more processing time.
- A condition when each cell of the cube is not filled with data and that leads to less processing time.
- A condition when each cell of the cube is not filled with data and that leads to more processing time.
- A condition when each cell of the cube is not filled with data.
Correct Answer

A. A condition when each cell of the cube is not filled with data and that leads to more processing time.

Explanation

Sparsity refers to a condition when each cell of the cube is not filled with data. This means that there are empty or missing values in the cube. When the cube is sparse, it can lead to more processing time because the system needs to handle the empty cells and make calculations or aggregations based on the available data. The presence of empty cells adds complexity to the processing, resulting in increased processing time.

Rate this question:
21.

Which of the following below is/are OLAP vendors?
- Cognos
- Infor
- Oracle corporation
- All of the above
Correct Answer

A. All of the above

Explanation

The given answer, "All of the above," is correct because all three options listed - Cognos, Infor, and Oracle Corporation - are indeed OLAP vendors. OLAP stands for Online Analytical Processing, which refers to the technology used for organizing and analyzing large volumes of data from multiple sources. Cognos, Infor, and Oracle Corporation are well-known vendors in the field of OLAP, providing software and solutions for data analysis and reporting purposes.

Rate this question:
22.

____________________operation of OLAP involves computing all of the data relationships for one or more dimensions
- Slice
- Roll up
- Dice
- Pivot
Correct Answer

A. Roll up

Explanation

Roll up is the correct answer because it refers to the operation of OLAP that involves computing all of the data relationships for one or more dimensions. In roll up, data is aggregated or summarized from a lower level of detail to a higher level of detail. It allows users to view data at different levels of granularity and helps in analyzing trends and patterns in the data.

Rate this question:
23.

Property expressions update the values of properties when the _____________ is run
- Task
- Expression
- Report
- Package
Correct Answer

A. Package

Explanation

Property expressions update the values of properties when the package is run.

Rate this question:
24.

What is Microsoft SQL Server 2005 Analysis Services used for?
- Delivers online analytical processing (OLAP).
- Delivers data mining functionality
- Used for extracting and storing data which allows easier reporting
- None of these
Correct Answer(s)

A. Delivers online analytical processing (OLAP).
A. Delivers data mining functionality

Explanation

Microsoft SQL Server 2005 Analysis Services is used for delivering online analytical processing (OLAP) and data mining functionality. OLAP allows users to analyze large amounts of data from multiple dimensions, providing insights and supporting decision-making. Data mining functionality enables users to discover patterns, correlations, and trends in data, helping to identify hidden relationships and make predictions. Therefore, this tool is used for both OLAP and data mining purposes.

Rate this question:

0
25.

What is the purpose of ReadContingent access right?
- Allows members of the role to read from the object
- Allows members of the role to read a cell value only if the user can access all the cells from which the value is derived
- Provides Read access for any cells specified by this permission that are not derived from other cells
- None of these
Correct Answer(s)

A. Allows members of the role to read a cell value only if the user can access all the cells from which the value is derived
A. Provides Read access for any cells specified by this permission that are not derived from other cells

Explanation

The purpose of the ReadContingent access right is to allow members of the role to read a cell value only if the user can access all the cells from which the value is derived. This access right ensures that the user has the necessary permissions to access all the required data in order to read the cell value. Additionally, it also provides Read access for any cells specified by this permission that are not derived from other cells, allowing the user to read those specific cells as well.

Rate this question:
26.

What is the typical fashion of processing a task?
- Typically, you process dimension tables before processing fact tables
- Typically, you process fact tables before dimension fact tables
- Either of two
- Both can be processed simultaneously
Correct Answer

A. Typically, you process dimension tables before processing fact tables

Explanation

In data warehousing, dimension tables contain descriptive attributes that provide context to the data in the fact tables. These attributes are used to categorize and filter the data. Processing dimension tables first ensures that the necessary context is available when processing the fact tables. By processing dimension tables before fact tables, you can establish the necessary relationships and hierarchies between the data elements, enabling accurate analysis and reporting. Therefore, it is typical to process dimension tables before processing fact tables.

Rate this question:
27.

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a production server. The database contains a cube.You add new functionality to the cube on a development server. You need to deploy the new functionalityfrom the development server to the production server by ensuring that the effect on the users is minimized.What should you do?
- Use the Synchronize Database Wizard.
- Detach the production database. Copy the appropriate files to the production server, and then attach the database on the production server.
- Modify the Target Server property to the production server by using Business Intelligence Development Studio (BIDS). Deploy the solution.
- Copy the appropriate files from the development server to the production server.
Correct Answer

A. Use the Synchronize Database Wizard.

Explanation

The Synchronize Database Wizard is the best option for deploying changes to the production server while minimizing the impact on users. This wizard allows you to synchronize the development and production databases, transferring only the necessary changes. Detaching and copying files or modifying the Target Server property may require more manual steps and can potentially disrupt the users' access to the cube. Simply copying files from the development server to the production server may not properly handle all the necessary changes and dependencies.

Rate this question:
28.

You are developing a SQL Server 2008 Analysis Server (SSAS) method which includes a measure group called TestGroup with a one partition for Company.com.The condition listed below should be included:
- You should configure Real-time hybrid online analytical processing (HOLAP)
- You should configure Real-time relational offline analytical processing (ROLAP).
- You should configure scheduled relational offline analytical processing (ROLAP).
- You should configure scheduled online processing (MOLAP).
Correct Answer

A. You should configure Real-time hybrid online analytical processing (HOLAP)
29.

You are creating a Microsoft SQL Server 2005 Analysis Services (SSAS) project for Company.com. In order to move database from Analysis Services 2000 to Analysis Services 2008, which is the correct answer?
- You should close a new SSAS project by using Business Intelligence Development Studio (BIDS). Rightclick Project. Click the Add option, and then click the Existing Item option
- You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server 2005 Reporting Services (SSRS). Right-click Instance in Object Explorer, and then click the
- You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server 2005 Integration Services (SSIS). Right-click Instance in Object Explorer, and then click the
- You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server Management Studio (SSMS). Right-click Instance in Object Explorer, and then click the Migrate
Correct Answer

A. You should link to the SQL Server 2008 SSAS instance by using Microsoft SQL Server Management Studio (SSMS). Right-click Instance in Object Explorer, and then click the Migrate
30.

You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There is a table called Product which includes listed columns below:* ProductKey* Logger* ProductNumberFirstly you develop a dimension called DimProductOrders from the Product table, and then configure the ProductKey as a key column and the Logger column as a property. At last you create a measure group called FactProductOrders from the Product table. You should make sure that you could develop a dimension relationship . Then you could make ProductNumber column gathered by the Logger column.Which is the correct answer?
- Between the DimProductOrders dimension and the ProductNumber measure group, you should develop a virtual dimension relationship.
- Between the DimProductOrders dimension and the ProductNumber measure group, you should develop a fact dimension relationship.
- Between the DimProductOrders dimension and the ProductKey measure group, you should develop a fact dimension relationship.
- Before configuring the Granularity attribute to ProductKey and the measure group columns to ProductNumber, you should you should develop a fact dimension relationship.
Correct Answer

A. Between the DimProductOrders dimension and the ProductNumber measure group, you should develop a fact dimension relationship.

Explanation

The correct answer is "Between the DimProductOrders dimension and the ProductNumber measure group, you should develop a fact dimension relationship." This means that a relationship should be established between the dimension table (DimProductOrders) and the measure group table (ProductNumber) using a fact dimension relationship. This relationship allows for the aggregation of data from the dimension table to be used in calculations with the measures in the measure group.

Rate this question:
31.

You are creating a SQL Server 2008 Analysis Services (SSAS) database which contains some measure groups for Company.com.One of measure groups Product Data allows refresh Than others' frequently. You should make sure that Product Data measure group would operate on a schedule managed through SSAS.Which is the correct answer?
- You should change the attribute of the ProactiveCaching property.
- You should change the attribute of the DataAggregation property.
- You should change the attribute of the ProcessingMode property.
- You should change the attribute of the ProcessingPriority property.
Correct Answer

A. You should change the attribute of the ProactiveCaching property.

Explanation

The correct answer is to change the attribute of the ProactiveCaching property. This property allows you to schedule the refresh of the measure group on a regular basis, ensuring that the Product Data measure group is refreshed more frequently than others. By setting a schedule for proactive caching, you can manage the refresh of the measure group through SSAS. This ensures that the data in the measure group is always up to date and available for analysis.

Rate this question:
32.

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. A sales manager called Clerk is responsible for the sales of bikes in the Northeast region. You decide to give some rights to the rights to Clerk to visit the database. You won two roles below called Northeast Region and Bikes.Their schemas are listed below:You have make The Visual Totals properties attribute true for roles above. You should make sure that Clerk could browser the workers in the Product dimension which link to the Bikes category in the Northeast region.Which is the correct answer?
- You should increase Clerk to a Bikes role
- You should increase Clerk to the Northeast Region role.
- [Product Category].[Bikes]} as the permitted
- You should increase Clerk to the default Region role.
Correct Answer

A. [Product Category].[Bikes]} as the permitted

Explanation

Increase Clerk to the Bikes role.

Rate this question:

0
33.

38You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a Sale dimension that includes the Category and Subcategory properties for Company.com.There is a rigid relationship type for properties.The data source for the Sale dimension alters the relationship between the Type and Sub Type values.You should make sure that you could run an XML to operate the dimension to reflect the change normally for Analysis (XMLA).Which is the correct answer?
- You should utilize the ProcessDefault command.
- You should utilize the ProcessClear command.
- You should utilize the ProcessIndexes command.
- You should utilize the ProcessDefault and the ProcessClear commands.
Correct Answer

A. You should utilize the ProcessDefault and the ProcessClear commands.

Explanation

The correct answer is to utilize the ProcessDefault and the ProcessClear commands. This is because the data source for the Sale dimension alters the relationship between the Type and Sub Type values, and to reflect this change normally for Analysis (XMLA), both the ProcessDefault and ProcessClear commands need to be used. The ProcessDefault command will process the dimension using the default settings, while the ProcessClear command will clear any existing data in the dimension before processing it. By using both commands, the dimension can be updated correctly to reflect the changes in the data source.

Rate this question:
34.

You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard you should make query logging enable. Which is the correct answer?
- You should make the QueryLogSampling server attribute default value.
- You should make the QueryLogSampling server attribute
- You should configure the server property of DefaultFolders
- You should configure the QueryLogConnectionString server attribute and set a valid connection string.
Correct Answer

A. You should configure the QueryLogConnectionString server attribute and set a valid connection string.

Explanation

The correct answer is to configure the QueryLogConnectionString server attribute and set a valid connection string. This is because in order to execute the Usage-Based Optimization Wizard, query logging needs to be enabled. This can be done by configuring the QueryLogConnectionString server attribute and providing a valid connection string.

Rate this question:
35.

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. You get the Duplicate Key error when you operate the Analysis Services database. You should alter the ErrorConfiguration attribute in order to make processing run normally.Which is the correct answer?
- You should alter the Dynamic Management View (DMV)
- You should alter the Local Group
- You should alter the dimension
- You should alter the Transactions Log
Correct Answer

A. You should alter the dimension
36.

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method.In order to solve the problem, which is the correct answer?
- You should utilize ProcessAdd for Analysis (XMLA) command
- You should utilize default command for Analysis (XMLA)
- You should utilize ProcessNone for Analysis (XMLA)
- You should utilize ProcessView for Analysis (XMLA) command
Correct Answer

A. You should utilize ProcessAdd for Analysis (XMLA) command

Explanation

The correct answer is "You should utilize ProcessAdd for Analysis (XMLA) command". This is because the question states that the goal is to update data in a partition each hour, and the ProcessAdd method is specifically designed to add new data to an existing partition without affecting the existing data. This method is efficient for incremental updates and will ensure that only the new data is processed, reducing processing time and resource usage.

Rate this question:
37.

42You are managing a SQL Server 2008 Analysis Services (SSAS) instance which includes a database for Company.com.You alter the DataDir attribute of the instance to a new folder. You should make sure that instance utilizes the new folder in least time.Which is the correct answer?
- You should operate the database.
- You should operate the database at the same time.
- You should stop the Analysis Services service.
- Before stopping the Analysis Services service you should remove the files in the original folder
Correct Answer

A. You should operate the database.

Explanation

To ensure that the SQL Server 2008 Analysis Services (SSAS) instance utilizes the new folder in the least amount of time, you should operate the database. This means that you should continue running queries and performing operations on the database while the DataDir attribute is being altered. By doing so, the instance can immediately start utilizing the new folder for storing and retrieving data without any interruption or downtime.

Rate this question:
38.

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Through utilizing SQL Profiler, you decide to troubleshoot search function. You should make sure that it will cost a lot of time to query.Which is the correct answer?
- You should utilize store procedure.
- You should utilize Query Subcube
- You should utilize a Dynamic Management View (DMV)
- You should utilize Transactions Log.
Correct Answer

A. You should utilize Query Subcube

Explanation

Using Query Subcube in SQL Server Analysis Services allows you to retrieve a subset of data from a cube instead of retrieving the entire cube. This can help in improving performance and reducing the time it takes to execute the query. By specifying the dimensions and measures that are required for the search function, unnecessary data can be excluded, resulting in faster query execution.

Rate this question:
39.

You create a SQL Server 2008 Analysis Services (SSAS) solution.You create a dimension named Customer. The Customer dimension has the attributes named Country and State.The Country attribute has the following components:
- Set the OrderBy property to Name and the OrderByAttribute property to Country for the State attribute.
- Set the OrderBy property to AttributeName and the OrderByAttribute property to Country for the State attribute.
- Set the OrderBy property to Key and the OrderByAttribute property to Country for the State
- Set the OrderBy property to AttributeKey and the OrderByAttribute property to Country for the State attribute
Correct Answer

A. Set the OrderBy property to AttributeName and the OrderByAttribute property to Country for the State attribute.

Explanation

The correct answer is to set the OrderBy property to AttributeName and the OrderByAttribute property to Country for the State attribute. This means that the State attribute will be sorted alphabetically by the attribute name (i.e. the state name) within each Country. This is the most logical and common way to order the states within each country in a dimension.

Rate this question:
40.

You create the dimensions as shown in the following table.The CustKey attribute is used as a column in a table named FactSales.You need to create a referenced dimension that allows you to browse the measures of the FactSales table by using the DimGeography dimension.What should you do?
- Set the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as CustKey.
- Set the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as GeoKey.
- Set the reference dimension to DimCustomer by using a referenced dimension attribute as CustKey and an intermediate dimension attribute as GeoKey.
- Set the reference dimension to DimCustomer by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as GeoKey.
Correct Answer

A. Set the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as GeoKey.

Explanation

The correct answer is to set the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey and an intermediate dimension attribute as GeoKey. This means that the DimGeography dimension will be used as a reference dimension for browsing the measures of the FactSales table. The GeoKey attribute will be used as the referenced dimension attribute, which links the FactSales table to the DimGeography dimension. Additionally, an intermediate dimension attribute, also named GeoKey, will be used to establish the relationship between the FactSales table and the DimGeography dimension.

Rate this question:
41.

You create a SQL Server 2008 Analysis Services (SSAS) solution.You add a data source view (DSV) to the solution. The DSV has a table named Employee that includes the following columns
- A. Create a Named Calculation that uses EmployeeKey and ManagerKey
- Create a relationship by using EmployeeKey as the source column and ManagerKey as the destination column.
- Create a Named Query that uses a relationship with EmployeeKey as the source column and ManagerKey as the destination column.
- Create a relationship by using ManagerKey as the source column and EmployeeKey as the destination column.
Correct Answer

A. Create a relationship by using ManagerKey as the source column and EmployeeKey as the destination column.

Explanation

The correct answer is to create a relationship by using ManagerKey as the source column and EmployeeKey as the destination column. This means that the ManagerKey column in the Employee table will be used to establish a relationship with the EmployeeKey column in another table. This relationship will allow for analysis and querying of data based on the hierarchical relationship between employees and their managers.

Rate this question:
42.

You create a SQL Server 2008 Analysis Services (SSAS) solution.The solution contains a time dimension named DimTime. You have a table named FactSales that contains the two columns named OrderDate and ShipDate. The two columns refer to the DimTime dimension.You need to ensure that the DimTime dimension can be used to browse through measures in the FactSales table for both OrderDate and ShipDate.What should you do?
- Create a reference relationship between the DimTime dimension and the FactSales measure group.
- Create a many-to-many relationship between the DimTime dimension and the FactSales measure group.
- Create two regular relationships between the DimTime dimension and the FactSales measure group. Use identical measure group columns.
- Create two regular relationships between the DimTime dimension and the FactSales measure group. Use different measure group columns.
Correct Answer

A. Create two regular relationships between the DimTime dimension and the FactSales measure group. Use different measure group columns.

Explanation

Creating two regular relationships between the DimTime dimension and the FactSales measure group, using different measure group columns, allows the DimTime dimension to be used to browse through measures in the FactSales table for both OrderDate and ShipDate. This means that users can analyze sales data based on either the order date or the ship date, using the same DimTime dimension. By using different measure group columns, the relationships are established correctly, ensuring accurate analysis and browsing capabilities.

Rate this question:
43.

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a key performance indicator (KPI) named GPMargin for your solution. You set the Value expression of the KPI in the following manner.You need to set a Trend expression of the KPI to show a difference in the values compared with the previous quarter. Which MDX code segment should you insert at line 02?
- KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" )
- KPITrend( "GPMargin" ) > ( KPIValue ( "GPMargin" )
- KPIStatus( "GPMargin" ) > ( KPIValue( "GPMargin" )
- KPIGoal( "GPMargin" ) > ( KPIValue( "GPMargin" )
Correct Answer

A. KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" )

Explanation

The correct answer is "KPIValue( "GPMargin" ) > ( KPIValue( "GPMargin" )". This expression compares the current value of the KPI (GPMargin) with the previous value, indicating a difference in values compared to the previous quarter.

Rate this question:
44.

Which of following statements clearly defines the Database dimension and Cube dimension? 1. The Database dimension has only Name and ID properties, whereas a Cube dimension has several more properties.2. Database dimension is created once where as Cube dimension is referenced from database dimension.3. Database dimension exists only once, where as Cube dimensions can be created more than once using ROLE PLAYING Dimensions concept.
- Statements 1,2&3 are correct
- Statements 2&3 are correct
- Statements 1& 2 are correct
- Statements 1,2&3 are wrong
Correct Answer

A. Statements 1,2&3 are correct

Explanation

The explanation for the given correct answer is that all three statements accurately define the differences between the Database dimension and the Cube dimension. Statement 1 states that the Database dimension only has Name and ID properties, while the Cube dimension has several more properties. Statement 2 explains that the Database dimension is created once, while the Cube dimension is referenced from the Database dimension. Statement 3 clarifies that the Database dimension exists only once, whereas Cube dimensions can be created multiple times using the concept of ROLE PLAYING Dimensions. Therefore, all three statements are correct in defining the distinctions between the two dimensions.

Rate this question:
45.

Carefully read the question and answer accordingly.In which scenario, you would like to go for materializing dimension?Statement 1: To increase the speedStatement 2: To decrease memory sizeStatement 3: Less Coding
- Statement 3 only
- Statement 2 only
- Statement 1 only
- Statement 1& 3 only
Correct Answer

A. Statement 1 only

Explanation

Materializing dimension refers to the process of storing pre-calculated results of a dimension in order to improve query performance. In this scenario, choosing to materialize dimensions would be beneficial if the main objective is to increase the speed of queries. Therefore, the correct answer is "Statement 1 only".

Rate this question:
46.

How will you make an attribute not to process?
- By setting the property: AttributeHierarchyEnabled = False
- All of the listed options
- By setting the property: IsAggregatable = False
- By setting the property: AttributeHierarchyVisible = False
Correct Answer

A. By setting the property: AttributeHierarchyEnabled = False

Explanation

By setting the property "AttributeHierarchyEnabled = False", the attribute will not be processed. This means that it will not be used in any calculations or aggregations. This property specifically controls whether the attribute can be used in the attribute hierarchy of a dimension.

Rate this question:
47.

Which of the below are Common types of Hierarchies in SSAS?
- Natural Hierarchy
- Ragged Hierarchy
- Unbalanced Hierarchy
- Balanced Hierarchy
Correct Answer(s)

A. Natural Hierarchy
A. Ragged Hierarchy
A. Unbalanced Hierarchy
A. Balanced Hierarchy

Explanation

The common types of hierarchies in SSAS include natural hierarchy, ragged hierarchy, unbalanced hierarchy, and balanced hierarchy. Natural hierarchy refers to a hierarchy that follows a logical and intuitive order, such as a hierarchy of dates or geographical locations. Ragged hierarchy is a type of hierarchy where some levels have a different number of members, resulting in uneven branching. Unbalanced hierarchy refers to a hierarchy where the number of members at each level varies significantly. Balanced hierarchy is a type of hierarchy where each level has an equal number of members.

Rate this question:
48.

How many types of dimensions are there in SSAS ?
- 6
- 3
- 4
- 5
Correct Answer

A. 6

Explanation

There are six types of dimensions in SSAS. These include regular dimensions, referenced dimensions, role-playing dimensions, writeback dimensions, virtual dimensions, and many-to-many dimensions. Each type of dimension serves a specific purpose and can be used to organize and analyze data in different ways within SSAS.

Rate this question:
49.

It is possible to generate a data dictionary for the given CUBE in SSAS.
- True
- False
Correct Answer

A. True

Explanation

A data dictionary is a centralized repository of information about data elements, such as their definition, format, and relationships with other data elements. In SSAS (SQL Server Analysis Services), a CUBE is a multidimensional database structure used for data analysis and reporting. Since a CUBE contains data elements and their relationships, it is possible to generate a data dictionary for the given CUBE in SSAS. This can provide valuable insights into the structure and meaning of the data stored in the CUBE, making it easier for users to understand and work with the data.

Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 21, 2023

Quiz Edited by
ProProfs Editorial Team
Mar 08, 2016

Quiz Created by
Akshay Mishra

MSBI SSAS Exam Quiz: MCQ!

Which operation of OLAP provides alternate presentation of data by rotating it?

Quiz Preview

Dice operation is also known as rotate.

It is because of ________________ that enables OLAP to achieve great performance for a query.

What is the source of the OLAP cube’s metadata?

Which type of data models are used by databases configured for OLAP?

MOLAP databases generally give better performance?

Which property for objects in the data source view is used to increase the user-friendliness of their name?

Aggregations are built from the _________________ by changing the granularity on specific dimensions

The output of an OLAP query is displayed as a

The Analysis Services Processing task can process only analytic objects created by using the SQL Server tools?

Which of the following should be kept in mind for a task?

The user can perform data-entry or editing tasks on OLAP data?

What are the applications of OLAP?

What is the use of Analysis Services Execute DDL task?

Which of the following attributes can be accessed using a database object?

The instance of Analysis Services can contain multiple databases?

Which of the following is true for a cube role?

The Analysis Services Processing task can be used to process which of the following objects?

CALCULATE statement is used to populate each cell in the cube with aggregated data.

What is sparsity?

Which of the following below is/are OLAP vendors?

____________________operation of OLAP involves computing all of the data relationships for one or more dimensions

Property expressions update the values of properties when the _____________ is run

What is Microsoft SQL Server 2005 Analysis Services used for?

What is the purpose of ReadContingent access right?

What is the typical fashion of processing a task?

You are developing a SQL Server 2008 Analysis Server (SSAS) method which includes a measure group called TestGroup with a one partition for Company.com.The condition listed below should be included:

You are creating a Microsoft SQL Server 2005 Analysis Services (SSAS) project for Company.com. In order to move database from Analysis Services 2000 to Analysis Services 2008, which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard you should make query logging enable. Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. You get the Duplicate Key error when you operate the Analysis Services database. You should alter the ErrorConfiguration attribute in order to make processing run normally.Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method.In order to solve the problem, which is the correct answer?

42You are managing a SQL Server 2008 Analysis Services (SSAS) instance which includes a database for Company.com.You alter the DataDir attribute of the instance to a new folder. You should make sure that instance utilizes the new folder in least time.Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Through utilizing SQL Profiler, you decide to troubleshoot search function. You should make sure that it will cost a lot of time to query.Which is the correct answer?

You create a SQL Server 2008 Analysis Services (SSAS) solution.You create a dimension named Customer. The Customer dimension has the attributes named Country and State.The Country attribute has the following components:

You create the dimensions as shown in the following table.The CustKey attribute is used as a column in a table named FactSales.You need to create a referenced dimension that allows you to browse the measures of the FactSales table by using the DimGeography dimension.What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution.You add a data source view (DSV) to the solution. The DSV has a table named Employee that includes the following columns

Carefully read the question and answer accordingly.In which scenario, you would like to go for materializing dimension?Statement 1: To increase the speedStatement 2: To decrease memory sizeStatement 3: Less Coding

How will you make an attribute not to process?

Which of the below are Common types of Hierarchies in SSAS?

How many types of dimensions are there in SSAS ?

It is possible to generate a data dictionary for the given CUBE in SSAS.