單項(xiàng)選擇題

You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Reporting Services （SSRS） infrastructure in a scale-out deployment. All reports use a SQL Server 2008 relational database as the data source. You implement row-level security. You need to ensure that all reports display only the expected data based on the user who is viewing the report. What should you do？（）

A. Store the credential of a user in the data source.
B. Configure the infrastructure to support Kerberos authentication.
C. Configure the infrastructure to support anonymous authentication by using a custom authentication extension.
D. Ensure that all report queries add a filter that uses the User.UserID value as a hidden parameter.

你可能感興趣的試題

單項(xiàng)選擇題

You design a Business Intelligence （BI） solution by using SQL Server 2008.
The solution includes a SQL Server 2008 Analysis Services （SSAS） database. The database contains a cube named Financials. The cube contains objects as shown in the exhibit. （Click the Exhibit button.）
A calculated member named Gross Margin references both Sales Details and Product Costs. You need to ensure that the solution meets the following requirements：
Managers must be able to view only their cost centers percentage of the companys gross margin. The impact on query performance is minimal. What should you do？（）

A. Add dimension-level security and enable the Visual Totals option.
B. Add cell-level security that has read permissions on the Gross Margin measure.
C. Add cell-level security that has read contingent permissions on the Gross Margin measure.
D. Change the permissions on the Managers dimension level from Read to Read/Write.

單項(xiàng)選擇題

You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day， an application adds millions of fact rows and thousands of new customers. Currently， a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use？（）

A. hybrid online analytical processing （HOLAP）
B. relational online analytical processing （ROLAP）
C. multidimensional online analytical processing （MOLAP）
D. automatic multidimensional online analytical processing （automatic MOLAP）

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精