Microsoft-Implementing Data Models and Reports with Microsoft SQL Server 2012 Set 2

You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a Microsoft Azure SQL Database database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data. You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT). The model must meet the following requirements: Maximize performance Data latency of up to one month is acceptable You need to choose a project type and a data access mode to meet the requirements. What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube. The cube consists of a single measure group that contains the following measures: Total Quantity On Hand Average Quantity On Hand The measure group has a single partition that uses the MOLAP storage mode. You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly. What should you do?

You are conducting a design review of a multidimensional project. In the Customer Geography dimension, all non-key attributes relate directly to the key attribute. The underlying data of the Customer Geography dimension supports relationships between attributes. You need to increase query and dimension processing performance. What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension. The marketing team has requested that customer marketing categories be added to the database. The marketing categories must meet the following requirements: A customer member must be able to belong to multiple category members. A category member must be able to group several customer members. The marketing team must be able to create new categories every month in the data source. You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server. The Developer role cannot view and modify report caching parameters. You need to ensure that the Developer role can view and modify report caching parameters. Which task should you add to the Developer role?

You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging. Some users report that they cannot access the server. You need to ascertain the IP addresses of the client computers that are accessing the server. What should you do?

A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting. A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RetailSales. Each RetailSales database stores data only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical. Reports must meet the following requirements: A report parameter named ServerName must be defined in each report. When running a report, users must be prompted to select a server instance. The report data source must use the Microsoft SQL Server Analysis Services data source type. You need to create a data source to meet the requirements. How should you define the expression that is assigned to the connection string property of the data source?

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson. The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target slightly off target, or on target. You need to add a report item that visually displays the KPI status value as a red, yellow, or green flag. Which report item should you add?

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color. You need to modify the report so that users can sort products by the Price column. What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. The calculations are used to calculate the budget and forecast for the current quarter. You need to hide the tables and columns. What should you do?