70-467 Real Exam Questions

You need to select the appropriate storage settings for the cube. Which settings should you choose?

A group of report writers develop reports. The report writers currently use Report Builder 1.0 and report models. The report writers are not trained on SQL Server query writing. Their report assignments come from various departments within the organization. The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode. After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables. You are designing the data access strategy. You have the following requirements: - Ensure that report writers can create only reports that display data which they have database permissions to view. - Minimize the effort required to update connection strings for all reports developed by the report writers. - Minimize the number of fields visible in a specific report for report writers who work for multiple departments. You need to design the data access strategy. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You need to implement the security requirement for the sales representatives. Which MDX expression should you use?

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the product. For all other products, Projected Revenue is defined as 110 percent of the Total Sales of the product. You need to calculate the Projected Revenue as efficiently as possible. Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic. You have the following requirements: - Ensure that queries of the data model correctly display average student age by class. - Ensure that the solution supports role-based security and partitions. - Minimize development effort. You need to design the data model. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)