Olete.in – MCQs, Mock Tests & Government Job Prep | SSAS SQL Server Questions and Answers

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

1. database
2. server
3. user
4. None of the mentioned

✅ Correct Answer: 2

Point out the correct statement.

1. The permissions of a role may allow members to access and administer the database
2. Server roles, roles defined by administrators to control access to objects and data for non-administrator user
3. Database roles, roles defined by administrators to control access to objects and data for administrator user
4. None of the mentioned

✅ Correct Answer: 1

Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?

1. Database
2. Membership
3. Client
4. Server

✅ Correct Answer: 1

________ let you create external, user-defined functions using any common language runtime (CLR) language.

1. Aggregate
2. Assemblies
3. Synonym
4. All of the mentioned

✅ Correct Answer: 2

Point out the wrong statement.

1. The SSAS host-level policy is a combination of Analysis Services fixed policy for system assemblies and user-specified policy for user assemblies
2. Security for assemblies is based on the .NET Framework security model, which is a code-access security model
3. Calling a user-defined function in an assembly is performed just like calling an intrinsic function
4. None of the mentioned

✅ Correct Answer: 1

Which of the following permission setting provides internal computation permission?

1. Unsafe
2. ExternalAccess
3. Safe
4. All of the mentioned

✅ Correct Answer: 3

If the __________ setting is used, the execution context corresponds to the Windows login user account IUSER_servername on the server.

1. ImpersonateAnon
2. Anonymous
3. ImpersonateAnonymous
4. None of the mentioned

✅ Correct Answer: 3

Which of the following namespace discover set of assemblies?

1. a) System.Reflection
2. System.Refraction
3. Sys.Reflection
4. All of the mentioned

✅ Correct Answer: 1

Security for stored procedures is set with the _________ property on a stored procedure.

1. PermissionSet
2. SetPermissionSet
3. Permission
4. None of the mentioned

✅ Correct Answer: 1

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

1. client
2. server
3. table
4. None of the mentioned

✅ Correct Answer: 2

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

1. Translation
2. Dimension translation
3. Dim translation
4. None of the mentioned

✅ Correct Answer: 2

Point out the correct statement.

1. The collation and language information for the client computer is stored in the form of a locale identifier (LCID)
2. SQL Server 2008 Analysis Services also supports translations of cube objects
3. SQL Server 2000 Analysis Services supports translations of cube objects
4. None of the mentioned

✅ Correct Answer: 1

Members of a _________ dimension can only be moved within the same level.

1. readback
2. writeback
3. readwrite
4. All of the mentioned

✅ Correct Answer: 2

Updates to the ______ attribute in a parent-child hierarchy must not include updates to any other properties or attributes.

1. child
2. parent
3. both child and parent
4. none of the mentioned

✅ Correct Answer: 2

Point out the wrong statement.

1. The data in a dimension is generally read-write both
2. Upon connection, the client passes the LCID to the instance of Analysis Services
3. For a write-enabled cube or partition, updates are stored in a writeback table separate from the cube’s source tables
4. None of the mentioned

✅ Correct Answer: 1

Which of the following is not supported by linked dimensions? a) b) c)

1. readback
2. writeback
3. readwrite
4. None of the mentioned

✅ Correct Answer: 2

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.

1. Dim
2. KEY
3. PK
4. None of the mentioned

✅ Correct Answer: 2

Which of the following property is set to zero so that all levels are not created?

1. Aggregatable
2. IsAggregatable
3. IsAggregate
4. All of the mentioned

✅ Correct Answer: 2

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

1. Relational
2. Snowflake
3. Star
4. None of the mentioned

✅ Correct Answer: 3

Parent-child hierarchies are automatically detected by the _________ Wizard.

1. Dimension
2. Cube
3. Dimension and Cube
4. None of the mentioned

✅ Correct Answer: 3

____ is currency used to store transactions on which measures to be converted are based in SSAS.

1. Local currency
2. Pivot currency
3. Global currency
4. None of the mentioned

✅ Correct Answer: 1

Point out the correct statement.

1. The Type property of the dimension is set to Reporting Currency
2. The Type property of one attribute for the dimension is set to CurrencyName in Latin
3. The values of Type attribute must be used in all columns that should contain a currency identifier
4. All of the mentioned

✅ Correct Answer: 1

For _________ currency conversions, the pivot currency and reporting currency are the same.

1. one-to-one
2. many-to-one
3. many-many
4. All of the mentioned

✅ Correct Answer: 2

You can use the __________ Wizard to specify which measures from the rate measure group are used to convert values.

1. BI
2. ETL
3. MIS
4. OBIEE

✅ Correct Answer: 1

Point out the wrong statement.

1. Transactions are stored in the fact table in local currencies for many-to-many conversion
2. Transactions are stored in the fact table in the pivot currency for one-to-many conversion
3. If you choose a many-to-many or one-to-many conversion type for your currency conversion, you need to specify the reporting currencies
4. None of the mentioned

✅ Correct Answer: 2

If you select the __________ conversion type, a reporting currency dimension is also created.

1. one-to-one
2. many-to-one
3. many-many
4. All of the mentioned

✅ Correct Answer: 2

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

1. BIN2 (_BIN2)1
2. Binary (_BIN)1
3. Case-sensitive (_CS)
4. Case-insensitive

✅ Correct Answer: 2

_________ distinguishes between a single-byte character and the same character when represented as a double-byte character.

1. Accent-insensitive (_AI)
2. ) Kana-sensitive (_KS)
3. Accent-sensitive (_AS)
4. Width-sensitive (_WS)

✅ Correct Answer: 4

Which of the following property enables Analysis Services to use a faster algorithm for string hashing and comparison?

1. EnableFast1033Local
2. EnableFast1036Locale
3. EnableFast1033Locale
4. EnableQuick1033Locale

✅ Correct Answer: 3

__ lets you manage cube context from within an MDX script.

1. CALCULATE
2. CALC
3. SCOPE CALC
4. None of the mentioned

✅ Correct Answer: 1

Point out the correct statement.

1. Few MDX queries run within a specified cube context
2. SELECT statement is the most frequently used query in MDX c) When formulating a Multidimensional Expressions (MDX) SELECT statement, an application typically examines a cube and divides the set of hie
3. When formulating a Multidimensional Expressions (MDX) SELECT statement, an application typically examines a cube and divides the set of hierarchies into three subsets
4. None of the mentioned

✅ Correct Answer: 2

___ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script.

1. Ignore
2. IgnoreNone
3. IgnoreAll
4. None of the mentioned

✅ Correct Answer: 2

The Backus-Naur Form (BNF) of {*(<comment> | <whitespace> | <newline>)} will be parsed as ______ for backwards compatibility.

1. {}
2. {*}
3. {+}
4. {-}

✅ Correct Answer: 2

Point out the wrong statement.

1. The WHERE clause describes the slicer axis in an MDX query
2. MDX syntax distinguishes sets by surrounding tuples or members with braces
3. MDX queries can have three query axes in the SELECT statement
4. None of the mentioned

✅ Correct Answer: 3

_____ creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube.

1. CREATE CELL CALCULATION
2. CREATE CELL CALC
3. CREATE MEMBER CALCULATION
4. None of the mentioned

✅ Correct Answer: 1

The following code is a syntax of which statement? CREATE [ SESSION ] [HIDDEN] [ CALCULATED ] MEMBER CURRENTCUBE | Cube_Name.Member_Name AS MDX_Expression [,Property_Name = Property_Value, ...n] ......[,SCOPE_ISOLATION = CUBE]

1. CREATE SESSION
2. CREATE CUBE
3. CREATE MEMBER
4. CREATE MDX

✅ Correct Answer: 3

Which of the following is valid syntax for CREATE GLOBAL CUBE?

1. CREATE GLOBAL CUBE [LocalReseller] Storage 'C:LocalAWReseller1.cub' FROM [Adventure Works] ( MEASURE [Adventure Works].[Reseller Sales Amount], DIMENSION [Adventure Works].[Reseller], DIMENSION [Adventure Works].[DATE
2. CREATE GLOBAL CUBE [LocalReseller] FROM [Adventure Works] ( MEASURE [Adventure Works].[Reseller Sales Amount], DIMENSION [Adventure Works].[Reseller], DIMENSION [Adventure Wor
3. CREATE GLOBAL CUBE [LocalReseller] Storage 'C:LocalAWReseller1.cub' ( MEASURE [Adventure Works].[Reseller Sales Amount], DIMENSION [Adventure Works].[Reseller], DIME
4. All of the mentioned

✅ Correct Answer: 1

Which of the following is the MDX Data Definition Statement? a)

1. CREATE ACTION
2. DROP CUBE
3. CREATE CUBE
4. None of the mentioned

✅ Correct Answer: 1

_________ is the set of hierarchies from which data is retrieved for a single member.

1. Slicer axis
2. Query axes
3. Dice axis
4. All of the mentioned

✅ Correct Answer: 1

Point out the correct statement.

1. Only dropping the default member is supported in MDX Scripting
2. In the SELECT statement, the FROM clause determines the cube context
3. Very few cube can control how errors within a Multidimensional Expressions (MDX) script are handled
4. None of the mentioned

✅ Correct Answer: 2

When you include a many-to-many dimension, which of the following rules apply?

1. You must add the intermediary measure group
2. You must add the entire many-to-many dimension
3. You must add the entirety of all dimensions common to the two measure groups involved in the many-to-may relationship
4. All of the mentioned

✅ Correct Answer: 4

______ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.

1. UPDATE CUBE
2. DELETE CUBE
3. ALTER CUBE
4. None of the mentioned

✅ Correct Answer: 1

Point out the wrong statement.

1. A weight expression should be expressed as a decimal value between zero (0) and 1
2. Each UPDATE CUBE allocation should be considered to be atomic for transactional purposes
3. When updated cells overlap, the Update Isolation Level connection string property can be used to enhance performance for UPDATE CUBE
4. None of the mentioned

✅ Correct Answer: 3

Which of the following scenario demonstrates USE_EQUAL_INCREMENT allocation method?

1. leaf cell value> = <NEW Value> / COUNT(leaf cells that are contained IN <tuple>)
2. leaf cell value> = < NEW Value> * Weight_Expression
3. <leaf cell value> = <leaf cell value> + (<NEW VALUE > - <existing value>) / COUNT(leaf cells contained IN <tuple>)
4. leaf cell value> = <leaf cell value> + (<NEW Value> - <existing value>) * Weight_Expression

✅ Correct Answer: 3

If a weight expression is not specified, the UPDATE CUBE statement implicitly uses which of the following expression?

1. Weight_Expression = <leaf cell value> * <existing value>
2. Weight_Expression = <leaf cell value> / <existing value>
3. Weight_Expression = <leaf cell value> – <existing value>
4. Weight_Expression = <leaf cell value> + <existing value>

✅ Correct Answer: 2

When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.

1. USE_EQUAL_ALLOCATION
2. USE_WEIGHTED_ALLOCATION
3. USE_WEIGHTED_INCREMENT
4. None of the mentioned

✅ Correct Answer: 1

Which of the following is valid syntax for DRILLTHROUGH statement?

1. DRILLTHROUGH[MAXROWSUnsigned_Integer] <MDX SELECT statement> [RETURNSet_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...]
2. DRILL[MAXROWSUnsigned_Integer] <MDX SELECT statement> [RETURNSet_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]
3. DRILLTHROUGH[MAXROWSUnsigned_Integer] <MDX SELECT statement>
4. None of the mentioned

✅ Correct Answer: 1

Which of the following keyword forces a specified set to be evaluated within the current context?

1. SCOPE
2. CASE
3. EXISTING
4. FREEZE

✅ Correct Answer: 3

Which of the following tool requires Reporting Services in SharePoint mode?

1. Report Designer
2. Power View
3. Report Builder
4. None of the mentioned

✅ Correct Answer: 2

Point out the correct statement.

1. The tools that you use is independent of the deployment mode of your report server
2. A set of scripting tools are available for administering the report server in SQL Server Reporting Services
3. SQL Server Reporting Services contains a set of graphical and scripting tools that support the development and use of rich reports in a managed environment
4. None of the mentioned

✅ Correct Answer: 3

________ does not help you manage report server content, enable additional features, or grant access to the server.

1. Reporting Services Configuration Manager
2. SSMS
3. SQL Server Configuration Manager
4. None of the mentioned

✅ Correct Answer: 4

____ is a tool to configure and manage a report server connection to the report server database.

1. Rskeymgmt Utility
2. Windows Management Instrumentation (WMI) Classes
3. Rsconfig Utility
4. None of the mentioned

✅ Correct Answer: 3

Point out the wrong statement.

1. Report Manager works in all modes
2. A report server is a computer that has an instance of Reporting Services installed
3. A report server integrated with SharePoint has two possible configurations
4. All of the mentioned

✅ Correct Answer: 1

Which of the following is a tool for Report Content Management?

1. Report Server Web service URL
2. Rskeymgmt Utility
3. Configuration manager
4. None of the mentioned

✅ Correct Answer: 1

Which of the following mode lets you interact with the report server, reports, and report related items by using a browser with Report Manager or URL access commands?

1. SharePoint mode report server
2. Native
3. SSRS
4. All of the mentioned

✅ Correct Answer: 2

Reports use __________ to retrieve data for a report when a query runs or when the report is processed.

1. Data connections
2. Data source definition
3. Connection string
4. All of the mentioned

✅ Correct Answer: 1

A _________ is an item stored internally in an alerting database.

1. Connection string
2. Data alert
3. Shared data source
4. None of the mentioned

✅ Correct Answer: 2

A __________ is a report server item that contains a pointer to the report definition.

1. Drilldown report
2. Linked report
3. Subreport
4. Drillthrough report

✅ Correct Answer: 2

A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information.

1. Main
2. Detail
3. Drillthrough
4. All of the mentioned

✅ Correct Answer: 4

Point out the correct statement.

1. A published report is a report definition (.rdl) file
2. A saved report is a published report definition that is converted to a newer schema when a report server is upgraded
3. Report history is a collection of report snapshots
4. All of the mentioned

✅ Correct Answer: 3

🧪 SSAS MCQ Quiz Hub

SQL Server Questions and Answers – Analysis Services Set 1