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

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance. You need to ascertain the memory consumed by each object in the SSAS instance. 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. You need to hide the tables and columns. What should you do?

You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The project will be deployed to a SSAS server that has 16 GB of RAM. The project will source data from a SQL Server database that contains a fact table named Sales. The fact table has more than 60 billion rows of data. You need to select an appropriate design to maximize query performance. Which data access strategy should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to query data in a tabular model. Which role permission should you use?

You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft Azure SQL database. The PowerPivot model includes a single table named FactSales that consists of four columns named Year, Country, Product and Revenue. The model includes the following two measures. Sales:=SUM(FactSales[Revenue]) Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales)) In Microsoft Excel 2010 you create the following PivotTable report. Users report that the Sales % measure computes an incorrect ratio. The measure should meet a requirement to compute a ratio over all visible sales values defined by the query filters. The Grand Total value for the Sales % measure should equal 100%. You need to fix the Sales % measure to meet the requirement. Which Data Analysis Expressions (DAX) expression should you use?

You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache. You need to configure the appropriate query mode. Which query mode should you select?

You are developing a SQL Server Analysis Services (SSAS) tabular project. In the data warehouse, a table named Employee Security defines a relationship between a salesperson's name, logon ID, and assigned sales territory. You need to ensure that each salesperson has access to data from only the sales territory assigned to that salesperson. You also need to minimize the development effort. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server relational database each day. You define a connection. You need to ensure that the connection minimizes the attack surface area of the server. How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a SQL Server Analysis Services (SSAS) tabular project. A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table. You need to add the City column to the Customer table. How should you write the calculation?

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. Report users require PDF exports of the report with no bulky images of the report header. You need to ensure that the header of the report is hidden when a user exports the report to PDF format. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)