单选题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 Int

题目
单选题
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.

相似考题

1.● Business intelligence (BI) is the integrated application of data warehouse, data mining and (73)．（73）A．OLAPB．OLTPC．MRPIID．CMS．

2.Business intelligence (BI) is the integrated application of data warehouse data mining and ______A．OLAPB．OLTPC．MRPIID．CMS

3.商务智能（Business Intelligence，BI）

4.Business intelligence （BI） is the integrated application of data warehouse, data mining and （73）．A.OLAPB.OLTPC.MRPIID.CMS

参考答案和解析
正确答案： B
解析： 暂无解析
更多“You design a Business Intelligence （BI） solution by using SQ”相关问题

  • 第1题：

    Which three pre-sales Smart Design documents are available to help you implement and install a solution？（）

    • A、 Design Guide
    • B、 Cisco Configuration Assistant
    • C、 Implementation Guide
    • D、 Small Business Product Guide
    • E、 Solution Profile
    • F、 Application Notes

    正确答案:A,C,F

  • 第2题：

    Which three post-sales Smart Design documents are available to help you better serve your customers？ （）  

    • A、 Quick Quoting Tool
    • B、 Smart Business Communications System
    • C、 Overview Presentation
    • D、 Cisco Configuration Assistant
    • E、 Solution Profile
    • F、 Small Business Product Guide

    正确答案:C,E,F

  • 第3题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do？（）

    • A、 Add a reference to the assemblies in the Report Properties References tab. 
    • B、 Write the calculation logic used by the calculations by using T-SQL functions. 
    • C、 Write the code of the calculation logic into the Report Properties Custom Code tab.
    • D、 Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.

    正确答案:A

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

    正确答案:A,B

  • 第5题：

    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.

    正确答案:C

  • 第6题：

    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）

    正确答案:A

  • 第7题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    多选题
    Which three pre-sales Smart Design documents are available to help you implement and install a solution？（）
    A

    Design Guide

    B

    Cisco Configuration Assistant

    C

    Implementation Guide

    D

    Small Business Product Guide

    E

    Solution Profile

    F

    Application Notes


    正确答案： D,C
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do？（）
    A

     Add a reference to the assemblies in the Report Properties References tab. 

    B

     Write the calculation logic used by the calculations by using T-SQL functions. 

    C

     Write the code of the calculation logic into the Report Properties Custom Code tab.

    D

     Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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.

    C

     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.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:B

  • 第14题：

    A customer is interested in obtaining an AIX solution from IBM.  They have two primary global requirements：   ？ Availability （although HACMP is not required）   ？ Low cost   Which of the following approaches should the pSeries technical specialist use to meet the customer’s requirements and ensure customer satisfaction？（）

    • A、Design the least-cost solution to prevent the competition from winning the business.
    • B、Design a disaster recovery （DR） solution and convince the customer why DR is important to their business.
    • C、Use the HACMP specialist to design the solution and include HA SmoothStart services as part of the proposal.
    • D、Design a solution with redundant parts and explain to the customer the incremental cost associated with the redundancy.

    正确答案:D

  • 第15题：

    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.

    正确答案:A

  • 第16题：

    You need to design a remote administration solution for servers on the internal network. Your solution must meet business and security requirements. What should you do？（）

    • A、Permit administrators to use an HTTP interface to manage servers remotely
    • B、Permit only administrators to connect to the servers’ Telnet service
    • C、Permit administrators to manage the servers by using Microsoft NetMeeting
    • D、Require administrators to use Remote Desktop for Administration connections to manage the servers

    正确答案:B

  • 第17题：

    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.

    正确答案:D

  • 第18题：

    名词解释题
    商务智能（Business Intelligence，BI）

    正确答案： 是对商业信息的搜集、整理和分析的过程，目的是使企业的各级决策者获得知识或洞察力，促使他们作出对企业更有利的决策。
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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）


    正确答案： C
    解析： 暂无解析

相关内容