Analysis Services interview questions part 1
Analysis Services interview questions part 1
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. CALCULATE statement is used to populate each cell in the cube with aggregated data.
Correct Answer is : TRUE
2. When processing a task, objects can be processed in a batch or in a sequence only.
Correct Answer is : FALSE
3. The Analysis Services Processing task can be used to process which of the following objects?
Correct Answer is : All of the above
4. What is Microsoft SQL Server 2005 Analysis Services used for?
Correct Answer is : Both a and b
5. _________________ feature is used to copy database from one source server to a destination server.
Correct Answer is : Synchronization
6. The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.
Correct Answer is : server
7. Point out the correct statement :
Correct Answer is : The permissions of a role may allow members to access and administer the database
8. Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created ?
Correct Answer is : Database
9. _________ let you create external, user-defined functions using any common language runtime (CLR) language
Correct Answer is : Assemblies
10. Point out the wrong statement :
Correct Answer is : The SSAS host-level policy is a combination of Analysis Services fixed policy for system assemblies and user-specified policy for user assemblies
11. Which of the following permission setting provides internal computation permission ?
Correct Answer is : safe
12. If the __________ setting is used, the execution context is corresponds to the Windows login user account IUSER_servername on the server.
Correct Answer is : ImpersonateAnonymous
13. Which of the following namespace discover set of assemblies ?
Correct Answer is : System.Reflection
14. Security for stored procedures is set with the _________ property on a stored procedure.
Correct Answer is : PermissionSet
15. If functions in one assembly call functions in a separate assembly, you must register both assemblies in :
Correct Answer is : server
16. In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.
Correct Answer is : Dimension translation
17. Point out the correct statement :
Correct Answer is : The collation and language information for the client computer is stored in the form of a locale identifier (LCID)
18. Members of a _________ dimension can only be moved within the same level.
Correct Answer is : writeback
19. Updates to the ______ attribute in a parent-child hierarchy must not include updates to any other properties or attributes.
Correct Answer is : parent
20. Point out the wrong statement :
Correct Answer is : The data in a dimension is generally read-write both
