Quiz 70-467, Designing Business Intelligence Solutions with Microsoft SQL Server 2012
You need to implement security in the cube to limit the sites visible to each user
You need to implement the aggregation designs for the cube
Which settings should you choose?
You need to configure a parameter for the database connection string
You need to restrict access to data in the tables in the data warehouse
You need to ensure that managers can successfully run reports
You need to implement a strategy for efficiently storing sales order data in the data warehouse
You need to ensure that you can monitor the usage data
You need to improve the performance of data warehouse queries
Which type of table should you create?