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

单项选择题
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？（）
A. Create a new perspective for the current cube. Select DimGeography， DimProduct， and TotalSales.
B. Create a new cube. Add DimGeography， DimProduct， and TotalSales.
C. Create a new role. Grant access only to DimGeography， DimProduct， and TotalSales.
D. Create a new data source view. Add the tables used for DimGeography， DimProduct， and TotalSales.
单项选择题
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 data mining structure that uses a SQL Server 2008 table as a data source. A table named OrderDetails contains detailed information on product sales. The OrderDetails table includes a column named Markup. You build a data mining model by using the Microsoft Decision Trees algorithm. You classify Markup as discretized content. The algorithm produces a large number of branches for Markup and results in low confidence ratings on predictable columns. You need to verify whether the Markup values include inaccurate data. What should you do？（）
A. Modify the content type of Markup as Continuous.
B. Create a data mining dimension in the SSAS database from OrderDetails.
C. Create a data profile by using SQL Server 2008 Integration Services （SSIS）.
D. Create a cube in SSAS. Use OrderDetails as a measure group. Recreate the data mining structure and mining model from the cube data.
单项选择题
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. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）
A. Use a subreport.
B. Use a bookmark link.
C. Use the drilldown functionality.
D. Use a drillthrough report link.
单项选择题
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.