View Count: 0
Duration: 27 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

good

Posted By sourabh Patil on 25-Sep-2017

good

Posted By sourabh Patil on 25-Sep-2017
Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 9
How to create free form layout? 
Options:
  1. By using table
  2. By using Matrix
  3. By using List
  4. None of these
View Answer/Explanation:
b
Explanation:

Question No: 2 of 9
How many different tools we can use to create reports? 
Options:
  1. Report Designer
  2. Report Builder
  3. Data Sources
  4. Report Manager
View Answer/Explanation:
a b
Explanation:

Question No: 3 of 9
Which of the following statement is used to retrieve rows from the view ExecutionLog3? 
Options:
  1. Select * from ExecutionLog3 order by TimeStart DESC
  2. Select * from ExecLog3 order by TimeStart DESC
  3. Select * from ExecutionLog4 order by TimeStart DESC
  4. None of the mentioned
View Answer/Explanation:
a
Explanation:
ExecutionLog3 view added additional performance diagnostics node inside the XML based Additional Info column

Question No: 4 of 9
Which of the following tool requires Reporting Services in SharePoint mode? 
Options:
  1. Report Designer
  2. Power View
  3. Report Builder
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:
Power view gives interactive data exploration and visual presentation experience designed to let you create and interact with reports based on Analysis Services tabular models

Question No: 5 of 9
Point out the correct statement: 
Options:
  1. The tools that you use are independent of the deployment mode of your report server
  2. A set of scripting tools are available for administering the report server in SQL Server Reporting Services
  3. SQL Server Reporting Services contains a set of graphical and scripting tools that support the development and use of rich reports in a managed environment
  4. None of the mentioned
View Answer/Explanation:

Explanation:
The tool set includes development tools, configuration and administration tools, and report viewing tools

Question No: 6 of 9
Reports use __________ to retrieve data for a report when a query runs or when the report is processed. 
Options:
  1. Data connections
  2. Data source definition
  3. Connection string
  4. All of the mentioned
View Answer/Explanation:
a
Explanation:
A data connection includes a name and connection properties that are dependent on the connection type

Question No: 7 of 9
What are the different items are present in Report Data Window Container? 
Options:
  1. Parameters
  2. Images
  3. Data Sources
  4. Data Sets
View Answer/Explanation:
a b c d
Explanation:

Question No: 8 of 9
What is an extension of SSRS reports? 
Options:
  1. .RDL
  2. .DRL
  3. .MGR
  4. .SSR
View Answer/Explanation:
a
Explanation:

Question No: 9 of 9
RDL stands for 
Options:
  1. Report Data Language
  2. Report Definition Language
  3. Report Dimension Language
  4. Report Design Language
View Answer/Explanation:
b
Explanation:

  1