默认题库 - MCTS(70-452)

多选题

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.
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. 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.
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.

查看答案

单选题

自动收放缆索的电动机工作在（）状态。

A. 回馈制动
B. 能耗制动
C. 电源反接制动
D. 电动与倒增反接制动

查看答案

单选题

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.
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. 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.
Create a data profile by using SQL Server 2008 Integration Services （SSIS）.
D. Create a cube in SSAUse 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 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. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）

A. Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.
B. Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.
Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.
D. Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.

查看答案

单选题

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. 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）

查看答案