What is the easiest way to ensure that users can receive reports according to the schedules and format they sp
You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS).
A Windows Server 2008R2 server named ABC-Mail1 runs the Simple Mail Transport
Protocol (SMTP) service.
ABC-SSRS01 has a report named CorpReport1. Users will subscribe to CorpReport1 using
various schedules and reporting formats. The schedules and format information is entered
in a table by a custom application. The reports will be emailed using ABC-Mail1.
What is the easiest way to ensure that users can receive reports according to the
schedules and format they specify?
Which two of the following actions would require the least amount of development effort to achieve this goal?
You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). Another Windows Server 2012 server named ABC-SSRS01 runs SQL
Server 2012 Reporting Services (SSRS).
ABC-SSRS01 has a report that company users use to query a cube on ABC-SSAS01.
Users filter the report by a single date using Date/Time data type report parameter. The
Multidimensional Expressions (MDX) query for the dataset cannot be filtered by directly
using the report parameter.
You need to ensure that a value entered by the user can be used to filter the report data.
Which two of the following actions would require the least amount of development effort to
achieve this goal? (Choose two)
Which role should users be assigned to enable them to create folders and upload and deploy reports?
You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS). SSRS is configured to run in native mode.
You are evaluating the SSRS predefined roles to determine which users should be
assigned to the roles.
Company security policy states that all users must be assigned the minimum permissions
to perform their required tasks.
Which role should users be assigned to enable them to create folders and upload and
deploy reports?
Which role should users be assigned to enable them to run reports, subscribe to reports, and navigate through
You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS). SSRS is configured to run in native mode.
You are evaluating the SSRS predefined roles to determine which users should be
assigned to the roles.
Company security policy states that all users must be assigned the minimum permissions
to perform their required tasks.
Which role should users be assigned to enable them to run reports, subscribe to reports,
and navigate through the folder structure?
Which role should users be assigned to enable them to view basic information about the report server such as t
You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS). SSRS is configured to run in native mode.
You are evaluating the SSRS predefined roles to determine which users should be
assigned to the roles.
Company security policy states that all users must be assigned the minimum permissions
to perform their required tasks.
Which role should users be assigned to enable them to view basic information about the
report server such as the schedule information in a shared schedule?
Which role should users be assigned to give them full permission to manage report server content…?
You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS). SSRS is configured to run in native mode.
You are evaluating the SSRS predefined roles to determine which users should be
assigned to the roles.
Company security policy states that all users must be assigned the minimum permissions
to perform their required tasks.
Which role should users be assigned to give them full permission to manage report server
content, including the ability to grant permissions to other users, and to define the folder
structure for storing reports and other items?
Where should the corporate branding, fonts and text styles and the function code should be stored?
You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft
SQL Server 2012 environment and has recently deployed SQL Server 2012 Reporting
Services (SSRS).
The company will eventually use hundreds of SSRS reports. All the reports will use the
standard corporate branding, fonts and text styles. Many of the reports will also use
common functions that will be coded by developers.
You need to recommend a reporting strategy that enables all reports to use the corporate
branding and fonts and the function code. You need to be able to modify the corporate
branding and function code if required without recreating all the reports.
Where should the corporate branding, fonts and text styles and the function code should
be stored?
Which of the five package configuration options should you use?
You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages. You need
to select a package configuration option that will allow you to store multiple configuration
properties and values and will enable multiple packages to use the configuration.
Which of the five package configuration options should you use?
Which of the five package configuration options are always applied last, regardless of where you place them in
You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages.
Which of the five package configuration options are always applied last, regardless of
where you place them in the configurations organizer?
Which two of the following options describe the solution that meets the requirements and minimizes development
You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure which includes SQL Server
Integration Services (SSIS).
You need to create a project in SSIS that will contain multiple SSIS packages.
The variables and connection managers will be the same for all SSIS packages within the
project. You need to parameterize the connection manager strings to enable the properties
to be updated for subsequent package runs.
You need to ensure that calls to the catalog.start_execution stored procedure in the
Analysis Services database start your deployment model and that performance is
maximized.
Which two of the following options describe the solution that meets the requirements and
minimizes development effort? (Choose two).