Microsoft-TS Microsoft Office SharePoint Server 2007 - Application Development Set 3

You have a data connection library. You need to ensure that users can create and display Microsoft Office Excel workbooks that use data sources stored in the data connection library. Where should you add the data connection library?

You have a web part that uses Excel Web Services to open a published Microsoft Office Excel workbook. You need to calculate formulas in the workbook for a range. You write the following line of code: 01: Dim range as String = "Sheet1!A1:F17" Which method should you pass the range variable?

You are creating a site on a SharePoint 2007 server. You write the following code segment: 01: Public Function GetUserProperties() As String 02: Dim usersWithNoTitles as String = New String("") 03: Dim site as SPSite = new SPSite("http://sitename") 04: Try 05: Dim web as SPWeb = site.OpenWeb 06: Try 07: Dim profMan as UserProfileManager = New UserProfileManager 08: ... 09: Finally 10: CType(web.iDisposable).Disposable() 11: End Try 12: Finally 13: CType(site.iDisposable).Disposable() 14: End Try 15: Return usersWithNoTitles 16: End Function You need to display a list of users in the site who have blank titles. Which code segment should you use?

You plan to create an application definition file for a SQL Server database. You need to distribute the credentials used to connect the SharePoint site that are also used to connect to the SQL Server database. Which authentication method should you specify in the application definition file?

You are designing a MOSS 2007 solution. You need to implement a Single Sign-On (SSO) provider to access a Business Data Catalog (BDC). What should you do?

You create a Microsoft Office SharePoint Server 2007 site. You also create a BDC definition. The BDC definition accesses a product database that is stored on a SQL Server 2005 server. You need to ensure that users can filter the product data by the product type field from within the SharePoint server. What should you do?

You have an external line of business application. The LOB application data is exposed to a web service. You plan to use the BDC catalog to access the LOB application. You create the following type descriptor for the data row in the BDC application file: You attempt to import the application definition file to the BDC and receive the following error: "Could not create profile page for entity filtered contact. The error is profile page creation for the entity filtered contact skipped. Entity filtered contact has no identifiers defined in the specific finder view." You need to ensure that you can import the application definition file to the BDC. What should you do?

You create a custom field type and a corresponding custom field control. You need to ensure that the field type is available to users when they create list columns. What should you do?

You create a Microsoft Office SharePoint Server 2007 portal site. The site contains a document retention policy for request for proposal (RFP) documents. You need to customize the policy to ensure that a notification is sent to each project manager when the RFP date expires. What should you do?

You are creating a Microsoft Office SharePoint Server 2007 site. A document library contains documents on new products. The documents must contain a label that denotes the product status. You need to add a label to all documents in the library. What should you do?