Analysis Services MCQ

Test your knowledge with important Analysis Services MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Analysis Services MCQs at Bissoy

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

  EnableFast1033Local

  খ

  EnableFast1036Locale

  গ

  EnableFast1033Locale

  ঘ

  EnableQuick1033Locale
• ____________ distinguishes between a single-byte character and the same character when represented as a double-byte character.
  ক

  Accent-insensitive (_AI)

  খ

  Kana-sensitive (_KS)

  গ

  Accent-sensitive (_AS)

  ঘ

  Width-sensitive (_WS)
• Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character?
  ক

  BIN2 (_BIN2)1

  খ

  Binary (_BIN)1

  গ

  Case-sensitive (_CS)

  ঘ

  Case-insensitive
• If you select the __________ conversion type, a reporting currency dimension is also created.
  ক

  one-to-one

  খ

  many-to-one

  গ

  many-many

  ঘ

  all of the mentioned
• The Business Intelligence Wizard supports ______ different types of currency conversion.
  ক

  3

  খ

  4

  গ

  5

  ঘ

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

  BI

  খ

  ETL

  গ

  MIS

  ঘ

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

  one-to-one

  খ

  many-to-one

  গ

  many-many

  ঘ

  all of the mentioned
• _______ is currency used to store transactions on which measures to be converted are based in SSAS.
  ক

  Local currency

  খ

  Pivot currency

  গ

  Global currency

  ঘ

  None of the mentioned
• Parent-child hierarchies are automatically detected by the _________ Wizard.
  ক

  Dimension

  খ

  Cube

  গ

  Dimension and Cube

  ঘ

  None of the mentioned
• By default, in a ________ schema, all attributes are directly related to the key attributes.
  ক

  Relational

  খ

  Snowflake

  গ

  Star

  ঘ

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

  Aggregatable

  খ

  IsAggregatable

  গ

  IsAggregate

  ঘ

  All of the mentioned
• 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

  খ

  KEY

  গ

  PK

  ঘ

  None of the mentioned
• Which of the following is not supported by linked dimensions?
  ক

  readback

  খ

  writeback

  গ

  readwrite

  ঘ

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

  child

  খ

  parent

  গ

  both child and parent

  ঘ

  none of the mentioned
• Members of a _________ dimension can only be moved within the same level.
  ক

  readback

  খ

  writeback

  গ

  readwrite

  ঘ

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

  Translation

  খ

  Dimension translation

  গ

  Dim translation

  ঘ

  None of the mentioned
• If functions in one assembly call functions in a separate assembly, you must register both assemblies in ____________
  ক

  client

  খ

  server

  গ

  table

  ঘ

  none of the mentioned
• Security for stored procedures is set with the _________ property on a stored procedure.
  ক

  PermissionSet

  খ

  SetPermissionSet

  গ

  Permission

  ঘ

  None of the mentioned
• Which of the following namespace discover set of assemblies?
  ক

  System.Reflection

  খ

  System.Refraction

  গ

  Sys.Reflection

  ঘ

  All of the mentioned
• If the __________ setting is used, the execution context corresponds to the Windows login user account IUSER_servername on the server.
  ক

  ImpersonateAnon

  খ

  Anonymous

  গ

  ImpersonateAnonymous

  ঘ

  None of the mentioned
• Which of the following permission setting provides internal computation permission?
  ক

  Unsafe

  খ

  ExternalAccess

  গ

  Safe

  ঘ

  All of the mentioned
• _________ let you create external, user-defined functions using any common language runtime (CLR) language.
  ক

  Aggregate

  খ

  Assemblies

  গ

  Synonym

  ঘ

  All of the mentioned
• 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?
  ক

  Database

  খ

  Membership

  গ

  Client

  ঘ

  Server
• 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