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

You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales. You must design a matrix as shown in the following table. The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows {the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year. You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns. You need to add the countries on the rows of the matrix. Which Row Group option should you select when you add the group?

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support role cannot modify the report execution timeout period. You need to enable members of the Developer Support role to modify the report execution timeout period. Which task should you add to the Developer Support role?

You are managing a SQL Server Reporting Services (SSRS) instance. A website must pass credentials to the local security authority for Reporting Services. You need to configure Reporting Services to issue a challenge/response when a connection is made without credentials. Which authentication type should you configure in the RSReportServer.config file?

You are creating a SQL Server Analysis Services (SSAS) multidimensional database. Users need a time dimension for: Dates Delivery dates Ship dates You need to implement the minimum number of required SSAS objects. What should you do?

You are modifying a SQL Server Analysis Service (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 developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View. The reports will show the relationship between product sales and rainfall over time. You need to use an appropriate project type. Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

You work in the Business Intelligence (BI) department of a multinational company. To share its sales data between the various subsidiaries, the company has requested a new corporate BI solution that meets the following requirements: The solution must use SQL Server Analysis Services (SSAS) multidimensional or tabular Business Intelligence Semantic Model (BISM). The model must incrementally add 10 million fact rows of sales data per month. The model must be translated to English, German, Chinese, or Spanish based on users' locale. The model must be able to contain the most recent 36 months of data, in order to let users query the data. You need to select the appropriate model type and partitioning strategy to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A multidimensional SQL Server Analysis Services (SSAS) database will be tested next week. During the test period, users will access the database for 30 days. Multidimensional Expressions (MDX) queries generated during the test period must represent the variety of queries that will be used in the production environment. After testing completes, you need to implement aggregations for every partition in the solution while minimizing development effort. You need to ensure that the aggregations are optimal. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Analysis Services (SSAS) cube based on a Microsoft Azure SQL Database data warehouse. You need to implement a degenerate dimension. What should you do?

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions. You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis. What should you do before the partition can be write-enabled?