MCTSMCTS(70-452)章节练习(2018.07.26)

单项选择题
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）
单项选择题
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 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？（）
A. Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.
B. Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.
C. Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.
D. Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.
单项选择题
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？（）
A. Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.
B. Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.
C. Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.
D. Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports.
单项选择题
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.
多项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports. Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source. Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）
A. Filter data by using expressions.
B. Specify the default values for each parameter.
C. Create an available values list for each parameter.
D. Create report parameters by using query parameters to filter data at the data source.
单项选择题
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 Business Intelligence （BI） solution by using SQL Server 2008. You need to load data into your online transaction processing （OLTP） database once a week by using data from a flat file. The file contains all the details about new employees who joined your company last week. The data must be loaded into the tables shown in the exhibit. （Click the Exhibit button.） Employee.EmployeeID is an identity. The safer ，easier way to help you pass any IT exams. A SQL Server 2008 Integration Services （SSIS） package contains one data flow for each of the destination tables. In the Employee Data Flow， an OLE DB Command transformation executes a stored procedure that loads the Employee record and returns the EmployeeID value. You need to accomplish the following tasks： Ensure that the EmployeeID is used as a foreign key （FK） in all child tables for the correct Employee record. Minimize the number of round trips to the database. Ensure that the package performs in the most efficient manner possible. What should you do？（）
A. Use a Lookup Transformation in each of the child table data flows to find the EmployeeID based on first name and last name.
B. Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.
C. After the Employee table is loaded， write the data to a Raw File Destination and use the raw file as a source for each of the subsequent Data Flows.
D. After the Employee table is loaded， write the data to a Flat File Destination and use the flat file as a source for each of the subsequent Data Flows.
单项选择题
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 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.