Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

In order to use the Analyze in Excel feature, you must have ___________ installed on the system.(a) SSDT(b) SSMS(c) SSMA(d) None of the mentionedI have been asked this question in an interview.This intriguing question originated from Analyzing Data With Excel topic in division Business Intelligence of SQL Server

Answer» RIGHT choice is (a) SSDT

The explanation is: SQL Server Data Tools (SSDT) is a TOOLSET that provides an integrated environment for database developers to CARRY out all their data ANALYSIS.
Discussion
2.

Scenario Analysis tool allows you to model _______ types of scenarios.(a) 2(b) 3(c) 4(d) 5I have been asked this question during an interview.This intriguing question comes from Analyzing Data With Excel in section Business Intelligence of SQL Server

Answer»

Correct answer is (a) 2

For explanation: SCENARIO Analysis TOOL report the effect on EITHER a single row or the entire table of INPUT data.
Discussion
3.

Fill From Example tool also produces a patterns report similar to ___________(a) Analyze Key Influencers(b) Detect Categories(c) Fill From Example(d) None of the mentionedI have been asked this question in an international level competition.This key question is from Analyzing Data With Excel in chapter Business Intelligence of SQL Server

Answer» CORRECT CHOICE is (a) ANALYZE Key Influencers

Best explanation: Analyze Key Influencers tool describes the rules that were APPLIED to fill in the MISSING values.
Discussion
4.

Point out the wrong statement.(a) The Detect Categories tool detects the rows in the data table that contain similar characteristics and groups them into categories(b) The tool employs SQL Server Data Mining to detect patterns in the sample you provide and apply those to the remaining missing values(c) The Detect categories tool predicts future values based on trends in existing time series data(d) All of the mentionedThe question was posed to me in a national level competition.Question is taken from Analyzing Data With Excel topic in portion Business Intelligence of SQL Server

Answer»

Right choice is (c) The DETECT categories tool predicts future values BASED on TRENDS in existing time series data

The BEST EXPLANATION: The Forecast tool predicts future values based on trends in existing time series data.
Discussion
5.

Which of the following tool analyzes and highlights data rows that do not appear to match the general patterns found in the rest of the table?(a) Exceptions(b) Highlight(c) Scenario Analysis(d) Highlight ExceptionsThe question was asked in semester exam.Query is from Analyzing Data With Excel topic in section Business Intelligence of SQL Server

Answer» CORRECT option is (d) HIGHLIGHT Exceptions

To explain I would say: Highlight Exceptions not only HIGHLIGHTS exception rows, but it also highlights the SPECIFIC COLUMN value in each row that is likely to be the cause of the exception.
Discussion
6.

___________analyzes the patterns in data that have the strongest influence on a certain outcome.(a) Analyze Key Influencers(b) Detect Categories(c) Fill From Example(d) None of the mentionedThis question was posed to me in unit test.This question is from Analyzing Data With Excel topic in division Business Intelligence of SQL Server

Answer»

Right choice is (a) ANALYZE KEY Influencers

The EXPLANATION: Analyze Key Influencers can analyze the factors that are key to DETERMINING which customers will spend the most MONEY.
Discussion
7.

_____________ allows you to analyze your spreadsheet data in powerful ways.(a) Data Mining Templates for Visio(b) Table Analysis Tools for Excel(c) Data Mining Client for Excel(d) All of the mentionedI got this question in unit test.This interesting question is from Analyzing Data With Excel in portion Business Intelligence of SQL Server

Answer» RIGHT option is (B) Table Analysis Tools for Excel

Explanation: Table Analysis Tools for Excel is AVAILABLE in Data Mining Add-ins for Office 2007 PACKAGE.
Discussion
8.

The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue.(a) FireEvent(b) FireEventdata(c) Eventdata(d) None of the mentionedThe question was posed to me in an internship interview.The doubt is from Reporting Services topic in portion Business Intelligence of SQL Server

Answer»

The CORRECT ANSWER is (a) FireEvent

The BEST EXPLANATION: ReportingService2010.FireEvent METHOD raises an event based on the supplied parameters.
Discussion
9.

Point out the correct statement.(a) You cannot create and save connections to re-use data sources, repeat experiments, or re-train models(b) The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007(c) The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data(d) None of the mentionedI had been asked this question at a job interview.This interesting question is from Analyzing Data With Excel in portion Business Intelligence of SQL Server

Answer»

Right choice is (C) The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to UNCOVER hidden patterns and relationships in your data

To elaborate: To use the Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007, you must be connected to a SQL Server 2005 Analysis SERVICES DATABASE.
Discussion
10.

The Schedule and Delivery Processing feature must be enabled through the ____________ property.(a) ScheduleEventsDeliveryEnabled(b) ScheduleEventsAndReportDeliveryEnabled(c) ScheduleEventsAndReportDelivery(d) All of the mentionedI have been asked this question during an interview for a job.I'd like to ask this question from Reporting Services in chapter Business Intelligence of SQL Server

Answer» RIGHT option is (b) ScheduleEventsAndReportDeliveryEnabled

Explanation: The Scheduling and Delivery PROCESSOR requires that the Report SERVER SERVICE and SQL Server AGENT are started.
Discussion
11.

_____________ for Office is a lightweight set of tools for predictive analytics.(a) SQL Server 2008 Data Mining Add-ins(b) SQL Server 2012 Data Mining Add-ins(c) SQL Server 2014 Data Mining Add-ins(d) SQL Server 2012 Data Mining ExcelThe question was asked during an interview for a job.My enquiry is from Analyzing Data With Excel in portion Business Intelligence of SQL Server

Answer»

The correct answer is (b) SQL SERVER 2012 Data Mining Add-ins

The EXPLANATION is: SQL Server 2012 Data Mining Add-ins lets you use data in Excel to BUILD ANALYTICAL models for PREDICTION, recommendation, or exploration.
Discussion
12.

__________ are portable, multipurpose items that contain ready-to-use schedule information.(a) Report-specific schedule(b) Shared schedules(c) File schedules(d) None of the mentionedThis question was addressed to me during an internship interview.I would like to ask this question from Reporting Services topic in portion Business Intelligence of SQL Server

Answer»

The CORRECT answer is (b) Shared schedules

The best explanation: Shared schedules are system-level ITEMS, creating a shared SCHEDULE requires system-level permissions.
Discussion
13.

Which of the following is a list type in RDL with base 64 encoded value?(a) Boolean(b) Binary(c) Enum(d) NameI got this question in class test.I'd like to ask this question from Reporting Services topic in portion Business Intelligence of SQL Server

Answer» CORRECT option is (b) Binary

The EXPLANATION is: Name is a property with a STRING TEXT value.
Discussion
14.

Point out the wrong statement.(a) A report snapshot is a report that contains layout information and query results that were retrieved at a specific point in time. Unlike on-demand reports(b) A detailed report is a saved copy of a compiled report and report data(c) A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries(d) All of the mentionedThe question was asked in examination.I want to ask this question from Reporting Services topic in chapter Business Intelligence of SQL Server

Answer»

The CORRECT answer is (b) A DETAILED report is a saved copy of a compiled report and report data

Explanation: Cached reports are used to improve performance by reducing the NUMBER of processing REQUESTS to the report processor and by reducing the time that is required to retrieve large report datasets.
Discussion
15.

You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode.(a) Native, Sharepoint(b) Sharepoint, Native(c) Native, Native(d) Sharepoint, SharepointThis question was addressed to me in exam.My question is based upon Reporting Services topic in portion Business Intelligence of SQL Server

Answer»

The correct answer is (a) NATIVE, Sharepoint

For EXPLANATION I WOULD say: Schedule operations are not available in every EDITION of SQL Server.
Discussion
16.

An ___________ report is a fully paged report saved in a specific file format.(a) exported(b) fully processed(c) compiled(d) all of the mentionedI got this question by my college professor while I was bunking the class.Question is from Reporting Services topic in chapter Business Intelligence of SQL Server

Answer»

The correct OPTION is (a) exported

The explanation is: EXPORT FORMATS depend on installed rendering extensions and can be customized. By DEFAULT, export formats include Excel, Word, XML, PDF, TIFF, and CSV.
Discussion
17.

Point out the correct statement.(a) A published report is a report definition (.rdl) file(b) A saved report is a published report definition that is converted to a newer schema when a report server is upgraded(c) Report history is a collection of report snapshots(d) All of the mentionedI had been asked this question in class test.My question is from Reporting Services topic in division Business Intelligence of SQL Server

Answer»

Right choice is (c) REPORT history is a COLLECTION of report snapshots

To ELABORATE: Report history is not intended for REPORTS that contain confidential or personal DATA.
Discussion
18.

A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information.(a) Main(b) Detail(c) Drillthrough(d) All of the mentionedI had been asked this question in final exam.The above asked question is from Reporting Services in portion Business Intelligence of SQL Server

Answer»

Correct ANSWER is (d) All of the mentioned

To EXPLAIN I would SAY: The drillthrough REPORT opens separately from the main report. A hyperlink can be DEFINED on any report item that has an Action property.
Discussion
19.

A _________ is an item stored internally in an alerting database.(a) Connection string(b) Data alert(c) Shared data source(d) None of the mentionedI got this question during an interview for a job.This question is from Reporting Services in portion Business Intelligence of SQL Server

Answer»

The CORRECT answer is (b) DATA alert

The EXPLANATION is: A data alert definition includes which data to USE from existing report data feeds, the CONDITIONS to be met, a schedule.
Discussion
20.

Reports use __________ to retrieve data for a report when a query runs or when the report is processed.(a) Data connections(b) Data source definition(c) Connection string(d) All of the mentionedThe question was asked during an interview for a job.My question comes from Reporting Services in chapter Business Intelligence of SQL Server

Answer»

Right OPTION is (a) Data connections

The best explanation: A data CONNECTION includes a name and connection PROPERTIES that are dependent on the connection TYPE.
Discussion
21.

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?(a) SharePoint mode report server(b) Native(c) SSRS(d) All of the mentionedThis question was posed to me in quiz.My question is taken from Reporting Services in section Business Intelligence of SQL Server

Answer»

Correct option is (b) Native

Best explanation: A REPORT SERVER configured in native MODE is a computer that has SQL Server Reporting Services installed and configured as a stand-alone server.
Discussion
22.

Which of the following is a tool for Report Content Management?(a) Report Server Web service URL(b) Rskeymgmt Utility(c) Configuration manager(d) All of the mentionedThis question was posed to me by my college professor while I was bunking the class.Origin of the question is Reporting Services topic in section Business Intelligence of SQL Server

Answer» CORRECT answer is (a) Report SERVER WEB service URL

To explain I would say: USE Report Server Web service URL TOOL to browse content in the report catalog in a generic item navigation page.
Discussion
23.

Point out the wrong statement.(a) Report Manager works in all modes(b) A report server is a computer that has an instance of Reporting Services installed(c) A report server integrated with SharePoint has two possible configurations(d) All of the mentionedI had been asked this question in an interview.The doubt is from Reporting Services in section Business Intelligence of SQL Server

Answer» RIGHT option is (a) REPORT MANAGER works in all modes

The EXPLANATION: Report Manager works in native mode only.
Discussion
24.

__________ is a tool to configure and manage a report server connection to the report server database.(a) Rskeymgmt Utility(b) Windows Management Instrumentation (WMI) Classes(c) Rsconfig Utility(d) None of the mentionedThis question was addressed to me in quiz.I'd like to ask this question from Reporting Services topic in section Business Intelligence of SQL Server

Answer»

Right answer is (c) Rsconfig Utility

The BEST I can EXPLAIN: You can ALSO use it to specify a USER account to use for unattended report processing.
Discussion
25.

______________ does not help you manage report server content, enable additional features, or grant access to the server.(a) Reporting Services Configuration Manager(b) SSMS(c) SQL Server Configuration Manager(d) None of the mentionedI got this question by my college professor while I was bunking the class.This question is from Reporting Services topic in portion Business Intelligence of SQL Server

Answer»

Correct option is (d) NONE of the mentioned

Easiest explanation: REPORTING SERVICES CONFIGURATION Manager is used to configure a Reporting Services installation.
Discussion
26.

Point out the correct statement.(a) The tools that you use is independent of the deployment mode of your report server(b) A set of scripting tools are available for administering the report server in SQL Server Reporting Services(c) 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(d) None of the mentionedThis question was posed to me during an interview for a job.I want to ask this question from Reporting Services in division Business Intelligence of SQL Server

Answer»

Right answer is (c) 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

Easy explanation: The tool set includes development tools, configuration and administration tools, and REPORT viewing tools.
Discussion
27.

Which of the following tool requires Reporting Services in SharePoint mode?(a) Report Designer(b) Power View(c) Report Builder(d) None of the mentionedThis question was addressed to me during an interview.Query is from Reporting Services topic in section Business Intelligence of SQL Server

Answer»

Right choice is (B) Power View

For explanation: Power view gives interactive data exploration and visual presentation experience DESIGNED to LET you create and INTERACT with reports based on Analysis Services tabular models.
Discussion
28.

__________ is the set of hierarchies from which data is retrieved for a single member.(a) Slicer axis(b) Query axes(c) Dice axis(d) All of the mentionedI got this question in exam.My query is from MDX in section Business Intelligence of SQL Server

Answer» CORRECT option is (a) SLICER axis

Easy explanation: query and slicer axes can be CONSTRUCTED from MULTIPLE hierarchies of the CUBE to be queried
Discussion
29.

Which of the following is the MDX Data Definition Statement?(a) CREATE ACTION(b) DROP CUBE(c) CREATE CUBE(d) None of the mentionedThe question was posed to me in an online quiz.My question is based upon MDX topic in section Business Intelligence of SQL Server

Answer»

Correct option is (a) CREATE ACTION

Easy explanation: Creates an action that can be associated with a cube, DIMENSION, HIERARCHY, or subordinate OBJECT.
Discussion
30.

The Backus-Naur Form (BNF) of {*( | | )} will be parsed as ______ for backwards compatibility.(a) {\}(b) {*}(c) {+}(d) {-}This question was addressed to me in an international level competition.The question is from MDX in division Business Intelligence of SQL Server

Answer»

Correct option is (b) {*}

Easy explanation: By using CALCULATED cells, the client APPLICATION can specify a ROLLUP value for a particular set of cells, INSTEAD of for an entire set of cells as in the CASE of a custom rollup formula or a calculated member.
Discussion
31.

________ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script.(a) Ignore(b) IgnoreNone(c) IgnoreAll(d) All of the mentionedThis question was addressed to me by my college professor while I was bunking the class.My doubt is from MDX topic in chapter Business Intelligence of SQL Server

Answer» CORRECT option is (B) IgnoreNone

Explanation: ERROR handling is done through the ScriptErrorHandlingMode ENUMERATOR.
Discussion
32.

Point out the correct statement.(a) Few MDX queries run within a specified cube context(b) 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 hierarchies into three subsets(d) None of the mentionedThis question was addressed to me in my homework.Asked question is from MDX in chapter Business Intelligence of SQL Server

Answer»

The correct choice is (b) SELECT statement is the most frequently used QUERY in MDX

The best explanation: By understanding how an MDX SELECT statement must specify a result set, what the syntax of the SELECT statement is, and how to create a SIMPLE query using the SELECT statement, you will have a SOLID understanding of how to USE MDX to query multidimensional data.
Discussion
33.

_______ lets you manage cube context from within an MDX script.(a) CALCULATE(b) CALC(c) SCOPE CALC(d) None of the mentionedI have been asked this question during a job interview.This key question is from MDX in division Business Intelligence of SQL Server

Answer»

Right choice is (a) CALCULATE

To EXPLAIN I would say: In Microsoft SQL Server Analysis Services, a Multidimensional Expressions (MDX) script is MADE up of ONE or more MDX expressions or STATEMENTS that POPULATE a cube with calculations.
Discussion
34.

____________distinguishes between a single-byte character and the same character when represented as a double-byte character.(a) Accent-insensitive (_AI)(b) Kana-sensitive (_KS)(c) Accent-sensitive (_AS)(d) Width-sensitive (_WS)This question was posed to me by my college professor while I was bunking the class.My question is taken from Analysis Services topic in section Business Intelligence of SQL Server

Answer»

The correct CHOICE is (d) Width-sensitive (_WS)

Explanation: There is no SORT ORDER suffix for width-insensitive sorting.
Discussion
35.

Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character?(a) BIN2 (_BIN2)1(b) Binary (_BIN)1(c) Case-sensitive (_CS)(d) Case-insensitiveThis question was addressed to me during an online interview.Asked question is from Analysis Services in division Business Intelligence of SQL Server

Answer»

The CORRECT choice is (b) Binary (_BIN)1

For explanation I would SAY: Binary sort order is case sensitive and accent sensitive. Binary is also the fastest sorting order.
Discussion
36.

If you select the __________ conversion type, a reporting currency dimension is also created.(a) one-to-one(b) many-to-one(c) many-many(d) all of the mentionedI have been asked this question during an online exam.This intriguing question comes from Analysis Services topic in portion Business Intelligence of SQL Server

Answer» RIGHT CHOICE is (b) many-to-one

The best EXPLANATION: The dimension contains only one member representing the pivot currency because the pivot currency is ALSO used as the reporting currency for one-to-many currency CONVERSION.
Discussion
37.

The Business Intelligence Wizard supports ______ different types of currency conversion.(a) 3(b) 4(c) 5(d) 6This question was posed to me in an interview for internship.My question is based upon Analysis Services topic in division Business Intelligence of SQL Server

Answer»

Correct CHOICE is (a) 3

Explanation: Specifying the conversion type allows the BUSINESS INTELLIGENCE WIZARD to define the named query and dimension structure of the REPORTING currency dimension.
Discussion
38.

Point out the wrong statement.(a) Transactions are stored in the fact table in local currencies for many-to-many conversion(b) Transactions are stored in the fact table in the pivot currency for one-to-many conversion(c) If you choose a many-to-many or one-to-many conversion type for your currency conversion, you need to specify the reporting currencies(d) None of the mentionedThis question was posed to me in an interview for job.My enquiry is from Analysis Services topic in division Business Intelligence of SQL Server

Answer» RIGHT choice is (b) Transactions are STORED in the fact table in the PIVOT currency for ONE-to-many conversion

Easiest EXPLANATION: Transactions are stored in the fact table in the pivot currency, and then converted to one or more other reporting currencies.
Discussion
39.

You can use the __________Wizard to specify which measures from the rate measure group are used to convert values.(a) BI(b) ETL(c) MIS(d) OBIEEThis question was addressed to me during an interview.This interesting question is from Analysis Services in section Business Intelligence of SQL Server

Answer» RIGHT choice is (a) BI

Best explanation: You choose the EXCHANGE rate DIRECTION on the SET currency conversion options page of the Business Intelligence Wizard.
Discussion
40.

For _________ currency conversions, the pivot currency and reporting currency are the same.(a) one-to-one(b) many-to-one(c) many-many(d) all of the mentionedThe question was asked during an interview.The query is from Analysis Services topic in chapter Business Intelligence of SQL Server

Answer» CORRECT ANSWER is (b) many-to-one

Easiest EXPLANATION: REPORTING currency is the currency to which transactions are converted from the pivot currency.
Discussion
41.

Point out the correct statement.(a) The Type property of the dimension is set to Reporting Currency(b) The Type property of one attribute for the dimension is set to CurrencyName in Latin(c) The values of Type attribute must be used in all columns that should contain a currency identifier(d) All of the mentionedThe question was asked in a job interview.I'm obligated to ask this question of Analysis Services in portion Business Intelligence of SQL Server

Answer»

The correct answer is (a) The Type PROPERTY of the dimension is SET to Reporting CURRENCY

Best EXPLANATION: Currency dimension is a DATABASE dimension defined with type property of the dimension set to Currency.
Discussion
42.

_______ is currency used to store transactions on which measures to be converted are based in SSAS.(a) Local currency(b) Pivot currency(c) Global currency(d) None of the mentionedThis question was posed to me in an online quiz.Enquiry is from Analysis Services in division Business Intelligence of SQL Server

Answer»

The correct answer is (a) Local currency

Explanation: A Local currency identifier associated with an ATTRIBUTE in a DIMENSION table that is then associated with a TRANSACTION in the FACT table.
Discussion
43.

By default, in a ________ schema, all attributes are directly related to the key attributes.(a) Relational(b) Snowflake(c) Star(d) None of the mentionedThe question was asked by my college professor while I was bunking the class.The above asked question is from Analysis Services topic in section Business Intelligence of SQL Server

Answer»

The correct choice is (c) Star

Easy explanation: Star schema enables users to browse the facts in the CUBE BASED on any attribute HIERARCHY in the DIMENSION.
Discussion
44.

Which of the following property is set to zero so that all levels are not created?(a) Aggregatable(b) IsAggregatable(c) IsAggregate(d) All of the mentionedI had been asked this question during an online interview.This interesting question is from Analysis Services topic in chapter Business Intelligence of SQL Server

Answer»

The CORRECT OPTION is (b) IsAggregatable

Easiest explanation: The All level CONTAINS the aggregated value of the attribute’s members across the measures in each measure group to which the DIMENSION of which the attribute is RELATED is a member.
Discussion
45.

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.(a) Dim(b) KEY(c) PK(d) None of the mentionedI have been asked this question during an interview.This is a very interesting question from Analysis Services in section Business Intelligence of SQL Server

Answer»

The CORRECT answer is (B) KEY

Easiest explanation: TYPICALLY, the key attribute REPRESENTS the primary key column or columns in the dimension table.
Discussion
46.

Which of the following is not supported by linked dimensions?(a) readback(b) writeback(c) readwrite(d) all of the mentionedI had been asked this question in an internship interview.My question is from Analysis Services topic in division Business Intelligence of SQL Server

Answer»

Correct answer is (B) writeback

Explanation: In Microsoft SQL Server 2005 Analysis SERVICES (SSAS), a LINKED dimension is based on a dimension that is stored in another Analysis Services database.
Discussion
47.

Point out the wrong statement.(a) The data in a dimension is generally read-write both(b) Upon connection, the client passes the LCID to the instance of Analysis Services(c) For a write-enabled cube or partition, updates are stored in a writeback table separate from the cube’s source tables(d) All of the mentionedI have been asked this question in an international level competition.The origin of the question is Analysis Services topic in chapter Business Intelligence of SQL Server

Answer»

Correct CHOICE is (a) The data in a DIMENSION is GENERALLY read-write both

The BEST explanation: The data in a dimension is generally read-only.
Discussion
48.

Updates to the ______ attribute in a parent-child hierarchy must not include updates to any other properties or attributes.(a) child(b) parent(c) both child and parent(d) none of the mentionedI have been asked this question in an international level competition.My doubt stems from Analysis Services in portion Business Intelligence of SQL Server

Answer»

Right choice is (B) PARENT

The best explanation: If a member of a parent-child HIERARCHY is deleted, the member’s CHILDREN are moved to the member’s parent.
Discussion
49.

Members of a _________ dimension can only be moved within the same level.(a) readback(b) writeback(c) readwrite(d) all of the mentionedI have been asked this question during a job interview.My enquiry is from Analysis Services topic in chapter Business Intelligence of SQL Server

Answer» CORRECT answer is (B) writeback

Explanation: For a write-enabled DIMENSION, updates are RECORDED directly in the dimension’s table.
Discussion
50.

Point out the correct statement.(a) The collation and language information for the client computer is stored in the form of a locale identifier (LCID)(b) SQL Server 2008 Analysis Services also supports translations of cube objects(c) SQL Server 2000 Analysis Services supports translations of cube objects(d) None of the mentionedI have been asked this question in an online quiz.My question is from Analysis Services in section Business Intelligence of SQL Server

Answer» CORRECT answer is (a) The collation and language information for the client COMPUTER is stored in the FORM of a locale IDENTIFIER (LCID)

The best explanation: The instance uses the LCID to determine which set of translations to use when providing metadata for Analysis Services OBJECTS.
Discussion