Quiz 70-467, Designing Business Intelligence Solutions with Microsoft SQL Server 2012
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?
You need to configure permissions for the Customers dimension
What type of Transact-SQL (T-SQL) statement should you use?