click below
click below
Normal Size Small Size show me how
BusinessIntelligence
Manage Business Intelligence
| Question | Answer |
|---|---|
| Which filter Web Part is used to obtain data from a specific SharePoint list in a MOSS environment? | SharePoint List Filter Web Part |
| What should you do after enabling the Excel Services on the front-end Web server to access external data sources? | Configure a trusted connection in the SharePoint Server |
| Which filter Web Part is used in personalization pages in a MOSS environment? | the Property Profile Filter Web Part |
| Which authentication method should you use for users who access InfoPath forms by using a web browser in a MOSS environment? | Forms-based authentication |
| Which site template provides an optimized way to manage a large number of documents in an organization? | the Document Center site template |
| Which service is used to view business information, online analytical processing (OLAP) analysis, key performance indicators (KPI) scorecards, and data mining in a MOSS environment? | The MS SQL Server 2005 Analysis Services |
| What should you do to allow external data sources to be available from Excel Calculation Servies in MOSS environment? | Designate allow external data sources to trusted data connections library only |
| Which actions can users perform on the document library if you have assigned them the Limited Access permission level on the document library? | User can view specific lists, document libraries, or documents in the document library |
| Which service is responsible for open workbooks from trusted file locations in a MOSS environment? | Excel Calculation Services |
| Which Web Part is used to obtain user input on the dashboard page? | Text Filter Web Part |
| Which Web Part should you add to a dashboard site that provides visual information that helps users towards achieving goals and standands in MOSS environment? | Key Performance Indicator (KPI) Web Part |
| Which two Web Parts are automatically added to a dashboard page? | Current User Filter Web Part and Page Field Filter Web Part |
| Which authentication should you configure to ensure that when a user accessess workbook, the Excel Calculation Servies should impersonate user credentials when you are configuring data access security by using Excel Services Authentication? | Whindows Authentication by using Excel SErvices Authentication Settings |
| Which permission should you assign to a user to enable the user to upload Excel worksheets to the document library? | the Contribute permission |
| Which site template is used to create, manage, and deliver Web pages, dashboards, and key performance indicators (KPIs) to relay business intelligence information? | The Report Center site template |
| Which site template provides you a ready-to-use layout for organizing workboods, scorecards, data connections, reports, and dashboards? | the Report Center site template |
| Which two actions can users perform on the document libary if you have assigned them the Approve permission level on the document libary? | Edit and aprove the documents in the document library |
| Which service should you use to upload Excel worksheets to the SharePoint document library? | the Excel Web Services |
| Which site template should you use to create dashboard sites that will contain Filter Web Parts in MOSS environment? | Report Center site template |
| Which site template helps you to coordinate document development with users in a MOSS environment? | the Document Workspace site template |
| How should you configure a SharePoint document library to ensure that it can be accessed by Excel Calcualtion Services? | as a trusted repository for workbooks |
| Which service is used by dashboards to display data? | MS SQL 2005 Reporting Services |
| Which document libraries should you consider adding after adding connections to the data connection library for SQL Server Analysis Services while planning Web Parts in dashboards? | Add document libraries for the Excel Workbooks |
| Which Web Part allows you to add a button on the dashboard page, which will help users to submit the changes to the database? | Filter Action Web Part |
| Which site template includes a built-in Key Performance Indicator (KPI) list, a data connection library, and reference library in MOSS environment? | The Report Center site template |
| How should you configure a document library to ensure that the Excel workbooks are opened in a Web Browser? | Configure the default settings of the document library |
| Which services is helpful for developers in writing codes, passing parameters to workboods, refreshing calculations, and retrieving results in a MOSS environment? | Excel Web Services |
| Which Web Part should you add to the dashboard page to ensure that the reports in the dashboard contains information directly from the database server? | SQL Server 2005 Analysis Services Web Part |