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,281
| Attempts: 2,747
SettingsSettings
Please wait...
  • 1/165 Questions

    MOLAP databases generally give better performance?

    • True
    • False
Please wait...
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.

MSBI SSAS Exam Quiz: MCQ! - Quiz

Quiz Preview

  • 2. 

    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:

  • 3. 

    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:

  • 4. 

    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:

  • 5. 

    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:

  • 6. 

    HOLAP storage mode is suited for partitions of cubes that require rapid query response for summaries

    • True

    • False

    Correct Answer
    A. True
    Explanation
    HOLAP (Hybrid Online Analytical Processing) storage mode combines the benefits of both ROLAP (Relational Online Analytical Processing) and MOLAP (Multidimensional Online Analytical Processing) storage modes. It is suited for partitions of cubes that require rapid query response for summaries. In HOLAP, the detailed data is stored in a relational database while the aggregations and summaries are stored in a multidimensional format for faster query performance. This allows for efficient analysis of large data sets while still maintaining the flexibility of a relational database. Therefore, the statement is true.

    Rate this question:

  • 7. 

    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:

  • 8. 

    MDX stands for ------------------------ 

    • All of the listed options.

    • Memory, Distribution, extensions

    • Multi, dimension, expressions

    • Memory, dimension, expressions

    Correct Answer
    A. Multi, dimension, expressions
    Explanation
    MDX stands for Multi-Dimension Expressions. This language is used in data analysis and querying multidimensional databases, such as Microsoft Analysis Services. It allows users to retrieve and manipulate data from these databases using a syntax that is specifically designed for multidimensional data structures.

    Rate this question:

  • 9. 

    What are the component of SSAS? 

    • Slicing

    • Drilling

    • Pivoting

    • All of the listed options

    Correct Answer
    A. All of the listed options
    Explanation
    The correct answer is "All of the listed options." This is because all three components mentioned - slicing, drilling, and pivoting - are indeed components of SSAS. Slicing refers to the ability to filter data based on certain criteria, drilling allows users to navigate through different levels of detail in the data, and pivoting involves reorganizing and summarizing data to gain different perspectives. Therefore, all of these options are valid components of SSAS.

    Rate this question:

  • 10. 

    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:

  • 11. 

    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:

  • 12. 

    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:

  • 13. 

    ADOMD.Net is used for querying data?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    ADOMD.Net is a .NET library that provides a programming interface for querying and manipulating data from multidimensional data sources, such as Microsoft SQL Server Analysis Services. It allows developers to write code to execute MDX (Multidimensional Expressions) queries against the data source and retrieve the results. Therefore, it is correct to say that ADOMD.Net is used for querying data.

    Rate this question:

  • 14. 

    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:

  • 15. 

     If functions in one assembly call functions in a separate assembly, you must register both assemblies in : 

    • Client

    • Server

    • Table

    • None of the mentioned

    Correct Answer
    A. Server
    Explanation
    When functions in one assembly call functions in a separate assembly, both assemblies need to be registered in the server. The server acts as a central location where all the assemblies are registered and can be accessed by other components of the system. By registering both assemblies in the server, the functions in one assembly can successfully call the functions in the separate assembly.

    Rate this question:

  • 16. 

    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. [Measures].[Amount],[Account].[Accounts].[Operating Expenses] /[Measures].[Amount],[Account].[Accounts].[Gross Margin] Your solution has a time dimension named DimTime. You write the following Multidimensional Expressions (MDX) statement. (Line numbers are included for reference only.) Line 01 : IIf(Line 02 : ____________Line 03 : ParallelPeriodLine 04 : ( [DimTime].[Calendar].[Quarter],1,[DimTime].[Calendar].CurrentMemberLine 05: )?), 1, -1 ) 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?

    • KPIGoal( “GPMargin” ) >?( KPIValue( “GPMargin” ),

    • KPIValue( “GPMargin” ) >?( KPIValue( “GPMargin” ),

    • KPIStatus( “GPMargin” ) >?( KPIValue( “GPMargin” ),

    • KPITrend( “GPMargin” ) >?( KPIValue ( “GPMargin” ),

    Correct Answer
    A. KPIValue( “GPMargin” ) >?( KPIValue( “GPMargin” ),
    Explanation
    The correct answer is KPIValue( “GPMargin” ) >?( KPIValue( “GPMargin” ). This code segment is used to compare the current value of the KPI with the previous value. It checks if the current value is greater than the previous value and returns a boolean result. This is used to determine the trend of the KPI and set the Trend expression accordingly.

    Rate this question:

  • 17. 

    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:

  • 18. 

    What are the options to deploy SSAS cube in production?

    • Using BIDS

    • Using SSMS

    • Using XMLA.

    • All the above

    Correct Answer
    A. All the above
    Explanation
    The correct answer is "All the above" because all the options mentioned (Using BIDS, Using SSMS, Using XMLA) are valid methods to deploy SSAS cubes in production. BIDS (Business Intelligence Development Studio) is a development environment for SSAS, SSMS (SQL Server Management Studio) is a management tool for SQL Server, and XMLA (XML for Analysis) is a protocol used for managing and manipulating SSAS objects. Therefore, deploying SSAS cubes in production can be done using any of these options.

    Rate this question:

  • 19. 

    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:

  • 20. 

    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:

  • 21. 

    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:

  • 22. 

    By default, in a ________ schema, all attributes are directly related to the key attributes.

    • Relational

    • Star

    • None of the mentioned

    • Snowflake

    Correct Answer
    A. Star
    Explanation
    In a star schema, all attributes are directly related to the key attributes. This means that all the attributes in the schema are directly connected to the primary key attribute. This design is commonly used in data warehousing and allows for simple and efficient querying of data. The star schema is characterized by a central fact table surrounded by dimension tables, creating a star-like structure.

    Rate this question:

  • 23. 

    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:

  • 24. 

    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:

  • 25. 

    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:

  • 26. 

    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:

  • 27. 

    You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a cube for Company.com. On a production server, you have increased new function to the cube. You should make sure that you cost least time for publishing the new functions. Which is the correct answer? 

    • You should utilize the Synchronize Database Wizard.

    • Through utilizing a SQL Server 2008 Integration Services (SSIS) package, you should change the Target Server attribute to the production server

    • Through utilizing Business Intelligence Development Studio (BIDS), you should change the Target Server attribute to the production server.

    • Through utilizing a Dynamic Management View (DMV), you should change the Target Server attribute to the production server.

    Correct Answer
    A. You should utilize the Synchronize Database Wizard.
  • 28. 

    You maintain a SQL Server 2008 Analysis Services (SSAS) instance.You plan to run the Usage-Based Optimization Wizard.You need to enable query logging. What should you do?

    • Set the QueryLogSampling server property to 10

    • Set the AllowedBrowsingFolders server property to include the folder from the LogDir setting

    • Set the LogDir server property to a valid path

    • Set the QueryLogConnectionString server property to a valid connection string

    Correct Answer
    A. Set the QueryLogConnectionString server property to a valid connection string
    Explanation
    To enable query logging in SQL Server 2008 Analysis Services (SSAS) instance, you need to set the QueryLogConnectionString server property to a valid connection string. This connection string will specify the location where the query logs will be stored. By setting this property, the SSAS instance will start logging all the queries executed against it, allowing you to analyze and optimize the usage of the system.

    Rate this question:

  • 29. 

    You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Sales group. You configure a new role named Northern Region by using the "{[Customers].[Region].[Region].[Northern]}" allowed permission set. You assign the Sales group to the Northern Region role. You need to verify that users in the Northern Region role can view data only for their region.   What should you do? 

    • Add the Roles=Northern Region; parameter to the connection string

    • Select the Enable Visual Totals check box for the Northern Region role.

    • Temporarily add your account to the Northern Region role.

    • Add the User ID=Northern Region; parameter to the connection string.

    Correct Answer
    A. Add the Roles=Northern Region; parameter to the connection string
    Explanation
    By adding the Roles=Northern Region; parameter to the connection string, users in the Northern Region role will only have access to data for their region. This parameter ensures that only the specified role is applied to the user's connection, restricting their access to other data.

    Rate this question:

  • 30. 

    You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008. Now you are employed in a company named NaproStar which uses SQL Server2008. Your company makes and sells Cars. You work as the technical support. Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) database. Tim is the distributor of the Southern Area. Now according to the business requirement, Tim has to access the database. After discussion, your company decides to give Tim the necessary permissions. There are two roles respectively named Southern Area and Cars. The table below shows the schemas of the two roles. For both roles, you have set the Visual Totals property to True. Now you get another order from the company, according to the company requirement, Tim can only be able to view the members in the Product dimension that relate to the Cars category in the Southern Area. You have to accomplish this task. So what action should you perform?  

    • {[Product].[Product Category].[Product Category].[Cars]} as the allowed set.

    • CTim should be added to the Southern Area role

    • BTim should be added to the Cars role

    • {[Product].[Product Category].[Product Category].[Cars]} as the not allowed set.

    Correct Answer
    A. {[Product].[Product Category].[Product Category].[Cars]} as the allowed set.
    Explanation
    Tim should be added to the Southern Area role.

    Rate this question:

  • 31. 

    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:

  • 32. 

    Which is the default provider to create a CUBE?

    • SQLMDXOLEDB

    • OBDC

    • Native OLE/Native Client

    • Oracle Client

    Correct Answer
    A. Native OLE/Native Client
    Explanation
    The default provider to create a CUBE is Native OLE/Native Client. This means that when creating a CUBE in a database, the Native OLE or Native Client provider is used by default. These providers are commonly used in SQL Server and other database management systems to connect and interact with the database.

    Rate this question:

  • 33. 

    The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.

    • Database

    • Server

    • User

    • None of the mentioned

    Correct Answer
    A. Server
    Explanation
    The Analysis Services "server" role defines administrative access of Windows users and groups to an instance of Analysis Services. This role allows users and groups to manage and configure the Analysis Services server, including creating and modifying databases, managing security settings, and performing other administrative tasks.

    Rate this question:

  • 34. 

    You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Engineering group. You configure a new role named Engineering and Design by using the following allowed permission set: {[Employees].[Department].[Engineering and Design]} You assign the Engineering group to the Engineering and Design role. You need to ensure that users in the Engineering and Design role can only view data for their department. What should you do? 

    • Add the User ID= [Engineering and Design]; parameter to the connection string.

    • Add the Roles= [Engineering and Design]; parameter to the connection string.

    • Select the Enable Visual Totals check box for the Engineering and Design role.

    • Add your account temporarily to the Engineering and Design role.

    Correct Answer
    A. Add the Roles= [Engineering and Design]; parameter to the connection string.
    Explanation
    Adding the Roles= [Engineering and Design]; parameter to the connection string will ensure that users in the Engineering and Design role can only view data for their department. This parameter specifies the roles that the user is a member of and restricts their access to only the data allowed by those roles. By including the Engineering and Design role in the connection string, users will be limited to viewing data for their specific department.

    Rate this question:

  • 35. 

    How many types of actions available in the Cube?

    • 3

    • 4

    • 5

    • 6

    Correct Answer
    A. 3
    Explanation
    There are three types of actions available in the Cube.

    Rate this question:

  • 36. 

    What do you understand by dynamic named set (SSAS 2008)?

    • To create dynamic set of members

    • To create set of members

    • None

    • Either of two

    Correct Answer
    A. To create dynamic set of members
    Explanation
    A dynamic named set in SSAS 2008 is used to create a set of members that can change dynamically based on certain criteria or conditions. Unlike a regular named set, which contains a fixed set of members, a dynamic named set allows for flexibility and adaptability. This feature is useful when the set of members needs to be updated frequently or when the set needs to be based on changing data or calculations.

    Rate this question:

  • 37. 

    Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character ?

    • BIN2 (_BIN2)

    • Binary (_BIN)1

    • Case-sensitive (_CS)

    • Case-insensitive

    Correct Answer
    A. Binary (_BIN)1
    Explanation
    The correct answer is Binary (_BIN)1. This sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character. It considers the binary representation of the characters and compares them accordingly. This sort order is useful when dealing with data that is stored in a binary format or when the character set being used does not have a specific sort order defined.

    Rate this question:

  • 38. 

    The _______ attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table. 

    • Dim

    • PK

    • None of the mentioned

    • KEY

    Correct Answer
    A. KEY
    Explanation
    The KEY attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table. This means that the KEY attribute serves as a unique identifier for each record in the dimension table, allowing it to be linked to the corresponding records in the fact table.

    Rate this question:

  • 39. 

    You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the sales manager to access the database. You have two roles named Northeast Region and Bikes. The schemas of the two roles are as shown in the following table. The Visual Totals property is set to True for both roles. You need to ensure that the sales manager can view only the members in the Product dimension that relate to the Bikes category in the Northeast region. What should you do?

    • Add the manager to the Bikes role.

    • [Sales Territory Region].AllMembers} as the denied set{[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set

    • [Product Category].&[Bikes]} as the allowed set.

    • Add the manager to the Northeast Region role.

    Correct Answer
    A. [Product Category].&[Bikes]} as the allowed set.
  • 40. 

    You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com. In order to examine different data mining theories; you should alter the design of the data mining structure to test. In the data mining model and the underlying case table, you increase the ordered content type columns you should make sure that Data Mining Viewer is the good for altering in the data mining structure and the data mining model technology. Which is the correct answer? 

    • You should select ProcessFull

    • You should select VIEWDELETE

    • You should select SHRINKFILE

    • You should select INDEXDEFRAG

    Correct Answer
    A. You should select ProcessFull
    Explanation
    The correct answer is "You should select ProcessFull". The ProcessFull option in SQL Server Analysis Services is used to process the entire data mining structure and its associated objects, including the data mining model and the underlying case table. By selecting ProcessFull, you ensure that any changes made to the design of the data mining structure, such as increasing the ordered content type columns, are applied and the structure is updated accordingly. This allows you to test different data mining theories effectively.

    Rate this question:

  • 41. 

    You are developing SQL Server 2008 Analysis Services (SSAS) database sample for Company.com. In order to write down the Analysis Services performance information, when the database is operated you should gather information connected with the temporary file usage. Which is the correct answer? 

    • You should utilize MSAS 2008: store procedure

    • You should utilize MSAS 2008: Memory

    • You should utilize MSAS 2008: Proc Aggregations

    • You should utilize MSAS 2008: Transactions Log

    Correct Answer
    A. You should utilize MSAS 2008: Proc Aggregations
    Explanation
    The correct answer is to utilize MSAS 2008: Proc Aggregations. This is because proc aggregations in SQL Server 2008 Analysis Services allows you to optimize and improve query performance by pre-calculating and storing aggregated data. By gathering information connected with proc aggregations, you can monitor and analyze the temporary file usage, which can help in identifying any performance bottlenecks or issues related to memory usage in the SSAS database.

    Rate this question:

  • 42. 

    You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining extensions (DMX) to query a data mining model. You write the following DMX code segment to query a Bike Buyer data mining model in a Decision Tree data mining structure. (Line numbers are included for reference only.) 01 SELECT 02 [Decision Tree].[Bike Buyer] AS Buyer 03 FROM 04 [Decision Tree] 05 06 (SELECT 28 AS [Age], 07 '2-5 Miles' AS [Commute Distance], 08 '1' AS [House Owner Flag], 09 1 AS [Number Cars Owned], 10 2 AS [Total Children]) AS t You need to ensure that the input columns automatically map to the columns in the data mining structure.   Which code fragment should you insert at line 05?

    • PREDICTION JOIN

    • OPENQUERY

    • INNER JOIN

    • NATURAL PREDICTION JOIN

    Correct Answer
    A. NATURAL PREDICTION JOIN
  • 43. 

    You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a table called TestFact which includes two columns listed below for Company.com. In order to develop a measure which gets the amount of customers who owns placed orders. Which is the correct answer?     

    • You should configure the Usage attribute to Sum count and the Source Column attribute to CustomerKey.

    • You should configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey.

    • You should configure the Usage attribute to Sum count and the Source Column attribute to OrderKey.

    • You should configure the Usage attribute to Distinct count and the Source Column attribute to OrderKey.

    Correct Answer
    A. You should configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey.
    Explanation
    The correct answer is to configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey. This is because the requirement is to get the amount of customers who own placed orders, and in order to count the distinct number of customers, the Usage attribute should be set to Distinct count. Additionally, the Source Column attribute should be set to CustomerKey as it represents the column that uniquely identifies each customer.

    Rate this question:

  • 44. 

    You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008. Now you are employed in a company named NaproStar which uses SQL Server2008. There are two servers in your company. One is a production server and another one is a development server. Now you're in charge of a SQL Server 2008 Analysis Services (SSAS) database on a production server. The database has a cube. New functionality has been added to the cube on a development server. Now you receive an order from your company CIO, according to the requirement of the CIO, the new functionality has to be deployed from the development server to the production server. You have to accomplish this task and reduce the effect on the users to the least. So what action should you perform? 

    • In order to accomplish this task, first the production database should be detached. Second, you should copy the appropriate files to the production server; at last you should attach the database on the production server.

    • In order to accomplish this task, using Business Intelligence Development Studio (BIDS), modify the Target Server property to the production server. Then deploy the solution

    • In order to accomplish this task, the Synchronize Database Wizard should be used.

    • In order to accomplish this task, you should copy the appropriate files from the development server to the production server

    Correct Answer
    A. In order to accomplish this task, the Synchronize Database Wizard should be used.
  • 45. 

    Which API in SSAS is used to retrieve and manipulate data?

    • Amo.net

    • Adomd.net

    • Server adomd.net

    • Amo

    Correct Answer
    A. Adomd.net
    Explanation
    The correct answer is adomd.net. ADOMD.NET is an API in SSAS (SQL Server Analysis Services) that is used to retrieve and manipulate data. It provides a managed interface for accessing and querying multidimensional data from SSAS cubes. With ADOMD.NET, developers can perform various operations such as executing MDX queries, retrieving metadata about cubes and dimensions, and manipulating cube data programmatically.

    Rate this question:

  • 46. 

    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:

  • 47. 

    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:

  • 48. 

    In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.

    • Translation

    • Dim translation

    • None of the mentioned

    • Dimension translation

    Correct Answer
    A. Dimension translation
    Explanation
    In Microsoft SQL Server 2005 Analysis Services (SSAS), a dimension translation is a language-specific representation of the name of a dimension. This means that the dimension name can be translated into different languages, allowing users to view and interact with the dimension in their preferred language. The dimension translation feature helps to make the SSAS solution more user-friendly and accessible to a diverse range of users.

    Rate this question:

  • 49. 

    Which of the below statement are valid about the Natural Key?

    • All of the listed options are valid

    • It can be numeric, string, a combination of both and etc…

    • Merging data from different source systems can be difficult when there is a conflict in the type of value coming from each source system

    • It uniquely identifies each record and has a business meaning attached to it

    • History cannot be maintained if used as a Primary Key

    Correct Answer
    A. All of the listed options are valid
    Explanation
    The given correct answer states that all of the listed options are valid about the Natural Key. This means that the Natural Key can be numeric, string, or a combination of both. Merging data from different source systems can be challenging when there is a conflict in the type of value coming from each source system. The Natural Key uniquely identifies each record and has a business meaning attached to it. However, history cannot be maintained if the Natural Key is used as a Primary Key.

    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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.