Analysis services online test with 15 practice questions & some sample
questions. This Analysis services quiz helps you prepare for upcoming
interviews, certification tests and other entrance exams. The score displayed
at the end of test helps you assess your level of preparation.
Here are few sample Analysis services quiz/test questions
What is Microsoft SQL Server 2005 Analysis Services used for?
Delivers online analytical processing (OLAP).
Delivers data mining functionality
used for extracting and storing data which allows easier reporting
Both a and b
What is the typical fashion of processing a task?
Typically, you process dimension tables before processing fact tables
Typically, you process fact tables before dimension fact tables
Either a or b
Both can be processed simultaneously
What is the purpose of ReadContingent access right?
allows members of the role to read from the object
allows members of the role to read a cell value only if the user can access all
the cells from which the value is derived
provides Read access for any cells specified by this permission that are not
derived from other cells
Both b and c
Click here to
start Analysis services practice quiz/test
Servive brokers allow build applications in which independent components work
together to accomplish a task. They help build scalable, secure database
applications. The brokers provide a message based ..................
Synchronization feature is used to copy database from one source server to a
destination server. While the synchronization is in progress, users can still
browse the cubes..................