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 deployment model must support changing the content of connection strings by using parameters at execution time.✑ The deployment model must automatically log events to the SSISDB database.✑ Maximize performance at execution time.You need to design a solution that meets the requirements.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
HOTSPOT -You are setting role permissions for a SQL Server Analysis Service (SSAS) cube.You plan to grant Read access for specific attribute members only to specific Active Directory security groups.You need to enter a Multidimensional Expressions (MDX) expression to configure the attribute member access.On which tab should you enter the MDX expression? To answer, select the appropriate tab in the answer area.Hot Area:
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 hardware requirements.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales. Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.The FactSales5 partition contains the current year's information. The other partitions contain information from prior years; one year per partition. Currently, no aggregations are defined on the partitions.You remove fact rows that are more than five years old from the fact table in the data source and configure query logs on the SSAS server.Several queries and reports are running very slowly.You need to optimize the partition structure and design aggregations to improve query performance and minimize administrative overhead.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
HOTSPOT -A school stores information about teachers, students, classes, and enrollments in a Windows Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects.The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.You need to ensure that the report parameter displays the correct subjects for each teacher.Which item should you configure? To answer, select the appropriate item in the answer area.Hot Area:
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.)
