You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a Microsoft SharePoint 2010 farm.You need to upgrade to SSRS 2014 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 designing a partitioning strategy for a SQL Server Analysis Services (SSAS) cube. New data is loaded in real-time into the data warehouse that feeds the cube. Between 10 million and 15 million rows of data are loaded into the main fact table each day from a Microsoft Azure SQL Database.You have the following requirements:✑ Maximize cube query performance during business hours.✑ Ensure that data is available in the cube as soon as possible after it is loaded into the data warehouse.You need to design a partitioning strategy that meets the requirements.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
