You need to temporarily suspend the shared schedule until the email server is brought back online
You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting
Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are
configured to deliver reports through email by using a shared schedule.
The email server will be going offline.
You need to temporarily suspend the shared schedule until the email server is brought back
online.
What should you do?
Which view should you identify?
You have a database that uses the following management views:
Sys.dm_os_volume_stats
Sys.dm_db_partition_stats
Sys.dm_db_file_space_usage
Sys.fulltext_indexes
You plan to migrate the database to Microsoft SQL Azure.
You need to identify which view can be used in SQL Azure.
Which view should you identify?
What three tasks should you perform next?
DRAG DROP
You plan to create a custom aggregation function named Function1.
You plan to deploy Function1 to SQL Server 2012.
You need to ensure that Function1 can access a web service. The solution must minimize
the number of changes made to the database.
You create a Microsoft .NET Framework class that contains the definition of Function1.
You upload a certificate to SQL Server.
What three tasks should you perform next?
To answer, move the appropriate actions from the list of actions to the answer area and
arrange them in the correct order.
Which role should you assign?
You administer a SQL Server Reporting Services (SSRS) instance in native mode.
You need to assign a predefined role that meets the following requirements:
Members of the role must be able to update shared data sources.
Members of the role must not be able to consume reports or manage subscriptions.
The role must provide only the minimum permissions required.
Which role should you assign? (More than one answer choice may achieve the goal. Select
the BEST answer.)
Which source of spatial data should you use for the map?
You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has
Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a
Microsoft Azure SQL Database database.
The report must use a map to display the location and status of the ATMs as shown in the
following exhibit. (Click the Exhibit button.)
You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?
Which four actions should you perform in sequence?
DRAG DROP
You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are
building a shared dataset for your weekly performance reports. The shared dataset uses a
data source that is configured to use credentials that are stored in the Report Server.
You have a predefined shared schedule to perform cleanup and maintenance tasks for SSRS.
You need to enable caching on the shared dataset. You also need to use an existing shared
schedule to discard the cache.
Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
You need to ensure that up_customers returns rows when the following statement is executed: EXECUTEup_customer
You have a SQL Server 2012 database named Database1.
Database1 has a table named Customers. Customers contains more than 1 million rows.
The database has a stored procedure that was created by using the following script:
You need to ensure that up_customers returns rows when the following statement is
executed:
EXECUTEup_customers’1,2,3,4,5′;
What should you do?
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting sol
You are designing a strategy for an enterprise reporting solution that uses SQL Server
Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
Report utility functions and business logic in code
Standardized report formatting properties such as fonts and colors for report branding
Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire
enterprise reporting solution. You must also ensure that reports can be easily updated to
reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You need to modify the table to include a graphical item displaying the inventory count trend to the right of
You are developing a SQL Server Reporting Services (SSRS) report. The report includes a
dataset with fields namedYear Month Number, and InvCount. The report includes a table
that displays the inventory count per year, as shown in the following table.
You need to modify the table to include a graphical item displaying the inventory count trend
to the right of the Inv Count column.
What should you do?
Which dynamic management view should you use?
You need to identify which long running transactions use an index.
Which dynamic management view should you use?