Your network contains a SharePoint server 2007 server farm, you need to create a site map that displays the hierarchy of all the sites and subsites in a site ection What should you do ?

You deploy a report center site named report , you need to build a report that uses data from a Microsoft SQL server database located on a server outside of the SharePoint farm .

What should you do ?

Your network contians a SharePoint Server 2007 server farm , a Developer ( Just like us 😀 ) creates a DLL that contains Microsoft Office Excel-based custom business logic, a user creates an Excel workbook named Report1 that uses the custom DLL , the user upload Report1 to a document library , the user reports that report1 doesn’t render in a web broweser, you need to ensure that report1 renders in a web browser.

What should you do ?

Your network contains a SharedPoint Server 2007 server farm , the farm contains a KPI list named AllKPIs , you create a Microsoft SQL server analaysis services KPI named salesKPI, You add salesKPI to AllKPIs , you display salesKPI in a KPI details web part named salesWebPart , you need to prevent the value of the SalesKPI from automatically updating when users view SalesWebPart .
Which settings should you modify ?

Your network contains a SharePoint Server 2007 server farm , the farm contains Microsoft Office Excel workbook that is stored on a network file share , you need to ensure that Excel Servic can render the Excel workbook .

What sould you do ?

Your network contains a SharePoint Server 2007 server farm , You plan to use Bussiness Data Catalog (BDC) to access data in Microsoft SQL Server , the data will be displayed in a web part , you need to ensure that the BDC always uses the same credentials to access the data.

What should you Modify ?

Your network contains a SharePoint server 2007 server farm ,The farm contains web application named http://portal , You are creating a Bussiness Data Catalog (BDC) that connects to a web service , permissions to access the web service are only assigned to the application pool identity of http://portal , you need to identofy which authentication method must be used in the application definition file (ADF).

Which Authentication method should you identify ?

Your company uses a custom property in Microsoft Office documents named TrackingID, You need to ensure that users can find documents based on the TrackingID property even if the documents are stored in a library that doesn’t contain a trackingID column.

What should you do ?

Your network contains a SharePoint server 2007 server farm , the farm contains a site created by using the search center template , you create a new document template that contains a custom column named Employee ID, you need to ensure that users can search for documents by using the Emploee ID Property .

What should you do first ?

You network contains a SharePoint server 2007 server farm , the farm contains a document library named Docs , the Docs document library contains a document named report1.doc , users report the Report1.doc is always excluded from the search results , other documents in Doc`s are included in the search results , you need to identify what is causing report1.doc to be excluded from the search results.

What log should u analyze ?