Question 21 : Which of the following is a tool for Report Content Management?
1. Report Server Web service URL
2. Rskeymgmt Utility
3. Configuration manager
4. All of the mentioned
View Answer   Discuss with Members

Question 22 : __________ is a tool to configure and manage a report server connection to the report server database.
1. Rskeymgmt Utility
2. Windows Management Instrumentation (WMI) Classes
3. Rsconfig Utility
4. None of the mentioned
View Answer   Discuss with Members

Question 23 : ______________ does not help you manage report server content, enable additional features, or grant access to the server.
1. Reporting Services Configuration Manager
2. SSMS
3. SQL Server Configuration Manager
4. None of the mentioned
View Answer   Discuss with Members

Question 24 : Which of the following tool requires Reporting Services in SharePoint mode?
1. Report Designer
2. Power View
3. Report Builder
4. None of the mentioned
View Answer   Discuss with Members

Question 25 : Which of the following keyword forces a specified set to be evaluated within the current context ?
1. SCOPE
2. CASE
3. EXISTING
4. FREEZE
View Answer   Discuss with Members

Question 26 : Which of the following is valid syntax for DRILLTHROUGH statement ?
1.

DRILLTHROUGH[MAXROWSUnsigned_Integer]       <MDX SELECT statement>       [RETURNSet_of_Attributes_and_Measures             [,Set_of_Attributes_and_Measures ...]      ]
  2.  
DRILL[MAXROWSUnsigned_Integer]       <MDX SELECT statement>       [RETURNSet_of_Attributes_and_Measures             [,Set_of_Attributes_and_Measures ...]      ]
 
 3.  
DRILLTHROUGH[MAXROWSUnsigned_Integer]       <MDX SELECT statement>
 
  4.  None of the mentioned 

                                                
                                                    
                                                     View Answer
                                                       Discuss with Members
                                            

Question 27 : When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.
1. USE_EQUAL_ALLOCATION
2. USE_WEIGHTED_ALLOCATION
3. USE_WEIGHTED_INCREMENT
4. All of the mentioned
View Answer   Discuss with Members

Question 28 : If a weight expression is not specified, the UPDATE CUBE statement implicitly uses the following expression:
1. Weight_Expression = *
2. Weight_Expression = /
3. Weight_Expression = –
4. Weight_Expression = +
View Answer   Discuss with Members

Question 29 : _________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.
1. UPDATE CUBE
2. DELETE CUBE
3. ALTER CUBE
4. None of the mentioned
View Answer   Discuss with Members

Question 30 : When you include a many-to-many dimension, the following rules apply
1. You must add the intermediary measure group
2. You must add the entire many-to-many dimension
3. You must add the entirety of all dimensions common to the two measure groups involved in the many-to-may relationship
4. All of the mentioned
View Answer   Discuss with Members