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

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. You need to ensure that the header of the report is hidden when a user exports the report to PDF format. Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique color scheme combination of foreground and background colors. You need to ensure that all of the text boxes in the table headers use the correct business unit colors. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity YTD sales quantity values are classified in three bands: High Sales, Medium Sales, and Low Sales. You add a table to the report. Then you define two columns based on the fields named ProductName and YTDSalesQuantity. You need to set the color of the product text to red, yellow, or blue, depending on the value of the YTD sales quantity values. What should you do?

You are modifying a SQL Server Analysis Services (SSAS) multidimensional database. You have identified a dimension that is no longer used by any cubes. You need to delete the dimension. What should you do?

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts by using a hierarchy named Geography from a dimension named Geography. The DimGeography table in the data source view is used as the source of the Geography dimension. The table has the following structure. The Geography dimension has three attribute hierarchies: City State-Province Country The attributes have the following relationships defined: City> State-Province > Country. Each attribute has a key and a name sourced from the related key and name columns in the DimGeography table. During processing, you receive the following error message: 'Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimGeography', Column: 'StateProvinceKey', Value: '23'. The attribute is State-Province'." You verify that the data is accurate. You need to ensure that the dimension Processes successfully. What should you do?

You execute the following code: You need to reduce the amount of time it takes to execute the query. What should you do?

You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table. You need to implement a time dimension. What should you do?

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 32 GB of RAM. The source data, located in a SQL Server data warehouse, is currently using 10 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. You need to ensure the highest query performance and scalability for the accounting department queries. Which project type should you choose?

You have a server that has SQL Server 2012 installed. You need to identify which parallel execution plans are running in serial. Which tool should you use?

You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the following requirements: Support real-time monitoring. Be enabled and disabled easily. Support querying of the monitored data. What should you implement? More than one answer choice may achieve the goal. Select the BEST answer.