Home / CSE MCQs / SQL Server MCQs :: SQL Server Business Intelligence

CSE MCQs :: SQL Server MCQs

  1. _________ let you create external, user-defined functions using any common language runtime (CLR) language
  2. A.
    Aggregate
    B.
    Assemblies
    C.
    Synonym
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Members of a _________ dimension can only be moved within the same level.
  4. A.
    readback
    B.
    writeback
    C.
    readwrite
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Which of the following is not supported by linked dimensions ?
  6. A.
    readback
    B.
    writeback
    C.
    readwrite
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Point out the wrong statement :
  8. 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 mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. The Business Intelligence Wizard supports ______ different types of currency conversion.
  10. A.
    3
    B.
    4
    C.
    5
    D.
    6

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Point out the wrong statement :
  12. 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 mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Point out the wrong statement :
  14. A.
    Data is factual information for analysis
    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
    C.
    Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. The Backus-Naur Form (BNF) of {*( | | )} will be parsed as ______ for backwards compatibility.
  16. A.
    {\}
    B.
    {*}
    C.
    {+}
    D.
    {-}

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Point out the correct statement :
  18. A.
    Only droping the default member is supported in MDX Scripting
    B.
    In the SELECT statement, the FROM clause determines the cube context
    C.
    Very few cube can control how errors within a Multidimensional Expressions (MDX) script are handled
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. Point out the wrong statement :
  20. 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 mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum