MCTSMCTS(70-452)单项选择题每日一练(2019.01.11)

单项选择题
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.
单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services （SSIS） package to perform an extract， transform， and load （ETL） process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components： A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average， 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do？（）
A. Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
B. Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
C. Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
D. Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution contains a SQL Server 2008 Analysis Services （SSAS） database. A measure group in the database contains log entries of manufacturing events. These events include accidents， machine failures， production capacity metrics， and other activities. You need to implement a data mining model that meets the following requirements： Predict the frequency of different event types. Identify short-term and long-term patterns. Which algorithm should the data mining model use？（）
A. the Microsoft Time Series algorithm
B. the Microsoft Decision Trees algorithm
C. the Microsoft Linear Regression algorithm
D. the Microsoft Logistic Regression algorithm
单项选择题
You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？（）
A. List
B. Table
C. Matrix
D. Subreport
单项选择题
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？（）
A. Update the connection string of the DSProduction shared data source to point to the alternate data source.
B. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.
C. Create a new shared data source named DSProduction in the same folder as that of the modified report. Update the connection string of the new shared data source to point to the alternate data source.
D. Disable the DSProduction data source. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.