SQL Server Questions and Answers – Analysis Services – 1

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Analysis Services – 1”.

1. The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.
a) database
b) server
c) user
d) none of the mentioned
View Answer

Answer: b
Explanation: Members of this role have access to all Analysis Services databases and objects on an instance of Analysis Services.

2. Point out the correct statement.
a) The permissions of a role may allow members to access and administer the database
b) Server roles, roles defined by administrators to control access to objects and data for non-administrator user
c) Database roles, roles defined by administrators to control access to objects and data for administrator user
d) None of the mentioned
View Answer

Answer: a
Explanation: Each permission has one or more access rights associated with it, which in turn gives the permission finer control over access to a particular object in the database.

3. 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?
a) Database
b) Membership
c) Client
d) Server
View Answer

Answer: a
Explanation: An Analysis Services database role defines user access to objects and data in an Analysis Services database.

4. _________ let you create external, user-defined functions using any common language runtime (CLR) language.
a) Aggregate
b) Assemblies
c) Synonym
d) All of the mentioned
View Answer

Answer: b
Explanation: Assemblies let you extend the business functionality of MDX and DMX.

advertisement
advertisement

5. Point out the wrong statement.
a) The SSAS host-level policy is a combination of Analysis Services fixed policy for system assemblies and user-specified policy for user assemblies
b) Security for assemblies is based on the .NET Framework security model, which is a code-access security model
c) Calling a user-defined function in an assembly is performed just like calling an intrinsic function
d) All of the mentioned
View Answer

Answer: a
Explanation: The Analysis Services host-level policy is a combination of Analysis Services fixed policy for system assemblies and user-specified policy for user assemblies.

6. Which of the following permission setting provides internal computation permission?
a) Unsafe
b) ExternalAccess
c) Safe
d) All of the mentioned
View Answer

Answer: c
Explanation: This permission bucket does not assign permissions to access any of the protected resources in the .NET Framework.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

7. If the __________ setting is used, the execution context corresponds to the Windows login user account IUSER_servername on the server.
a) ImpersonateAnon
b) Anonymous
c) ImpersonateAnonymous
d) None of the mentioned
View Answer

Answer: c
Explanation: The default setting, ImpersonateCurrentUser, runs an assembly under the current user’s network login account.

8. Which of the following namespace discover set of assemblies?
a) System.Reflection
b) System.Refraction
c) Sys.Reflection
d) All of the mentioned
View Answer

Answer: a
Explanation: Analysis Services does not expose application domains directly.

advertisement

9. Security for stored procedures is set with the _________ property on a stored procedure.
a) PermissionSet
b) SetPermissionSet
c) Permission
d) None of the mentioned
View Answer

Answer: a
Explanation: You can use stored procedures to call external routines from Microsoft SQL Server 2005 Analysis Services(SSAS).

10. If functions in one assembly call functions in a separate assembly, you must register both assemblies in ____________
a) client
b) server
c) table
d) none of the mentioned
View Answer

Answer: b
Explanation: Stored procedures are registered on a server or on a database. Server stored procedures can be called from any query context.

advertisement

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.