70-542 Exam
MS Office SharePoint Server 2007.Application Development
- Exam Number/Code : 70-542
- Exam Name : MS Office SharePoint Server 2007.Application Development
- Questions and Answers : 65 Q&As
- Update Time: 2011-09-21
- Price:
$ 119.00$ 69.00
Free 70-542 Demo Download
Test4pass offers free demo for Microsoft Licensing 70-542 exam (MS Office SharePoint Server 2007.Application Development). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Exam Description
It is well known that 70-542 exam test is the hot exam of Microsoft certification. Test4pass offer you all the Q&A of the 70-542 real test . It is the examination of the perfect combination and it will help you pass 70-542 exam at the first time!
Why choose Test4pass 70-542 braindumps
Quality and Value for the 70-542 Exam
100% Guarantee to Pass Your 70-542 Exam
Downloadable, Interactive 70-542 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.
Microsoft Microsoft Licensing 70-542 exam braindumps questions and answers
¡¡
Exam : Microsoft 70-542
Title : MS Office SharePoint Server 2007.Application Development
1. You are creating two user-defined functions (UDFs) of Excel Services in Microsoft Office SharePoint Server 2007.
You write the following code segment.
Public Class Class1
Public Function MyDouble(ByVal d As Double) As Double
Return d * 9
End Function
Public Function ReturnDateTimeToday() As DateTime
Return (DateTime.Today)
End Function
End Class
You need to ensure that the MyDouble method and the ReturnDateTimeToday method are recognized as UDFs of Excel Services.
What should you do?
A. Add a reference to the Excel Services DLL.
B. Change the methods from public to private.
C. Add an out parameter to each of the method statements.
D. Mark the class by using the UdfClass attribute and mark the methods by using the UdfMethod attribute.
Answer: D
2. 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 Office 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.
Answer: C
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.
Answer: AC
4. You create a Microsoft Office SharePoint Server 2007 site. The site is configured to use a Shared Services Provider (SSP) that manages user profiles. The user profiles contain user contact information. You need to retrieve the telephone number of a user. What should you do?
A. Perform a keyword search by using the WorkPhone: prefix.
B. Obtain the value of the WorkPhone node from the SPUser.Xml property of the user.
C. Obtain the value of the UserProfile[PropertyConstants.WorkPhone] property of the user.
D. Obtain the value of the PropertyInformation.Description property where the value of the PropertyInformation.Name property is WorkPhone.
Answer: C
5. You are creating a Microsoft Office SharePoint Server 2007 application. The application reads data from the Microsoft Office Excel 2007 workbook named SalesGoals.xls. SalesGoals.xls is located in a document library. The first sheet of the SalesGoals.xls workbook contains the following information.
You need to retrieve the values for 2008 from within your application.
Which two actions should you perform? (Each correct answer provides part of the solution. Choose two.)
A. Instantiate a new RangeCoordinates object.
B. Instantiate the Microsoft Office Excel Web Services service.
C. Call the GetRangeA1 method by passing B3:D3 as a parameter.
D. Call the GetRange method along with a RangeCoordinates object by using the following parameters. column=2, row=3, height=1, width=3
Answer: BC
6. 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.
Answer: B
7. 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.
Answer: A
8. You are creating a Microsoft Office SharePoint Server 2007 site.
You create a Microsoft WinForms application to enter information about a user.
You write the following code segment. (Line numbers are included for reference only.)
01 Shared Sub AddUser(ByVal user_name As String())
02 ' Using
03 Dim site As SPSite = New SPSite("http://sitename")
04 Try
05 Dim context As ServerContext = _
06 ServerContext.GetContext(site)
07 Dim profileManager As UserProfileManager = New _
08 UserProfileManager(context)
09 ...
10 Finally
11 CType(site, IDisposable).Dispose()
12 End Try 13 End Sub
You need to add a user profile to the profile store.
Which code segment should you insert at line 09?
A. Private u As UserProfile = _
profileManager.GetUserProfile(user_name)
...
B. Private profileManager As UserProfileManager = New _
UserProfileManager(context)
Private u As UserProfile = profileManager.GetUserProfile(user_name)
...
u.Commit
C. Private user_name As String = "<UserProfile>"
...
user_name += userProfile + user_name
...
user_name += "</UserProfile>"
profileManager.CreateUserProfile(user_name)
D. Private u As UserProfile = _
profileManager.CreateUserProfile(user_name)
...
u.Commit
Answer: D
9. 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?
A. Call the MemberGroupData method of the UserProfiles object.
B. Call the GetPrivacyPolicy method of the UserProfileManager object.
C. Pass Privacy.Manager as the privacy setting to the Membership.Create method.
D. Pass PrivacyPolicyIdConstants.MembershipsFromDistributionLists to the CreateMemberGroup method of the user profile.
Answer: C
10. 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?
A. Public Class MyUdfs
Private rand As Random = New Random
<UdfMethod()> _
Public Function GetRandomNumber() As Integer
Return (rand.Next(100, 500))
End Function
End Class
B. <UdfClass()> _
Public Class MyUdfs
Private rand As Random = New Random
<UdfMethod(IsVolatile=True)> _
Public Function GetRandomNumber() As Integer
Return (rand.Next(100, 500))
End Function
End Class
C. <UdfClass()> _
Public Class MyUdfs
Private rand As Random = New Random
Public Function GetRandomNumber() As Integer
Return (rand.Next(100, 500))
End Function
End Class
D. Public Class MyUdfs
Private rand As Random = New Random
Public Function GetRandomNumber() As Integer
Return (rand.Next(100, 500))
End Function End Class
Answer: B
11. 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.
Answer: A
12. 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.
Answer: B
13. You create a Microsoft Office SharePoint Server 2007 application. The application has a user named UserA.
You need to retrieve a list of colleagues for UserA.
Which code segment should you use?
A. Private Sub RetrieveColleagues(ByVal Cntxtobj As ServerContext)
...
Dim site As SPSite = New SPSite("http: //servername/sites/site1")
Dim profileManager As UserProfileManager = New _
UserProfileManager(Cntxtobj) Dim profile As UserProfile = _
profileManager.GetUserProfile("abcUserA")
Dim colleagues As Colleague() = profile.Colleagues.GetItems
Site.Dispose
...
End Sub
B. Private Sub RetrieveColleagues(ByVal Cntxtobj As ServerContext)
...
Dim site As SPSite = New SPSite("http: //servername/sites/site1")
Dim context As ServerContext = ServerContext.GetContext(site)
Dim profileManager As UserProfileManager = New _
UserProfileManager(context) Dim profile As UserProfile = _
profileManager.GetUserProfile("abcUserA")
Dim colleagues As UserProfile() = _
profile.Colleagues.GetCommonColleagues
Site.Dispose
...
End Sub
C. Private Sub RetrieveColleagues(ByVal Cntxtobj As ServerContext)
...
Dim site As SPSite = New SPSite("http: //servername/sites/site1")
Dim context As ServerContext = ServerContext.GetContext(site)
Dim profileManager As UserProfileManager = New _
UserProfileManager(context) Dim profile As UserProfile = _
profileManager.GetUserProfile("abcUserA")
Dim manager As ColleagueManager = _
New ColleagueManager(profile)
Dim profiles As UserProfile() = _
manager.GetColleaguesOfColleagues
Site.Dispose
...
End Sub
D. Private Sub RetrieveColleagues(ByVal Cntxtobj As ServerContext)
...
Dim site As SPSite = New SPSite("http: //servername//sites/site1")
Dim context As ServerContext = ServerContext.GetContext(site)
Dim audMgr As AudienceManager = New AudienceManager(context)
Dim web As SPWeb = site.AllWebs("mainpage")
Dim audienceIDNames As ArrayList = _
audMgr.GetUserAudienceIDs("domainuserA", True, web)
Site.Dispose
...
End Sub
Answer: A
14. 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.
Answer: D
Click Online chat to talk with us , get more informations about Microsoft Microsoft Licensing 70-542 practice exam study guides questions and answers
Test4pass 70-542 Exam Features
Quality and Value for the 70-542 Exam
Test4pass Practice Exams for Microsoft 70-542 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your 70-542 Exam
If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the Microsoft Licensing 70-542 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
Microsoft 70-542 Downloadable, Printable Exams (in PDF format)
Our Exam 70-542 Preparation Material provides you everything you will need to take your 70-542 Exam. The 70-542 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.
70-542 Downloadable, Interactive Testing engines
We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Microsoft 70-542 Exam will provide you with free 70-542 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 70-542 Exam:100% Guarantee to Pass Your Microsoft Licensing exam and get your Microsoft Licensing Certification.
Test4pass 70-542 examTest4pass 70-542 pdf exam
Test4pass 70-542 braindumps
Test4pass 70-542 study guides
Test4pass 70-542 trainning materials
Test4pass 70-542 simulations
Test4pass 70-542 testing engine
Test4pass 70-542 vce
Test4pass 70-542 torrent
Test4pass 70-542 dumps
free download 70-542
Test4pass 70-542 practice exam
Test4pass 70-542 preparation files
Test4pass 70-542 questions
Test4pass 70-542 answers
http://www.test4pass.com/70-542-exam.html The safer.easier way to get Microsoft Licensing Certification
.




