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…

You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which users can filter the report by a single date. The…

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription schedules and report formats. You need to ensure that users can receive reports by email…

You are developing a SQL Server Reporting Services (SSRS) solution. You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular database configured in DirectQuery mode. You need to configure a shared data source. Which data source…

You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet- facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured. You need to upgrade to SSRS 2012 with the minimum downtime and…

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. You have the following requirements: - The…

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy. You need to return only the female customers in…

You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart. You have the following requirements: - Ensure that the process supports the creation of…

A hospital has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Pharmacy. Shared data sources exist in SSRS for the relational and…

You are designing a self-service reporting solution based on published PowerPivot workbooks. The reporting solution must allow users to perform the following tasks: - Easily create reports. - Create report queries by dragging and dropping fields. - Create presentation-quality reports…