Sail E0 Webinar

MCQs

Total Questions : 10
Question 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
 Discuss Question
Answer: Option B. -> Assemblies


Assemblies let you extend the business functionality of MDX and DMX.


Question 2. Members of a _________ dimension can only be moved within the same level.
  1.    readback
  2.    writeback
  3.    readwrite
  4.    All of the mentioned
 Discuss Question
Answer: Option B. -> writeback


For a write-enabled dimension, updates are recorded directly in the dimension's table.


Question 3. Which of the following is not supported by linked dimensions ?
  1.    readback
  2.    writeback
  3.    readwrite
  4.    All of the mentioned
 Discuss Question
Answer: Option B. -> writeback


In Microsoft SQL Server 2005 Analysis Services (SSAS), a linked dimension is based on a dimension that is stored in another Analysis Services database.


Question 4. The Business Intelligence Wizard supports ______ different types of currency conversion.
  1.    3
  2.    4
  3.    5
  4.    6
 Discuss Question
Answer: Option A. -> 3


Specifying the conversion type allows the Business Intelligence Wizard to define the named query and dimension structure of the reporting currency dimension.


Question 5. 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
 Discuss Question
Answer: Option B. -> Transactions are stored in the fact table in the pivot currency for one-to-many conversion


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


Question 6. Point out the wrong statement :
  1.    The Detect Categories tool detects the rows in the data table that contain similar characteristics and groups them into categories
  2.    The tool employs SQL Server Data Mining to detect patterns in the sample you provide and apply those to the remaining missing values
  3.    The Detect categories tool predicts future values based on trends in existing time series data.
  4.    All of the mentioned
 Discuss Question
Answer: Option C. -> The Detect categories tool predicts future values based on trends in existing time series data.


The Forecast tool predicts future values based on trends in existing time series data.


Question 7. 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
 Discuss Question
Answer: Option A. -> Report Manager works in all modes


Report Manager works in native mode only.


Question 8. The Backus-Naur Form (BNF) of {*( | | )} will be parsed as ______ for backwards compatibility.
  1.    {\}
  2.    {*}
  3.    {+}
  4.    {-}
 Discuss Question
Answer: Option B. -> {*}


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.


Question 9. Point out the wrong statement :
  1.    Data is factual information for analysis
  2.    BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data
  3.    Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data


Online Analytical Processing is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data.


Question 10. Point out the correct statement :
  1.    Only droping 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
 Discuss Question
Answer: Option B. -> In the SELECT statement, the FROM clause determines the cube context


This context can be the whole cube or just a subcube from that cube. Having specified cube context through the FROM clause, you can use additional functions to expand or restrict that context.


Latest Videos

Latest Test Papers