CSE MCQs :: SQL Server MCQs
- _________ let you create external, user-defined functions using any common language runtime (CLR) language
- Members of a _________ dimension can only be moved within the same level.
- Which of the following is not supported by linked dimensions ?
- Point out the wrong statement :
- The Business Intelligence Wizard supports ______ different types of currency conversion.
- Point out the wrong statement :
- Point out the wrong statement :
- The Backus-Naur Form (BNF) of {*( | | )} will be parsed as ______ for backwards compatibility.
- Point out the correct statement :
- Point out the wrong statement :
Whatsapp
Facebook
|
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
|
|
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
|
|
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
|