You plan to create a batch file that defines several trusted workbook locations. You need to ensure that
connections that are defined in trusted data connection libraries are allowed to be used.
Which stsadm.exe operation should you use in the batch file?
Your company uses a portal site to recreate site hierarchies. You need to add additional sites to the hierarchy
that is defined in the portal site template.
What should you do?
You create a Microsoft Office InfoPath form library. You need to provide users with the ability to convert new
forms to web pages on demand. You must use an existing document converter.
Which code segment would you use?
Your company stores product information in a SQL Server 2005 database. You create a BDC definition to
search for product information within the database. You need to ensure that incremental crawls can be
performed in the database for indexing.
What should you do?
Your organization has a department named product testing. You are creating a new membership named
ProductTesting. 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 have a document library that contains .docx documents. You need to create a web part that allows users
with the ability to convert documents to .aspx pages by using the default document converter. You write the
following code segment:
01: Public Sub ConvertFileOpen(ByVal file as SPFile)
02: Dim pubWeb as PublishingWeb =
PublishingWeb.GetPublishingWeb(SPContext.Current.Web)
03: Dim pages as PublishingWebCollection = pubWeb.GetPublishingPages()
04: Dim title[String] = GUID.NewGUID().toString() & ".aspx"
05: Dim converterID as new GUID("1234.........7890")
06:
07: End Sub
Which code segment should you add at line 6?
You implement a custom function as a user-defined function (UDF) in Excel Services in Microsoft Office
SharePoint Server 2007. A Microsoft Office Excel 2007 workbook uses the custom function to generate a
random number between 100 and 500. You need to generate a new random number each time you load the
workbook. Which code segment should you use?