Business Intelligence Set 4

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 4 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 4.

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

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

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

A	exported
B	fully processed
C	compiled
D	Drillthrough

Question 2

Which of the following tool analyzes and highlights data rows that do not appear to match the general patterns found in the rest of the table?

A	Exceptions
B	Highlight
C	Scenario Analysis
D	Highlight Exceptions

Question 3

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

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

Question 4

A __________ is a report server item that contains a pointer to the report definition

A	Drilldown report
B	Linked report
C	Subreport
D	Drillthrough report

Question 5

_____________ allows you to analyze your spreadsheet data in powerful ways

A	Data Mining Templates for Visio
B	Table Analysis Tools for Excel
C	Data Mining Client for Excel
D	Data Client for Excel

Question 6

Point out the correct statement____

A	You cannot create and save connections to re-use data sources, repeat experiments, or re-train models
B	The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007
C	The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data
D	The add-ins are built on the capabilities of the .NET Framework 3.0 and the .NET programmability support provided by Office 2007

Question 7

In order to use the Analyze in Excel feature, you must have ___________ installed on the system

A	SSDT
B	SSMS
C	SSMA
D	SSTD

Question 8

___________ analyzes the patterns in data that have the strongest influence on a certain outcome

A	Analyze Key Influencers
B	Detect Categories
C	Fill From Example
D	Fill From sample

Question 9

Reports use __________ to retrieve data for a report when a query runs or when the report is processed

A	Data connections
B	Data source definition
C	Connection string
D	Data source

Question 10

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

A	ScheduleEventsDeliveryEnabled
B	ScheduleEventsAndReportDeliveryEnabled
C	ScheduleEventsAndReportDelivery
D	ScheduleAndReportDelivery

Question 11

Which of the following mode lets you interact with the report server, reports, and report related items by using a browser with Report Manager or URL access commands?

A	SharePoint mode report server
B	Native
C	SSRS
D	All of the above

Question 12

__________ is a tool to configure and manage a report server connection to the report server database

A	Rskeymgmt Utility
B	Windows Management Instrumentation (WMI) Classes
C	Rsconfig Utility
D	None of the above

Question 13

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 14

Point out the wrong statement____

A	Report Manager works in all modes
B	A report server is a computer that has an instance of Reporting Services installed
C	A report server integrated with SharePoint has two possible configurations
D	All of the above

Question 15

Which of the following is a tool for Report Content Management?

A	Report Server Web service URL
B	Rskeymgmt Utility
C	Configuration manager
D	Riskymgmt Utility

Question 16

Scenario Analysis tool allows you to model _______ types of scenarios

A	5
B	2
C	3
D	4

Question 17

_____________ for Office is a lightweight set of tools for predictive analytics

A	SQL Server 2008 Data Mining Add-ins
B	SQL Server 2012 Data Mining Add-ins
C	SQL Server 2014 Data Mining Add-ins
D	SQL Server 2012 Data Mining Excel

Question 18

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	A published report is a pdf file

Question 19

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	data Event

Question 20

Point out the wrong statement____

A	The Detect Categories tool detects the rows in the data table that contain similar characteristics and groups them into categories
B	The tool employs SQL Server Data Mining to detect patterns in the sample you provide and apply those to the remaining missing values
C	The Detect categories tool predicts future values based on trends in existing time series data
D	All of the above

Question 21

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 22

Fill From Example tool also produces a patterns report similar to ___________

A	Analyze Key Influencers
B	Detect Categories
C	Fill From Example
D	Fill From sample

Question 23

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

A	Boolean
B	Binary
C	Enum
D	Name

Question 24

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

A	Report-specific schedule
B	Shared schedules
C	File schedules
D	specific schedule

Question 25

A _________ is an item stored internally in an alerting database

A	Connection string
B	Data alert
C	Shared data source
D	Data connections

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 3

Study Zone

MCQ » Business Intelligence Set 4

Business Intelligence Set 4

Important Links