Business Intelligence Set 2

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Free Online Best Business Intelligence MCQ Questions for improve your basic knowledge of Business Intelligence. This Business Intelligence set 2 test that contains 25 Multiple Choice Questions with 4 options. You have to select the right answer to a question.

Start

Congratulations - you have completed Business Intelligence Set 2.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

Which of the following is a list type in RDL with base 64 encoded value?

A	Boolean
B	Binary
C	Enum
D	Name

Question 2

Security for stored procedures is set with the _________ property on a stored procedure

A	PermissionSet
B	SetPermissionSet
C	Permission
D	SetPermissiont

Question 3

For _________ currency conversions, the pivot currency and reporting currency are the same

A	one-to-one
B	many-to-one
C	many-many
D	All of the Above

Question 4

You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode

A	Native, Sharepoint
B	Sharepoint, Native
C	Native, Native
D	Sharepoint, Sharepoint

Question 5

_________ let you create external, user-defined functions using any common language runtime (CLR) language

A	Aggregate
B	Assemblies
C	Synonym
D	All of the above

Question 6

Which of the following namespace discover set of assemblies?

A	System.Reflection
B	System.Refraction
C	Sys.Reflection
D	Systm.Reflection

Question 7

_______ is currency used to store transactions on which measures to be converted are based in SSAS

A	Local currency
B	Pivot currency
C	Global currency
D	None of the above

Question 8

An ___________ report is a fully paged report saved in a specific file format

A	exported
B	fully processed
C	compiled
D	All of the above

Question 9

The Schedule and Delivery Processing feature must be enabled through the ____________ property

A	ScheduleEventsDeliveryEnabled
B	ScheduleEventsAndReportDeliveryEnabled
C	ScheduleEventsAndReportDelivery
D	All of the above

Question 10

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 above

Question 11

A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information

A	Main
B	Detail
C	Drillthrough
D	All of the above

Question 12

Which of the following permission setting provides internal computation permission?

A	Unsafe
B	ExternalAccess
C	Safe
D	Membership

Question 13

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	server
C	user
D	Membership

Question 14

Point out the correct statement____

A	The Type property of the dimension is set to Reporting Currency
B	The Type property of one attribute for the dimension is set to CurrencyName in Latin
C	The values of Type attribute must be used in all columns that should contain a currency identifier
D	All of the Above

Question 15

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 above

Question 16

The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue

A	FireEvent
B	FireEventdata
C	Eventdata
D	None of the above

Question 17

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 above

Question 18

You can use the __________ Wizard to specify which measures from the rate measure group are used to convert values

A	BI
B	ETL
C	MIS
D	OBIEE

Question 19

Which of the following statement is used to retrieve rows from the view ExecutionLog3?

A	select * from ExecutionLog3 order by TimeStart DESC
B	select * from ExecLog3 order by TimeStart DESC
C	select * from ExecutionLog4 order by TimeStart DESC
D	None of the above

Question 20

__________ are portable, multipurpose items that contain ready-to-use schedule information

A	Report-specific schedule
B	Shared schedules
C	File schedules
D	None of the above

Question 21

Point out the correct statement____

A	A published report is a report definition (.rdl) file
B	A saved report is a published report definition that is converted to a newer schema when a report server is upgraded
C	Report history is a collection of report snapshots
D	All of the above

Question 22

Point out the wrong statement____

A	A report snapshot is a report that contains layout information and query results that were retrieved at a specific point in time. Unlike on-demand reports
B	A detailed report is a saved copy of a compiled report and report data
C	A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries
D	All of the above

Question 23

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 above

Question 24

If functions in one assembly call functions in a separate assembly, you must register both assemblies in ____________

A	user
B	client
C	server
D	table

Question 25

Point out the wrong statement___

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 above

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 25 questions to complete.

←

List

→

Return

Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	17	18	19	20
21	22	23	24	25
End

Return

BACK SET 1

NEXT SET 3

Study Zone

MCQ » Business Intelligence Set 2

Business Intelligence Set 2

Important Links