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

You have a publishing site. You plan to add an article page to a site by using a console application. You create a console application that contains the following code segment: 01: Using 02: Dim site As New SPSite("http://internet") 03: Dim web as SPWeb = site.RootWeb 04: Dim spSite as new PublishingSite(site) 05: Dim pWeb as PublishingWeb = PublishingWeb.GetPublishingWeb(web) 06: Dim articleCTID as New XPContentTypeID(08373...9373) 07: Dim articlePL as PageLayout=pWeb.GetAvailablePageLayout(articleCTID)(1) 08: Dim pageName as String = DateTime.Now.ToString("yyyyMMdd-HHmmss") 09: Dim nPage as PublishingPage = pWeb.GetPublishingPages().Add(String.Format("myPage.aspx","myPage",0), articlePL) 10: 11: End Using You need to ensure that the content owners can modify the page. What line of code should you use?

You have an Active Directory domain. All user accounts in the domain contain a custom attribute named Language. The Language attribute is set to either French or English. You have a web application that contains a site in English. You enable the variations to create a French version of the site. You need to ensure that users are automatically redirected to the site that corresponds to the Language attribute of the user account. Which file should you modify?

You create a Windows Form application that accesses Excel web services and displays workbook data on the form by using the GetWorkbook method. You need to identify the items that the workbook author selected as viewable when he saved the workbook. Which parameter should you pass to the GetWorkbook method?

You have a database that contains a table named Customers and a table named Orders. The Orders table contains a CustomerID foreign key. You need to create an association between the Customers entity and the Orders entity in the BDC. What should you do?

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

Your organization has a department named product testing. You are creating a new membership named Product Testing. You are adding a distribution list to the new membership. You need to ensure that the membership is displayed only to managers. What should you do?

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

You are creating a Microsoft Office SharePoint Server 2007 site. The site has five audiences. A user might belong to more than one of the five audiences. You need to obtain a list of audience names for the current user. Which code segment should you use?

You have two Microsoft Offce SharePoint Server 2007 site collections named Staging and Production. The Staging site collection runs on Server A. The Production site collection runs on Server B. Server A and Server B are located on separate networks. You need to write a script that replicates content from the Staging site collection to the Production site collection. What should you do? (To answer, move the appropriate three actons from the list of actions to the answer area and arrange them in the correct order.)

You create a Microsoft WinForms application that allows you to search within a Microsoft Office SharePoint Server 2007 site collection. You write the following code segment. SPSSearchWS.QueryService searchWS = new SPSSearchWS.QueryService(); string query = "My_Query"; You need to bind a DataGridView control directly to a query result set. Which code segment should you use?