MCTSMCTS(70-452)單項(xiàng)選擇題每日一練(2019.01.20)

來(lái)源：考試資料網(wǎng)

1 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？（）

點(diǎn)擊查看答案

2 You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution by using SQL Server 2008. Several reports on the server use a shared data source named DSProduction. You modify an existing report that uses the DSProduction data source. After deployment， the modified report must use an alternate data source. You need to prevent the modified report from affecting other reports. What should you do？（）

點(diǎn)擊查看答案

3 You design a Business Intelligence （BI） solution by using SQL Server 2008. A SQL Server 2008 Analysis Services （SSAS） solution contains a cube that has the following objects： ·Dimensions named DimCustomer，DimProduct，and DimGeography ·Measures named InternetSales and TotalSales Users run reports against all dimensions and measures by authenticating with their Windows accounts. You need to provide a basic view of data to the users to display only DimGeography， DimProduct，and TotalSales by using the least amount of storage space. What should you do？（）

點(diǎn)擊查看答案

4 You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）

點(diǎn)擊查看答案

5 You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do？（）

點(diǎn)擊查看答案