Microsoft 70-542 Real Exam Questions

When the exam begins, you can choose the programming language in which the code segments will appear. The available code languages for this exam are:

• Microsoft Visual Basic 2005

• Microsoft Visual C# 2005

1: Your company uses a Microsoft Office SharePoint Server 2007 site that has user profiles enabled. Your company also uses a Web-based human resources (HR) application that runs on a different server.   The HR department wants to display the user profile data from the SharePoint site in the Web-based application.  
You need to retrieve the user profile information from within the Web-based application.  
Which method of the UserProfileService object should you use?
A.The GetUserProfileByName method.
B.The ModifyUserPropertyByName method.
C.The GetCurrentChangeToken method.
D.The GetUserCurrentChangeToken method.
Correct Answers: A

2: You create a Microsoft Office SharePoint Server 2007 site.   A document library named CompanyWorkbooks on the site contains Microsoft Office Excel workbooks.   You need to ensure that users can access the workbooks in the CompanyWorkbooks document library by using Excel Services in Microsoft Office SharePoint Server 2007.   What should you do?
A.Define the site as a managed path within SharePoint.
B.Add the CompanyWorkbooks URL to the trusted location list.
C.Edit the permissions of the CompanyWorkbooks document library to grant full control to the SharePoint application pool identity account.
D.Create a custom security policy file for the CompanyWorkbooks document library. Add the file to the securityPolicy section of the Web.config file for the site.
Correct Answers: B

3: You are designing a Microsoft Office SharePoint Server 2007 solution. A Microsoft SQL Server 2005 Analysis Services cube stores key performance indicators (KPIs).   You need to display details of a KPI in a Web Part.   Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.Create a KPI List.
B.Add a List Item Web Part.
C.Create a .odc file for the data connection.
D.Create a .udl file for the data connection.
E.Create a Business Data Catalog (BDC) definition.
Correct Answers: A C
4: You create an application for a Microsoft Office SharePoint Server 2007 server. You create a call center dashboard. You create a Key Performance Indicator (KPI) list that contains KPIs. You add a KPI Web Part to the dashboard to view KPIs.   You need to permit users to view details that make up each KPI.   What should you do?
A.Add a link to each KPI in the list to take the user to a details page.
B.Add data to a custom SharePoint list and use built-in filter and view capabilities.
C.Add a Filter Web Part to the dashboard page and connect the page to the KPI list Web Part.
D.Filter the items in the KPI list Web Part by the indicator that the user wants to view.
Correct Answers: A

5: You are creating a Microsoft Office SharePoint Server 2007 Report Center Web site. Your company stores product data in a Microsoft SQL Server 2005 database named Product Management.   You need to ensure that the product data is available for use in Microsoft Office Excel 2007 reports.   What should you do?
A.Upload a custom Office Data Connection file to the Data Connections library.
B.Upload a custom set of Microsoft SQL Server Reporting Services Report Model files to the Data Connections library.
C.Create a single sign-on (SSO) provider that manages access to the Product Management database.
D.Create a Business Data Connection for the Product Management database, and define entities in the Business Data Catalog (BDC) definition.
Correct Answers: A

6: You are developing a Microsoft Office SharePoint Server 2007 solution that integrates with Microsoft SQL Server 2005 Reporting Services.   You need to configure the SharePoint solution to allow storage of reports in SharePoint document libraries.   What should you do?
A.Specify the Report Server URL in the Report Explorer Web Part.
B.Configure the proxy server endpoint in the Reporting Services Configuration tool.
C.Specify a Report Explorer Web Part as the target for the Report Viewer Web Part.
D.Specify a Report Viewer Web Part as the target for the Report Explorer Web Part.
Correct Answers: B

7: You have a Microsoft Office SharePoint Server 2007 site. You create a Microsoft Office Excel 2007 workbook that contains the telephone numbers of all your company locations.   You need to ensure that users can filter the Excel 2007 workbook on the basis of company locations by using Excel Services in Microsoft Office SharePoint Server 2007.   What should you do?
A.Create an ActiveX control in the workbook.
B.Create an Excel 2007 Microsoft Visual Basic for Applications (VBA) application in the workbook.
C.Filter the workbook by using the Data-Filter option of the Excel 2007 workbook.
D.Filter the list in place by using Excel 2007, and protect the Excel 2007 workbook that contains the telephone numbers.
Correct Answers: C

8: Your company stores employee details in a Microsoft SQL Server database. You are creating a Report Center site on a Microsoft Office SharePoint Server 2007 server.   You need to ensure that a report on employee details can be generated in the Report Center site.   What should you do?
A.Add the Data Connections library to the trusted file locations.
B.Import the application definition to the Business Data Connector.
C.Import the Office Data Connection file to the trusted data providers.
D.Create an Office Data Connection file in a trusted Data Connections library.
Correct Answers: D

9: 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?
A.Reference the Microsoft.SharePoint.Portal assembly.
B.Reference the Microsoft.SharePoint.SoapServer assembly.
C.Reference the Microsoft.Office.Server.Utilities assembly.
D.Reference the Microsoft.Office.Server.WebControls assembly.
Correct Answers: A

Download  |  Password: certificatexam.com